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.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!