Objective :
Sometimes having a requirement to build the BIP report to display records other than English (ex: Arabic, French, German etc). In Order to build such a report, you have written a query in such a way BIP data model.
System Variable- :xdo_user_report_oracle_lang
eg: (Sample Query)
select distinct a.trx_number,to_char(a.trx_date,’dd/mm/yyyy’) trx_date,b.name,b.description from ra_customer_trx_all a, ra_terms_tl b
where 1=1
and a.term_id=b.term_id
and language =:xdo_user_report_oracle_lang
Once you completed the report, you can log into the Fusion Application with the german language and then go to Tools>Report and analytics and see the output in the german language.
Recent Posts
