My Oracle Support Banner

OBIA 11.1.1.10.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 11.1.1.10.1 and later
Information in this document applies to any platform.

Symptoms

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 11.1.1.10.2 - Oracle Project Analytics

OBIEE version : Build: 11.1.1.9.X

Data Source and version : EBS R12.1.3

Target database version : Oracle 11.2

ODI Version : 11.1.1.9

 

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.

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.