Table not found error when calling any public API (Doc ID 388514.1)

Last updated on JULY 19, 2017

Applies to:

Oracle Shipping Execution - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Oracle Inventory Management - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Oracle Purchasing - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Oracle Order Management - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Symptoms

On 11.5.10 in Production:
When attempting to call the any Oracle Public API,  the following error occurs.

ERROR
The called procedure only returns a return_status code of E
Customer then calls APPS.WSH_UTIL_CORE.GET_MESSAGES and gets the following error message:
ORA-00942: table or view does not exist ORA-00942: table or view does not exist in Package WSH_DELIVERIES_PUB Procedure _x_.


STEPS
The issue can be reproduced at will with the following steps:
1. Customer is calling the public APPS.Wsh_Deliveries_Pub.Create_Update_Delivery from third party software, in order to import deliveries into Order Management
2. Error occurs when the API is called.
3. This same error can occur when calling any Oracle Public API, regardless  of which e-Business Suite module is being used.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms