1. Tables and Views for Common Features
  2. FND_OBJECTS_TL_

FND_OBJECTS_TL_

Stores the translatable attributes of Objects that are secured.

Details

  • Schema: DATASECURITY

  • Object owner: FND

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

FND_OBJECTS_TL_PK_

LAST_UPDATE_DATE, OBJECT_ID, LANGUAGE, ENTERPRISE_ID, SANDBOX_ID

Columns

Name Datatype Length Precision Comments
ENTERPRISE_ID NUMBER 18 ENTERPRISE_ID
SANDBOX_ID VARCHAR2 64 Sandbox Id
OBJECT_ID NUMBER 18 OBJECT_ID
LANGUAGE VARCHAR2 4 Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Indicates the code of the language in which the contents of the translatable columns were originally created.
DISPLAY_NAME VARCHAR2 240 DISPLAY_NAME
DESCRIPTION VARCHAR2 2000 DESCRIPTION
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP 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.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Actione Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1's and 0s for each row. 1 will be stored if the value has changed and 0 will be stored if the value hasn't.
SEED_DATA_SOURCE VARCHAR2 512 Seed data file from which the row originates.

Indexes

Index Uniqueness Tablespace Columns
FND_OBJECTS_TL_N1_ Non Unique Default OBJECT_ID, LANGUAGE, ENTERPRISE_ID, SANDBOX_ID
FND_OBJECTS_TL_U1_ Non Unique Default LAST_UPDATE_DATE, OBJECT_ID, LANGUAGE, ENTERPRISE_ID, SANDBOX_ID
FND_OBJECTS_TL_U2_ Non Unique Default LAST_UPDATE_DATE, DISPLAY_NAME, LANGUAGE, ENTERPRISE_ID, SANDBOX_ID