FND_OBJECT_INSTANCE_SETS_BK

Stores the backup data of Object Instance Sets that corresponds to an Object. Object Instance Set is nothing but a filter condition used to stripe data. Filter condition can be stored as a predicate or as a Filter XML Document.

Details

• Schema: CSM

• Object owner: FND

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
FND_OBJECT_INSTANCE_SETS_BK_PK	INSTANCE_SET_ID, 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
INSTANCE_SET_ID	NUMBER		18	Yes	INSTANCE_SET_ID
INSTANCE_SET_NAME	VARCHAR2	30		Yes	INSTANCE_SET_NAME
OBJECT_ID	NUMBER		18	Yes	OBJECT_ID
PREDICATE	VARCHAR2	4000			PREDICATE
FILTER	XMLTYPE				Filter column to store instance set as xml based rule.
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.
PROGRAM_NAME	VARCHAR2	30			PROGRAM_NAME
PROGRAM_TAG	VARCHAR2	30			PROGRAM_TAG
CUST_SET_ID	VARCHAR2	300		Yes	Customization Set ID

Indexes

Index	Uniqueness	Tablespace	Columns
FND_OBJECT_INSTANCE_SETS_BK_N1	Non Unique	Default	OBJECT_ID, ENTERPRISE_ID, SANDBOX_ID
FND_OBJECT_INSTANCE_SETS_BK_N2	Non Unique	Default	LAST_UPDATE_DATE, ENTERPRISE_ID, SANDBOX_ID
FND_OBJECT_INSTANCE_SETS_BK_U1	Unique	Default	INSTANCE_SET_ID, ENTERPRISE_ID, SANDBOX_ID, CUST_SET_ID
FND_OBJECT_INSTANCE_SETS_BK_U2	Unique	Default	INSTANCE_SET_NAME, ENTERPRISE_ID, SANDBOX_ID, CUST_SET_ID