Blitz Report™ Changelog

History of new functionality, updates and bug fixes for each Blitz Report™ release

Version:

3.3.1

New Features

  • Financial Statement Generator – Beta version of Blitz FSG allowing to query GL balances through an Excel function and drill down to sub ledger without opening the EBS UI
  • BI Publisher import – Added new ‘Blitz Report BI Publisher Import’ concurrent program
  • SSRS import – Added new ‘Blitz Report SSRS Import’ concurrent program for automated import of Microsoft SQL Server Reporting Services (SSRS) rdl report files

Updates

  • Report run – Enabled automated refresh of function values in uploaded Excel templates
  • Report run – Enhanced performance of reports with large clob column data and limited the column width detection to the first 400 instead of 600 records only
  • Report run – Enhanced ‘Error parsing SQL’ message to show ‘Enter required parameters before opening the template.’ when opening a template for a report with dynamic SQL requiring entered parameter values
  • Report run – Added call to cep_standard.init_security before report execution to enable running cash management queries
  • Report run – Enhanced report PLSQL API with return status and error message
  • Report run – Added call to cep_standard.init_security before report execution
  • Report run – Changed the template LOV sort order to show the most recently used templates first for each user
  • Report run – Changed license validation logic to immediately disable report execution for users without a Blitz Report Access profile option value
  • Data upload – Introduction of multi language and multi date format support
  • Data upload – Various performance enhancements, for example to use bind values in dynamic sql execution for cell comments and default values
  • Data upload – Enhanced performance of the INV Item Upload. Switched to use Open Item Interface will support for multiple parallel import requests
  • Data upload – Changed date columns to date instead of character format in Excel
  • Data upload – Enhanced upload code to work on EBS release 11i using mod_plsql
  • Data upload – Enabled ‘Hide All’ button for upload template columns
  • Data upload – Enabled template column display sequence updates for uploads, to allow re-ordering of columns by typing the new position number
  • Report setup – Enabled the RDF export program to work on EBS release 11i
  • Report setup – Allow addition of custom parameters to Enginatics seeded reports and keep them during subsequent code upgrades
  • Report setup – Removed obsolete profile option ‘Blitz Report Start Window’, as this setting is replaced with profile ‘Blitz Report Start Tab’ instead
  • Report setup – New function xxen_util.dff_columns to dynamically generate sql text for descriptive flexfield columns
  • Report setup – Renamed report ‘AR Aging – 7 Buckets – By Salesperson/Agent’ to AR Aging
  • RDF import – Enhanced import routine to handle reports with long names
  • Installation script – Various enhancements to the detection of the ISG installation status, warning messages and managing the online upgrade maintenance mode
  • Installation script – New profile option ‘Blitz Report Load Default Assignments during Upgrades’ to control automated load of default assignments during upgrades
  • Installation script – Moved the forms integration code from CUSTOM.pll to XXEN.pll for easier upgrades

Fixes

  • ECC import – Corrected Enterprise Command Center imports having deactivated parameters tab after import
  • Report setup – Fixed FRM-40735: WHEN-VALIDATE-RECORD trigger raised unhandled exception ORA-06502, when removing the license key
  • Report setup – Corrected last_updated_by not shown in parameter LOV history after using mass_change API
  • Report run – Fixed ORA-06502: PL/SQL: numeric or value error: NULL index table key value, when trying to run a report without having the Blitz Report Access profile option set
  • Report run – Fixed ORA-00932: inconsistent datatypes: expected – got CLOB, when running reports having beforereport DB Package code, such as ‘AR Aging – 7 Buckets – By Salesperson/Agent’
  • Report run – Resolved ORA-00933: SQL command not properly ended when running ‘AR Transactions and Lines’ by gl period and gl date at the same time, due to incorrect removal of line feed chr(10)
  • Report run – Resolved ORA-00932: inconsistent datatypes: expected CHAR got NUMBER trying to parse/access the template of ‘CST AP and PO Accrual Reconciliation’
  • Report run – Fixed scheduled reports ending with missing required parameter warnings, such as: Please enter a period, posted date, batch or journal restriction
  • Report run – Fix for scheduled reports no longer showing an output file
  • Report run – Fixed multiple values with like operator, such as a%;b% did not work with mixed case :Bind names
  • Report run – Dependent parameter default values, starting with :$flex$ did not work anymore
  • Report run – Runtime options window was incorectly opening when using the F1 key while the cursor navigation was on the New Template button
  • Report run – Saving null parameter default values to clear out the report defaults did not work anymore
  • Report run – Reports with uploaded xlsm templates were incorrectly generating output files as xlsx
  • Report run – Fixed ORA-00918: column ambiguously defined, when running the MSC Pegging Hierarchy report
  • Report run – Fix for ‘The LOV query is not valid’ error after upgrading Blitz Report when opening reports using LOVs with dependent parameters
  • Report template – Corrected template column reordering not working and showing ‘Do you want to save changes you have made’, when entering a new display sequence and navigating to a different record through the mouse or arrow up or down key
  • Forms assignment – Fixed ORA-00900: invalid SQL statement, when running a report without a template through zoom forms integration directly after running a report which had a template
  • Data upload – Fix for PL/SQL: numeric or value error due to text size exceeding 4k in excel cell
  • Data upload – Corrected multibyte characters in LOV’s
  • Data upload – Fixed output file not opening when trying to run an upload with an invalid license key
  • Data upload – Fixed “Uploaded file is generated from a different database xx”, when running upload on a multi node RAC database
  • Data upload – Fixed missing required flag when copying upload templates
  • Data upload – Corrected column names appearing editable in the template screen
  • Data upload – Corrected remove+close template functionality for uploads
  • Data upload – Corrected upload parameters form not saving removal of mapped column names
  • Data upload – Fix for ORA-01722: invalid number when using different number formats between Excel and EBS
  • Data upload – Corrected ‘Please enter a value to limit the list.’ message when using upload LOVs in Excel
  • Discoverer import – Fixed ORA-01427: Subquery returns more than one row, when accessing Discoverer Folder import LOV
  • Discoverer import – Fixed ORA-00001: unique constraint (XXEN.XXEN_DISCOVERER_SHEETS_U1) violated, when running Blitz Report Discoverer import concurrent program
  • Discoverer import – Fix for ORA-00903: invalid table name, when opening migrated Discoverer reports with LOV queries based on a custom SQL Discoverer folder having a name starting with a digit
  • Discoverer import – Fixed workbook XML file upload rejected and ORA-01722: invalid number, when trying to import Discoverer workbooks, which are owned by database instead of EBS user accounts
  • Installation script – Fixed ORA-00972: identifier is too long in install.sh
  • Installation script – Fix for ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes, when running install.sh
  • Installation script – Fixed “ORA-00955: name is already used by an existing object, ORA-06512: at line 14” when upgrading Blitz Report directly after an upgrade from 12.1.3 to 12.2
  • Installation script – Corrected compilation error on DB versions lower than 19c: PLS-00222: no function with name ‘L_ROWS_TAB_TYPE’ exists in this scope
  • Installation script – Fixed ORA-01407: cannot update (“XXEN”.”XXEN_REPORT_PARAMETERS_TL”.”SOURCE_LANG”) to NULL, when upgrading Blitz Report after manually downloading and importing blitz reports from the online library
  • Installation script – Fixed ORA-00001: unique constraint (XXEN.XXEN_REPORT_PARAMETERS_U2) violated, when loading seeded Enginatics reports
  • Installation script – Fixed ORA-00001: unique constraint (XXEN.XXEN_REPORT_PARAMETERS_U3) violated, when loading seeded Enginatics reports
  • Installation script – Fix for ORA-30926: unable to get a stable set of rows in the source tables
  • Installation script – Added workaround for FRM-30085 happening occasionally in edition enabled databases

New Uploads

New Reports

Updated Uploads

Updated Reports

Blitz Report Financial Statement Generator (FSG)
Blitz Report BI Publisher Import

3.3.0

New Features

  • Blitz Upload – Create or update even very large data in Excel and upload it to EBS, replacing Web ADI or other data loader tools
  • RDF import – Automatically convert custom RDF reports into Blitz Report
  • BI Publisher import – New concurrent program to import BI Publisher reports
  • New API to create Blitz Reports from PLSQL and return the output file as a blob without running a concurrent request, to allow integration with custom code and technologies such as APEX
  • Report access – New concurrent program Blitz Report Update Menu Entries. Automatically add or remove the Blitz Report function for all active menus

