My Oracle Support Banner

Autoinvoice Not Updating AR_TRX_BAL_SUMMARY (Doc ID 1394488.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.


After the AutoInvoice is completed, the business events should update the table AR_TRX_BAL_SUMMARY.

For other events like creating a manual transaction, receipt, adjustment the business events are working properly.

1. Run the program Refresh AR Transactions Summary Tables and check the table AR_TRX_BAL_SUMMARY
The results are OK
2. Select a customer with no open balance (no invoices, receipts etc) and create an invoice through AutoInvoice
3. Check the table AR_TRX_BAL_SUMMARY (after a few minutes) > nothing updated
4. Check the sql
select wfd.user_data.EVENT_NAME EVENT_NAME,
0, '0 = Ready',
1, '1 = Delayed',
2, '2 = Retained',
3, '3 = Exception',
to_char(substr(wfd.state,1,12))) State,
count(*) COUNT
from applsys.wf_deferred wfd
group by wfd.user_data.EVENT_NAME, wfd.state
order by 3 desc, 1 asc;
Results: no records founds


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 File(s)
 3. Recommended Patch(es)

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