My Oracle Support Banner

NLS_CURRENCY Setting Not Taking Effect in Reports Output (Doc ID 1314343.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Oracle Reports Developer - Version 10.1.2.3 to 10.1.2.3 [Release 10gr2]
Oracle Forms for OCI - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

The environment variable NLS_LANG is set to ARABIC_AMERICA.AR8MSWIN1256.
The default Currency for the territory=AMERICA is $. 
In order to change it to a different value the NLS_CURRENCY is set to "NLS_CURRENCY"="K.D. " in the registry.

However, the report still displays the $ as the currency symbol in the reports output, even though the format mask for currency is set as per the example listed below:

Format mask set to LNNNGNN0

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


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