Funds Accrual Engine Program Running Very Slowly Post Upgrade To R12.1.3 (Doc ID 2252438.1)

Last updated on APRIL 06, 2017

Applies to:

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

Symptoms

Trade Management Administrator > Concurrent Request:

Funds Accrual Engine was running in half an hour in R12.1.1 but post upgrade to R12.1.3 it's taking 3 days to run. We did some initial analysis and found out that the query on RA_CUSTOMER_TRX_LINES_ALL seems to be causing this performance issue. Could you please suggest a solution for this issue.



Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms