Categories
- All Categories
- 104 Oracle Analytics News
- 9 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 58 Oracle Analytics Trainings
- 60 Oracle Analytics Data Visualizations Gallery
- 5 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
How to print salary amount in Latvian and Estonian in BI Report?

We have a requirement to generate Employment Contracts for Latvian and Estonian employees. We got everything to print in the letter except the salary amount. As per requirement, we need to print Salary Amount in words (in Latvian and Estonian). We are using this word function to translate and it is working for other language, for example: Lithuanian.
Function: <?xdoxslt:toCheckNumber('LV', SALARY, 2, ‘CASE_INIT_CAP’, ‘DECIMAL_STYLE_WORDS’)?> - This one doesn't work for Latvian or Estonian with 'LV', 'lv-LV', 'ET' or 'et-ET'.
Can any expert here please confirm the XDOLOCALE code for Latvian and Estonian to be used for printing the salary amount in words ? Thanks in advance!
Kindly advise.
Regards,
Yash B
Answers
-
Are you facing the issue while testing your template from MS office/template viewer or after uploading the template on BIP server?
Regards,
Arjun
0 -
To print the salary amount in words for Latvian and Estonian employees in an Oracle BI Publisher report, the correct XDOLOCALE values for the languages may be causing issues in the function.
In Oracle BI Publisher, the
xdoxslt:toCheckNumber
function needs the proper locale code for the desired language. Based on your requirement:- Latvian (LV): The correct locale code should be 'lv-LV'.
- Estonian (ET): The correct locale code should be 'et-EE'.
Here’s how you can adjust your function call:
- xmlCopy code<?xdoxslt:toCheckNumber('lv-LV', SALARY, 2, 'CASE_INIT_CAP', 'DECIMAL_STYLE_WORDS')?>
- xmlCopy code<?xdoxslt:toCheckNumber('et-EE', SALARY, 2, 'CASE_INIT_CAP', 'DECIMAL_STYLE_WORDS')>
1 -
@Mallikarjuna Kuppauru-Oracle - I am facing this issue with both template viewer and BIP server where translation is not working and salary is getting printed in English words.
0 -
@Jayant Ajayrao Deshmukh - I tried both of the examples (both template viewer and BIP server) which you shared and still i am getting the salary in English words.
- <?xdoxslt:toCheckNumber('lv-LV', SALARY, 2, 'CASE_INIT_CAP', 'DECIMAL_STYLE_WORDS')?>
- <?xdoxslt:toCheckNumber('et-EE', SALARY, 2, 'CASE_INIT_CAP', 'DECIMAL_STYLE_WORDS')?>
0 -
To fix the issue where the salary is still appearing in English words in your BI Publisher report, even after using locale-specific functions like
toCheckNumber('lv-LV', ...)
ortoCheckNumber('et-EE', ...)
, you can try the following:- Make sure that the locales (
lv-LV
,et-EE
) are installed and supported by your BI Publisher environment. - Verify that the BI Publisher server is set to recognize these locales.
- Check if your BI Publisher version fully supports these locale formats for number conversion.
These adjustments should ensure that the salary appears in the correct language format.
0 - Make sure that the locales (
-
- Latvian & Estonian are not installed in our BI Publisher environment. So is the Lithuanian language but number-to-word conversion is still working for LT.
- For point 2 & 3, can you please share the navigation in BI to check this ?
0