Archive Plan Summary Fails With "Error while populating the fact tables. purging this plan summary." When Run With Enable Details "Yes"

(Doc ID 2121201.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle Advanced Planning Command Center - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On a 12.2.4.1 Value Chain Planning Instance in Advanced Planning Command Center (APCC)

Running Archive Plan summary with Enable Details as "Yes"  in order to see Pegging Information in APCC results in an error.
The Program completes successfully when we run with Enable Details as "No"

ERROR
-----------------------

MSCHUBA: Archive Plan Summary

Error while populating the fact tables. purging this plan summary.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the MSCHUBA: Archive Plan Summary program with Enable Details as "Yes"
2. It completes with an error "Error while populating the fact tables. purging this plan summary."

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