1. Tables and Views for Common Features
  2. FND_OBJECT_INSTANCE_SETS_TL_BK

FND_OBJECT_INSTANCE_SETS_TL_BK

Stores the backup data translatable attributes of an Instance Set.

Details

  • Schema: CSM

  • Object owner: FND

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

FND_OBJECT_INST_SETS_TL_BK_PK

INSTANCE_SET_ID, LANGUAGE, ENTERPRISE_ID, SANDBOX_ID, CUST_SET_ID

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
SANDBOX_ID VARCHAR2 64 Yes Sandbox Id
DISPLAY_SHORT_NAME VARCHAR2 512 Display Short Name
INSTANCE_SET_ID NUMBER 18 Yes INSTANCE_SET_ID
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
DISPLAY_NAME VARCHAR2 2000 Yes DISPLAY_NAME
DESCRIPTION VARCHAR2 2000 DESCRIPTION
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
CUST_SET_ID VARCHAR2 300 Yes Customization Set ID

Indexes

Index Uniqueness Tablespace Columns
FND_OBJECT_IS_TL_BK_N1 Non Unique Default LAST_UPDATE_DATE, ENTERPRISE_ID, SANDBOX_ID
FND_OBJECT_IS_TL_BK_U1 Unique Default INSTANCE_SET_ID, LANGUAGE, ENTERPRISE_ID, SANDBOX_ID, CUST_SET_ID
FND_OBJECT_IS_TL_BK_U2 Unique Default DISPLAY_NAME, LANGUAGE, ENTERPRISE_ID, SANDBOX_ID, CUST_SET_ID