WIP Move Transaction Interface - Unable To Determine The Correct Error Message
Last updated on JUNE 12, 2018
Applies to:Oracle Work in Process - Version 12.1.3 to 12.2.3 [Release 12.1 to 12.2]
Information in this document applies to any platform.
On : 12.1.3 to 12.2.3 version, Transactions
Customer built integration between shop floor systems and EBS in order to do WIP Moves and completions in Oracle.
Their integration works as follows
- Scans happening in the shop floor are inserted as records into EBS staging table for WIP moves and completions.
- Program developed would insert these records into WIP_MOVE_TXN_INTERFACE
The standard WIP Move transaction manager processes these records and creates Move transactions.
The following error occurs when processing this move transaction and are not able to understand the reason behind the generic message .
INTERFACE_ERROR = Some records in this group cause errors. Check error interface table for more information.
The issue can be reproduced at will with the following steps:
Step1 – We receive WIP move and completion transaction into staging table on the EBS side
Step2 – We run a concurrent program that inserts the records into the WIP_MOVE_TXN_INTERFACE to process move transaction
Step3 – After the move is processed the staging table is updated as MOVE_STATUS = ‘CP’
But if there is any error in the interface table it is updated in the staging table error message.
This error message is being sent to an email DL so that the reasons for the error is understood and fixed by them.
> Some records in this group cause errors. Check error interface table for more information.
Step4-Now we see that even in the interface table the same error reason code is appearing without any mention of actual reason
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