CMF_PROCESS_ERRORS

This table stores errors occurred during the execution of background processes in fiscal document capture.

Details

  • Schema: FUSION

  • Object owner: CMF

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CMF_PROCESS_ERRORS_PK

PROCESS_ERROR_ID

Columns

Name Datatype Length Precision Not-null Comments
PROCESS_ERROR_ID NUMBER 18 Yes Process error detail row identifier.
PROCESS_NAME VARCHAR2 250 Yes Name of the CMF process being detailed.
TABLE_NAME VARCHAR2 30 Yes Table name to which this errored transaction belongs.
FISCAL_DOC_HEADER_ID NUMBER 18 Identifies the fiscal document in the error records.
FISCAL_DOC_LINE_ID NUMBER 18 Identifies the fiscal document line in the error record.
FISCAL_DOC_SCHEDULE_ID NUMBER 18 Identifies the fiscal document schedule in the error record.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
TABLE_ROW_ID VARCHAR2 18 Table Row Id stores the surrogate key reference or table rowid to uniquely identify the row within the given table.
ERROR_CODE VARCHAR2 30 Identifies error code during the processing of transaction. It maps to FND_MESSAGES.MESSAGE_NAME.
ERROR_MESSAGE VARCHAR2 1000 Error message details will be stored here
TOKEN1_NAME VARCHAR2 30 Token name as required by error code message.
TOKEN1_VALUE VARCHAR2 240 Token value as required by error code message.
TOKEN2_NAME VARCHAR2 30 Token name as required by error code message.
TOKEN2_VALUE VARCHAR2 240 Token value as required by error code message.
TOKEN3_NAME VARCHAR2 30 Token name as required by error code message.
TOKEN3_VALUE VARCHAR2 240 Token value as required by error code message.
TOKEN4_NAME VARCHAR2 30 Token name as required by error code message.
TOKEN4_VALUE VARCHAR2 240 Token value as required by error code message.
TOKEN5_NAME VARCHAR2 30 Token name as required by error code message.
TOKEN5_VALUE VARCHAR2 240 Token value as required by error code message.
TOKEN6_NAME VARCHAR2 30 Token name as required by error code message.
TOKEN6_VALUE VARCHAR2 240 Token value as required by error code message.
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_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Indexes

Index Uniqueness Tablespace Columns
CMF_PROCESS_ERRORS_N1 Non Unique FUSION_TS_TX_IDX REQUEST_ID, JOB_DEFINITION_NAME
CMF_PROCESS_ERRORS_N2 Non Unique Default FISCAL_DOC_HEADER_ID, FISCAL_DOC_LINE_ID
CMF_PROCESS_ERRORS_U1 Unique FUSION_TS_TX_IDX PROCESS_ERROR_ID