PFTTBI ORA-00904: "DIM_PRODUCT_V"."V_PROD_CODE": invalid identifier Errors Running SCD for Product Dimension

(Doc ID 1572107.1)

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms