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 transaction. 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. | |||
| CHARGE_ESTIMATE_ID | NUMBER | 18 | A value that identifies a charge estimate in Landed Cost Management. | ||
| CHARGE_ACTUAL_ID | NUMBER | 18 | A value that identifies a charge actual in Landed Cost Management. |