Performance problem with oe_order_pub.process_order
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.