Install Base Transaction Error Troubleshooting
- by LuciaC
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  The program provides comprehensive information about the errors found as well as links to known knowledge articles which can help to resolve the specific error. 
    
    
  Troubleshooting 
    
  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.