Update Quote with oe_order_pub.process_order has issue "could not find program unit being called"
Hi,
I am trying to update a quote that is in DRAFT status by calling the oe_order_pub.process_order API.
However, when I try to test my code by calling it from an anonymous block, I get the following error:
Calling overloaded Process_order api by passing out parameter billing plan usage tier tbl
ORA-06508: PL/SQL: could not find program unit being called in Package OE_Delayed_Requests_PVT Procedure Clear_Request
ORA-06508: PL/SQL: could not find program unit being called in Package OE_Header_Util Procedure Get_customer_info_ids
What is confusing me is that I exposed this API in ORDS and called it as a web service and it works as expected. But when I call again from my anonymous block, I get the above error. I even tried recompiling these packages. Then another package will have the same issue and eventually after a full circle, the initial packages will start to appear.