OE_ORDER_PUB.Process_Order Slow When Updating Order Line.
Last updated on JUNE 20, 2018
Applies to:Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Transaction Booking
OE_ORDER_PUB.Process_Order slow when updating order line, and the performance is getting worse each day.
Should only take minutes.
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.
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