FND_BOSS_PN_METADATA

BOSS proper name index physical storage information for indexes defined in FND_BOSS_PN_METADATA.

Details

• Schema: FUSION

• Object owner: FND

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
FND_BOSS_PN_METADATA_PK	ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ID	NUMBER		18	Yes	Unique identifier of the index.
MODULE_NAME	VARCHAR2	255		Yes	Module name in which proper name is present.
BUSINESS_OBJECT_NAME	VARCHAR2	255		Yes	Business object name in which proper name is present.
FIELD_NAME	VARCHAR2	255		Yes	Field Name used for the proper name in the apg.
COLUMN_NAME	VARCHAR2	30		Yes	Mapping column Name of the proper name in the apg.
TABLE_NAME	VARCHAR2	30		Yes	Mapping table Name of the proper name in the apg.
LANGUAGE_CODE	VARCHAR2	4			Language Code for the proper name.
CREATE_VIEW_SQL	CLOB			Yes	View creation statement.
INCREMENTAL_INGESTION_QUERY	CLOB			Yes	Incremental ingestion query statement.
VIEW_NAME	VARCHAR2	30		Yes	View name which is created and added to the proper name index.
INITIAL_INGESTION_STATUS	VARCHAR2	30			Initial Ingestion status of the view.
INITIAL_INGESTION_LOG	VARCHAR2	4000			Initial Ingestion logs for proper name.
INCREMENTAL_INGESTION_STATUS	VARCHAR2	30			Most recent Incremental ingestion status for the proper name.
INCREMENTAL_INGESTION_LOG	VARCHAR2	4000			Most recent Incremental ingestion log for the proper name.
LAST_SYNC_DATE	TIMESTAMP				last time when the proper name data was synced on the index.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of 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.

Indexes

Index	Uniqueness	Tablespace	Columns
FND_BOSS_PN_METADATA_U1	Unique	Default	MODULE_NAME, BUSINESS_OBJECT_NAME, FIELD_NAME, COLUMN_NAME, TABLE_NAME, LANGUAGE_CODE