Order Management - EBS (MOSC)

MOSC Banner

Performance problem with oe_order_pub.process_order

edited Dec 20, 2016 4:05AM in Order Management - EBS (MOSC) 1 commentAnswered

Hi,

We have a custom program in Oracle EBS 12.1.1 that creates OM orders. It has now been running for seven years. From the beginning the performance was good but during the years the performance has deteriorated. Tables that were nearly empty seven years ago now contains about a million rows, like tables oe_order_headers_all and oe_order_lines_all.

I checked what takes time in the custom program and the call to API oe_order_pub.process_order often takes between 9 and 80 seconds, per call. On Oracle Support patching is suggested as the remedy for problem. As patches often fix many bugs there will also be a lot of testing, which takes time.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center