Transaction Error: You have Material Transaction_id (&MAT_TXN_ID) pending Prior to the Current Transaction. You need to process that first.

(Doc ID 1053066.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Installed Base - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 16-May-2016***

CSI_PENDING_PRIOR_TXN
csiviivb.pls
csi_Item_Instance_Vld_pvt

Symptoms

 

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


This error can occur in a number of scenarios:

 ScenarioSymptoms/Steps to Reproduce
1 After flipping the IB Trackable flag on an item from non IB Trackable to IB Trackable Steps to Reproduce The Scenario
a) Create an item with IB Trackable flag set to 'No'
b) Perform various transactions on item such as shipping to external customers and returning
c) Change IB Trackable flag to 'Yes'
d) Subsequent transactions fail with the error
2 Processing RMA Receipt transactions After running the IBtxnerr.sql script found the earliest error is A future transaction is processed. So not processing this.
3 When applying Item Number Change from one item to another in Oracle CMRO Steps to Reproduce The Scenario
a) OSP Administrator > OSP Orders
b) Search order number XXXX > select update > select Modify item > indicate new item number > select button apply
4 After applying patch 6983818 when attempting to ship an exchange item to replace an item that was previously shipped before the Install Base Trackable flag was set Steps to Reproduce The Scenario
1. Manually create Install Base record using Org, Install Date and Start Date from original Sales Order item was shipped out with. Do not populate Installed At address info.
2. Create a Service Request with an Advance Exchange order to ship out an exchange item and return the item you manually created the instance for.
3. Ship out the exchange item
4. Review the Transaction Errors Processing form in Install Base and see error.
5 Creating an item instance manually in the Install Base UI  


All of the above scenarios can result in the following error:

You have Material Transaction_id (&MAT_TXN_ID) pending Prior to the Current Transaction. You need to process that first.

This error can also occur because a transaction which should have been interfaced to Install Base has not been for some unknown reason. In cases such as these the IBtxnerr.sql diagnostic script will show the message Cannot find this transaction in SFM for the transaction referenced in the error.
The patches detailed below will NOT resolve cases of the error with the cause outlined here

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms