INV_LOC_WMS_PUB.CREATE_LOCATOR FAILS WITH RETURN STATUS U, SQLERRM ORA-0000 (Doc ID 1050712.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Inventory Management - Version: 11.5.10.2 to 12.1.3 - Release: 11.5.10 to 12.1
Information in this document applies to any platform.
INV_LOC_WMS_PUB

Symptoms

On : 12.0.6 version, Setup of orgs, subs, locators

When attempting to create new locators with API INV_LOC_WMS_PUB.CREATE_LOCATOR, the following error occurs.

ERROR
-----------------------
Return Status U
# of Errors 1
Error Could not create locator.
inventory_location_id
locator_exists
SQLCODE 0
SQLERRM ORA-0000: normal, successful completion


STEPS
-----------------------
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.

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