Table not found error when calling any public API
Last updated on NOVEMBER 08, 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]
Oracle Bills of Material - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.
On 11.5.10 in Production:
When attempting to call the any Oracle Public API, the following error occurs.
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_.
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.
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