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

Last updated on SEPTEMBER 07, 2017

Applies to:

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

Symptoms

When a department is deleted from RMS and 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.

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