My Oracle Support Banner

Deleted Departments Are Not Deleted from Hierarchy Table RK_HIERARCHY (Doc ID 1968859.1)

Last updated on APRIL 15, 2021

Applies to:

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


When a department is deleted from Retail Merchandising System (RMS) and Store Inventory Management (SIM) then a new department is created with the same ID, RIB_DELETE_FLAG in RK_HIERARCHY table is not getting updated to N.

Steps to Reproduce:

1. On RMS screen Delete a department.
2. Mark that department as Delete.
3. Run DLYPRG batch.
4. Note that, in RMS the Department (dept) is deleted.
5. DeptDel message flows to SIM STAGED_MESSAGE table and gets processed.
6. In RK_HIERARCHY table, RIB_DELETE_FLAG is updated to 'Y' for the deleted dept.
7. Create the same department again with the same department ID
8. RIB_DELETE_FLAG is not updated to 'N' again in SIM RK_HIERARCHY table.




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.