CMR_PO_DIST_ERRORS_GT

Global temporary table (session) to store all the CIPOD 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 purchase order entity
EXTERNAL_SYSTEM_REF_ID VARCHAR2 30 Identifier of the purchase order distribution line in the source system
ERROR_CODE VARCHAR2 30 Error Message Name and maps to FND_MESSAGES_B.
TOKEN_VALUE VARCHAR2 240 Attribute Token Value to store error specific attribute value.
BILL_TO_BUSINESS_UNIT_ID NUMBER 18 Bill to Business Unit Identifier
BUSINESS_UNIT_ID NUMBER 18 Business Unit Identifier of receipts transactions are accounted.