OBIA: Unable To Access Project Analytic Subject Areas/Dashboards After Fresh Installation
(Doc ID 2264249.1)
Last updated on JULY 08, 2021
Applies to:
Business Intelligence Applications Consumer - Version 11.1.1.10.2 and laterInformation in this document applies to any platform.
Symptoms
On: Oracle Business Intelligence Application
- Installed and configured vanilla BI apps project analytics 11.1.1.10.2,
- Unable to access the project analytics subject areas and all the projects dashboards have errors in them.
- Can access other subject areas such as Financials
- The error getting in accessing any subject area is "Invalid subject area"
- And the error getting in the dashboards layer is
ERROR:
"Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000]
[nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 23037] The presentation object "Project - Performance".."Project Attribute Extension" visibility expression "case when 'HIDE' = VALUEOF(NQ_SESSION.FLEX__PROJECT__ANY__ATTRIBUTE) then 1 else 0 end " is not valid.
[nQSError: 23006] The session variable, NQ_SESSION.FLEX__PROJECT__ANY__ATTRIBUTE, has no value definition. (HY000)
SQL Issued: {call NQSGetSQLCustomTables('Project - Performance','%','%','%')}".
Changes
Fresh Installation and configuration of OBIA
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |