PFTTBI ORA-00904: "DIM_PRODUCT_V"."V_PROD_CODE": invalid identifier Errors Running SCD for Product Dimension
Last updated on JUNE 04, 2015
Applies to:Oracle Financial Services Profitability Analytics - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On Oracle Financial Services Profitability Analytics (PFTBI) 6.1, while running INFODOM_SCD batch to populate the dimension data in a new Infodom, the following errors occur:
ORA-00904: "DIM_PRODUCT_V"."V_PROD_CODE": invalid identifier
ORA-00904: "DIM_ORG_UNIT_V"."V_ORG_UNIT_CODE": invalid identifier
It seems the views created by the installer (DIM_PRODUCT_V , DIM_ORG_UNIT_V ) are missing CODE column.
The issue can be reproduced at will with the following steps:
1. Run the SCD for Org and Prod
2. Check the generated log file for errors
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms