Lot Without Any Reservations Fails Change Status With Error: Cannot Change the Status if Reservations Are Associated With This Entity (Lot Status Hook) (Doc ID 1903525.1)

Last updated on FEBRUARY 09, 2017

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Oracle Warehouse Management - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.
INV_RESV_STATUS_INVALID
INV_MATERIAL_STATUS_HOOK
Lot Status Hook

Goal

Why when try to change Lot Status, do users get an error?
Have no reservations on this lot but have high level reservations on the item.

Note: High level reservations without the lot are automatically created when a user allocates material for a pickwave move order on a sales order. The reservation remains high level (without a lot) even when the user allocates a specific lot.

ERROR
Cannot change the status if reservations are associated with this entity.

Expected Behavior
Expect that the lot status should work without error because there is no reservation on this specific lot.
 

Solution

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