Updates

  • Forms assignment – Enhanced forms assignment to allow passing default parameter values to hidden parameters. For example for forms having an organization_id column, but the report requiring an organization code parameter value.
  • Blitz Report UI integration – Disabled the Excel menu icon if the Blitz Report function not part of the menu or the Blitz Report Access profile option is not set
  • Report run – Updated user and template parameter default value logic to only save values if they are different than the report level defaults
  • Report run – Enhanced performance when running reports with large SQLs and many parameter binds, such as GL Balance
  • Report run – Enhanced email validation to avoid ‘invalid email’ message when entering a comma-separated email distribution list with line feeds
  • Report run – Updated email LOV to exclude emails of inactive users
  • Report run – Increased the template LOV window width to show the template owner
  • Report run – Enhanced report search and LOV performance and removed obsolete profile option ‘Blitz Report Restrict Assignments by Operating Unit Level’
  • Report run – Added session initialization statement to log file to simplify debugging with DB access tools
  • Report run – Enhanced error logging by writing the failed report status into the xxen_report_runs history table
  • Discoverer import – Added uploaded workbook XML count to Setup > Tools > Import > Discoverer Folder import LOV to show which object_use_keys are eligible for imported
  • Discoverer import – Enhanced Discoverer workbook upload message to include already existing and rejected workbook count
  • Discoverer import – Enhanced error logging to show workbook name and owner instead of doc_id
  • Discoverer import – Various performance enhancements, such as automated gather table stats before import
  • Report setup – Enabled &lexical replacement for strings derived from custom DB Package variables
  • Report setup – New profile option ‘Blitz Report Show Hidden Parameters’, which allows Developers to show hidden parameters for debugging purposes, or to store default hidden parameter values against templates
  • Report setup – Added support for dynamic SQL in the default email field on report level, which allows using a SQL query to derive the email default dynamically
  • Report export – Enhanced XML export/import to include the latest version comments
  • Report export – Changed XML Export to not include LOV, Category and Columns by default for better performance and to avoid accidentally overwriting existing later versions of LOVs
  • Report import – Enhanced XML import performance by including anchors and parameter dependencies in the XML file
  • Report import – Enhanced LOV XML import logic to allow updating an LOVs Filter Before Display setting to ‘Y’, but not the other way around
  • Installation script – Improved performance by loading Enginatics reports in parallel batches
  • Installation script – Added a new skip_db parameter to reduce installation time on multi-node systems with non-shared appl tops
  • Installation script – Enhanced detection of CUSTOM.pll update requirements during upgrades
  • Installation script – Added support for EBS version 12.0.6

Fixes

  • Report run – Fixed ORA-00911: invalid character, when using a multiple values string with an or clause and single upperquote, such as a%;b’%
  • Report run – Corrected ORA-06502: PL/SQL: numeric or value error, when launching reports from a standard forms assignment, which have a date parameter with a dynamic default and a saved user default value
  • Report run – Fixed ORA-01830: date format picture ends before converting entire input string, when using hardcoded to_date(…,’DD-MON-RRRR’), such as view pa_expend_items_adjust2_v
  • Report run – Fixed ampersand character incorrectly removed from sql text when used in strings such as hp.party_name like ‘Business-R&D Projects’
  • Report run – Fixed ORA-06502: PL/SQL: error : buffer de cadenas de caracteres demasiado pequeño numérico o de valor, ORA-06512: en “APPS.XXEN_UTIL”, línea 934, when encountering a Blitz Report SQL error in foreign languages
  • Report run – Segment value descriptions were not shown for segments with a dependent value set, for example in GL Account Analysis or GL Balance
  • Report run – Incrementing date parameters for scheduled reports with monthly intervals did not work
  • Report run – Resolved issue when MSC Reports are run from the EBS Instance and the users current language is not an installed language on the ASCP Instance. In this scenario the MSC Report will run in the ASCP Instance base language
  • Report run – Corrected multiple values not allowed for reports with dynamic parameter sql_text, for example running GL Account Analysis for multiple ledgers
  • Report run – Reports with null display_sequence parameters did not return any data when used with multiple values, for example running ‘CAC Inventory to G/L Reconciliation’ for multiple ledgers
  • Report run – Fixed Zoom form integration incorrectly hiding disabled reports from Developers
  • Report run – Fixed display of Validate From List and Filter Before Display for LOV Oracle parameter types
  • Report run – Corrected Invalid value ‘1’ for parameter: set_of_books_currency, when scheduling reports with dependent parameter values, such as ‘FA Journal Entry Reserve Ledger’
  • Report run – Fixed ORA-12725: unmatched parentheses in regular expression, when using the xxen_util.contains() function with corrupted ascii=0 character data
  • Report run – Corrected various forms navigation issues related to Report and Template querying
  • ECC import – Corrected blank screen was shown after import instead of imported ECC report
  • Report import – Fixed ORA-00001: unique constraint error when importing report XMLs with default values for parameters without display sequence
  • Report import – Fixed ORA-06502: PLJSQL: numeric or value error: character string buffer too small, when trying to import a corrupted XML
  • Report import – Fixed ORA-01722: invalid number, when trying to import a report XML with a template having automatically hidden dynamic columns, and having ICX numeric characters differently set during the previous export.
  • Report import – Fixed unique constraint error when importing report XMLs with default values for parameters without display sequence
  • Report import – Fixed error ORA-06502: PL/SQL: numeric or value error: character string buffer too small, when trying to import a corrupted XML
  • Report setup – Corrected Validate From List and Filter Before Display display for LOV Oracle parameter types
  • Report setup – Fixed ORA-06502 and ORA-01403 while checking the Blitz Report license on the Setup window
  • Report template – Fixed parameter values still passed for a template with excluded parameters after populating parameter values for a template without parameter exclusion
  • Discoverer import – Fixed ORA-06502 character string buffer too small during discoverer import
  • Discoverer import – Fixed ORA-00001: unique constraint violated, when running the Blitz Report Discoverer Import concurrent program for specific workbooks having the same AxisItem of two different item types
  • Discoverer import – Fixed Discoverer import ORA-00942: table or view does not exist, when using folders from an external database link
  • Discoverer import – Added missing version history record for newly created Discoverer LOVs
  • Discoverer import – Fixed Discoverer import missing LOV version creation
  • Forms assignment – Fixed incorrect parameter value defaulting when running the same report through the forms assignment from different forms after each other
  • Forms assignment – Fixed form integration incorrectly hiding disabled reports from Developers
  • Forms assignment – Corrected 11i GL drilldown forms assignments error due to item LEDGER_NAME not found
  • Seeded 11i reports – Removed incorrect R12 table references from 11i installation file, for example referencing gl_ledgers instead of xxen_gl_ledgers_v
  • Fixed INV Item Supply/Demand report no longer working for multiple items
  • Installation script – Fixed issue with deriving the ASCP Instance in the case the client has multiple instances defined in the ERP instance with the same Instance ID
  • Installation script – Fixed ORA-31011: XML parsing failed, when loading seeded Enginatics reports on non UTF8 character set databases
  • Installation script –- Scheduled blitz reports were losing parameter values during upgrades

New Uploads

New Reports

Updated Reports

Blitz Upload to load data from Excel to EBS and replace Web ADI and other slow load tools
Automatically add or remove the Blitz Report function for all active menus
Import RDF reports into Blitz Report automatically

3.2.6 

New Features

  • Introduced Blitz Report Web, an OAF page to run blitz reports
  • Added support for Standby Active Data Guard via ADG DML redirect. The new profile option ‘Blitz Report Target Database’ and Target Database field allows moving reporting load to a standby server
  • Report template – Added the possibility to exclude parameters at the template level
  • Added the Output File Name runtime option, which allows users to customize the downloaded Blitz Report output file name
  • Released more than 90 cost accounting reports

