OE_ORDER_PUB.Process_Order Slow When Updating Order Line. (Doc ID 1606605.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Transaction Booking

ACTUAL BEHAVIOR
---------------
OE_ORDER_PUB.Process_Order slow when updating order line, and the performance is getting worse each day.

EXPECTED BEHAVIOR
-----------------------
Should only take minutes.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Modified the the OEOH workflow to add a node that will update the order line with payment terms. Noticed that the booking process is slow (even up to 4 hours sometimes) and have narrowed down the issue to the call to OE_ORDER_PUB.Process_Order. The workflow node procedure calls a wrapper package that calls this API and I have added statistics to this wrapper package to tell me start and end times to each API call. One call to this API to update the payment term on the line can take hours. Have not been able to determine why at times it's fast and other times it's slow, butt this situation is getting worse each day.

Wrapper is attached. This wrapper is called from many areas inside Order Management. We are seeing the most impact from it's call from the workflow to update payment_term_id, shipping_method, pricing_date etc. Have noticed that the API is consistently fast when doing a "CREATE". So, in this case, the problem is when doing an "UPDATE".

Uploaded order/line that took over 2 hours to process the API call.


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