My Oracle Support Banner

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.

Symptoms

ACTUAL BEHAVIOR

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.


EXPECTED BEHAVIOR

WIP_SERIAL_MOVE_INTERFACE data to be removed as well.

STEPS

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.


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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