FND_TREE_VERSION_AUDIT_RES

Tree Version Audit Resoult storage for batch mode auditing of tree versions.

Details

  • Schema: FUSION

  • Object owner: FND

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

FND_TREE_VERSION_AUDIT_RE_PK

REQUESTID, AUDIT_RESULT_ID, ENTERPRISE_ID

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
DETAIL_MESSAGE VARCHAR2 1024 Detail error Message during audit.
REQUESTID NUMBER 20 Yes REQUESTID
AUDIT_RESULT_ID VARCHAR2 32 Yes AUDIT_RESULT_ID
TREE_STRUCTURE_CODE VARCHAR2 32 Yes TREE_STRUCTURE_CODE
TREE_CODE VARCHAR2 30 Yes TREE_CODE
TREE_VERSION_ID VARCHAR2 32 Yes TREE_VERSION_ID
VALIDATOR_CODE VARCHAR2 30 Yes VALIDATOR_CODE
VALIDATION_PASS VARCHAR2 1 Yes VALIDATION_PASS
CORRECTIVE_ACTION VARCHAR2 30 CORRECTIVE_ACTION
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.

Indexes

Index Uniqueness Tablespace Columns
FND_TV_AUDIT_RES_U1 Unique Default REQUESTID, AUDIT_RESULT_ID, ENTERPRISE_ID