My Oracle Support Banner

Transfer Create From Existing With Work Order Raises An Exception When Adding WO Activities (Doc ID 2797693.1)

Last updated on AUGUST 23, 2021

Applies to:

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


When creating a transfer from an existing transfer with a Work Order(WO), when creating WO activities for new items, the screen raises an Integrity constraint exception TWD_TWH_FK.

Error ORA-02291 :integrity constraint (RMS.TWD_TWH_FK) violated -parent key not found returned by program_unit TSF_WO_SQL.ITEM_APPLY

Steps To Recreate:
1 . Create from existing from a transfer  with an item and WO.
2 . Remove item.
3 . Add another item (or the same original item).
4 . Click on Work Order.
5 . Add an activity to the new item.
6 . Click on Apply and the error pops up.




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.