My Oracle Support Banner

Purge Item Batch Fails With 'ORA-02292: Integrity Constraint (SCH_SIM.RAN_AIM_FK) Violated' Exception (Doc ID 1927937.1)

Last updated on SEPTEMBER 16, 2019

Applies to:

Oracle Retail Store Inventory Management - Version 13.2.4 to 13.2.8 [Release 13.2]
Information in this document applies to any platform.


The Store Inventory Management (SIM) 13.2.x batch does not delete items with 'D' (Deleted) status and fails with the following ORA error:

Steps to Reproduce:

  1. Select from SIM an item that meets all criteria for deletion (the criteria can be found in PURGE_DATA.Is_item_delete_allowed function), but the data in RK_ALLOCATION table exists for this item.
  2. Select from SIM a second item that meets all criteria for deletion but does not exist in RK_ALLOCATION table.
  3. Delete the items selected in steps 1 and 2 from Retail Merchandising System (RMS).
  4. Check that the deletion messages were sent to SIM, and the statuses of those items in SIM is 'D'.
  5. Run batch and check if items were deleted in SIM.




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.