Updates

  • Installation script – Added compatibility for EBS 11i running on IBM AIX and Solaris by including 32-bit instantclient sqlplus versions
  • Installation script – Added Blitz Report Web to create_menu_entries_sh and removed choice between Top and End, as no customer was using Top
  • Report template – Changed ctrl-F11 template name search to case-insensitive
  • Hide Blitz Report entries automatically in the forms navigator for users not having access to a Blitz Report license (access profile is blank)
  • Discoverer import – Added ‘History Date From’ and ‘Report Name Prefix’ parameters to ‘Blitz Report Discoverer Import’ concurrent program
  • Discoverer import – Enhanced LOV import logic to update ‘Validate from List’
  • Discoverer import – Enhanced to have not like conditions as complex condition in parameters, included case sensitive into conditions, handled duplicate calculations with same name but different expressions, aggregation in subtotals will be limited to the current scope and corrected issues of buffer overflow for advanced required parameters
  • Discoverer import – Enhanced migration routine to handle subtotals, have logic to get tabular layout using a macro, parameter exclusion logic and report name to start with a customer based prefix
  • Discoverer import – Corrected remove_to_date() function to remove to_date() if there is either a :bind or a column_name containing the word ‘date’+
  • Discoverer import – Support of aggregation type ‘Count Distinct’
  • Discoverer import – Support for having-clauses conditions through a new &having_clause lexical, replaced with &template_having_clause
  • Report template – Added option to exclude parameters for individual templates
  • Report template – Added new report category column to the template LOV
  • Report template – Added support for Excel template uploads with pivot tables based on data models
  • Enhanced performance of ONT Order Headers and Lines report
  • Standard forms integration – Added a new parameter to the xxen_reports procedure allowing to define a special menu entry number for Blitz Report
  • Report setup – New profile option ‘Blitz Report License Expiration Warning Days’ to ensure that customers do not miss the license renewal
  • Report setup – Enhanced bind variable mapping logic to better handle multiple variables used in sql text, such as for between conditions
  • Report setup – Enhanced n=n anchor matching logic to allow spaces before or after the equal sign
  • Report setup – Added Database Name and Current Date to License Key window
  • Report setup – Enhanced import menu functionality to remember a user’s previous setting
  • Report execution – New Output File Name runtime option allowing to customize the downloaded Blitz Report output file name

Fixes

  • Discoverer import – Include workbooks which have doc_batch=1 instead of just 0
  • Discoverer import – ORA-01745: invalid host/bind variable name, when having migrated bind parameters named as reserved keywords
  • Discoverer import – ORA-21560: argument 2 is null, invalid, or out of range, when trying to upload a Discoverer zip of .eex files with one of them having zero size
  • Output file names – Fixed incorrect output file naming under $APPLCSF/out
  • Output file names – Fixed bug preventing use of date-time format strings in filename tokens
  • Report template – Non privileged users were incorrectly allowed to save and clear other users’ template default values
  • Report template – Copy template functionality was missing template parameter default values for hidden parameters
  • Report setup – ORA-00001 unique constraint error on XXEN_REPORT_TEMPL_EXCL_PAR_U1 when importing reports with template parameter exclusions
  • Installation script – Profile option ‘Blitz Report Template Access’ was incorrectly set to null during upgrades
  • Standard forms integration incorrectly opens Blitz Report form with an empty setup window if the Blitz Report setup window was open already
  • Report Execution – ORA-06502: PL/SQL: numeric or value error: character to number conversion error, when running MSC reports from the Supply Chain Hub. Changed multiple parameter expansion logic to expand before beforereport plsql trigger execution.
  • Report execution – ORA-00932: inconsistent datatypes: expected DATE got NUMBER, when running ‘PO Purchase Requisitions with PO Details’, due to binding a date variable with a char data type
  • Report execution – Run button incorrectly stayed active after clearing the template name on the runtime options screen and then clicking Run
  • Report output – Excel pivot is corrupted when the pivot value aggregated column name has <,> or & in it
  • Report execution – ORA-06502: PL/SQL: numeric or value error: character string buffer too small at XXEN_API, line 109, when having report parameters with a long SQL Text, close to 4000 characters
  • Report setup – ORA-00001: unique constraint (XXEN.XXEN_REPORT_DEFAULT_TMPL_U1) violated, when importing report XML containing template default values due to corrupted Discoverer import data
  • Report setup – Import name field was incorrectly shown for XML Upload
  • Report execution – ORA-06502: PL/SQL: numeric or value error: character string buffer too small, when using long report and template names
  • Report execution – ORA-01722: invalid number, when running reports with parameters using the :run_id bind variable, for example starting reports from the Supply Chain Hub
  • Report execution – ORA-00001: unique constraint (XX.XXEN_REPORT_TEMP_IDS_U1) violated, when trying to run reports for multiple selected items from the Supply Chain Hub
  • Report execution – Operating Unit LOVs didn’t work for reports requiring single org initialization, when run from a responsibility with multi org access with ‘MO: Security Profile’ set, but having ‘MO: Default Operating Unit’ blank. Oracle’s mo_global.init(‘S’) incorrectly set’s the mo access_mode to M without doing the M initialization (mgoat remains empty)

New Reports

Updated Reports

Blitz Report Web
Redirect blitz report load to a standby database
Blitz Reports template specific parameter exclusions

3.2.5 

New Features

  • Discoverer import – The new folder import process automatically migrates complete Discoverer workbooks, including formulas, conditions, parameter defaults, crosstab layouts and other properties
  • Report template – Enabled more granular template sharing on Site, Responsibility and User levels
  • Report setup – The new request type field allows setting up concurrent manager specialization rules to assign specific blitz reports to different managers
  • Microsoft Power BI integration – Introduced a new anchor :sheet_name to support dynamic Excel sheet naming
  • Dynamic output file naming allows including parameter values, such as organizations or financial periods names

Updates

  • Report execution – In case of multiple occurrences of the same :bind in the SQL Text of different parameters, bind a parameter value only to the first occurrence.
  • Forms assignment – Added defaulting of forms block item name from the parameter name when assigning default parameter values
  • Report setup – Increased maximum allowed parameter SQL Text size from 4000 to 32767 characters
  • Report setup – Enhanced performance when querying reports with large dependent LOVs on the setup window, such as the DBA SGA Active Session History
  • Report setup – Enhanced performance when querying reports with large SQL queries on the setup window, for example AR Aging – 7 Buckets – By Salesperson/Agent
  • Report setup – Added automated source_lang correction to the ‘Blitz Report Maintain Multilingual Tables’ concurrent program
  • Report template – Automatically include new dynamically generated columns during SQL execution, for example when using different chart of accounts
  • Added backend code for Public Sector Financials (PSA) Budgetary Control Results report
  • Added a new profile option ‘Blitz Report Include SQL in log’ allowing to show or hide the report’s SQL in the log file
  • Report execution – Enhanced performance when opening reports with many dependent parameters such as GL Account Analysis. Moved parameter dependencies from gtt to permanent table xxen_report_param_dependencies to enable result cache for LOV queries and default values.
  • Installation script – Added a check that the installation was started from the apps tier owner.
  • Installation script – Corrected warning messages in install.sh so that they show up in the error summary

Fixes

  • Report setup – Report exclusions at the responsibility level did not take effect
  • Report delivery – Code correction to use Oracle’s new concurrent requests delivery option ‘Send output as attachment’
  • Report execution – Reports with multiple default values, saved for dependent parameters, had an incorrect in-clause inserted, in case they were run from a responsibility not having access to the saved default values
  • Report execution – ‘Change Organization’ selection was not shown automatically when opening inventory related reports from a responsibility which did not have access to the previously set inventory organization
  • Report setup – Anchors were not available in parameter anchor LOV after uploading large SQL exceeding 32767 characters
  • Report setup – License Users report started from a double click on the active users count on the license key window end in error if a report with a template was run directly before
  • Report setup – Corrected duplicated report count in forms assignment LOV
  • Report template – Corrected template columns’ display sequence LOV to only show visible columns
  • Installation script – ‘ERROR: Invalid parameter CUSTOM_APP:’ when running installation script for the first time and there was an issue during the installation (e.g. missing grants to insert into the tablespace of the created xxen_report_license_key table)
  • Report execution – Column ambiguously defined duplicate column issue in GL Account Analysis reports when chart of account segments are defined uppercase, e.g. PROJECT or ACCOUNT
  • Report execution – ORA-00904: “ROW4″.”VALUE_”: invalid identifier, when running AP Trial Balance in an environment having “ACCOUNT” in the chart of accounts segments
  • Report setup – Corrected missing parameter dependency update after modifying an LOV query
  • Installation script – Resolved issue with XXEN_FA_FAS_XMLP package not compiling at some client sites with earlier patching level
  • Installation script – Improved PN code level installed check to check for both Equipment Lease and required IFRS objects
  • Report execution – LOVs for reports with parameter :$flex$ dependencies matching by LOV and Parameter Name do not show any values since upgrade to 3.2.4
  • Report setup – Cannot insert null into xxen_report_zoom_param_vals.parameter_id when trying to import forms parameter assignments for a report that exists with the same name in two different languages

