My Oracle Support Banner

StoreDel Message Goes In Error For FK Violated (Doc ID 3026723.1)

Last updated on JUNE 05, 2024

Applies to:

Oracle Retail Store Inventory Management - Version 16.0.3 and later
Information in this document applies to any platform.

Goal

Need to delete from our Store Inventory Manager a store that was created by mistake.

If manually put in the MPS_STAGED_MESSAGE a message with Family Stores and method StoreDel, during the process of this method, there are errors related to violation of FK. (Department, Inventory adjustment etc).

Is there any solution to delete a store with just one single action (i.e. avoiding to delete all the records in all the tables that have a FK with the Store table)?
 

Solution

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
Goal
Solution


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