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