My Oracle Support Banner

WIP_MOVE_TXN_INTERFACE Common Errors In Pending Move Transactions With Possible Causes And Action Plan To Process Them (Doc ID 457066.1)

Last updated on MAY 12, 2018

Applies to:

Oracle Work in Process - Version 11.5.10.0 and later
Information in this document applies to any platform.

Goal

Some Common Errors in pending move transactions along with their possible causes and action plan to process them.
 

Script to identify the errored rows in pending move transactions:
select * from WIP_MOVE_TXN_INTERFACE where process_status = 3;
  

Script to identify the actual errors associated with the errored tranactions:
select * from wip_txn_interface_errors where TRANSACTION_ID in (select TRANSACTION_ID from WIP_MOVE_TXN_INTERFACE where process_status = 3);
  

Apart from the action plans provided for the errors below, it is recommended to apply the Move Processing <Patch 5038886>. This patch fixes some critical issues related to move processing in the Work in Process module.

Solution

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
Goal
Solution
 Error 1: No charges allowed for this job/schedule
 
Error 2: No open period found for date entered
 

Error 3: The transaction quantity exceeds the overcompletion tolerance set for the Job, Repetitive Line/Assembly, or the Organization
 
Error 4: Transaction quantity must be less than or equal to quantity available to move
 

Error 5: TRANSACTION_ID not valid. Please re-enter
 
Error 6: TRANSACTION_QUANTITY must be greater than zero
 

Error 7: You cannot move assemblies within the same operation and step.Cause:You tried to perform a shop floor move within a single operation and intraoperation step. You can only move assemblies between distinct operations or between dist
 
Error 8: The value for PRIMARY_QUANTITY either does not correspond to the value for TRANSACTION_QUANTITY or does not uniquely specify a value for TRANSACTION_QUANTITY. Please change PRIMARY_QUANTITY or TRANSACTION_QUANTITY
 
Error 9: WIP_BATCH_MOVE_ERROR
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.