My Oracle Support Banner

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)


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.