Deleting Data From WIP_SERIAL_MOVE_INTERFACE Is Not Deleting WIP_SERIAL_MOVE_TRANSACTIONS
(Doc ID 2719374.1)
Last updated on OCTOBER 13, 2020
Applies to:Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.
The customer have now 4 records in WIP_MOVE_TXN_INTERFACE table and 4 related records in WIP_SERIAL_MOVE_INTERFACE table. If they go to PENDING MOVE TRANSACTION application window and click on Delete Icon then it
will delete 4 records from WIP_MOVE_TXN_INTERFACE but 4 records WIP_SERIAL_MOVE_INTERFACE will remain as it is and it will not be deleted by the system. This is the main issue so our concerns in oracle application pending transaction
window should delete the SERIAL record as well from WIP_SERIAL_MOVE_INTERFACE.
WIP_SERIAL_MOVE_INTERFACE data to be removed as well.
The issue can be reproduced at will with the following steps:
1. Responsibility: Work in process.
2. Navigation: Discrete->Move Transactions > Pending Move Transactions
3. Delete the pending records.
4. WIP_SERIAL_MOVE_INTERFACE table stills the records although it is removed from WIP_MOVE_TXN_INTERFACE.
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