My Oracle Support Banner

Workflow Agent Listener Service Used But Does Not Refresh Summary Table AR_TRX_BAL_SUMMARY (Doc ID 353630.1)

Last updated on MAY 05, 2021

Applies to:

Oracle Credit Management - Version to [Release 11.5.10]
Information in this document applies to any platform.


On version 11.5.10 the Workflow Agent Listener is a Service and no longer a concurrent program.
It is expected that the business events will be correctly processed by the WFAL Service, but this is not the case.

The Workflow Agent Listener Service WF_DEFERRED is currently enabled on the environments. However, this does not refresh the AR_TRX_BAL_SUMMARY table.

The AR_TRX_BAL_SUMMARY table is used in Advanced Collections in the UWQ/Collectors Work Queue.

The following steps are taken to check this:
1.  Run:
SELECT count(*)

2. Create and complete transactions in Accounts Receivable.

3. Run again:
SELECT count(*)
Result: no change in count.


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

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