My Oracle Support Banner

Troubleshooting Performance Problems in the OZF-TM: Funds Accrual Engine Program Due to the ASO_ORDER_FEEDBACK_T Queue (Doc ID 470174.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Trade Management - Version 11.5.10 and later
Information in this document applies to any platform.

Purpose

Performance problems when running the Funds Accrual Engine after an upgrade or in a fresh instance can be caused by the number of messages in ASO_ORDER_FEEDBACK_T.

Several applications track events that occur in the order fulfillment flow in Order Management. Trade Management tracks budgets/offers to calculate accruals, earnings,..etc. Order Management then feeds for every relevant change in the flow of the order information into the queue ASO_ORDER_FEEDBACK_T. OZF-TM Funds Accrual Engine process the messages in this queue with the Consumer name OZF. If Funds Accrual Engine program is not run for a long time, the queue will grow, as the criteria for message deletion wont ever be met which would cause Performance problem when running Funds Accrual Engine program.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
References

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