'Metadata Could Not Be Parsed' Message Running Save Metadata (Doc ID 1346017.1)

Last updated on NOVEMBER 29, 2011

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version: 7.2 and later   [Release: 7 and later ]
Oracle Financial Services Profitability Analytics - Version: 5.1 and later    [Release: 5 and later]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When implementing Oracle Financial Services Profitability Analytics (PFTBI), you try to Save Metadata in the Metadata Resave screen and it fails.  The following errors appear under "Show Details":

Measure Hierarchy for FA [3829] Unknown error
Measure Hierarchy for Ledger [3829] Unknown error
Next Repricing Month [3819] Operation Successful
Organisation Unit [3819] Operation Successful
Origination Month [3819] Operation Successful
PRODUCT [3819] Operation Successful
Reporting Line for Account Level Profitability [3829] Unknown error
Reporting Line for Financial Accounting [3829] Unknown error
Reporting Line for Management Accounting [4520] Metadata could not be parsed. Please check SQL syntax
Reporting Line in Reporting Currency [3829] Unknown error
Segment [3819] Operation Successful
Time [3819] Operation Successful

Others have seen similar errors for MHGL0002 (Measure Hierarchy For Financial Accounting) and MHEPMAS04 (Reporting Line in Reporting Currency).

The problem in the Save Metadata screen prevents you from building the PFTACPNP cube successfully.  You have the following errors when building the cube:

2011-06-30 | 18:40:32 | olapengine | SEVERE | | | Could not find the member in the outline : DEPMAMT1 : 0
2011-06-30 | 18:40:32 | olapengine | SEVERE | | | Could not find the member in the outline : DEPMCU01 : 0
2011-06-30 | 18:40:32 | olapengine | SEVERE | | | Could not find the member in the outline : DEPMINT1 : 0
2011-06-30 | 18:40:32 | olapengine | SEVERE | | | Could not find the member in the outline : DEPMNR01 : 0
2011-06-30 | 18:40:32 | olapengine | SEVERE | | | Could not find the member in the outline : DEPMOR01 : 0
2011-06-30 | 18:40:32 | olapengine | SEVERE | | | Could not find the member in the outline : DEPMPR01 : 0
2011-06-30 | 18:40:32 | olapengine | SEVERE | | | Could not find the member in the outline : DEPMTI01 : 0
2011-06-30 | 18:40:32 | olapengine | SEVERE | | | Could not find the member in the outline : DHEPAS01 : 0

Steps to Reproduce:
  1. Go to Administration > Save Metadata
  2. Choose all the available metadata under Hierarchy
  3. Move it to the right by using '>>'
  4. Save
  5. Click on the Show Details button
The errors appear under Show Details.

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