My Oracle Support Banner

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 OCTOBER 19, 2023

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.

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:

  Scenario Symptoms/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

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.