'Unknown Member Allocated Asset Error Used In The Query' Error In PFTBI Dashboards (Doc ID 1493186.1)

Last updated on SEPTEMBER 21, 2012

Applies to:

Oracle Financial Services Profitability Analytics - Version 5.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.x
Oracle Financial Services Analytical Applications (OFSAA)
PFT BI

Symptoms

On Oracle Financial Services Profitability Analytics (PFTBI) 5.6 when attempting to access the drop down list for Reporting Lines in the Balance base currency and the RAPM base currency reports, the following error occurs:

ERROR
Balance-Base Currency

Current tab
Business Month: 2011 September

Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE:HY000][nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 43119] Query Failed:
[nQSError: 96002] Essbase Error: Unknown Member Allocated Asset used in query (HY000)
SQL Issued: SELECT "Reporting Lines"."LineItems Level1" FROM Profitability."Reporting Lines" where "Reporting Lines"."LineItems Level1" not in ('Balance Sheet','No of Accounts','Contribuation to Total Income','Risk Adjusted Net Income') union all SELECT "Reporting Lines"."LineItems Level2" FROM Profitability."Reporting Lines" where "Reporting Lines"."LineItems Level2" not in ('Source Balance','Allocated Asset','Allocated Capital (Economic)','Allocated Capital (Profitability)','Allocated Capital (Regulatory)','Allocated Liabilties') union all SELECT "Reporting Lines"."LineItems Level3" FROM Profitability."Reporting Lines" union all SELECT "Reporting Lines"."LineItems Level4" FROM Profitability."Reporting Lines" union all SELECT "Reporting Lines"."LineItems Level5" FROM Profitability."Reporting Lines"


STEPS
The issue can be reproduced at will with the following steps:

1. Navigate in OBIEE PFTBI Dashboard to Balance-Base Currency
2. Attempt to choose from the Reporting Lines drop down list

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