ORA-00942 & 'Add Operation Failed' Errors Creating Dimension Member in PCD (Doc ID 2243373.1)

Last updated on MARCH 13, 2017

Applies to:

Oracle Financial Services Pricing Management, Transfer Pricing Component - Version 8.0.1 and later
Information in this document applies to any platform.
Oracle Financial Services Price Creation and Discovery (PCD)
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Price Creation and Discovery (PCD) 8.0 standalone environment, when creating a new member for the Bank dimension, you get the following error:

Add Operation Failed

You find the following error in FUSIONSUBSYSTEMSService.log in the web server's OFSAA log directory:

[FUSIONSUBSYSTEMS] Feb 8,17 15:22:54 : [MEMBERHANDLER]Query to get Next Maximum value of Members : SELECT MAX(BANK_CD) + 1 BANK_CD FROM FSI_BANK_CD
[FUSIONSUBSYSTEMS] Feb 8,17 15:22:54 : [MEMBERHANDLER]SQL Exception occured while trying to get Next Maximum value of Members.
[FUSIONSUBSYSTEMS] Feb 8,17 15:22:54 : [MEMBERHANDLER]
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

As a result of the error, you cannot create new members.

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