WIP 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 APRIL 29, 2024
Applies to:
Oracle Work in Process - Version 11.5.10.2 and laterInformation in this document applies to any platform.
Symptoms
Scenario 1 - Not enough quantity in the to-move of the last countpoint operation.
There are WIP or Service Work Order Completion Transactions Stuck In MTL_TRANSACTIONS_INTERFACE table with Error Message:
ERROR
Steps to reproduce the issue:
1. Go to: Inventory - Transactions - Transaction Open Interface.
2. Find Transactions in Error.
3. Error Explanation = total txn qty-cap must be less than or equal to qty avail to complete
The error records in Material Transaction Interface can also be found using the following Select statement:
Scenario 2 - Duplicate WIP Assembly Completion transaction.
When attempting to use the table MTL_TRANSACTIONS_INTERFACE to report production (WIP Completion) and/or waste, while doing an easy-completion (WIP Move and Complete transaction) simultaneously.
ERROR
total txn qty-cap must be less than or equal to avail to complete.
Steps to reproduce the issue:
1. Import data into WIP_MOVE_TXN_INTERFACE
2. Import data to MTL_TRANSACTIONS_INTERFACE
3. Run the Move Manager and the Inventory Transactions Processor
4. See pending transactions via MTL_TRANSACTIONS_INTERFACE table.
Scenario 3 - Overcompletion fails for missing data from the interface.
Unable to perform overcompletion via MTI (mtl_transactions_interface)
ERROR
total txn qty-cap must be less than or equal to qty avail to complete.
Changes
N/A
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! |
In this Document
| Symptoms |
| Scenario 1 - Not enough quantity in the to-move of the last countpoint operation. |
| Scenario 2 - Duplicate WIP Assembly Completion transaction. |
| Scenario 3 - Overcompletion fails for missing data from the interface. |
| Changes |
| Cause |
| Cause 1 - quantity not moved yet to the last operation. |
| Cause 2 - the completion transaction from MTI is not required. |
| Cause 3 - Missing data from MTI interface. |
| Solution |
| Solution 1 - Move the assembly quantity in the last countpoint operation and into ToMove intraoperation step. |
| Solution 2 - The MTI record is redundant and would cause duplicate completion. Do not insert it. Delete the record from MTI to avoid duplicate completion transactions. |
| Solution 3 - Insert the required missing information from the interface. |
| References |