My Oracle Support Banner

On-Hand Exists Having an Owning Organization Id Value of Non-Existent Organization (Doc ID 2614925.1)

Last updated on JUNE 15, 2020

Applies to:

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


  1. There are on-hand quantity records (table MTL_ONHAND_QUANTITIES_DETAILS) having a not null owning organization id value.
    The owning organization id value is invalid as there is no corresponding organization with this organization id (table MTL_PARAMETERS).
    In addition, there are similar transaction history records (table MTL_MATERIAL_TRANSACTIONS) with the same invalid owning_organization_id value.

  2. It is unknown if on-hand with the invalid owning organization id can be transacted (has not been tested).
    At the verify least, the invalid value prevents concurrent program "Consolidate Inventory Onhand Quantites"
    from consolidating on-hand quantity for these records  if the records should have OWNING_ORGANIZATION_ID = ORGANIZATION_ID

    Refer to <Note 353345.1> - Consolidate Onhand Quantity /Sum Quantity Zero in MTL_ONHAND_QUANTITIES_DETAIL (MOQD) / Concurrent Program Consolidate Inventory Onhand Quantites (Quantities) / Datafix for 0 Quantity Displayed For Finished Goods

  3. The following queries identify the records:



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.