Inconsistent Behavior Of Onhand Status
(Doc ID 1495362.1)
Last updated on JANUARY 03, 2023
Applies to:Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.
In INVCYCLB.pls file,the procedure existing_serial_number is querying for serials and in where clause is_serial_load function
used to check for loaded SNs. Because of this query the performance is very poor as it is calling the function for all
rows and there is no check for current status in where clause.
On : 12.1.3 version,
Inconsistent behavior of on-hand status when we change it from reservable to non-reservable status.
Change on-hand status from reservable to non-reservable status.
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