WIP, EAM, or Service Work Order Completion Transactions 'Stuck' In MTLTRANSACTIONS_INTERFACE (Transaction Open Interface) With Error Message 'total txn qty-cap must be less than or equal to qty avail to complete' (Doc ID 1457334.1)

Last updated on FEBRUARY 27, 2022

Applies to:

Oracle Inventory Management - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2]
Oracle Cost Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Enterprise Asset Management - Version 12.1.3 and later
Oracle Work in Process - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

Scenario 1.

There are WIP, EAM, or Service Work Order Completion Transactions 'Stuck' In MTLTRANSACTIONS_INTERFACE table with Error Message:

ERROR

'total txn qty-cap must be less than or equal to qty avail to complete'.

Steps to reproduce the issue:

1. Go to: Inventory - Transactions - Transaction Open Interface.

2. Find Errored Transactions.

3. Error Explanation = "total txn qty-cap must be less than or equal to qty avail to complete", note the Transaction Source.

The error records in Material Transaction Interface can also be found using the following Select statement:

Scenario 2.

When attempting to use the table MTL_TRANSACTIONS_INTERFACE to report production and waste, the information arrives correctly the table, but the concurrent process does not do it correctly and leaves the transactions pending in the open interface table. The following error is found.

ERROR

total txn qty-cap must be less than or equal to avail to complete.

Steps to reproduce the issue:

1. Import data to MTL_TRANSACTIONS_INTERFACE.
2. See pending transactions via MTL_TRANSACTIONS_INTERFACE table.