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

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***

Symptoms

In Advanced Planning Command Center On a 12.1.3 Instance

ACTUAL BEHAVIOR
---------------
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.


EXPECTED BEHAVIOR
-----------------------
Expect the data to be purged.

STEPS
-----------------------
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.

Cause

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