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:Oracle Installed Base - Version 126.96.36.199 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms