My Oracle Support Banner

APCC: Purge Plan Summary Leaves Orphaned Data Causing Significant Database Size Issues (Doc ID 1375759.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Advanced Planning Command Center - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


After we run Purge Plan Summary for some earlier runs of ASCP archived data, the plan_run_id aren’t visible in the list of values (both in the purge program as well as in APCC dashboards) as expected. However, we still see significant data remaining in the underlying MSC_%_F tables like msc_supplies_f, msc_demands_f etc.

The uploaded example output of the record count from msc_supplies_f shows information for each plan_run_id while the only last 2 plan_run_id are visible in the list of values.

(1) Run the purge plan concurrent program
(2) Note that there is orphaned data remaining.


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.