what are Steps Required for registering a Table in oracle Apps?
Answers
Answered by
3
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>
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>
Similar questions