My Oracle Support Banner

Troubleshooting "You have Material Transaction_id (&MAT_TXN_ID) errored / pending Prior to the Current Transaction. You need to process that first." in Install Base (Doc ID 1452814.1)

Last updated on JANUARY 18, 2018

Applies to:

Oracle Installed Base - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Purpose

*****Checked for relevance 29-May-2014*****

Material Transactions against Install Base trackable Inventory items are interfaced to Install Base via Service Fulfilment Manager (SFM). The details of the transaction are placed in the  SFM Event Queue Manager Service message queue and processed sequentially. On successful interface to Install Base the transaction message is marked in the SFM message queue table (XNP_MSGS) as PROCESSED. If for any reason the interface to Install Base is unsuccessful the transaction message is marked as FAILED.

Material transaction messages that are successfully PROCESSED through SFM are then processed by Install Base to update the relevant item instances according to the type of transaction being processed. There are a number of validation steps which occur in Install Base as it processes the transactions. If any of these validation steps encounters a problem an error record is written to the Install Base transaction errors table (CSI_TXN_ERRORS). If no problems are encountered then the relevant item instance(s) on the transaction are updated appropriately and the successful transaction is recorded in the Install Base transactions table (CSI_TRANSACTIONS).

Two of the most common errors that can occur during the Install Base transaction validation process are:

You have Material Transaction_id (&MAT_TXN_ID) errored Prior to the Current Transaction. You need to process that first. [Error Code: CSI_ERROR_PRIOR_TXN]
You have Material Transaction_id (&MAT_TXN_ID) pending Prior to the Current Transaction. You need to process that first. [Error Code: CSI_PENDING_PRIOR_TXN]

This document provides guidance on how to troubleshoot these errors

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 1. Troubleshooting error code CSI_ERROR_PRIOR_TXN
 1.1 Diagnosing The Issue
 2. Troubleshooting error code CSI_PENDING_PRIOR_TXN
  2.1 Diagnosing the issue
 2.2 Submitting Missing Transactions To SFM
 2.3 Reprocessing FAILED Transactions In SFM
 2.4 Verifying Successful Install Base Integration
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.