I Have two reverse_id in my table ic_tran_pnd
Hello Peoples,
I come to share with you a problem I had recently.
An appointment was made in a production order as follows (In the Line of ingredients):
TRANS_DATE TRANS_QTY REVERSE_ID
25/11/2011 212.482,00 2505643
25/11/2011 212.482,00 2505643
30/11/2011 -212.482,00) 2519944
30/11/2011 212.482,00 2519860
25/11/2011 -212.482,00) 2509383
Note that the system generated two reverse_id , which increased my amount in stock improperly in 212,482.
-------
I then opened a call on My Oracle Support, and they came back to me with a plan of action.
I was asked to update a table ic_tran_pnd, marking the field in a delete_mark of duplicate transactions.
I'll try to reproduce the case in my test environment and let you know the results.
0