Skip to the content.

Blitz Report Parameter Default Values – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Blitz Report · all Blitz Report reports

Overview

Blitz Report’s user or template specific parameter default values

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Category, Anchor, Report Name

Oracle EBS Tables Used

xxen_report_templates_v, xxen_report_parameters_v, xxen_report_param_default_vals

Report Categories

Enginatics

DBA ORDS Configuration Validation, DIS End User Layers, INV Item Templates, Blitz Report Assignment Upload, Blitz Report Assignments, Blitz Report Templates, Blitz Report Default Templates, Blitz Reports, Blitz Report Parameter Dependencies

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output Blitz Report Parameter Default Values 20-Jan-2019 120243.xlsx
Blitz Report™ XML Import Blitz_Report_Parameter_Default_Values.xml
SQL Source Blitz Report Parameter Default Values.sql
Full Report on Enginatics www.enginatics.com/reports/blitz-report-parameter-default-values/

Case Study: Blitz Report Parameter Default Values

Executive Summary

The Blitz Report Parameter Default Values report is an administrative utility that provides visibility into the configuration of default parameter values across the Blitz Report system. It details how defaults are applied at different levels—global report definitions, specific templates, and user-level preferences—ensuring transparency in report execution behavior.

Business Challenge

Blitz Report offers a flexible parameter system where default values can be layered. A report might have a standard default date range (e.g., “Current Month”), but a specific user might have overridden this to “Last Month,” or a shared template might enforce a specific “Department” filter.

Solution

This report generates a detailed listing of all configured parameter default values.

Technical Architecture

The report queries the Blitz Report metadata repository, specifically joining the parameter definitions with the default value storage tables.

Key Views and Tables

Parameters

Performance

The report is highly efficient, querying indexed metadata tables to provide immediate results.

FAQ

Q: Can I use this report to bulk-update default values? A: No, this is a reporting tool. To update values, you would use the Blitz Report setup forms or API.

Q: Does it show system-level defaults like ‘sysdate’? A: Yes, it shows the literal values or SQL expressions used as defaults.


© Enginatics GmbH