Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to print salary amount in Latvian and Estonian in BI Report?

Received Response
31
Views
6
Comments
Bhardwaj Yash
Bhardwaj Yash Rank 2 - Community Beginner

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

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @Bhardwaj Yash

    Are you facing the issue while testing your template from MS office/template viewer or after uploading the template on BIP server?

    Regards,

    Arjun

  • Jayant Ajayrao Deshmukh
    Jayant Ajayrao Deshmukh Rank 3 - Community Apprentice

    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:

    1. xmlCopy code<?xdoxslt:toCheckNumber('lv-LV', SALARY, 2, 'CASE_INIT_CAP', 'DECIMAL_STYLE_WORDS')?>
    2. xmlCopy code<?xdoxslt:toCheckNumber('et-EE', SALARY, 2, 'CASE_INIT_CAP', 'DECIMAL_STYLE_WORDS')>

  • Bhardwaj Yash
    Bhardwaj Yash Rank 2 - Community Beginner

    @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.

  • Bhardwaj Yash
    Bhardwaj Yash Rank 2 - Community Beginner

    @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.

    1. <?xdoxslt:toCheckNumber('lv-LV', SALARY, 2, 'CASE_INIT_CAP', 'DECIMAL_STYLE_WORDS')?>
    2. <?xdoxslt:toCheckNumber('et-EE', SALARY, 2, 'CASE_INIT_CAP', 'DECIMAL_STYLE_WORDS')?>

  • Jayant Ajayrao Deshmukh
    Jayant Ajayrao Deshmukh Rank 3 - Community Apprentice

    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', ...) or toCheckNumber('et-EE', ...), you can try the following:

    1. Make sure that the locales (lv-LV, et-EE) are installed and supported by your BI Publisher environment.
    2. Verify that the BI Publisher server is set to recognize these locales.
    3. 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.

  • Bhardwaj Yash
    Bhardwaj Yash Rank 2 - Community Beginner
    edited October 2024

    @Jayant Ajayrao Deshmukh -

    1. 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.
    2. For point 2 & 3, can you please share the navigation in BI to check this ?