APCC Archive Summary is Taking too Long to Complete (Doc ID 1498306.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Planning Command Center - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 02-JUN-2014***

Symptoms

In Advanced Planning Command Center on a 12.1.3 Instance, Performance

ACTUAL BEHAVIOR  
---------------
We are running ASCP plans with Archive Summary set to yes.  We have noticed that the archive processes are taking an hour plus to complete whereas the ascp plan is completing in half an hour or so.  We run gather schema at 20 percent once a week.  We believe that the apcc archive process taking an hour plus is too long.

We have tried running GSS multiple times for msc schema, but the performance hasn't improved.

EXPECTED BEHAVIOR
-----------------------
Expect the Archive Plan Summary to take 20 minutes to complete.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ASCP plans with Archive Summary set to Yes
2. Note the performance issue described above.

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