Purge of Records Not Happening From RK_PRODUCT_GROUP_ITEM Table (Doc ID 2092681.1)

Last updated on DECEMBER 29, 2015

Applies to:

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

Symptoms

Purge process fails to delete items when the same item exists in RK_PRODUCT_GROUP_ITEM table.


Steps to Recreate
:

  1. Create product group in Oracle Retail Store Inventory Management (SIM) and include some items.
  2. Whenever the item (present in step 1) is deleted, it will flow to SIM and marks the status ='D' in AS_ITM.
  3. Run purge item job.
  4. Note that system does not purge the data, as the item is present in the RK_PRODUCT_GROUP_ITEM table.

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