CMR_PROCESS_ERRORS_GT
Stores receipt accounting process errors and error rows are moved to persistent table.
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_ERROR_ID | NUMBER | 18 | Transaction error Identifier and surrogate key column. | ||
| CMR_PROCESS_ERROR_ID | NUMBER | 18 | Process Error Identifier and maps to {CMR_PROCESS_ERRORS.CMR_PROCESS_ERROR_ID} | ||
| CMR_RCV_TRANSACTION_ID | NUMBER | 18 | Receipt accounting Receiving Transaction identifier. | ||
| BILL_TO_BUSINESS_UNIT_ID | NUMBER | 18 | Bill to Business Identifier of error transaction. | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Profit center business Unit identifier of error transaction. | ||
| PROCESSOR_NAME | VARCHAR2 | 30 | Receipt accounting process schedule name and pre-process name to identify the error transactions error stage.. | ||
| TABLE_NAME | VARCHAR2 | 30 | Yes | Name of the table has a error txn. The table names are receipt accounting tables. | |
| ERROR_CODE | VARCHAR2 | 30 | Yes | Error indicator of error transaction. These error code maps to {FND_MESSAGES_B.MESSAGE_NAME} | |
| ERROR_CATEGORY | VARCHAR2 | 30 | Category of error transactions.Supported values - Warning and Error. | ||
| TOKEN1_NAME | VARCHAR2 | 30 | Token name of error transaction. This is applicable for specific error codes. | ||
| TOKEN1_VALUE | VARCHAR2 | 240 | Token value of error transaction. This is applicable for specific error codes. | ||
| TOKEN2_NAME | VARCHAR2 | 30 | Token Name of error transaction. This is applicable for specific error codes. | ||
| TOKEN2_VALUE | VARCHAR2 | 240 | Token Value of error transaction. This is applicable for specific error codes. | ||
| TOKEN3_NAME | VARCHAR2 | 30 | Token Name of error transaction. This is applicable for specific error codes. | ||
| TOKEN3_VALUE | VARCHAR2 | 240 | Token Value of error transaction. This is applicable for specific error codes. | ||
| TOKEN4_NAME | VARCHAR2 | 30 | Token Name of error transaction. This is applicable for specific error codes. | ||
| TOKEN4_VALUE | VARCHAR2 | 240 | Token Value of error transaction. This is applicable for specific error codes. | ||
| TOKEN5_NAME | VARCHAR2 | 30 | Token Name of error transaction. This is applicable for specific error codes. | ||
| TOKEN5_VALUE | VARCHAR2 | 240 | Token Value of error transaction. This is applicable for specific error codes. | ||
| TOKEN6_NAME | VARCHAR2 | 30 | Token Name of error transaction. This is applicable for specific error codes. | ||
| TOKEN6_VALUE | VARCHAR2 | 240 | Token Value of error transaction. This is applicable for specific error codes. | ||
| TRADE_EVENT_ID | NUMBER | 18 | Trade Event Identifier of error transaction and maps to {CST_TRADE_EVENTS.TRADE_EVENT_ID}. | ||
| CMR_PO_DISTRIBUTION_ID | NUMBER | 18 | Receipt accounting Purchase order distribution identifier | ||
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | External System Reference of error transaction. | ||
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | External system reference of error transaction. | ||
| ACCOUNTING_EVENT_ID | NUMBER | 18 | Accounting event identifier of error transactions and maps to CMR_RCV_EVENTS.ACCOUNTING_EVENT_ID | ||
| TRADE_OVERHEAD_ID | NUMBER | 18 | Trade Overhead Identifier of error transaction and maps to CMR_TRADE_OVERHEADS.TRADE_OVERHEAD_ID | ||
| TRANSACTION_ID | NUMBER | Stores cmr_transactions table reference key column if any error report based on receipts in cmr_transaction table |