Performance Issue In Change Line Qty And Save (Doc ID 2280521.1)

Last updated on JUNE 26, 2017

Applies to:

Oracle Advanced Pricing - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Upgrade related issues

ACTUAL BEHAVIOR
---------------
Performance issue in Change line qty and save

Customer recently upgraded EBS from 11.5.10.2 To 12.2.5.
After this, they are getting the below performance issue.

Below is one example with record data :

Navigation: OM Super User – USA > Orders, Returns > Sales Orders.
Query with Order # 36577729 (total 306 order lines on it out of which most of the lines are in Closed status).
Go to line # 13 (or 12) and update the order quantity and save the record, system prompts for changed reason. After giving the changed reason it took 15-20 mins to save the record. Earlier in 11i environment it used to take hardly 2-3 minutes.

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