My Oracle Support Banner

Secondary quantity fields are populating as null (Doc ID 2641618.1)

Last updated on FEBRUARY 21, 2020

Applies to:

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

Symptoms

On : 12.2.6 version, Onhand and Availability

ACTUAL BEHAVIOR

---------------
Secondary Quantity is populating Null


EXPECTED BEHAVIOR
-----------------------
onhand should be sum quantity for same item, sub,and locator

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Create batch OSP
  2. Create job with secondary UOM enabled item and transact
  3. Complete the job
  4. Current behavior: Secondary Quantity and secondary UOM fields are populating as null in MOQD table for dual UOM
    control item is causing data corruption issue

Changes

With the fix: Secondary Quantity and  secondary UOM fields will now populated
in MOQD  

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.