ORA-00942 & 'Error while querying the database for NLS_LENGTH_SEMANTICS' on Data Model Upload (Doc ID 2289410.1)

Last updated on JULY 28, 2017

Applies to:

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

Symptoms

In Oracle Financial Services Profitability Management (PFT) 8.0.2, when running a data model upload, the model upload fails and you have the following ORA-00942 error in the model upload log from /<ftpshare>/<infodom>/logs:

----------------------------------------------
STARTED SUPER CATEGORY - SUB CATEGORY HANDLING AT Wed Jun 07 09:46:50 CDT 2017
SUCCESSFULLY COMPLETED SUPER CATEGORY - SUB CATEGORY RELATIONS HANDLING AT Wed Jun 07 09:47:14 CDT 2017

Error while querying the database for NLS_LENGTH_SEMANTICS...Error while Executing query :Error Executing Query. Error: ORA-00942: table or view does not exist

Key :@@system Value:system----------------------------------------------

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