ORA-00904: N_PROD_SKEY During SCD for Product Dimension
(Doc ID 1328411.1)
Last updated on MARCH 14, 2019
Applies to:Oracle Financial Services Enterprise Financial Performance Analytics - Version 5.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
When attempting to run Slowly Changing Dimension (SCD )for product dimension, the following error found in the SCD log:
ORA-00904: "N_PROD_SKEY": invalid identifier
1. Install Oracle Financial Services Profitability Analytic (PFT BI) 5.1.
2. Execute SCD process for product dimension.
3. Error shown in the SCD log, and there is no dimension members in DIM_PRODUCT.
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