My Oracle Support Banner

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.

Symptoms

On : 12.1.3 version,

Inconsistent behavior of on-hand status when we change it from reservable to non-reservable status.

Changes

Change on-hand status from reservable to non-reservable status.

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
Changes
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.