ORA-00904: N_PROD_SKEY During SCD for Product Dimension (Doc ID 1328411.1)

Last updated on NOVEMBER 20, 2015

Applies to:

Oracle Financial Services Profitability Analytics - Version: 5.1 and later   [Release: 5 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
PFTBI
FINSRV

Symptoms

When attempting to run Slowly Changing Dimension (SCD )for product dimension, the following error found in the SCD log:

Error:
ORA-00904: "N_PROD_SKEY": invalid identifier

Steps:
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.

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