'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 MAY 20, 2018

Applies to:

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

Symptoms

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

Error:

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. 



Changes

 

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