Compare Blitz Report Column Number Fomats 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 Number Fomats between environments and other Oracle EBS reports with Blitz Report™ on our demo environment
select
nvl(xrc.column_name,xrc2.column_name) column_name,
xrc.number_format,
xrc2.number_format number_format_remote,
xxen_util.user_name(xrc.last_updated_by) last_updated_by,
xrc.last_update_date,
xxen_util.user_name@&database_link(xrc2.last_updated_by) last_updated_by_remote,
xrc2.last_update_date last_update_date_remote,
xxen_util.user_name(xrc.created_by) created_by,
xrc.creation_date,
xxen_util.user_name@&database_link(xrc2.created_by) created_by_remote,
xrc2.creation_date creation_date_remote
from
(select xrc.* from xxen_report_columns xrc where xrc.number_format is not null) xrc
full join
(select xrc.* from xxen_report_columns@&database_link xrc where xrc.number_format is not null) xrc2
on
xrc.column_name=xrc2.column_name
where
1=1
Parameter Name SQL text Validation
Remote Database 
<parameter_value>
 LOV
Show Differences only 
nvl(xrc.number_format,'x')<>nvl(xrc2.number_format,'x')
 LOV
Download
Related Blitz Reports
INV Transaction Historical Summary AP Invoices and Lines RWB Report Columns GL Balance XXFT GL Balance Blitz Report Pivot Colums Validation RWB Database Functions used by Calculated Columns AP Trial Balance Mrugesh: GL Balance
Blitz Report™

Blitz Report™ provides multiple benefits: