My Oracle Support Banner

BI Publisher: Conditional Format Dynamic Currencies For Negative Values In Brackets  (Doc ID 2919717.1)

Last updated on JANUARY 07, 2023

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When running a BI Publisher report in pdf, the negative values are not containing the currency symbol inside the () brackets. 
The RTF template can use the conditional format as $#,##0.00;($#,##0.00) but this is not useful because having multiple currencies, not just $, the dynamic conditional format cannot be selected.

The request is to have the option of using dynamic currencies (multiple) in the same template and the currency code for negative values to be inside the brackets.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the report and export it in pdf
2. See the negative values are not containing the currency symbol inside () brackets.


Changes

 

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


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