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 |
OBJECT_ID, ENTERPRISE_ID, SANDBOX_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | ENTERPRISE_ID | |
| SANDBOX_ID | VARCHAR2 | 64 | Yes | Sandbox Id | |
| OBJECT_ID | NUMBER | 18 | Yes | OBJECT_ID | |
| OBJ_NAME | VARCHAR2 | 80 | Yes | OBJ_NAME | |
| MODULE_ID | VARCHAR2 | 32 | Yes | 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 | Yes | DATABASE_OBJECT_NAME | |
| PK1_COLUMN_NAME | VARCHAR2 | 60 | Yes | 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 | Yes | 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 | 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. | ||
| 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 | Yes | FUNCTION_SECURITY_ENABLED | |
| CHANGE_SINCE_LAST_REFRESH | VARCHAR2 | 1 | Yes | Flag indicates if rows has been updated since last sandbox refresh. | |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Seed data file from which the row originates. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FND_OBJECTS | fnd_appl_taxonomy | MODULE_ID, ENTERPRISE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_OBJECTS_N1 | Non Unique | Default | MODULE_ID, ENTERPRISE_ID, SANDBOX_ID |
| FND_OBJECTS_N2 | Non Unique | Default | LAST_UPDATE_DATE, ENTERPRISE_ID, SANDBOX_ID |
| FND_OBJECTS_U1 | Unique | Default | OBJECT_ID, ENTERPRISE_ID, SANDBOX_ID, ORA_SEED_SET1 |
| FND_OBJECTS_U11 | Unique | Default | OBJECT_ID, ENTERPRISE_ID, SANDBOX_ID, ORA_SEED_SET2 |
| FND_OBJECTS_U2 | Unique | Default | OBJ_NAME, ENTERPRISE_ID, SANDBOX_ID, ORA_SEED_SET1 |
| FND_OBJECTS_U21 | Unique | Default | OBJ_NAME, ENTERPRISE_ID, SANDBOX_ID, ORA_SEED_SET2 |