New Reports

Updated Reports

Blitz Report additional out dir and file
Blitz Report template sharing window
Blitz report request type
Dynamic sheet naming

3.2.4 

New Features

  • Report template – Moved the layout template functionality on the run window to reduce navigation steps
  • Blitz Report UI integration – New menu entry and icon replacing the zoom button to call Blitz Report from any Oracle standard form

Updates

  • Report execution – SQL error messages show the problematic line number and SQL text
  • Report template – Enhanced template functionality to remember the column names in case of dynamic changes, for example due to different chart of accounts, and to add new SQL columns automatically
  • Report output – Enhanced output filename logic to support cases where the client and database character set are different, for example on Arabic client operating systems
  • Report setup – Аdded profile option ‘Blitz Report Debug’ to always open the logfile automatically to facilitate development and testing of dynamic SQL scenarios
  • Installation scipt – Removed prompts for custom data and index tablespaces leaving possibility to define environment variables before the first installation
  • Discoverer import – Updated dynamic template column functionality to add hidden columns in Discoverer folder and RWB import code, and to add them to already existing customer templates
  • Discoverer import – Removed business area assignment from Discoverer folder import and keep assignments from workbooks (containing the imported folders) only
  • Discoverer import – Enhanced folder import logic to create readable table aliases for complex views
  • Discoverer import – Enhanced logic to import folders and columns based on the latest execution of a specific Discoverer workbook and worksheet only
  • Discoverer import – Set public flag for templates with existing access priviliges only
  • Discoverer import – Default ‘Date To’ parameter values with the last day of the month, based on the ‘Date From’ value
  • Discoverer import – Discoverer Folder import automatically removes owner from table names if there exists an apps synonym
  • Report output – Enhanced Excel output column width calculation for all languages, supporting multibyte characters
  • Report execution – Improved forms UI and report performance when using large multiple parameter values strings

Fixes

  • Report output – Data sheet Excel template upload for large files produces corrupted output files
  • Installation script – Resolved ORA-00942: table or view does not exist, when upgrading BR from 3.2.0 on an envionment, which was freshly upgraded from 12.1.3 to 12.2.x
  • Discoverer import – Corrected ORA-00904: invalid identifier errors due to missing schema and package name information
  • Discoverer import – Fixed discoverer folder import error when the column text (formula+column alias) exceeds 251 chars
  • Discoverer import – Corrected column alias for Discoverer Folder import
  • Upgrade script – Fixed upgrade.sql to avoid ORA-01430: column being added already exists in table adding sheet_type to xxen_report_template_files
  • Report template – Fixed templates column position not retained after searching for columns
  • Report output – Corrected column names containing special characters such as é showing up in all uppercase in report column headers and template screen
  • Report template – Fixed ORA-06502 error when uploading an Excel template while logged in with German UI language
  • Report execution – Fixed ORA-14551: cannot perform a DML operation inside a query, when scheduling reports with multiple parameter value strings
  • Report setup – Fixed ORA-01843: Not a valid month, when trying to save zoom parameter values after chaning the date format to MM/DD/YYYY.
  • Discoverer import – Added support to import folders based on complex view object types (COBJ)
  • Report template – Fixed ORA-01400 cannot insert null into STYLE_ID when uploading an Excel template
  • Report execution – Fixed FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-00001, when entering a multiple parameter values string with duplicate values
  • Zoom functionality – Fixed constant parameters not defaulting if the parameter LOV is dependent on other parameter values
  • Report execution – Fixed ‘DBA AWR SQL Performance Summary’ report not returning SQL text and other dynamic columns anymore
  • Report execution – Fixed ORA-01403: no data found in sheet break functionality after commenting one of the columns in the underlying SQL

New Reports

Updated Reports

Blitz Report Template name on run window
Blitz Report parameter values passed from a standard Oracle form changelog

3.2.3 

Updates

  • Blitz Report – “AR Aging – 7 Buckets – By Salesperson/Agent”. Change to allow the report to be run across multiple Ledgers or OUs (from those accessible to the current responsibility as determined by MO Global Security constraints). Reporting Context is now optional and also supports selecting multiple parameter values.
  • New Blitz Report: FA Asset Summary Report (Germany). Extended the functionality to allow the report to be run across accessible ledgers and/or depreciation books as per the requested enhancement.
  • Discoverer import – Added folder import option to create SQL based on historically used columns only, instead of all folder columns
  • Discoverer import – Enhanced Discoverer Folder import to only create templates if there is more than one workbook per folder combination imported. If there is only one, the workbook name will become the Blitz Report name instead of the folder names
  • Profile option – Renamed the profile option XXEN_REPORT_ALLOW_TEMPLATE_CREATION to XXEN_REPORT_TEMPLATE_ACCESS and introduced ‘Super User’ template access allowing to modify other owner’s templates
  • Report execution – Increased parameter multiple values limit to 32K bytes
  • Report execution – Resolved issue with certain ICX Date Formats resulting in character parameter values being converted to date format in XML Publisher Linked Reports resulting in error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Fixes

  • Report setup – Fixed ORA-01006 when opening the setup for reports having an XML beforereport trigger or DB package defined
  • Blitz Report – AR Aging – 7 Buckets – By Salesperson/Agent. Change to set dynamic bucket title alias width based on clients max allowable column width.
  • Report setup – Fixed parameter default values incorrectly stored for hidden parameters when importing or copying templates
  • Discoverer import – Fixed ORA-00972: identifier is too long, when using Folder import option on pre 12.2 database versions
  • Report import – Fixed ORA-00001: unique constraint (XXEN.XXEN_REPORT_PARAM_DEF_VALS_U1) violated, when using XML Upload with report templates containing default parameter values
  • Report execution –  Fixed no data returned when scheduling reports, for example GL Account Analysis (Distributions), if default parameter values are cleared out
  • Report setup – Correcting LOV query logic to retain comments with database hints
  • Report setup – Fixed ORA-01722: invalid number, when using :$flex$ dependencies on parameters of type Oracle standard LOV, e.g. report AR Applied Receipts
  • Report setup –  Resolved issue in a certain scenario where the Flex Bind SYS Context is being incorrectly set to the parameter value instead of the parameter value ID for Oracle LOV based parameters. In the scenario where a parameter has a dependent parameter with multiple dependencies (:$flex$. references to more than one parameter), and one of those references uses the :$flex$..value notation, then the flex bind sys context is set to the parameter value in all the referenced parameters instead of just the parameter using the .value notation.

New Reports

Updated Reports

Blitz Report Discoverer Folder import include columns

3.2.2 

New Features

  • Report template – Option to define template specific parameter default values to allow different parameter restrictions depending on the template
  • Report template – Excel template upload now supports Excel functions, pictures, screenshots, charts, header footers, comments, notes and freeze panes in the datasheet

Updates

  • Report template – Increased the maximum allowed template column identifier length from 30 to 128 bytes for DB versions 12.2+
  • Report template – Template column positions can be moved even after setting a column name filter
  • Report template – Enhanced Excel template upload performance

Fixes

  • Report setup – Fixed XML import not working for some larger reports on database version 11g
  • Report scheduling – Fixed increment dates functionality for scheduled blitz reports with date parameters incorrectly shifting the month instead of the day for date format MM/DD/YYYY
  • Report scheduling – Fixed delivery options email subject cleared out for scheduled reports, when the subject line does not contain a single token, such as &ROW_COUNT
  • Report scheduling – Fixed scheduled reports ending with Warning: ‘Invalid value ‘x’ for parameter: y’ if the parameter LOV validation depends on fnd_profile.value(‘MFG_ORGANIZATON_ID’)
  • Report execution – Fixed ORA-00923: FROM keyword not found where expected, when using all uppercase column names starting with a digit in a template
  • Fixed ‘ORA-12899: value too large for column’ when uploading Excel templates with a file name longer than 100 characters
  • Installation scipt – Create required custom indexes on standard tables only if these columns aren’t indexed yet
  • Installation scipt – Fixed installation error ‘Import of XML file: reports_from_category_Enginatics.xml failed. ORA-31011: XML parsing failed’, in case of installation on non UTF8 database charactersets not supporting all delivered Blitz Report languages
  • Installation script – Fixed upgrades incorrctly changing the Blitz Report function type from form to subfunction on non UTF8 charset databases
  • Installation script – Fixed incorrect installation date of a previous Blitz Report version was displayed during upgrades

