My Oracle Support Banner

'ORA-02291' Error When User Tried to Delete and Add a New Work Order in 2 Legged Transfer (Doc ID 2396442.1)

Last updated on MARCH 02, 2019

Applies to:

Oracle Retail Merchandising System - Version 15.0.1 and later
Information in this document applies to any platform.


When attempting to delete and add new WorkOrder(WO) in 2 legged transfer , the following error occurs.


Steps To Recreate:

1. Create a 2 legged transfer. Add From_location, Finisher and To_location (from location and finisher belong to same physical warehouse).
2. Add items.
3. Add WO details.
4. Navigate to tsfhead screen and submit the transfer. But don't click on OK or come out of the screen.
5. Change the status of transfer from submit to input.
6. Navigate to WO screen.Delete the existing records and add new one and click on apply.Notice that, Integrity constraint error is displayed. 


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

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