How to Create Installed Base Concurrent Program 'Integration Fix - Non Serial or Serial at Sales Order Issue'

Last updated on MARCH 21, 2018

Applies to:

Goal

This document is to help users understand how to create a comprehensive data fix concurrent program called Integration Fix - Non Serial or Serial at Sales Order Issue for non-serialized or serialized at sales order issue items.

In Installed Base, Inventory instances for a non-serialized items or serialized at sales order issue items are in a location pool grouped by item, lot number, revision, inventory organization, subinventory and locator.

There are two situations that can happen in Oracle Installed Base for these inventory instances:

1) Installed Base on hand quantity is out of synch from Oracle Inventory

    For example:  In Oracle Inventory Item1 has quantity 10 in organization 123, subinventory 'STAGING' but in Oracle Installed Base Item1 has only quantity = 2 in organization 123, subinventory 'STAGING'

2) Installed Base has more than one instance in the exact same inventory location. 

The above two situations are mostly due to a missing step during Installed Base implementation, Inventory on hand quantity was not brought to Oracle Installed Base when Installed Base went live, due to pending error transactions in Installed Base interface, or due to code problem in <Bug 11061556> <Bug 15840470> <Bug 13821497> instances are incorrectly updated.

In first case, usually you will see the following error messages in Oracle Installed Base error transaction interface (table csi_txn_errors), or in Oracle debrief submission etc.

     'The source item instance &ITEM, in Subinventory &SUBINVENTORY, for Organization &ORG_ID in Oracle Install Base does not exist. Please verify that any receipt transactions were  successful.'

     'This transaction will drive the instance quantities to negative. Negative balances are not allowed for this subinventory.'

     'Invalid quantity specified for the item instance. An instance cannot be created with a negative quantity'

     'No instance is found for the inventory location attributes'

     'Shipment cannot be done because Negative quantities are not allowed for this organization (&ORG_ID).'

In second case, usually you will receive the following error messages Oracle Installed Base error transaction interface (table csi_txn_errors), or in Oracle debrief submission etc

    'Multiple active item instances for inventory item &INV_ITEM were found.'

    'Multiple active instances found for the item attributes provided.
        Inventory Item ID : &INV_ITEM_ID
        Organization ID   : &INV_ORG_ID
        Sub-Inventory     : &SUBINV
        Locator ID        : &LOCATOR
        Action: Check for duplicate inventory records found in CSI_ITEM_INSTANCES’

The concurrent program created in this note is to fix the problems through the following steps:

1. Merge multiple instances to a single one instance

2. Reprocess all pending error transactions

3. Synchronize on hand quantity currently in Oracle Inventory to Oracle Installed Base to prevent any further errors from happening

Solution