Install Base Transaction Error Troubleshooting
By LuciaC-Oracle on Dec 19, 2012
Oracle Installed Base is an item instance life cycle tracking application that facilitates enterprise-wide life cycle item management and tracking capability.
In a typical process flow a sales order is created and shipped, this updates Inventory and creates a new item instance in Install Base (IB). The Inventory update results in a record being placed in the SFM Event Queue. If the record is successfully processed the IB tables are updated, if there is an error the record is placed in the csi_txn_errors table and the error needs to be resolved so that the IB instance can be created.
It's extremely important to be proactive and monitor IB Transaction Errors regularly. Errors cascade and can build up exponentially if not resolved. Due to this cascade effect, error records need to be considered as a whole and not individually; the root cause of any error needs to be resolved first and this may result in the subsequent errors resolving themselves.
Install Base Transaction Error Diagnostic Program
In the past the IBtxnerr.sql script was used to diagnose transaction errors, this is now replaced by an enhanced concurrent program version of the script. See the following note for details of how to download, install and run the concurrent program as well as details of how to interpret the results:
Doc ID 1501025.1 - Install Base Transaction Error Diagnostic Program
Watch the replay of the 'EBS CRM: 11i and R12 Transaction Error Troubleshooting - an Overview' webcast or download the presentation PDF (go to Doc ID 1455786.1 and click on 'Archived 2011' tab). The webcast and PDF include more information, including SQL statements that you can use to identify errors and their sources as well as recommended setup and troubleshooting tips.
Refer to these notes for comprehensive information:
- Doc ID 1275326.1: E-Business Oracle Install Base Product Information Center
- Doc ID 1289858.1: Install Base Transaction Errors Master Repository
- Doc ID: 577978.1: Troubleshooting Install Base Errors in the Transaction Errors Processing Form
Don't forget your Install Base Community where you can ask questions to help you resolve your IB transaction errors.