Compare Blitz Report Column Translations between environments

Description
Categories: Enginatics, Toolkit - Setup & Support
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