Blitz Report Column Number Fomat 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(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 GL Balance XXFT GL Balance Blitz Report Pivot Colums Validation CAC Calculate ICP PII Item Costs RWB Database Functions used by Calculated Columns AP Trial Balance Blitz Report Text Search Mrugesh: GL Balance
Blitz Report™

Blitz Report™ provides multiple benefits: