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 APRIL 04, 2025

Applies to:

Symptoms

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.

Cause

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