Error In API Of Inv_loc_wms_pub.update_locator ORA-1403
(Doc ID 2295967.1)
Last updated on JANUARY 03, 2023
Applies to:
Oracle Inventory Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.3 version, Inventory Transactions
Error in API of inv_loc_wms_pub.update_locator
A change was introduced to inv_loc_wms_pub.update_locator to prevent updating locators which have a reservation. This new block of code is producing an unhandled error due to this line "select 1 into l_reservation_flag" when a valid, legitimate stock locator does not exist in tbl_reservations even though l_reservation_flag is defaulted to 0:
*Validation reservation associate with locator
ORA-01403: no data found
ORA-06512: at line xxxx - this equates to whatever line has the statement "select 1 into l_reservation_flag"
01403. 00000 - "no data found"
ERROR
-----------------------
ORA-01403: no data found
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |