APCC: Purge Plan Summary Leaves Orphaned Data Causing Significant Database Size Issues
Last updated on JUNE 07, 2017
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.
***Checked for relevance on 16-MAY-2013***
In Advanced Planning Command Center On a 12.1.3 Instance
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.
Expect the data to be purged.
The issue can be reproduced at will with the following steps:
(1) Run the purge plan concurrent program
(2) Note that there is orphaned data remaining.
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