My Oracle Support Banner

Inconsistent Behavior Of Onhand Status (Doc ID 1495362.1)

Last updated on AUGUST 08, 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

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