Deleted Departments Are Not Deleted from Hierarchy Table RK_HIERARCHY
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms