Oracle Fusion #18: Multi-Language reports or translation in Fusion
Вставка
- Опубліковано 8 лют 2025
- -- Oracle Fusion Video Series : Video 18
#SQL
#PLSQL
#Oracle
#ORACLEAPPS
#OracelFusion
#TechTalkswithNaresh
#Naresh
#R12
#EBSConsultant
Join Our Telegram Group:
t.me/techtalks...
FOLLOW US :
============
UA-cam : / techtalkwithnaresh
For More details Contact Us:
Email: nareshtech21@gmail.com
--------------------------------------------------------------------------------------------------------------------------------------------------------------
In this Playlist I had uploaded all the videos which help you to learn the Oracle Fusion BI Reports and Oracle Fusion OTBI Reports which will help you to improve your skills. If you have any doubt's regarding any of the uploaded videos you can write in comment section. If you need more videos on other topics or training in Oracle fusion you can reach out me at nareshtech21@gmail.com. Please do like, share and Subscribe the channel to get latest videos.
----------------------------------------------------------------------------------------------------------------------------------------------------------------
Steps:
1. Create Data Model
Query:
SELECT
a.po_header_id "PO Header",
b.po_header_id "PO Header Id",
b.po_line_id "PO Line Id",
b.item_id "Item ID",
b.unit_price "Unit Price",
b.quantity "Quantity",
b.base_unit_price "Base Unit Price"
FROM
po_headers_all a,
po_lines_all b
WHERE
a.po_header_id = b.po_header_id
AND a.segment1 = 162352
2. Create Layout and Template.
3. Test the Report using current Local.
4. Go to report layout properties & download translation file (XLIFF File) under translation section(Extension .xlf).
5. Now edit .xlf file following fields.
The file have two languages types Source language & Target Language.
You created layout under English Locale -- Base Language
Spanish Locale -- Target Language
English to Spanish Translation:
ENGLISH SPANISH
PO Header -- Encabezado de PO
PO Header Id -- ID de encabezado de pedido
PO Line Id -- ID de línea de PO
Item ID -- Identificación del producto
Unit Price -- Precio unitario
Quantity -- Cantidad
Base Unit Price -- Precio unitario base
6. Change the English values to Spanish values for target-language & the Target, from the translation file.
7. Upload translated file with target language. Go to report properties & upload the transnational file under section translation.
8. Upload the Transnational(.xlf) file to the translation section, and Save it.
9. Go to catalog and schedule the report.
10. Check the output.
Notes:
1. Code for Spanish is es.
2. Don't touch fields like[&1].
Thanks for the video. I appreciate your efforts.
@MTOracle Welcome. Keep learning keep sharing.
Great video, could you please share a video on HCM technical Interview questions and answers
@Suresh Thanks for Acknowledgement. Will try to share asap.
What typeof service used in financial moduels and what domain used
@Om Which service you are talking about can you elaborate your requirement.
Impressive Video..thanks for sharing
Please do make a video on Dynamic logo in Fusion
and Oracle fusion financial tables
@Manikamta welcome I will make the videos on such topics aslo. you can reffer the videos of sub template for dynamic logo till now. Please subscribe to get latest updates
THANK YOU FOR YOUR VIDEO from where we have to get the tags for target language like for Spanish you said "es" this es value how to get for other languages
@Sreenivasulu This information is available on oracle support.
@@TechTalkwithNaresh Thank you very much
Hi Naresh.. Tahnks for the video. Just one question. How do we know the target language codes. For example for spanish you mentioned es. Like wise what is it for chinese and how and where to get the language ids. Please respond.
@Suneel You can just get it from Google. Or there is oracle seeded table by which you can also get this. I will upload you shortly with table name. Subscribe to get latest updates.
Thanks for the video. Is there a way to translate amount in words to a different language? Not just the headers or static text. Thoughts?
@Arun you can give the rtf language as per requirement, as we give in barcode reports.
Hello Naresh , I just wanted to conform that is dynamic filed is in English in database and i wanted to print through Report RTF , is it possible to change language of any filed in RTF Level or data model level ?
@Rajdip Please write the case with example at nareshtech21@gmail.com
Is there a solution to translate the parameters "Display Label" dynamically in user login language ?
@Siddharth till Fusion verion 21D it was not possible, for latest version chek the oracle support.
@@TechTalkwithNaresh i do not see any option in the application. I am using 23A
How to translate Dynamic Alphabets and Numerical Values in the Report ?
@MTOracle You can follow same process as per video.
Hi, do you know how can i translate the label of the parameters ?
@Pablo You can add cod for it in same transaction file.
@@TechTalkwithNaresh Hi!!, thanks for the answer but i didn't understood , where do you say that i can put the translation for the parameters ?, in your video there is no any parameters. I mean when you are going to execute the report, the execution parameters...
@Ensamble Yes
do you have a video how to translate data apart from static headers in different language, and Multi Language report where it shows English and non-english as well in same report
@Balaji Till now I had not upload video on non static header translation. Subscribe to get latest videos and notification update.
good.
@Amar Thanks
How to get values in Spanish not only column names please
@Kurupati The values which are in the table that only will get populated using this. We can't convert the table values.
The method that you are showing translates the static text. But how do we translate dynamic text to a specific language? As an example, I have an Outstanding Invoice payment report that lists all the open invoices for a customer with the amounts and at the end of the report I have the total outstanding amount being reported in words. So the RTF template is converting the outstanding amount from numbers to words (Three Thousand and Fifteen Dollars and Zero Cents). How can we translate this dynamic text (Three Thousand and Fifteen Dollars and Zero Cents) into Spanish? I am able to change all the static text to Spanish, but this text in the report does not get translated to Spanish as it is not static but dynamically generated based on the actual amount. Any way of translating this as well?
@Ashok you can give the rtf language as per requirement, as we give in barcode reports.
How to translate Dynamic Alphabets and Numerical Values in the Report ?
@MTOracle You can follow same process as per video.