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 MARCH 08, 2017

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!

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