The developer team is using the function IBY_AMOUNT_IN_WORDS.Get_Amount_In_Words() for amount in spanish to XML payload for electronic invoicing. however, for some latam countries the translation is incomplete or is not in spanish.
example, for Peru all words are in english, Argentina no mention of the currency name, Mexico is one of the few countries that show translation in spanish and proper cent and currency words.
i appreciate the help because i could not have any solution through My Oracle Support.
example below:
Query
Select extended_amount,
IBY_AMOUNT_IN_WORDS.Get_Amount_In_Words(extended_amount,'PEN') as Valor_letra_PEN,
IBY_AMOUNT_IN_WORDS.Get_Amount_In_Words(extended_amount,'MXN') as Valor_letra_MXN,
IBY_AMOUNT_IN_WORDS.Get_Amount_In_Words(extended_amount,'ARS') as Valor_letra_ARS,
IBY_AMOUNT_IN_WORDS.Get_Amount_In_Words(extended_amount,'COP') as Valor_letra_COP,
IBY_AMOUNT_IN_WORDS.Get_Amount_In_Words(extended_amount,'CLP') as Valor_letra_CLP
from RA_CUSTOMER_TRX_LINES_ALL
Where CUSTOMER_TRX_ID =[&invoice_ID]
Output
G_1
EXTENDED_AMOUNT (45)
VALOR_LETRA_PEN (Forty-Five Peruvian Nuevo Soles And Zero Centimos*****)
VALOR_LETRA_MXN ( CUARENTA Y CINCO PESOS 00/100 M.N.)
VALOR_LETRA_ARS (Cuarenta y Cinco pesos)
VALOR_LETRA_COP (Cuarenta y Cinco pesos)
VALOR_LETRA_CLP (Cuarenta y Cinco pesos)
G_1
EXTENDED_AMOUNT (8.1)
VALOR_LETRA_PEN (Eight Peruvian Nuevo Soles And Ten Centimos*****)
VALOR_LETRA_MXN ( OCHO PESOS 10/100 M.N.)
VALOR_LETRA_ARS (Ocho pesos con 10 Centavos )
VALOR_LETRA_COP (Ocho pesos con 10 Centavos )
VALOR_LETRA_CLP (Ocho pesos con 10 Centavos )