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

Question

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.

RVohra · Answer

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!

Subha_Tripathy-Oracle · Answer

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