Transaction Error: You have Material Transaction_id (&MAT_TXN_ID) pending Prior to the Current Transaction. You need to process that first.
Last updated on MARCH 08, 2017
Applies to:Oracle Installed Base - Version 220.127.116.11 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***
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.
The patches detailed below will NOT resolve cases of the error with the cause outlined here
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