Running 'Inventory Data Purge' (IN_PURGE) Process for Multiple Business Units Keeps the Last Processed Business Unit Value in PS_CM_PURGE_TMP table (Doc ID 2827440.1)

Last updated on DECEMBER 14, 2021

Applies to:

Symptoms

Running 'Inventory Data Purge' (IN_PURGE) process for multiple business units keeps the last processed business unit (BU) value in PS_CM_PURGE_TMP table.

When running the 'Inventory Data Purge' process (IN_PURGE) for multiple business units (BUs), only the data of the last processed BU is kept in the PS_CM_PURGE_TMP table.
The result of the purge can be seen in the 'Process Message Log' link where messages such as this one can be seen:

Steps to Reproduce the Issue:
-------------------
1. Run 'Inventory Data Purge' process (IN_PURGE) in one run control
Navigation Inventory>Purge Inventory Data
2. Add two requests for two different Business Units
3. As result only last BU is added in the PS_CM_PURGE_TMP table after the process is completed

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.