Refresh APCC Materialized Views Completing In Error
(Doc ID 2403847.1)
Last updated on JULY 17, 2018
Applies to:Oracle Advanced Supply Chain Planning - Version 12.2.7 and later
Information in this document applies to any platform.
On : 12.2.7 version, Collection
Advanced Planning Command Center
Running the program 'Refresh APCC Materialized Views' for the first time in APS instance and it is failing with below error message:
msc_phub_pkg.refresh_mvs.exception: ORA-00904: "T_EP_ITEM"."EBS_ITEM_DEST_KEY": invalid identifier
The issue can be reproduced at will with the following steps:
1. Run 'Refresh APCC Materialized Views' program
Customer reported the issue on a new cloned instance.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!