My Oracle Support Banner

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 (Doc ID 1541168.1)

Last updated on JULY 10, 2020

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.