My Oracle Support Banner

API USER_PKG_LOT.USE_EXPIRED_LOTS Is Not Working As Expected (Doc ID 1297637.1)

Last updated on SEPTEMBER 11, 2019

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In version 12.1.3, Oracle allows Expired Lot in the Move Order Allocation process. A warning appears when attempting to Transact Move Order (An expired lot is allocated, do you want to continue).
When you modify the function USER_PKG_LOT.USE_EXPIRED_LOTS to return true, the lots expired could be selected.
You see the same result regardless of whether function return false or true.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.