Unable To View "Past Due" Exceptions On APCC. (Doc ID 2233757.1)

Last updated on JUNE 21, 2017

Applies to:

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

Symptoms

12.2.5 in Test


PROBLEM
-------------
Business users tried to configure a report to see "past due" exceptions, ( using a standard fact from the "exceptions" folder).

Upon investigating we find the following:
there are 146 rows when you run this query:
SELECT count(1) FROM MSC.MSC_EXCEPTION_DETAILS
WHERE PLAN_ID=3
AND EXCEPTION_TYPE=10;

but on the APCC fact table there are only 53 rows when you run this query:
SELECT count(1) FROM MSC.MSC_EXCEPTIONS_F
WHERE PLAN_ID=3
AND PLAN_RUN_ID=49050
AND EXCEPTION_TYPE=10;

These tables can be identified from the package :msc_exception_pkg






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