1. Tables and Views for SCM
  2. CMR_PROCESS_ERRORS

CMR_PROCESS_ERRORS

This table stores all the errors for transactions occurred during transaction processing by back ground processes in receipt accounting

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CMR_PROCESS_ERRORS_PK

CMR_PROCESS_ERROR_ID

Columns

Name Datatype Length Precision Not-null Comments Status
CMR_PROCESS_ERROR_ID NUMBER 18 Yes Process Error Identifier and surrogate key column. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
PROCESSOR_NAME VARCHAR2 30 Yes identifies the processor name - 1. Receipt Accounting Distribution processor 2.Unvinvoice Receipt Accrual process 3.match Receipt Accrual Process 4.Accrual Auto Clear process Active
ERROR_CODE VARCHAR2 30 Yes identifies error code during the processing of transaction. It maps to FND_MESSAGES.MESSAGE_NAME. Active
ERROR_COUNT NUMBER Count of transaction errors for a error code
TABLE_NAME VARCHAR2 30 Yes table name to which this errored transaction belongs Active
BILL_TO_BUSINESS_UNIT_ID NUMBER 18 Bill to Business unit identifier
BUSINESS_UNIT_ID NUMBER 18 Business unit identifier where transactions are accounted
SOLD_TO_BUSINESS_UNIT_ID NUMBER 18 Pre R9: business unit identifier where accrual is accounted Active
ERROR_CATEGORY VARCHAR2 30 This column gives details about error category. PO Currency Conversion - if it is PO currency conversion issue and Ledger Currency Conversion - if it is related to ledger currency conversion issue
INVENTORY_ITEM_ID NUMBER 18 Inventory Item Identifier andReferences {EGP_SYSTEM_ITEMS_B.inventory_item_id}. Active
INVENTORY_ORGANIZATION_ID NUMBER 18 Inventory organization Identifier of transactions.
TOKEN1_NAME VARCHAR2 30 Token name as required by error code message Active
TOKEN1_VALUE VARCHAR2 240 Token value as required by error code message Active
TOKEN2_NAME VARCHAR2 30 Token name as required by error code message Active
TOKEN2_VALUE VARCHAR2 240 Token value as required by error code message Active
TOKEN3_NAME VARCHAR2 30 Token name as required by error code message Active
TOKEN3_VALUE VARCHAR2 240 Token value as required by error code message Active
TOKEN4_NAME VARCHAR2 30 Token name as required by error code message Active
TOKEN4_VALUE VARCHAR2 240 Token value as required by error code message Active
TOKEN5_NAME VARCHAR2 30 Token name as required by error code message Active
TOKEN5_VALUE VARCHAR2 240 Token value as required by error code message Active
TOKEN6_NAME VARCHAR2 30 Token name as required by error code message Active
TOKEN6_VALUE VARCHAR2 240 Token value as required by error code message Active
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.
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.
CMR_PO_DISTRIBUTION_ID NUMBER 18 Single column FK: Identifies entity in Receipt accounting PO Distributions. This value will exist for match to PO as well as match to Receipt cases. Active
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 Active
TRANSACTION_DATE TIMESTAMP The date when this transaction happened. Active
CMR_RCV_TRANSACTION_ID NUMBER 18 Stores receipt transaction identifier
EXCEPTION_SOURCE VARCHAR2 30 This columns displays the source from where the exception has occurred

Indexes

Index Uniqueness Tablespace Columns Status
CMR_PROCESS_ERRORS_N1 Non Unique Default ERROR_CODE, TABLE_NAME, BILL_TO_BUSINESS_UNIT_ID, BUSINESS_UNIT_ID, INVENTORY_ORGANIZATION_ID, INVENTORY_ITEM_ID, ERROR_CATEGORY, TABLE_ROW_ID Obsolete
CMR_PROCESS_ERRORS_N2 Non Unique FUSION_TS_TX_DATA REQUEST_ID
CMR_PROCESS_ERRORS_N3 Non Unique Default BILL_TO_BUSINESS_UNIT_ID, ERROR_CODE, TABLE_NAME, BUSINESS_UNIT_ID, INVENTORY_ORGANIZATION_ID, INVENTORY_ITEM_ID, ERROR_CATEGORY, TABLE_ROW_ID
CMR_PROCESS_ERRORS_PK Unique FUSION_TS_TX_DATA CMR_PROCESS_ERROR_ID