Skip to Main Content
This is a BETA environment
This environment is only for testing and may be reset multiple times during the testing period. We will be frequently upgrading this BETA environment, so check back often for changes. Please assist us by providing feedback via the bug icon to the left of your profile avatar. For the current active community, visit

ORA-01403: no data found in Package OE_Order_Cache Procedure Load_Order_Typ

3743099Jan 12 2008
Hi all,

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!
Post Details
Added on Jan 12 2008