INV_LOC_WMS_PUB.CREATE_LOCATOR FAILS WITH RETURN STATUS U, SQLERRM ORA-0000
Last updated on AUGUST 21, 2016
Applies to:Oracle Inventory Management - Version: 188.8.131.52 to 12.1.3 - Release: 11.5.10 to 12.1
Information in this document applies to any platform.
When attempting to create new locators with API INV_LOC_WMS_PUB.CREATE_LOCATOR, the following error occurs.
Return Status U
# of Errors 1
Error Could not create locator.
SQLERRM ORA-0000: normal, successful completion
The issue can be reproduced at will with the following steps:
1. customer has created wrapper test2_sql.txt emulating the example in Locator Maintenance APIs.txt
2. when he runs if for locator test in subinventory GENERAL it errors
Note: Customer does not have WMS installed, but this appears to be a valid API for non WMS customers.
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