My Oracle Support Banner

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 APRIL 25, 2022

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

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.