My Oracle Support Banner

Autoinvoice Not Updating AR_TRX_BAL_SUMMARY (Doc ID 1394488.1)

Last updated on OCTOBER 01, 2018

Applies to:

Oracle Receivables - Version: 12.1.2 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms

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,
decode(wfd.state,
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

Cause

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
  Symptoms
  Cause
  Solution
     1. Bug Summary
     2. Fixed File(s)
     3. Recommended Patch(es)
  References

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