top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

what are Steps Required for registering a Table in oracle Apps?

+3 votes
394 views
what are Steps Required for registering a Table in oracle Apps?
posted Nov 10, 2015 by Vidhya Sagar

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Register Custom Table In Oracle Applications

All you technical people out there very well know the purpose of creating custom table. Its basically when we need to store data before pulling into standard table (In case of inbound interface) or putting extract of data to share with external entity (In case of outbound interface). All these activities can be accomplished without registering custom table in oracle apps.

If you have a need to use these custom tables in standard functionality in frond end like using in Alerts / Audits, you must register them. Otherwise your custom table will not be visible in front end.
Lets start this by creating a sample custom table.
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.2.0
Connected as c_apps

SQL> 
SQL> CREATE TABLE C_FND_INTERFACES
    ( 
    INTERFACE_ID            NUMBER               NOT NULL PRIMARY KEY,
    SERVICE_CHANNEL         VARCHAR2(64 BYTE)    NOT NULL,
    SOURCE                  VARCHAR2(64 BYTE) NOT NULL,
    ATTRIBUTE1              VARCHAR2(2000 BYTE),
    ATTRIBUTE2              VARCHAR2(2000 BYTE),  7    ATTRIBUTE3              VARCHAR2(2000 BYTE),
    ATTRIBUTE4              VARCHAR2(2000 BYTE),
    ATTRIBUTE5              VARCHAR2(2000 BYTE),
    ATTRIBUTE6              VARCHAR2(2000 BYTE),
    ATTRIBUTE7              VARCHAR2(2000 BYTE),
    ATTRIBUTE8              VARCHAR2(2000 BYTE),
    ATTRIBUTE9              VARCHAR2(2000 BYTE),
    ATTRIBUTE10             VARCHAR2(2000 BYTE),
    STATUS                  VARCHAR2(50 BYTE)    NOT NULL,
    ERROR_MESSAGE           VARCHAR2(2000 BYTE),
    CREATED_BY              NUMBER               NOT NULL,
    CREATION_DATE           DATE                 NOT NULL,
    LAST_UPDATED_BY         NUMBER               NOT NULL,
    LAST_UPDATE_DATE        DATE                 NOT NULL,
    REQUEST_ID              NUMBER,
    BATCH_ID                NUMBER
   )
   TABLESPACE C_APPS
   PCTUSED    0
   PCTFREE    10
   INITRANS   1
   MAXTRANS   255
   STORAGE    (
               INITIAL          64K
               NEXT             1M
               MINEXTENTS       1
               MAXEXTENTS       UNLIMITED
               PCTINCREASE      0
               BUFFER_POOL      DEFAULT
              )
   LOGGING
   NOCACHE
   NOPARALLEL
   /

Table created

SQL> 

For more infoClick here!

answer Nov 12, 2015 by Manikandan J
...