Errors Opening PFT Screens & ORA-00904: "NAT_HOUSING_PRCING_INDEX": Invalid Identifier in Fsapps.log

(Doc ID 1939761.1)

Last updated on OCTOBER 30, 2014

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.0.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

After installing Oracle Financial Services Analytical Applications (OFSAA) Infrastructure 7.3.4, Profitability Management (PFT) 6.1 and 6.1.0.3, you gets errors when opening the Profitability Management screens.  You get the following error on the Application Preferences screen:

java.lang.NullPointerException at
com.ofs.fsapps.commonapps.core.preference.action.ApplicationPreferenceAction.init (ApplicationPreferenceAction.java:256)


And you get the following error when clicking on the Allocation Specification, Allocation Model, and Static Table Driver screens:

Error while loading the page

* Error while customizing the query to be executed for module Id_Type: ALLC_SPEC_PFT

Finally, the fsapps.log from $CATALINA_HOME/webapps//logs contains the following:

[13-10-14 10:13:37 AM] ~ INFO ~ FSAPPS ~ [COMMONAPP] Failed to fetch applicaltion preference
java.sql.SQLSyntaxErrorException: ORA-00904: "NAT_HOUSING_PRCING_INDEX": invalid identifier


These errors prevents you from using the PFT functionality.

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