CMR_AP_ERRORS_GT

Global temporary table (session) to store all the CIAID records which come with corrupt data from source system

Details

  • Schema: FUSION

  • Object owner: FUSION

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Comments
EXTERNAL_SYSTEM_REFERENCE VARCHAR2 60 Identifier of the source system that owns the Invoice entity
EXTERNAL_SYSTEM_REF_ID VARCHAR2 30 Identifier of the Invoice in the source system
ERROR_CODE VARCHAR2 30 Error Message Code on the invoice distribution lines and these error code maps to FND_MESSAGES_B
BILL_TO_BUSINESS_UNIT_ID NUMBER 18 Bill to business unit identifier. Indicates the invoicing business unit on purchase orders.
BUSINESS_UNIT_ID NUMBER 18 Profit Center business unit of purchase order.
TOKEN_VALUE1 VARCHAR2 240 Token Value stored populated on error type of invoice distribution.
TOKEN_VALUE2 VARCHAR2 240 Token Value 2 -populated based on error type of invoice distribution.
TOKEN_VALUE3 VARCHAR2 240 Token Value 3 -populated based on error type of invoice distribution.