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 MARCH 06, 2023

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

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