Oracle Fusion ERP Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion ERP Analytics

Categories

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

the function IBY_AMOUNT_IN_WORDS.Get_Amount_In_Words() is not return the words in spanish for Peru

Received Response
6
Views
2
Comments
User_RLAVD
User_RLAVD Rank 1 - Community Starter
in Oracle Fusion ERP Analytics

the function IBY_AMOUNT_IN_WORDS.Get_Amount_In_Words() only return the words in spanish for select countries/currencies like Spanish Mexico/MXN but for Peru/PEN is returning only in english. something ismilar happen for other latam countries. and we cannot find the way to translate correctly.

we are trying to generate an XML file output not a RFT file output, the developers are using this function in the SQL data model.

Thanks in advance for the help.

Tagged:

Answers

  • Subha_Tripathy-Oracle
    Subha_Tripathy-Oracle Mod

    Hi @User_RLAVD,

    Thank you for visiting and posting in Fusion Data Intelligence(FDI) Product Community Page.

    This forum is for FDI product and looks like your question is for Fusion Applications.

    Please note that this Question is for Fusion Apps and it is managed in our sister community, which can be found at the below links:

    Oracle Cloud Customer Connect :

    https://community.oracle.com/customerconnect

    Please make a note of the above URL and visit those Fusion Apps forums to submit ideas, receive support from our FA Cloud experts and check out the resources they have available for you.

    Thanks
    Subha

  • RVohra
    RVohra Rank 6 - Analytics Lead

    I donot think it is possible, but Oracle Support is your best bet

    You can try creating your own custom PL/SQL function to convert a number to Spanish words (for PEN and other unsupported currencies). Then use this function in your data model SQL.

    Hope it helps!