New Reports

Updated Reports

Blitz Report save template specific parameter default values
Blitz Report additional data sheet formatting options
Blitz Report Pivot Template output translated to support 36 languages

3.2.1 

New Features

  • Report delivery – Introduced email sending functionality for EBS 11i
  • Report content – Several new reports replacing Oracle standard text format reports, for example Inventory Cycle Counts

Updates

  • Report setup – New profile option ‘Blitz Report Disable SQL Text Double Click Editor Window’ to allow SQL text highlighing through double click
  • Report export – Enhanced report definition XML export performance for reports including uploaded Excel template files
  • Report output – Increased performance for large Blitz Report output file writing on the apps node
  • Report output – Automatically run Excel refresh macro when opening Excel workbook having references from different sheets
  • Multi language support – Enhanced pivot and Excel upload label translations to support 36 languages
  • Report output – Added compression to report template XML export to minimize file size
  • Excel template upload – Added logic to automatically correct corruption caused by a Microsoft Excel 2013 version bug
  • Installation script – Added database name to installation logfile

Fixes

  • Report execution – Fixed ORA-00923: FROM keyword not found where expected, when using all uppercase column names starting with a digit in a template
  • Installation script – Fixed ‘Import of XML file: reports_from_category_Enginatics.xml failed. ORA-31011: XML parsing failed’, in case of installation on non UTF8 character set databases not supporting all delivered Blitz Report languages
  • Report template – Fixed ‘ORA-01858: a non-numeric character was found where a numeric was expected, at “APPS.XXEN_REPORT”, line 4039’, when date fields are used in pivot table rows or columns and have null values
  • Report template – Fixed ‘ORA-31011: XML parsing failed ORA-19213: error occurred in XML processing at lines 2 LPX-00240: element-start tag is not well formed’ when using multibyte characters in non UTF8 character set databases
  • Report output – Fixed certain multibyte characters, such as emojicons corrupting the output file structure
  • Report output – Fixed incorrect Excel creation and modified dates, when using Excel template upload functionality
  • Report export – Fixed ‘numeric or value’ forms error when trying to export report XML files for very long report names
  • Report template – Fixed ORA-00900: invalid SQL statement, when running reports with a template, after changing the SQL to no longer match the template column name with display sequence 1
  • Report delivery – Corrected email delivery rows duplication for scheduled Blitz Reports
  • Report template – Fixed ORA-06502: PL/SQL: numeric or value error ORA-06512: at “APPS.XXEN_REPORT”, line 4294967295 error while importing or running a report with an Excel template including large pivot table definitions
  • Report execution – Fixed ‘ORA-00936: missing expression’ on 12.1.0.1.0 DB versions in combination with large SQLs such as ‘CAC Inventory to G/L Reconciliation’
  • Report output – Corrected dependent parameters default date values showing an incorrect date (one day earlier, e.g. 31-Dec-2020 instead of 1-Jan-2021), if timezone conversion is enabled and the client timezone is set to a later (further east) time than the server
  • Report template – Correction for too many data sheets created when there is a sheet break defined for a column not having the first sort order priority

New Reports

Updated Reports

Blitz Report Template screen translated to support 36 languages
Blitz Report Pivot Template output translated to support 36 languages

3.2.0 

New Features

  • Report template – Excel template upload functionality allowing creation of additional sheets with graphs, pie charts, macros or any other Excel functionality
  • Report content – Several new reports replacing Oracle standard text format reports, for example for Cash Management and Fixed Assets

Updates

  • Changed output filenames from underscore to space and to concatenate report and template name. There is a new profile option ‘Blitz Report File Name Convention’ to control the naming logic
  • Multiple values – Enhanced wildcard detection to work for strings such as a;b;c instead of just a%;b%;c%, if the parameter sql_text contains a like operator with ‘%’
  • Enhanced the xxen_util.time function to work for negative numbers, e.g. to show a time difference for too early or delayed shipments in human readable format
  • Report template – Removed the shortkey alt+r from the reset button to prevent users from accidentally resetting the template
  • Installation script – Enhanced to support EBS running on MS Windows OS with MKS Toolkit
  • Installation script – Changed the blitz report zip filename to include the version date

Fixes

  • Report template – Fixed available template column display incorrectly showing up in uppercase, e.g. COMPANY WITH DESCRIPTION
  • Report setup – Fixed ‘FRM-40654: Record has been update by another user’ when uploading a large SQL from a file
  • Report setup – Fixed SQL download from version history not working for SQLs larger than 32000 characters
  • Report setup – Fixed LOV version history created_by entry incorrectly showing LOV created_by instead of the last_updated_by of the LOV history change record
  • Report output – Fixed missing Camel Case translation for columns containing $ or #, such as code_line# -> Code Line#
  • Report output – Fixed aggregated columns disappearing from pivot table after refresh in Excel
  • Discoverer import – Fixed ORA-06502: PL/SQL: numeric or value error, when importing Discoverer folders with multibyte characters or running reports with multibyte bind variables longer than 30 bytes
  • Report execution – Cursor navigation retains parameter position when running a report

New Reports

Updated Reports

Blitz Report in Oracle EBS standard form personalization integration
Blitz Report in Oracle EBS standard form personalization integration
Blitz Report in Oracle EBS standard form personalization integration

3.1.10 

New Features

  • Report template – Sheet break functionality which allows splitting the output file into different sheets for every column value change
  • Report template – Column filter fields to quickly find specific available or displayed columns
  • Report setup – Version history for LOV changes
  • Report setup – ‘Copy LOV’ menu option
  • Report setup – ‘Resequence Parameters’ menu option to assign new parameter sequence numbers automatically

Updates

  • Report export – Added ‘select all’ option to export checkbox options
  • Report template – New unique index on template columns sort order to avoid duplications
  • Zoom functionality – Added functionality to set the parameter values to null or a constant value when running a Blitz report from an Oracle standard form via zoom
  • Report delivery – Changed maximum email length to 240 characters, which is the same as the OPP delivery options limit
  • MRP Horizontal Plan – Added function to retrieve BOM Level and BOM Sort Order
  • Report execution – Enhanced performance for dependent parameter LOVs (:$flex$.) by using a system context instead of a PLSQL function
  • Report execution – Changed column translation logic to preserve original column names, if they are inside double upper quotes in the SQL, such as “Supplier Name”
  • Report execution – Enhanced automated INV Organization setting popup to detect if the MFG_ORGANIZATION_ID profile option is used in LOV custom or parameter default values
  • Report setup – Added ‘Used by’ button also for Oracle Standard LOV type popup window

Fixes

  • Report execution – Fixed dependent parameters are not greyed out if their dependent LOV does not contain any value
  • Report execution – Fixed template columns not showing up in report if they have names in double upperquotes and their length is 29 or 30 characters
  • Report execution – Fixed scheduled reports end in warning with message ‘Invalid value ‘AD3;M1;S1′ for parameter: organization_code’, when using multiple values with Oracle LOVs
  • Report execution – Fixed output file corruption for clobs larger than 32K characters, which contain html tags exactly at the 32k limit
  • Report execution – Removed obsolete ‘flex value missing’ error message when using :$flex$ binds, which don’t exist in the current report
  • Report execution – Fixed FRM-40735: WHEN-VALIDATE-ITEM raised unhandled exception ORA-01858, when trying to set a non date default value string for a date parameter, such as ‘sysdate’
  • Report scheduling – Fixed ‘Invalid value … for parameter’ error when scheduling blitz reports with parameter values having an LOV depending on a :$flex$.bind

New Reports

Updated Reports

Blitz Report in Oracle EBS standard form personalization integration
Blitz Report in Oracle EBS standard form personalization integration
Blitz Report in Oracle EBS standard form personalization integration

3.1.9 

New Features

  • Multiple parameter values – Allow ‘like’ operator with wildcards for multiple values, such as A%;C%;E%

