My Oracle Support Banner

Errors Opening PFT Screens & ORA-00904: "NAT_HOUSING_PRCING_INDEX": Invalid Identifier in Fsapps.log (Doc ID 1939761.1)

Last updated on MARCH 19, 2019

Applies to:

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


After installing Oracle Financial Services Analytical Applications (OFSAA) Infrastructure 7.3.4, Profitability Management (PFT) 6.1 and, 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 (

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.


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.