OBIA 184.108.40.206.X : Project Dashboards does not show data for Specific Currency
(Doc ID 2322615.1)
Last updated on NOVEMBER 13, 2019
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.1 and later
Information in this document applies to any platform.
OOTB Dashboard prompts or reports are returning no data or showing 'Null' or 'Unspecified'. An example analysis is : "Project Financial Performance Overview" in
"Project management" -> "Project Performance".
Issue is observed in below Environment.
OBIA version : Oracle Business Intelligence Applications Configuration Manager version 18.104.22.168.2 - Oracle Project Analytics
OBIEE version : Build: 22.214.171.124.X
Data Source and version : EBS R12.1.3
Target database version : Oracle 11.2
ODI Version : 126.96.36.199
Report gives results when column format is set to Number.
but when data format in the column properties is changed to currency like add [$:currencyTagColumn="Project - Performance"."Currency Code"."BI Common Currency Code"] as a custom numeric format then the result is : no data is found.
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