Bills Receivable Remittance: The AR Invoice Number (RA_CUSTOMER_TRX_ALL.TRX_NUMBER) Needs to be Used Instead of Invoice ID (RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID) in AR Bill Remittance (RIBA) Format For Italy
Last updated on FEBRUARY 06, 2018
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
Customer is using latest version of IBYC_BR_IT_en.rtf is 120.3.12010000.7 from patch 15883694:R12.IBY.B.
This is being used in conjunction with AR Bills Receivable (BR) Remittance.
The AR Invoice Number (RA_CUSTOMER_TRX_ALL.TRX_NUMBER) needs to be used, instead of Invoice ID (RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID) that is used by IBY.
Receivables doesn't use the Invoice ID in Bills Receivable and the transaction number is only available in Oracle front end.
Currently Documents data is populated from GT tables (IBY_AR_DOC_HEADER_GT).
The query to insert data into IBY_AR_DOC_HEADER_GT for BR is as follows:
Thus, the data is being passed from AR as NULL.
IBY forms extract from the data in GT table. Hence, this fix needs to be done in AR.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms