'Error occurred while reverse populating data' Creating Dimension Member in PCD

(Doc ID 2240767.1)

Last updated on MARCH 13, 2017

Applies to:

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

Symptoms

In Oracle Financial Services Price Creation and Discovery (PCD) 8.0, when creating a new member for the Common Chart of Accounts dimension, you get the following error:

Error occurred while reverse populating data

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

[FUSIONSUBSYSTEMS] Feb 8,17 15:18:59 : [HIERARCHYCONFIGCACHE]Looking value in cache for the key..MEMBER_REVERSE_POP-OFSPMINFO-3
[FUSIONSUBSYSTEMS] Feb 8,17 15:18:59 : [COMMONFUNCTIONS]SQL Exception occur while reverse populating Member
[FUSIONSUBSYSTEMS] Feb 8,17 15:18:59 : [COMMONFUNCTIONS]
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'ADHM_MGMT.POPULATEMEMBERS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

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