My Oracle Support Banner

Transactions Workbench: Balance Forward Bills Program is Inserting Data in the AR_CONS_INV_TRX_ALL Table with XXXXXXXXXX (Doc ID 1630150.1)

Last updated on JULY 10, 2020

Applies to:

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


There are a lot of bad data with TRANSACTION_TYPE = 'XXXXXXXXXX' created after running 'Generate Balance Forward Bills'.

Existing customers, with many receipt applications at the detail level, have already been processed have an XXXXXXXXXX record created.

There are around 10~20 thousand transactions every month, which generates around one million rows data with TRANSACTION_TYPE = 'XXXXXXXXXX' every time.

This is reproducible each time and requires the code fix.
The code fix provided by <Bug 8208763> seems partial and does not address the scenario here.




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.