My Oracle Support Banner

Bills Receivables Number Transaction Autonumbering Is Not Reflected On PAYMENT_TRXN_EXTENSION_ID (Doc ID 2606211.1)

Last updated on DECEMBER 11, 2019

Applies to:

Oracle Receivables - Version 12.2.3 and later
Information in this document applies to any platform.


The client creates a bill receivable document (short : "BR") and it has setups for assigning a sequence to the BR.

The record in IBY_FNDCPT_TX_EXTENSIONS is created with old number (before it is assigned the sequence number) in order_id in table IBY_FNDCPT_TX_EXTENSIONS, not the new doc number obtained from the sequence.

this way, further processing for this BR in Payments/ iby are wrong, they are refering the old Br's number which does not exist any more in AR. The client has a BR number but the payment process would need to be for a different BR number, so they may refuse to pay the wrong BR number.

PACKAGE BODY AR_BILLS_MAINTAIN_PUB ARBRMAIB.pls versions lower than  120.14.12020000.5

Also make sure to be on latest versions for :




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.