FND_OBJECTS_
Stores the object defintion of the object (table or view) that needs to be secured.
Details
-
Schema: DATASECURITY
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FND_OBJECTS_PK_ |
LAST_UPDATE_DATE, OBJECT_ID, 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 | |
| OBJ_NAME | VARCHAR2 | 80 | OBJ_NAME | |
| MODULE_ID | VARCHAR2 | 32 | Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. | |
| DATABASE_OBJECT_NAME | VARCHAR2 | 30 | DATABASE_OBJECT_NAME | |
| PK1_COLUMN_NAME | VARCHAR2 | 60 | PK1_COLUMN_NAME | |
| PK2_COLUMN_NAME | VARCHAR2 | 60 | PK2_COLUMN_NAME | |
| PK3_COLUMN_NAME | VARCHAR2 | 60 | PK3_COLUMN_NAME | |
| PK4_COLUMN_NAME | VARCHAR2 | 60 | PK4_COLUMN_NAME | |
| PK5_COLUMN_NAME | VARCHAR2 | 60 | PK5_COLUMN_NAME | |
| PK1_COLUMN_TYPE | VARCHAR2 | 8 | PK1_COLUMN_TYPE | |
| PK2_COLUMN_TYPE | VARCHAR2 | 8 | PK2_COLUMN_TYPE | |
| PK3_COLUMN_TYPE | VARCHAR2 | 8 | PK3_COLUMN_TYPE | |
| PK4_COLUMN_TYPE | VARCHAR2 | 8 | PK4_COLUMN_TYPE | |
| PK5_COLUMN_TYPE | VARCHAR2 | 8 | PK5_COLUMN_TYPE | |
| 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. | |
| OBJECT_TYPE | VARCHAR2 | 80 | Stores the type of object. This is useful when you want to hint the UI for some special processing for an object type. Examples could be Flex Value Set, Lookups, Messages, Profiles, etc. | |
| OBJECT_STRIPE_CONDITION | VARCHAR2 | 4000 | This is used when we have multiple logical objects for a given physical object and we want the stripe condition to be captured. | |
| OBJECT_TAG | VARCHAR2 | 80 | This is useful when you want to hint the UI for some special processing for an Object. This special processing could be in addition to the special processing for Object Type. An example would be to tag the object as used for ECSF. This means only Filters can be used as instance sets instead of predicates. | |
| FILTER_COLUMN_LIST | VARCHAR2 | 4000 | FILTER_COLUMN_LIST | |
| FUNCTION_SECURITY_ENABLED | VARCHAR2 | 1 | FUNCTION_SECURITY_ENABLED | |
| 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_N1_ | Non Unique | Default | OBJECT_ID, ENTERPRISE_ID, SANDBOX_ID |
| FND_OBJECTS_U1_ | Non Unique | Default | LAST_UPDATE_DATE, OBJECT_ID, ENTERPRISE_ID, SANDBOX_ID |
| FND_OBJECTS_U2_ | Non Unique | Default | LAST_UPDATE_DATE, OBJ_NAME, ENTERPRISE_ID, SANDBOX_ID |