CMR_RCV_ERRORS_GT
Global temporary table (session) to store all the CIRT records which come with corrupt data from source system
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Identifier of the source system that owns the Receipt entity | |
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Identifier of the Receiving transaction in the source system | |
| ERROR_CODE | VARCHAR2 | 30 | Error Message Code of receipt transaction. These error codes are mapped to FND_MESSAGES_B | |
| BILL_TO_BUSINESS_UNIT_ID | NUMBER | 18 | Bill to business unit identifier on the receiving transactions. | |
| BUSINESS_UNIT_ID | NUMBER | 18 | Profit center business unit identifier of the receipt transactions. | |
| TOKEN_VALUE1 | VARCHAR2 | 240 | Token Value 1 for error receipt transaction. | |
| TOKEN_VALUE2 | VARCHAR2 | 240 | Token Value 2 for error receipt transaction. | |
| TOKEN_VALUE3 | VARCHAR2 | 240 | Token Value 3 for error receipt transaction. |