WIP Move Transaction Interface - Unable To Determine The Correct Error Message (Doc ID 1925451.1)

Last updated on OCTOBER 28, 2016

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.

Symptoms

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 .

ERROR
-----------------------
INTERFACE_ERROR = Some records in this group cause errors. Check error interface table for more information.


STEPS
-----------------------
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.
INTERFACE_ERROR
> 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
 


Cause

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