How to Create Installed Base Concurrent Program 'Integration Fix - IB Error Transaction' (Doc ID 1538138.1)

Last updated on JUNE 21, 2022

Applies to:

Goal

This document is to help users understand how to create a comprehensive data fix concurrent program called Integration Fix - IB Error Transaction for both non-serialized or serialized items.

Why Installed Base Error Transactions happen

•     Item control attributes (Installed Base trackable, IB tracking level, Serial, lot, revision control) are changed in the middle of business and standard change procedure was not correctly followed.
•     Incorrect/unsupported business flow or incorrect set up
•     Data Corruption caused by the code bugs
•     User errors and unverified user update through API
•     Previously incorrect data fix attempts.

How this concurrent program works

   The fix is majorly based on two separated type items - serialized or non-serialized control

     For non-serialized

•     The majority error transactions are due to instance's on hand quantity is out of sync with on hand quantity in inventory, duplicated instances are in the same physical location or there is no reference instance entered for RMA return (refer to note390035.1).

•     The fix is to sync on hand quantity with INV, merge duplicated instances and auto populate reference for RMA receipt transactions.

     For serialized

•     The majority error transactions for serialized item are due to instance's location is out of sync with inventory location.
•     The fix is to go through each serial number of each error transaction and verify the correct location it should be based on last processed inventory transaction.  If the serial number instance is not in the correct location then move it to correct location.

   The fix also check error transaction's serial, lot situation when the transaction happened compare with current item's serial lot control and determine if the attribute control is changed and should be taken into consideration.

What type error transactions are fixed by the concurrent program

        Usually you will see the following error messages in 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).'

                '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’

Solution