Updates

  • Polaris RWB import – Added mapping for $ sign and numeric formats
  • New profile option ‘Blitz Report XLSX Column Width Scale Percentage’ to adjust the column width, in case data does not fit the width on certain screen resolutions
  • Report template – Added new profile option ‘Blitz Report Allow Template Creation’ (Yes, No, Private only) to control access to template creation
  • Report template – Changed public flag default to ‘No’
  • Report template – Allow creating a new template using the new record button, menu entry or ctrl + arrow down key
  • Pivot template – Enabled multi selection for pivot filter LOV by default
  • Installation script – Added automated removal of unused GL segment parameters from seeded GL % reports at installation time
  • Installation script – Enhanced upgrade script to automatically shift fnd conc request parameters in case of runtime option changes. This avoids the need to reschedule Blitz Report concurrent requests during upgrades
  • Installation script – Added script to automatically add Blitz Report to the users’ navigator top10 list
  • Report output – Added user name and responsibility to Excel output parameter sheet
  • Report output – Enhanced column width calculation for numeric values when an Excel format string is specified
  • Report execution – Re-enabling run button while a report is still running immediately after runtime option or template changes
  • Report setup – Allow the Oracle standard forms assignment to pass null default values or values for hidden parameters from an Oracle form
  • Pivot functionality – Various enhancements for pivot sheet generation, such as multilanguage support, addition of numeric formatting, clob column type support

Fixes

  • Report template – Fixed ORA-06502: PL/SQL: numeric or value error, when having using clob columns in the pivot dataset
  • Report template – Fixed FRM-40212: Invalid value for field TEMPLATE_NAME, when switching to a different report while leaving the template window open
  • Report execution – Enhanced performance for large datasets
  • Report execution – Fixed ORA-06502: PL/SQL: numeric or value error: character to number conversion error, ORA-06512: at “APPS.XXEN_REPORT”, line 1270
  • Report execution – Fixed Resubmission of request xxxxx has been cancelled. dbms_sql.execute failed, when using ‘Increment date parameters each run’
  • Report execution – Fixed incorrect removal of multiple parameter values when changing a parameter that they depend on through a :$flex$ dependency
  • Report execution – Fixed ORA-06502: PL/SQL: numeric or value error: character string buffer too small, when starting blitz reports by PLSQL fnd_request.submit_request() and specifying report_name only
  • Report setup – Fixed FRM-40831: Truncation occurred: value too long for field REPORT_NAME, when opening a report with a name exceeding 120 characters via Setup->Tools->Assignments
  • Report setup – Fixed ORA-01400: cannot insert NULL into (“XXEN”.”XXEN_REPORT_ASSIGNMENTS”.”ASSIGNMENT_ID”), when saving report assignments via Setup->Tools->Assignments
  • Enterprise Command Center import – Fixed invalid parameters security error

New Reports

Updated Reports

Blitz Report in Oracle EBS standard form personalization integration

3.1.8 

New Features

  • Report template – Excel pivot definition to include a pivot sheet in the Excel output file
  • Report template – Define column aggregations (avg, sum, count, min, max), sort order or distinct to aggregate large datasets
  • Report Template – Functionality to copy templates via Menu > Actions > Copy Template
  • Import option for Polaris Reporting Workbench reports, allowing fully automated migration to Blitz Report

Updates

  • Report Run – When opening the form, default the most recently run report automatically, instead of showing the LOV of available reports
  • Report Run – Changed report LOV sort order to show an individual user’s most recently run reports on top
  • Report Run – Added code to avoid message ‘No organizations are currently defined’ when opening inventory organization related reports in responsibilities without having access to any organization
  • New profile option Blitz Report Email Attachment Multibyte Filenames to allow using only english report names on operating systems not supporting multibyte attachment filenames
  • Zoom functionality – Enhanced forms zoom assignment to allow different parameter values on different block names
  • Report export/import – Option to include template definitions in reports XML export
  • Report export/import – Option to include column translations and number formats in reports XML export
  • Runtime options – Allow use of custom postprocess option for non privileged users
  • Runtime options – New email concurrent request parameter to enable use of email delivery option when using blitz reports in request sets
  • LOV definition – Enhanced ‘Used By’ button to allow navigation to report parameters using the current LOV
  • Report setup – Allow specifying a custom postprocess default on the report setup options window
  • Report setup – Improved performance when opening reports with many dependent parameters such as GL Account Analysis
  • Report setup – Added email LOV to email and author email fields on report setup options window
  • Report setup – When using the x to close the LOV window user is prompted to save changes before validating a LOV query to avoid getting stuck if a query is invalid
  • Report output – Removed parameter name duplication on Excel output parameters sheet in case of different anchors used for the same parameter
  • Run Window – Extended full text search to template names and description
  • Report execution – Enabled resubmit report (activate run button) after changing runtime options, while a report is still running

Fixes

  • Report template – Enhanced validation to prevent forms error messages after clearing out the template name and pressing column add / remove buttons
  • Report template – Fixed cannot set enabled attribute of current item template.public_flag when changing the public flag
  • Report export/import – Convert any non utf-8 DB charset to utf-8 for exported XML files to avoid issues during import as the Blitz Report import routine expects the xml files in utf-8 character set
  • Zoom functionality – Fixed second forms restart through zoom assignment not working
  • Zoom functionality – Fixed zoom forms assignment integration not passing all parameters for multiple parameters with dependencies
  • XML import – Fixed report parameters not imported if source environment does not have a record in US source language
  • Fixed parameter sql_text not saved when inserting new parameters in EBS 11i version
  • Installation script – Fixed issue with installation on Solaris due to awk not supporting some advanced functions. Replaced awk with nawk for Solaris
  • Installation script – Identification of customizations of FND_WEBFILE and FND_WEBFILEPUB package bodies did not work in EBS 11i environments

New Reports

Updated Reports

Blitz Report in Oracle EBS standard form personalization integration
Blitz Report in Oracle EBS standard form personalization integration
Blitz Report in Oracle EBS standard form personalization integration

3.1.7

New Features

  • Discoverer import – Allow consolidation of workbooks by importing Discoverer folder combinations instead of individual workbook SQLs

Updates

  • Report template – Added option to set global default templates for all users
  • Report import – Enhanced report XML import to perform an upsert for parameters instead of deleting and re-creating them
  • Profile options – Added a new profile option ‘Blitz Report Email Attachment Multibyte Filenames’ to allow using multibyte linux filenames for email attachments and additional output files
  • Profile options – Added a new profile option to limit the email attachment filename length for mail servers with limitations, such as Lotus Notes’ 60 character limit
  • Profile options – Added a new profile option ‘Blitz Report Discoverer Default End User Layer’ for customers with multiple Discoverer EULs
  • Report setup – Enhanced copy parameter routine to skip parameters which exist in the target report already
  • Report setup – Enhanced parameter default value LOV with the previous parameter value :$flex.previous_parameter_value
  • Report execution – Added automated launch of the change organization form for reports requiring the inventory org to be set for parameter LOVs, such as ‘CST Inventory Value Report – by Subinventory (Subinventory)’
  • Installation script – Enhanced the Blitz Report installer to detect fnd_webfile and fnd_webfilepub customizations and show a notification that manual changes are required to complete the Blitz Report installation

Fixes

  • Installation script – Corrected missing business event flag settings on Blitz Report concurrent program for fresh installations
  • Installation script – Added setting execution permissions for sqlplus inside instant client home for 11i environments as on some systems it may not be done by default depending on umask setting
  • Installation script – Separating ‘create or replace view’ into dropping and then creating to prevent the ORA-01720 error happening for databases upgraded from 11.2.0.3
  • Report setup – Fixed parameter SQL text and LOV query getting corrupted in 11i version (forms 6i) by changing the xxen_report_parameters_v block property ‘Update Changed Columns Only’ back to the default ‘No’
  • Report setup – Fixed orphan parameter records left behind in tables xxen_report_parameters_tl, xxen_report_param_default_vals, xxen_report_zoom_param_vals, when deleting reports
  • Report import – Fixed XML upload not working in base languages other than US
  • Report execution – Fixed output file corruption for reports returning multibyte clobs larger than 32k bytes
  • Report setup – Improved performance of clear_text() routine in 12/19c database versions

New Reports

Updated Reports

Blitz Report in Oracle EBS standard form personalization integration
Blitz Report in Oracle EBS standard form personalization integration
Blitz Report VPD security policy creation concurrent programs

3.1.6

New Features

Updates

