Compare Blitz Report Column Translations 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
Run Compare Blitz Report Column Translations between environments and other Oracle EBS reports with Blitz Report™ on our demo environment
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
QP Customer Pricing Engine Request GL Account Analysis (Distributions) andy column translation test CST Supply Chain Indented Bills of Material Cost Blitz Report Column Translations COPY OF: GL Account Analysis GL Account Analysis INV Transaction Historical Summary Mrugesh: GL Balance
Blitz Report™

Blitz Report™ provides multiple benefits: