My Oracle Support Banner

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:

PeopleSoft Enterprise SCM Inventory - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


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




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.