Fixes

  • Report setup – Added :run_id bind for dynamic SQL execution, e.g. to enable in-clause based on multiple values of another parameter, such as pivot reports (GL balance for multiple ledgers)
  • Report setup – Fixed LOV query validation getting stuck when pressing on ‘save as shared LOV’ with an invalid custom LOV query
  • Report setup – Fixed ‘Error reading LOV value, ORA-00918: column ambiguously defined’ when using a Blitz Report LOV with ID column
  • Report execution – Fixed invalid number error, when running ‘CST Inventory Value Report – by Subinventory’ with german numeric characters
  • Report execution – Fixed ‘Error parsing SQL.’ when trying to edit templates for &lexical anchors based on LOV Oracle, such as report: ‘GL Journals’, parameter: ‘Show Attachment Details’
  • Report template – Fixed bug incorrectly deleting all templates of a specific user when he deletes just one of them
  • Report execution – Fixed forms navigation getting stuck in runtime options email field when using the text editor window and entering an invalid email
  • Report execution – Fixed email address not cleared out from delivery options when running reports even after removing the email from runtime options
  • Report execution – Corrected ‘ORA-01006: bind variable does not exist’ in bind logic to ignore binds in commented SQL code
  • Report execution – Fixed ‘Invalid License: invalid license hash’ error when running two reports at exactly the same time
  • Report execution – Prevent ‘ORA-00001: unique constraint (XX.XXEN_REPORT_DYNAMIC_COLUMNS_U1) violated’ for non unique dynamic column translation rule SQLs
  • Report import – Fixed ORA-06502: PL/SQL: numeric or value error: host bind array too small, when loading XML in case of errors due to limitation of dbms_output.put_line to 255 characters
  • Installation script – Corrected install.sh execution order to run create_objects.sql before FNDLOAD to fix DFF upload error: ORA-20002: LDR.GET_TBL(P) is not able to find APP SHORT NAME:’XXEN’, TABLE NAME:’XXEN_REPORTS’.
  • Installation script – Changed install.sh to prevent FNDLOAD for number format lookup from overwriting customer modifications
  • Installation script – Added setting NLS_LANG variable to fix incorrect UI translations
  • Installation script – Included automated substitution of EBS->ASCP database link for ASCP reports
  • Installation script – Fixed access profile not set to ‘User’ on sitel level during news installations

New Reports

Updated Reports

Blitz Report in Oracle EBS standard form personalization integration
Blitz Report in Oracle EBS standard form personalization integration
Blitz Report VPD security policy creation concurrent programs

3.1.5

New Features

  • Descriptive flexfield ‘Blitz Report Information‘ for customers to store additional information, e.g. for change management
  • Import option to automatically migrate Excel4apps Reports Wand reports to Blitz Report
  • Export option for all reports from a specific application or by search pattern with the use of wildcards
  • API for automated report setup export / import e.g. for scripted report migration between environments

Updates

  • Output file size – Enhanced report generation to support files larger than 2G and avoid ORA-01426: numeric overflow
  • Report execution – Enhanced refresh of GL segment parameter names when switching to a ledger with a different chart of accounts
  • Report template – Allow developers to edit user-created public and private templates
  • Report template – New profile option to define the public flag default
  • Report import – Removed obsolete ‘include assignments’ checkbox
  • Report setup – Added refresh of report assignments and categories list after returning from Setup > Tools > Assignments or Categories
  • Report setup – Enhanced parameter copy functionality to include anchors when copying from a different report
  • Report setup – Increased size of dynamic SQL text generated for lexical parameters to CLOB length
  • Report postprocessing – Added report parameter value passing to custom post-process.sh to allow using these in script logic
  • Report export – Removed rep_ prefix from exported report XML filenames for simplification
  • Installation script – Split XML for column translations into different language files and detect installed languages to improve performance
  • Installation script – Added validation for number format lookup FNDLOAD to prevent overwriting customer-created number formats
  • Installation script – Added menu entry position variable export option to allow running scripted/non-interactive installations, e.g. in daily cloned environments
  • Report execution – Allow use of multiple values also for parameter type LOV Oracle, if parameter Value and ID value are identical
  • Discoverer import – Enhanced column header translation to cover additional worksheet SQL scenarios

Fixes

  • Report execution – Fixed ORA-01843: not a valid month, when using a different date format than DD-MMM-RR
  • Report execution – Fixed navigation getting stuck in options window email field validation in case there is an invalid email setup on user or person level
  • Installation script – Fixed ORA-12899: value too large for the column, when installing in application short names longer than 10 characters
  • Installation script – Corrected XML column translation import to avoid reprocessing files from previous unsuccessful load attempts
Blitz Report in Oracle EBS standard form personalization integration
Blitz Report in Oracle EBS standard form personalization integration
Blitz Report VPD security policy creation concurrent programs

3.1.4

New Features

  • Online help – Integration of online user guide and support chat with the EBS help
  • Report setup – Additional option to call PLSQL package functions before or after report execution
  • Report export / import – Option to include assignments in report exports for migration between environments
  • Report export / import – New import_xml shell script for automated migrations to replace deprecated SQL export option
  • Seeded reports: Added Enterprise Command Center maintenance reports
  • Multi-language – Added report header column and user interface translations for: Arabic, Brazilian Portuguese, French, German, Italian, Japanese, Korean, Russian, Simplified Chinese, Spanish, Swedish, Turkish
  • Report setup – New copied from field on the options window to show the origin of reports

Updates

  • Discoverer import – Enhanced installation script to create index xxeul5_documents_n1 for discoverer import performance automatically
  • Runtime options – Fixed row number limitation not working by adding a ‘Freeze’ checkbox to optionally keep option values such as the row limit when switching between reports
  • Report export / import – Aligned rowset and row XML tags with Oracle’s naming convention. Note that due to this change, XML files exported with previous Blitz Report versions are no longer compatible with the new format
  • Report setup – Moved maintain_multi_lingual_tables.sql to concurrent program ‘Blitz Report Maintain Multilingual Tables’ to be run after additional EBS language activation
  • Report template – Updated logic to insert new columns after existing ones, to enable adding them one by one in sequential order. Enabled CTRL+F11 search for column names
  • Report performance – Enhanced output file generation to skip writing to the DB node for less resource use and better performance for large reports
  • Added output file name parameter without path to custom postprocess script call
  • Seeded reports – Changed references to hr_all_organization_units to _vl view to allow multi language
  • Installation script: – Removed uninstall.sh from installation guide and deployment directory to prevent DBAs from accidentally running it
  • Renamed profile option ‘Blitz Report Access Level’ to ‘Blitz Report Access’ for simplified communication
  • Report setup – Increased column translation size from 150 to 753 bytes to hold a maximum of 251 multibyte characters to support multi language
  • Installation script: – Enhanced column translation load logic to prevent Enginatics’ seeded translations from overwriting customer’s translations or number formats
  • Installation script: – Enhanced column translations XML import performance

Fixes

  • Report execution – Introduced workaround for a missing EBS bugfix causing ORA-01861: literal does not match format string, when setting ICX date format different to the database default on old EBS 12.1.3 versions before 2013 (or 11i before 2009)
  • Installation script – Fixed ORA-00942: table or view does not exist, when running an upgrade to a new Blitz Report version directly after an EBS upgrade from 12.1.3 to 12.2.x
  • Report execution – Fixed ORA-20104: File creation for FND_FILE failed. Cause: The file handle for file l0307055.tmp is invalid, occuring intermittently on RAC environments with non shared file systems
  • XML Import – Fixed error ‘unique constraint (XXEN.XXEN_TEMP_IDS_U1) violated’ when importing two reports matching to the same report on the destination system
  • Installation script – Fixed column XML import not loading number formats for newly created columns
  • Report execution – Prevent scheduled ‘System’ reports without output file from ending in error
  • Installation script – Added detection to load column translation only for UTF8 character sets if there are other languages than US installed, to avoid ORA-19213: error occurred in XML processing at lines 206715
  • Report execution – Fixed empty anchor LOV after navigating to report templates and back to the parameter setup window without using the setup button
  • Report execution – Fixed ORA-12899: value too large for column “XXEN”.”XXEN_REPORT_COLUMNS_TL_GTT”.”TRANSLATION” (actual: 251, maximum: 150), when running blitz reports with very long column names
  • Report setup – Fixed sequence number incorrectly defaulting to 10 when creating new parameters on the setup window after navigating back from the run window without using the setup button
Blitz Report in Oracle EBS standard form personalization integration
Blitz Report in Oracle EBS standard form personalization integration
Blitz Report VPD security policy creation concurrent programs
Blitz Report Arabic UI translations

3.1.3

New Features

  • Add Blitz Report to any EBS standard form – New forms parameter ‘report_search’ allows integration of Blitz Report into Oracle standard forms via personalization, e.g. to replace the standard CSV export
  • Concurrent programs for VPD security policy creation, update and removal
  • Multi-language – Added Arabic user interface translations

