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 JUNE 04, 2019

Applies to:

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

Goal

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(*)
FROM AR_TRX_BAL_SUMMARY;

2. Create and complete transactions in Accounts Receivable.

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


Solution

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
Goal
Solution

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