ORA-01403: no data found in Package OE_Order_Cache Procedure Load_Order_Typ
We are facing issues while using DB Adapter (on ESB) to invoke the Oracle Applications Package HZ_CUST_ACCOUNT_V2PUB (Create Customer Account - For Person party) .
Sometimes, while invoking the package we get the following error response from the API:
ORA-01403: no data found in Package OE_Order_Cache Procedure Load_Order_Type
This error occurs without any type of pattern. We even retry invoking the package with the same payload after some time and the order got in successfully !
Any help on the matter would be pretty much appritiated!