Updates

  • User license assignment – Changed logic to not add license users automatically if their access profile option is not set. Access profile is set on site level to User at installation time and would need to be unset to turn off automatic assignment
  • Seeded reports – Enhanced GL reports to run by ledger sets
  • Report setup – Increased lov_query column size from 4000 characters to 32767
  • Report execution – Enhanced API to call blitz reports from custom code to ignore null parameter values passed
  • Installation script – Changed to load VPD policy table lookup values at first installation only to avoid overwriting customer changes
  • Installation script – Changed to load default report assignments at first installation only to not reassign during upgrades in case of customer changes
  • 11i version – Added separate seeded 11i report content to deployment script

Fixes

  • Discoverer import – Fixed ‘ORA-01489: result of string concatenation is too long’ in package XXEN_XDO, when importing discoverer worksheets with LOVs bigger than 4000 char
  • Report execution – Fixed ORA-01403: no data found when launching Blitz Reports from external forms such as ‘Supply Chain Hub’ without having runtime options initialized
  • Report execution – Fixed FRM-40212: Invalid value for DISABLE_COLUMN_TRANSLATIONS due to profile option value N not matching a value in the checkbox poplist
  • Installation script – Fixed XML and SQL import to update seeded LOV names in case of name changes during upgrades
  • 11i version – Fixed xml import to create parameters with null sql_text instead of empty_clob, to prevent problems in forms 6i, which can not handle empty_clob
  • 11i version – Fixed problem with empty clobs causing queried parameter records to show chaged status as forms 6i can not handle these
Blitz Report in Oracle EBS standard form personalization integration
Blitz Report VPD security policy creation concurrent programs
Blitz Report Arabic UI translations

3.1.2

New Features

  • Parameter name translations – Parameter names on the run window are automatically translated based on column translations
  • Dynamic column translations – Parameter names can be translated automatically based on dynamic SQL column translations. The seeded GL reports for example translate parameter name GL_SEGMENT2 to the customer specific chart of accounts segment name such as ‘Account’

Updates

  • Seeded reports – Added chart of accounts name to GL Ledger LOVs
  • Seeded reports – Enhanced GL parameter name translation to work with multiple ledgers of the same chart of accounts e.g. in GL Account Analysis
  • Report execution – Enhanced dynamic translation exception message with rule name
  • Report template – Show translated column names instead of original report SQL columns
  • Installation script – Added error_summary.log to simplify detection and investigation of installation problems

Fixes

  • Installation script – Changed default table and indexspace to APPS_TS_TX_DATA, APPS_TS_TX_IDX instead of deriving from already existing custom objects
  • Installation script – Fixed ORA-00955: name is already used by an existing object in synonm creation, in case there exist other non Blitz Report custom objects starting with XXEN_%
  • installation script – Fixed tr utility error on Solaris SPARC: “Bad string”
  • Installation script – Suppress language specific FNDLOAD error messages in error summary, originating from non installed languages included in the installation file
  • Installation script – Changed ending backtick position to be after EOF marker to avoid installation issues on AIX systems
  • Report template – Fixed column selection not working for mixed case column names, such as “Department”
  • Mutli-language – Increased column translation size to 150 characters to allow larger multibyte column headers
  • Report execution – Fixed output button incorrectly showing pending or running, when switching to a different report before waiting for previous report completion
  • Report setup – Fixed FRM-40105 Unable to resolve reference to item XXEN_REPORTS_V.PARAMETER_ID when navigating to setup before validation completion of a parameter value having other parameters depending on it
  • Report setup – Fixed ‘ORA-01006 bind variable does not exist’ in dynamic column rule validation for SQLs without bind
  • Report setup – Fixed problem with import window not opening again after importing an XML file
  • Report setup – Fixed bug storing incorrect source language in column translations when editing translations through the form
  • Report execution – Fixed dynamic column header translation to continue forms processing in case of exceptions during report query
  • Removed non required profile option ‘Blitz Report Output Button Refresh Time Limit’
  • Added numeric validation to profile option ‘Blitz Report Time Limit’
  • Deactivated ‘View Log’ popup window for System reports
Blitz Report Arabic UI translations
Blitz Report Arabic UI translations

3.1.1

New Features

  • Report template – Added user definable template functionality allowing to choose and reorder report columns
  • Version history comments – Added an editable comment field on the version history window
  • Report header and footer – Added profile options for report header and footer text in Excel

Updates

  • Column translations – Enhanced column translation column parsing to also work for dynamic &lexical SQLs such as ‘GL Balance by Account Hierarchy’
  • Report scheduling – Moved concurrent request business event subscription code to separate package XXEN_BES to avoid failing events for scheduled blitz reports after upgrades
  • Installation script – Detect XXEN_BES package changes to identify if it needs to be compiled during upgrades
  • Installation script – Added error summary, automatically grepping the logfiles for errors
  • Installation script – Modified install/create_menu_entries.sh, wrapped variables into double quotes to avoid issues in case variable is null
  • Installation script – Added warning in case of multiple nodes and multiple non-shared appl_tops to install blitz report on all the nodes
  • Installation script – Temp files are now created in local blitz report installer directory to avoid cases where directory /tmp may not exist, as mktemp utility doesn’t exist on AIX platform by default
  • Installation script – Changed default application short code from XX to XXEN

Fixes

  • Fixed increment date parameters functionality for scheduled reports, which was broken due to new runtime options in v2.9.4
  • Corrected runtime options window close code, as previous fix for date cursor jump was incorrectly moving the run window to the front when navigating to column selection
  • Fixed 11i (forms 6i) rtrim parameter type error
  • Corrected installation checks for XXEN_BES package status so they work in EBS R12.2 and AIX, HP-UX and Solaris
  • Fixed HP-UX installation error: ORA-06502: PL/SQL: numeric or value error: host bind array too small
  • Fixed HP-UX installation script: Replaced ‘==’ to ‘=’ as shell in HP-UX doesn’t support ‘==’
  • Fixed HP-UX installation XML load: Added newline character chr(10) to the end of all xml files as sed utility in HP-UX doesn’t recognize lines without end of line symbol
  • Fixed installation script to copy XXEN_VPD package code to $CUSTOM_TOP/sql for automated recompilation
Blitz Report for Oracle EBS column selection template
Blitz Report for Oracle EBS version history audit comments
Blitz Report for Oracle EBS profile option for sheet header in printouts

2.9.5

New Features

  • Data security – VPD functionality to secure sensitive data from developer access, e.g. for HR tables, configured by new lookup type XXEN_REPORT_VPD_POLICY_TABLES

Updates

  • Runtime options – Updated filename pattern LOV from RRRR to YYYY

Fixes

  • Fixed 11i error: ‘unsupported construct or internal error [2601]’ in forms UI when calling update_run_param_values_tmp
Blitz Report for Oracle EBS sensitive HR without VPD
Blitz Report for Oracle EBS hide sensitive HR data from developer access

2.9.4

New Features

  • Runtime options – Additional runtime options on run-window e.g. to specify output formats or file locations for individual reports schedules
  • Exclude headers – Option to exclude column headers from output files
  • Custom post processing – Option to run custom postprocess scripts after report execution with usage example

Updates

  • Report scheduling – Added validation for runtime parameter options when scheduling a report from the standard request form
  • Report setup – Enhanced options with tooltip showing the current setup, same as the options field on the run window
  • Report setup – Removed ‘Output Format’ and ‘Disable Column Translations’ from report level options as they are now on runtime level instead

Fixes

  • Data security – Fixed security issue passing the encrypted APPS password to XXEN_REPORT.prog by using the ENCRYPT option in the concurrent program definition
Blitz Report for Oracle EBS additional runtime options

2.9.3

Updates

  • Free version – Seeded Blitz % reports no longer count to the 30 reports list in the free version and can be run without limitation
  • Report setup – Renamed ‘Additional Attributes’ to ‘Options’ to be aligned with new runtime options

Fixes

  • Re-added missing profile option ‘Blitz Report Suppress Empty File Delivery’
  • Report setup – Fixed bug preventing new report creation after querying a protected report from Developer access
  • Report setup – Fixed anchor LOV not showing anchors for SQLs with multiline comments
  • Column translations – Fixed translations and number formats not working for column aliases in upper quotes, such as: base_rate “Base Rate”
  • Installation script – Fixed custom_top retrieval for cases where the application_short_name is different to the custom_top, such as: apps_short_name: TCC, custom_top: XXTCC_TOP

Find out more