Blitz Report Column Translation Comparison between environments

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Shows differences in Blitz Report column translations between the local and a remote database server

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
nvl(xrct.column_name,xrct2.column_name) column_name,
nvl(xrct.language,xrct2.language) language,
xrct.translation,
xrct2.translation translation_remote
from
(
select
xrc.column_name,
xrct.language,
xrct.translation
from
xxen_report_columns xrc,
xxen_report_columns_tl xrct
where
1=1 and
xrc.column_id=xrct.column_id
) xrct
full join
(
select
xrc.column_name,
xrct.language,
xrct.translation
from
xxen_report_columns@&database_link xrc,
xxen_report_columns_tl@&database_link xrct
where
1=1 and
xrc.column_id=xrct.column_id
) xrct2
on
xrct.column_name=xrct2.column_name and
xrct.language=xrct2.language
where
2=2
Parameter Name SQL text Validation
Remote Database 
<parameter_value>
 LOV
Language 
xrct.language in (select flv.language_code from fnd_languages_vl flv where flv.description=:language)
 LOV
Show Differences only 
nvl(xrct.translation,'x')<>nvl(xrct2.translation,'x')
 LOV
Download
 
Related Blitz Reports
CAC Calculate ICP PII Item Costs GL Account Analysis (Distributions) CST Supply Chain Indented Bills of Material Cost Blitz Report Column Translations XXRG GL Account Analysis GL Account Analysis QP Customer Pricing Engine Request INV Transaction Historical Summary Mrugesh: GL Balance
Blitz Report™

Blitz Report™ provides multiple benefits: