Unable To View "Past Due" Exceptions On APCC.
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.
12.2.5 in Test
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
but on the APCC fact table there are only 53 rows when you run this query:
SELECT count(1) FROM MSC.MSC_EXCEPTIONS_F
These tables can be identified from the package :msc_exception_pkg
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