Performance Issue in OM Customer Acceptance Form (Doc ID 1902584.1)

Last updated on JULY 13, 2016

Applies to:

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

Symptoms

Performance issue with customer acceptance function. The client calls Oe_Acceptance_Pvt.Process_Acceptance to process the data. Two sqls related to ra_cust_trx_line_gl_dist spend much time in whole process;they are executed thousands of times.

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