Blitz Report™ Changelog

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

Note: Below is the history of our major code releases, typically published twice a year. In addition to these releases, we frequently provide smaller updates between versions to address specific bug fixes, minor enhancements, or changes to individual reports and uploads. The most recent installation file build date is: 2026-05-09.

Version:

3.3.5 2026-04-15

Highlights

Blitz Report Excel Add-in – New Excel Add-in for running reports, uploads and FSG directly from Excel, with features including SSO authentication, LOV validation, progress tracking, background parallel execution and drilldown support.
ORDS connectivity – Oracle REST Data Services (ORDS) is now supported as the default webservice connection method, replacing ISG and MOD_PLSQL. ORDS is auto-configured during installation and provides improved performance and simplified setup.
Supply Chain Hub included – Supply Chain Hub is now included in the Blitz Report installation package. Existing standalone installations are automatically detected during upgrade.
FSG multi-report converter – New batch converter for migrating multiple Oracle FSG reports to Blitz FSG format in a single operation.
New uploads – BOM Routing, PA Project and Task, FND Flex Value, HR Organization, QA Collection Plan, PO Receiving Transaction, AR Cash Receipt, INV Manufacturers and more.

New Features

ORDS connectivity – Blitz Report now supports Oracle REST Data Services (ORDS) as the default webservice connection method for FSG and Upload workbooks, alongside ISG and MOD_PLSQL. OAuth2 security is configured automatically during installation, and the ORDS URL can be auto-derived from existing EBS configuration.
Blitz Report Excel Add-in – New Excel Add-in for running reports, uploads and FSG directly from Excel. Features include progress bar with timer, environment setup assistant, LOV validation, multiple value paste from clipboard, SSO/browser-based authentication, background parallel report execution, drilldown support with configurable columns, and mouse scroll support on all forms.
Supply Chain Hub – Now included in the Blitz Report installation package. Customers no longer need a separate installation. Existing standalone installations are automatically detected during upgrade.
Financial Statement – Multi-report converter for batch-converting Oracle FSG reports to Blitz FSG format. Multi-value journal drilldown with source/category support.
Financial Statement – Conditional drilldowns with matching column/value conditions, enabling different drilldown targets based on cell content. Batch drilldown grouping improves performance when drilling into multiple cells.
Report template – New tabular pivot layout option and repeat item label fields added to the template configuration.
Report setup – Report assignments now support an enabled flag, allowing assignments to be disabled without deletion.
Data upload – New APPS Tier File Directory parameter on the Blitz Upload concurrent program for processing upload files directly from server-side locations.
BOM Routing Upload – New upload for BOM routings including operations, resources, substitute resources, common routing assignments, and delete groups.
PA Project and Task Upload – New upload for creating and managing Projects and Project Tasks in Oracle Projects.
FND Flex Value Upload – New upload for flex values with child ranges and deletion support.
FND Menu Entries Upload – New upload for menu entries.
HR Organization Upload – New upload for creating and updating organizations, classifications, and organization information types including Cost Allocation Key Flexfield support.
QA Collection Plan and Element Uploads – New uploads for Oracle Quality collection plans, collection elements and plan relationships.
PO Receiving Transaction Upload – New upload for receiving transactions via the PO receiving interface.
AR Cash Receipt Upload – New upload for creating AR cash receipts.
INV Manufacturers Upload – New upload for inventory manufacturers.
India Localization – New upload for third-party tax registrations.

Updates

Financial Statement – New br_intersect function for accounting segment intersection logic and br_date_offset function. Balance formula movement/multiply cell references. HTTP Keep-Alive for better performance.
Financial Statement – Snapshot files now include “snapshot” in filenames. Drilldown reports are configurable. GL Balance drilldown custom properties added to templates.
Financial Statement – Drilldown display performance improved by up to 68% for large datasets (22K+ rows).
Financial Statement – GL Wand to Blitz FSG conversion improvements.
Report run – Recalculate Parameters option now available for scheduled reports.
Report run – Header rows are now frozen for single report runs in a worksheet, and the worksheet is named after the report on first run.
Report run – The apps_initialize helper procedure has been moved from xxen_report to xxen_report_ebs. Customers calling xxen_report.apps_initialize from their own code should update the references to xxen_report_ebs.apps_initialize.
Report setup – Report export enabled for User Admin access level.
Report setup – Dynamic column rule execution scoped to specific reports for better performance.
Report setup – New profile option to skip non-English column translations during upgrades.
Report setup – Removed obsolete profile options (XXEN_REPORT_ADDIN_DOWNLOAD_ENABLED, XXEN_UPLOAD_USE_MOD_PLSQL, XXEN_FSG_DRILLDOWN_BATCH_SIZE). FSG profile options moved to user preferences. “Blitz Upload Maximum LOV Size” replaced with generic “Blitz Report Webservice Maximum Response Size”.
Data upload – New new_value wrapper functions for simplified create/update logic. Decimal places configuration per upload. Interface table delete-before-load capability.
Data upload – Pre-validation for single API uploads. Excel validation performance improvements and autofill webservice optimization.
Data upload – Custom upload API parameters are now automatically re-parsed during upgrades, ensuring parameter signatures stay in sync with PL/SQL changes.
Data upload – Descriptive Flexfield functions now support non-standard column names, enabling DFF processing for a wider range of Oracle tables.
AR Customer Upload – Contact role columns, flexible address format validation against country-specific address styles, internal location/organization with PO location associations, and customer profile creation/update at party level.
AP Supplier Upload – Updating bank/branch names and numbers and reassigning vendor bank accounts to different branches. New optional parameter to disable TCA business events during bulk uploads for better performance.
AR Transaction Upload – Loading invoices without a salesperson (controlled by parameter). Dynamic distribution account creation.
ONT Order Upload – Upload Order Identifier to distinguish creation and update scenarios. Discount modifier handling.
QP Modifier Upload – Automatically end-date active matching modifier lines when loading replacements.
QP Modifier Upload – Performance improvements.
QP Price List Upload – Improved End Date Matching List Lines mode for direct modification and re-upload as new price list lines.
QP Price List Upload – Performance improvements when loading data to large price lists.
FA Asset Upload – Now supports retirement functionality.
INV Item Upload – Manufacturer part numbers with a dedicated template for create/update/delete operations.
PO Requisition Upload – Attachments support.
GL Journal Upload – Improved validation performance.
Financial Statement – Snapshot performance improvements.
Discoverer migration – Pivot layouts now converted to tabular with repeating item labels. Workbook descriptions appended to template descriptions.
Blitz Report upgrade – Can now be upgraded to a specific version via the Forms interface. New “Disconnect blocking sessions” parameter added.
Installation script – Reduced prompts, better error messaging, stronger default schema password, and automated customall.jar generation.

Fixes

Financial Statement – Fixed template upload failures when a single sheet exceeds 6.3 million characters, when the template contains a sheet named “Parameters”, or when the ledger name includes the word “Ledger”.
Financial Statement – Fixed single exclusion segment values (~X) returning invalid() error. Fixed formula going to (pending) on sheet/row/column delete.
Financial Statement – Fixed journal drilldown error when YTD balances from different periods are drilled down together (ORA-00936). Fixed last drilldown cell not working correctly.
Report run – Fixed corrupt Excel output caused by duplicate shared strings during template upload. Fixed ORA-01426 numeric overflow when output files exceed 2GB.
Report run – Fixed scheduled reports ending with warning “Invalid value for parameter” when the LOV has Id after Value column. Fixed parameter sheet showing IDs instead of display values when submitted from Forms.
Report run – Fixed SQL validation error when SQL starts with a comment longer than 600 characters.
Report run – Fixed ORA-01008 when scheduling AP Invoices with Recalculate Parameters=Yes.
Report run – Fixed display_flexfield_value dropping time component for DateTime attributes.
Report setup – Fixed FRM-40212 error on drilldown reports. Fixed FRM-99999 Error 408 when opening template window for SQL containing database links.
Report setup – Fixed window position saving to prevent negative positions. Fixed stuck navigation after report XML import.
Report setup – Fixed LOV cache on responsibility switch and formula mode on report change.
Data upload – Fixed ORA-01008 for single API call uploads and for LOV columns with Filter Before Display.
Data upload – Fixed ORA-01006 when using upload LOVs in Excel. Fixed incorrect date formats not following ICX Date Format profile.
Data upload – Fixed XLSM upload error “This file type is not allowed” when profile “Attachment File Upload Restriction Default” is set to No.
Data upload – Fixed hyperlinks in uploaded Excel templates causing “corrupted file” error.
Data upload – Fixed upload file being flagged by Gmail as virus.
Data upload – Fixed DFF LOV issues where Oracle value sets with date column dependencies returned no data, and HR value sets referencing fnd_sessions returned no data.
Data upload – Fixed upload column name search box on the upload parameters tab (increased from 30 to 251 characters).
Data upload – Fixed Run-time error ’13’ (Type Mismatch) on Autofill click. Enabled defaulting logic when clearing cell values.
AP Invoice Upload – Fixed ORA-01722 (invalid number) in post-upload phase when existing interface table data contains non-numeric group IDs.
AP Supplier Upload – Fixed preventing Party Site tax profile defaults from being overwritten when the party site is linked to multiple supplier sites.
AR Transaction Upload – Rewritten sales credit logic to properly handle multi-line invoices with multiple sales credits per line, including “No Sales Credit” scenarios.
ONT Order Upload – Fixed ORA-01427 (single-row subquery returns more than one row). Fixed agreement ID resolution. Fixed approval workflow triggering after each PO line update instead of once per PO.
AR Customer Upload – Fixed R12.1.3 issue where the standard API rejected records by auto-creating a customer profile against the Ship To site use. Fixed contact address processing logic.
QP Modifier Upload – Fixed error updating Modifier List with the Shareable Flag set.
BOM Routing Upload – Fixed ORA-06502 buffer too small error. Fixed false update detection. Fixed R12.1.3 compatibility with delete group archiving. Added validation for missing key columns in upload template. Automatic end-dating of active operation sequences when creating replacements.
INV Physical Inventory Tag Count Upload – Fixed API compatibility across R12 releases. Fixed error handling with pre-generated tag numbers.
INV Manufacturer Upload – Backported to work with Oracle releases prior to R12.2.11.
INV Item Transaction Defaults Upload – Fixed ORA-06512 error.
MRP Sourcing Rule Upload – Added hidden parameter to bypass DFF validations for customers using form-specific block references in DFF setups.
Blitz Report Assignment Upload – Fixed Enabled column and “Invalid value for Id or Value” error when updating.
Discoverer migration – Fixed ORA-06502 (character string buffer too small) and ORA-00001 (unique constraint violated) during migration.
ORDS – Fixed various installation issues including SP2-0306 sqlplus connection string errors, ORA-01749 grant errors, and graceful handling when upgrade runs as concurrent program.
ISG – Fixed connectivity preserved on upgrade when connection type profile is blank. Fixed webservice deployment logic when ORDS is configured.
Installation – Fixed ORA-04021 timeout during installation by increasing DDL lock timeout. Fixed mo_global.init failure for ASCP instances without MOAC setup.
Installation – Workarounds for Oracle 19c PL/SQL compiler bugs (PLS-00801 crash and MERGE SQL corruption).

New Uploads

New Reports

Updated Uploads

Updated Reports

3.3.4 2025-12-11

New Features

Data upload – Inbound interface option that allows scheduling an upload to automatically process xlsx and csv files and send emails for error records.
Data template – Individual template export and import menu options.
Installation script – New Blitz Report upgrade menu option and concurrent program to simplify upgrades.
Installation setup – ‘Blitz Report Create Manager’ concurrent program.

Updates

Report setup – Preserve customer specific number format and advanced required parameters on Enginatics reports during upgrades, if the report was manually updated.
Report setup – Added support for regular expression text replacement to mass change functionality.
Report run – Added Record Count and build date to parameter sheet.
Report run – Automated enabling of hyperlinks, for example for new view transaction feature in the GL Account Analysis report.
Report run – Enhanced performance for larger clob data type extracts and automated URL detection.
Report run – Added support for scheduled System reports so that they don’t end in error status.
Report run – Removed profile option ‘Blitz Report XLSX Cell Borders’, as similar functionality can now be achieved with uploaded Excel templates.
Report run – Enabled saving default parameter values for hidden parameters when profile option ‘Blitz Report Show Hidden Parameters’ is set to Yes, for example to correct hidden template default values in Discoverer migrated reports.
Report run – Moved dbms_application_info initialization section before Build SQL to set the current report’s module name also for beforereport and afterreport code.
Financial Statement – Various performance enhancements for Excel macro processing, balance retrieval and drilldown.
Financial Statement – Enhanced balance calculations and drilldowns to support >,>=,<,<= and % operators. Introduced segment value hierarchy and multi level drilldowns from Balance to Subledger and Balance to Journal.
Financial Statement – Enhanced session authentication to require only one single login, which other workbooks will inherit from the Excel application.
Financial Statement – Improvements to GL Wand conversion, for example handling range separator as . with shorter range digits.
Financial Statement – Update to prevent balances from switching to (pending) after inserting or deleting cells.
Financial Statement – Double click on GL Balance Drilldown sheet will take you to Journal drilldown and Subledger level when double clicked on Journal drilldown sheet.
Financial Statement – Snapshot functionality now removes old file reference from cells, pivots and charts, and keeps the same files name as the original file with timestamp.
Financial Statement – Attachment url now has a hyperlink in Journal Attachments drilldown.
Financial Statement – Execute drilldown will not be seen for sources not having an SLA link to view transaction.
Financial Statement – Improved error message handling and changed default to open drilldowns in the same workbook.
Report template – Enhanced upload performance for large workbooks.
Report template – Excel template upload is now compatible with Insert Table and Power Query.
Report template – Excel template upload feature allows a custom last row with formulas in the datasheet.
Report template – Enhanced Excel template upload feature to support rich text and empty strings in the uploaded excel file.
Data upload – Various processing, logging and performance enhancements, for example automated creation of data views for every upload, which can be used in PLSQL code during upload processing.
Data upload – Added automated defaults for Error and Success SQLs, including support for SQLs larger than 32k characters.
Data upload – Introduction of a ‘Group Validation’ column indicator to allow rejecting multiple rows with the same column value, in case one of them fails LoV validation.
Data upload – Enhanced upload logic to show message ‘No valid records to process.’ if the uploaded file does not contain any data in status Valid.
Data upload – Enhanced upload reporting to omit the first original SQL query unless it starts with a with clause.
Data upload – Enhanced validation for upload Excel validation function to check if the referenced :$flex$. and :$column$. names are correct.
Data upload – Added automated rollback to savepoint exception handling for upload API calls.
Data upload – Enhanced exception handling for excel validation errors to show exception messages in the excel message column.
Data upload – Introduction of new xxen_upload.value_changed function to simplify conditional variable assignment for Oracle standard API calls.
Data upload – Enhancement to allow multiple file attachment upload on a single record and changed file name delimiter from pipe to semicolon.
Data upload – New modified_columns_ column to keep track of column value changes in Excel.
Data upload – Excel navigation performance improvements for large data sets.
GL Budget Amounts Upload – Enhancement to support updating amounts for budgets requiring journal entries, also it can now extract amounts for existing budgets so that current amounts can be updated using the upload.
INV Item Upload – For updating items, attributes are now defaulted with existing values before being updated to resolve issue where existing values were not retained when attribute is not included in upload template.
AP Supplier Upload – Now supports the upload of Employee Type Suppliers.
AP Supplier Upload – Added Address Status to the upload.
AP Supplier Upload – Added Party and Party Site Descriptive Flexfield Attributes. These are not handled by the AP_VENDOR_PUB_PKG, so needed to add additional calls to the HZ APIs to update these DFFs.
AP Invoice Upload – Amended to support the upload of AP Invoice Distribution DFFs which cannot be achieved via the Payables Open Interface. Changed Invoice Validation submission logic to call API directly when uploading Distribution DFFs to improve upload performance.
AR Customer Upload – Extended to support the creation/update of Person Type Customers.
AR Transactions Upload – Added Interface Header Attributes to support population of CT Reference field.
GL Journal Upload – New functionality to allow imported journals to be submitted for immediate Posting if eligible.
GL Journal Upload – Added Submit for Approval functionality.
GL Journal Upload – Added validation to check if journal is balanced.
PO Purchasing Document Upload – Added price breaks effectivity columns for Quotations, item_revision column, Allow Price Override and Price Limit columns, and Effective Start/End dates.
PO Requisition Upload – Exposed Requisition Preparer, Initiate Approval on Import parameter, and Currency Unit Price to allow users to specify preparer for correct approval chain and import requisitions in Incomplete Status.
PA Project Transaction Upload – Enhanced to handle Expenditure Type Class translations correctly.
CST Item Cost Upload – Added functionality to perform cost rollup after costs are imported.
FA Asset Cost Report – Amended to optionally show Depreciation Reserve balances, effectively combining FA Asset Cost and FA Depreciation Reserve reports.

Fixes

Report setup – Fixed assignments not imported when doing xml export and import from SYSADMIN user.
Report setup – Fixed report deletion showing error FRM-40202: Field must be entered.
Report setup – Fix for ORA-01403: no data found, when trying to access report assignments record history.
Report setup – Fixed categories could no longer be created or updated from setup window.
Report setup – Fix for LOV definition window incorrectly opening on setup screen after navigating to report search field and saving.
Report setup – Corrected XXEN_REPORT_USE_ADVANCED_EMAIL_DELIVERY profile option name.
Report run – Fix for ORA-06502: PL/SQL: numeric or value error: character string buffer too small, when running a report in Greek, Thai or Ukrainian language.
Report run – Fix for ORA-06502: PL/SQL: numeric or value error: character to number conversion error, when using multiple values with parameters defined as type Number.
Report run – Fix for ORA-01426: numeric overflow when output file size is more than 2GB.
Report run – Fix for ORA-00932: inconsistent datatypes: expected CLOB got LONG, when querying long data types.
Report run – Fixed report could be submitted without all required parameters populated.
Report run – Fixed selection of ‘All Reports’ category showing ‘No records exist here’.
Report run – Fix for ORA-01427: single-row subquery returns more than one row when operating unit with same name exists in two different business groups.
Report run – Fix for GL segment column headers showing Gl Segment1 instead of correct segment names, due to profile option ‘MO: Default Operating Unit’ set inconsistently with ledger access.
Report run – Fix for email sending via plsql xxen_api.report_submit_concurrent did not work.
Report run – Fix for Excel corruption when the uploaded template has hyperlinks causing following message: Some parts of this workbook may have been repaired or discarded. Replaced Part: /xl/worksheets/sheet1.xml part with XML error. ‘>’ expected
Financial Statement – Fix for Balance drilldown throwing ORA-06500: PLSQL: storage error, ORA-04030: out of process memory.
Financial Statement – Fix for ORA-01403: no data found, ORA-06512: at “APPS.XXEN_UTIL”, line 3378, when running Blitz FSG for a non primary ledger.
Financial Statement – Fix for ORA-06502: PL/SQL: numeric or value error, when running ‘GL Financial Statement and Drilldown (FSG)’ in a responsibility having a different data group than ‘Standard’.
Financial Statement – Fix for long running Journal drilldown for many balances.
Financial Statement – Handling for Blitz FSG’s initial function name refresh.
Financial Statement – Fix for ORA-00904: “XWSV3″.”SEGMENT_VALUE”: invalid identifier, when using Blitz FSG for summary account balance with defined summary template.
Financial Statement – Fix for Journal and Subledger drilldown not working when code combination id collectively exceeds 4000 bytes.
Financial Statement – Fix for double click on empty cell on drilldown sheet throwing error.
Financial Statement – Fixed balance not shown when queried using source or category on a non functional journal entry.
Financial Statement – Handled ISG_SERVICE_EXECUTION_ERROR due to ORA-06502: PL/SQL: numeric or value error: associative array key violates its type constraints.
Discoverer import – Fixed key issues including treating sheets with identical names except trailing spaces as separate templates, handling DBMS_LOB.SUBSTR limitations, enforcing maximum parameter name length of 80 characters, and resolving ORA-01790 datatype errors.
Installation script – Fix for 23ai compilation error: PL/SQL: ORA-00932: expression is of data type CLOB, which is incompatible with expected data type.
Installation script – Fix for manually created assignments incorrectly being removed during upgrades.
Installation script – Fix for ORA-22303: type “APPS”.”XXEN_DBMS_BINDS_TAB” not found, when upgrading in 12c database versions.
Installation script – Fix for ORA-01418: specified index does not exist error in pre deployment script.
Installation script – Fix for ORA-00942: table or view does not exist, when installing 11i version.
Installation script – Fix for ORA-00942: table or view does not exist, ORA-06512: at line 1344, when upgrading Blitz Report from version 3.3.0.
Installation script – Fix for ORA-01426: numeric overflow during installations in environments with fnd_lobs.file_ids larger than 2147483647.
Installation script – Fix for ORA-00001: unique constraint (XXOH.XXEN_UPLOAD_SQLS_U2) violated, when upgrading Blitz Report.
Installation script – Fix for ORA-00001: unique constraint (APPLSYS.FND_PROFILE_OPTIONS_U2) violated in upgrade_pre.sql.
Installation script – Fix for ORA-00001: unique constraint (XXEN.XXEN_REPORT_PARAMETERS_U4) violated, when upgrading.
Installation script – Fix for ORA-31603: object “XXEN_GL_CODE_COMBINATIONS_N1” of type INDEX not found in schema “GL”, as dbms_metadata.get_ddl apparently requires authid current_user instead of the default definer.
Installation script – Fixed error “XRPLV”.”VALUE_TO_ID_QUERY”: invalid identifier, when upgrading from older Blitz Report versions.
Installation script – Fix for 11i forms compilation error.
Installation script – Fix for Invalid License: maximum users exceeded message after new installations.
Installation script – Workaround for db version 11.2.0.2 error: ORA-22926: specified trim length is greater than current LOB value’s length, when importing report xmls including an uploaded Excel template.
Data upload – Fix for incorrect GL segments initialization due to pooled webservice sessions still having previous sessions initialization values.
Data upload – Fix for exception messages not appearing when using mod plsql.
Data upload – Performance enhancements for server side validations triggered from the Excel upload.
Data upload – Fix to stop LOV defaulting for DFF columns for improved Excel navigation performance.
Data upload – Fix for defaulting issue when directly entering partial search text into excel cell and LOV form pops up.
Data upload – Fix to convert numeric values to text when copied over to text columns in upload file as text formatting is overridden by copied cell format.
Data upload – Fix for ORA-01426: numeric overflow when running uploads due to ‘FND_LOBS_S’ sequence value breaching limit for pls_integer variables.
Data upload – Fix for Upload processing fails for Interface table type uploads when using alias for column names in main SQL.
Data upload – Fix for upload error due to columns omitted in template which are mapped to upload parameters.
Data upload – Fix for ORA-01741: illegal zero-length identifier, when using upload columns in “Upperquotes” having value to id translations defined.
Data upload – Fix for ORA-00907: missing right parenthesis in upload processing with column name translations including a single upperquote.
Data upload – Fix for ORA-06502: PL/SQL: numeric or value error: character to number conversion error, when validating records where excel numeric format is different to EBS numeric format.
Data upload – Fix for ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion when running uploads with LOV queries larger than 4k characters.
Data upload – Fix for Upload macro Run-time error ‘1004’, when setting profile Blitz Upload Maximum Rows to more than Excel limit of 1048576 rows.
Data upload – Fix for Run Time Error 13 Type Mismatch on saving upload excel file.
Data upload – Fix for Date columns being incorrectly set to value of first row when copying and pasting data into sheet.
Data upload – Fix for Date column not defaulting in upload excel when server date format is DD.MM.YY.
Data upload – Fix for uploads with column LOVs having dependencies on date column types ending in error in 11g databases.
Data upload – Fix for columns incorrectly appearing as read only in upload excel.
Data upload – Fix to handle new line characters in json message response.
Data upload – Fix for upload files being flagged as virus by Gmail and other scanners.
Data upload – Fix for web request header values values e.g. Responsibility Key containing ‘&’ and ‘+’ to escape these characters properly as they are used by mod_plsql as separators.
Data upload – Fix for copying template not copying over read only flag.
Data upload – Fix for handling DFF date columns in upload excel.
Data upload – Fix to not clear message on record immediately when cell is changed, so message can still be referenced while working through errors.
Data upload – Fix to stop corruption in ‘custom.xml’ file due to presence of ‘&’ in custom property values which causes upload and FSG excel output file corruption.
Data upload – Fix for useform opening on wrong screen in case of multiple screens.
Data upload – Performance fix when saving file with large number of records marked for update and stopped authentication prompt from popping up on first time opening in mod plsql environment.
Data upload – Performance fix for PGA error when handling large upload files by replacing xmltable parsing with bespoke parsing routine, controlled by profile option ‘Blitz Upload Custom Sheet Parsing’.
Data upload – Performance fix for issue when modifying multiple cells while having a filter applied Excel.
Data upload – Fix for excel cells incorrectly populated in xxen_upload_xml_cells, divided insert into chunks to reduce array and PGA size.
Data upload – Replaced row by row update of status and out columns in xxen_upload_data with bulk update for performance.
Data upload – Fix to solve error related to column count exceeding 1000 in 11g databases.
Data upload – Corrected LoV form position to open in the center of the screen.
Data upload – VBA performance improvements when entering or altering multiple cells in the excel file.
Data upload – Corrected interface table column parsing to allow selecting custom tables also in the apps schema.
Data upload – Fix for multibyte character handling when the DB characterset is not UTF8.
Data upload – Applied filter to pick up only csv, xlsx and xlsm files from directory for scheduled upload processing.
Data upload – Fix for performance issue when navigating to report setup due to performance bug with user_views, replaced with user_objects now.
INV Item Upload – Fix for default buyer not getting updated.
INV Item Upload – Resolve bug with updating existing item’s attributes from Copy from Template functionality not working due to prior change where uploaded items were being pre-populated with item’s current attribute values.
INV Item Upload – Changes to minimize occurrence of “Master – Child Conflict in one of these Attributes” errors by not passing master controlled attributes to API for new child items.
INV Item Upload – Removed restriction of allowing Copy from Template only when creating new items, now allows existing items attributes to be updated based on specified Copy From Template.
INV Item Upload – Fix for few parameters mis-typed as varchar2 instead of number causing PL/SQL numeric error.
INV Item Upload – Change validation for Copy From Item from checking action_ = Create to checking existing item does not exist.
INV Item Upload – Adjusted purge logic to not purge when running in debug mode in case we need to examine interfaced data.
INV Item Upload – Changed purge logic to only purge current runs data, moved call to afterreport trigger which will fire purge only for INV Item Upload and only for results report run.
INV Item Upload – Fix for ORA-01722: invalid number.
INV Item Upload – Fix for PLS-00201: identifier ‘XXEN_INV_UPLOAD.P_COA_ID’ must be declared.
INV Item Upload – Removed Child Item already Exists in Master Org validation to remove restriction that Master Organization entry must appear as first row in upload excel for each item.
INV Physical Inventory Upload – Added in Physical Inventory DFF columns.
INV Physical Inventory Upload – Serial Count Option and Serial Detail Option not defaulting due to bug in dynamic sqls.
INV Physical Inventory Upload – Fix for physical inventory changes from subinventory specific to all subinventories, pre-existing subinventories should be deleted.
INV Physical Inventory Tag Count Upload – Fix for incorrectly reporting Error status when updating existing tag due to Oracle API differing return statuses.
INV Physical Inventory Tag Count Upload – Corrected logic where if Tag are generated without Serial Numbers the tags could not be downloaded and serial numbers could not be added to tags.
INV Physical Inventory Tag Count Upload – Fixed Bug with Upload reporting error when tag is successfully updated due to Oracle API differing return statuses for success condition.
INV Unit Of Measure Conversion Upload – Fix bug with update scenario for generic standard unit of measures where Inventory Item Id column is set to 0 not null.
INV Transaction Upload – Fixed ORA-00904: “TRANSACTION_GROUP_SEQ”: invalid identifier for some clients on lower patching level.
MRP Sourcing Rule Assignment Upload – DFF Attributes were being mapped against incorrect DFF structure, so Value to ID mapping was not occurring correctly.
MSC Plan Order Upload – Additional fixes.
MSC Plan Order Upload – Fix for returning no rows.
GL Journal Upload – Fix for ‘No Records to process’ as post process was incorrectly being executed twice in 11g database.
GL Journal Upload – Fix for error “You do not have access to this ledger and account combination.”
GL Journal Upload – Bug fixes to Journal Posting criteria for Encumbrance Period check being restricted to Encumbrance Journal Types only.
GL Journal Upload – Fix for period validation error in Oracle Database versions 11g and 12.1.0.2.0 where procedure was incorrectly handling date type columns.
GL Journal Upload – Correction to Submit for Approval logic to check if Funds Reservation is required as Journal cannot be submitted for Approval if Funds Reservation is required.
GL Account Upload – Fix to allow creation of new accounts even if Dynamic Inserts for Chart of Accounts Flex Structure is not enabled.
GL Account Upload – Fix to support updating end_date_active.
GL Account Upload – Fix for end dated code combinations not being processed.
GL Budget Amounts Upload – Fix to support maximum 60 GL periods.
GL Summary Account Upload – Changes to enable deletion of summary accounts.
GL Daily Rates Upload – Added correct DFF handling. GL Daily Rates Upload now also facilitates download of existing Daily Rates (Create, Update Mode).
AP Supplier Upload – Fix for bug with API returning error “Column party_site_id must have a value” when updating Vendor Sites for which multiple party sites exist with same Party Site Name.
AP Supplier Upload – Changed logic to allow update of Address Name and Site Name.
AP Supplier Upload – Change to allow update of existing Supplier Number for customers using manual vendor numbering.
AP Supplier Upload – Further refinements to vendor site contacts upload to address various bugs including contact address association issues.
AP Supplier Upload – Amended logic to allow linking of new Suppliers to existing Party and new Supplier Sites to existing Party Site.
AP Supplier Upload – Added additional validation if address details are not specified and location cannot be derived from specified Party Site Number or Address Name.
AP Invoice Upload – Fix for ORA-06502: PL/SQL: numeric or value error.
AP Invoice Upload – Changed Invoice Validation submission logic to always call API directly instead of submitting independent Invoice Validation Concurrent Request.
AP Invoice Upload – Fix for Submit AP Invoice Import post-process step not submitting Import due to P_SOURCE parameter now being passed as ID instead of Value.
AP Invoice Upload – Correction to 11i exception handling.
AR Customer Upload – Site Use DFF attributes were being incorrectly validated against Cust Account Site DFF Structure.
AR Customer Upload – Changed DFF validations to work for updates if not all assigned DFF attributes are included in template.
AR Customer Upload – Additional validation added to ensure Address Name cannot be changed to one that already exists against different party site.
AR Transaction Upload – Added validation to ensure Payment Term can be derived and applied currency rounding when Amount is automatically calculated.
AR Aging – Removed unnecessary select from ar_adjustments_s.nexval.
QP Modifier Upload – Fix for Duplicate qualifiers exist bug.
QP Modifier Upload – Further refinements and fixes including limit and limit other attributes flagged change processing.
QP Modifier Upload – Corrections for R1213.
QP Modifier Upload – Converted upload to use xxen_upload.value_changed function and changed to honor read only column status.
QP Modifier Upload – Added Exclude Items into upload.
QP Modifier Upload – Added in ability to upload List and Line level Limits plus few other bug fixes.
QP Modifier Upload – Fix for ORA-01407: cannot update (“QP”.”QP_LIST_HEADERS_B”.”CREATED_BY”) to NULL in Package QP_Modifier_List_Util Procedure Update_Row for clients who do not have fix for oracle Bug# 29319872.
QP Price List Upload, QP Qualifier Group Upload – Further refinements and fixes.
QP Price List Upload – Fix for ORA-01403: no data found error and DFF handling corrections to remove restriction for all defined DFF attributes to be included in upload excel template.
QP Price List Upload – Fix for Start/End Date not populated on Price Break Lines by oracle API when first inserted.
QP Price List Upload – Changed logic to only update entities that have actually been changed by upload and return message now shows what entities have been created/updated/deleted.
QP Price List Upload – Added option to end date matching active price lists lines when creating new price list lines.
QP Price List Upload – Added missing close cursor to no_more_rows exception handler in attribute_value_lov pipelined function.
QP Price List Upload – Fix for ORA-01403: no data found error when creating a new Price List Header.
QP Qualifier Group Upload – Changed to use new xxen_upload.value_changed function and prevent columns defined as read only from being updated.
PO Purchasing Document Upload – Fix for quotation price break issues and added line number column as optional for Quotations upload.
PO Purchasing Document Upload – Added ‘Allow Price Override’ and ‘Price Limit’ columns.
PO Purchasing Document Upload – Added Effective Start and End dates.
PO Purchasing Document Upload – Added price breaks effectivity columns for Quotations, also fixed issue of older price breaks being wiped off and replaced with new one post quotation upload.
PO Purchasing Document Upload – Fix to avoid wiping off start and end dates on existing price breaks when adding new price breaks on quotations.
PO Purchasing Document Upload – Changes to make line number column optional for Quotations upload.
PO Purchasing Document Upload – Added ‘item_revision’ column.
PA Project Budget Upload – Added functions to get actuals datapoints in PA Project Budget Blitz Report.
PA Project Transaction Upload – Fixed Incorrect Expenditure Type Class displayed for US language where translation does not align with name displayed in form.

New Uploads

New Reports

Updated Uploads

Updated Reports

3.3.3 2025-02-26

New Features

Financial Statement – Added automated Oracle FSG import option.
Upload setup – Simplified upload development with a new window to maintain error and success SQLs, referencing a database view of the uploaded data.
Upload setup – New quick search for upload parameters and column names.
Data upload – Added support for SSO from the upload Excel file.

Updates

Report setup – Enhanced user interface to remember user specific window size and positions.
Report setup – New ‘Create Categoy’ button on the categories tab to simplify new category creation.
Report setup – Enhanced XML import to only update the record history, for example of report parameters, if there was a data change.
Report setup – Removed obsolete profile option ‘Blitz Report Show LOV When Opening Form’.
Report setup – Added new template checkbox ‘Dynamic Columns’ for developers to indicate if newly added SQL columns are automatically added to existing templates.
Report setup – New profile options XXEN_REPORT_USE_LEDGER_SECURITY and XXEN_REPORT_USE_OPERATING_UNIT_SECURITY, which allow disabling ledger and operating unit security for inventory organization secured reports.
Report run – Changed order of &lexical and 1=1 anchor replacement to resolve &lexicals first and allow using 1=1 anchors in dynamically inserted text.
Report run – Enhanced parameter value logging to show display and id values and enhanced :bind detection logic to use binds found in strings, if the parameter sql text is a dynamic sql, starting with select.
Report run – New profile option XXEN_REPORT_EMAIL_BODY_MESSAGE to allow sending reports by email including a custom message body.
Upload setup – Removed REFRESH_UPLOAD_PARAMETERS menu entry and replaced it with automated object re-parsing when navigating to the upload tab or opening the post procedure parameters window.
Upload setup – Added functionality to call the Upload API just once if there are no parameters.
Upload setup – Renamed upload data retention profile option from XXEN_UPLOAD_DELETE_REPORT_DATA to XXEN_UPLOAD_DATA_RETENTION_DAYS and added cleanup to Blitz Report Monitor program.
Upload setup – Rearranged Error and Succes SQL’s in the Blitz Report form on a separate screen to simplify the upload developement process.
Data upload – Signed the Blitz Upload macro with the Certum commercial certificate.
Data upload – Enabled attachment upload from the upload excel file.
Data upload – New “Validate” icon in Excel menu ribbon allowing revalidation of invalid and error records without changing column values.
Data upload – Enabled changing responsibities from the upload excel file.
Data upload – Relaxed the upload validation to allow uploading files from a different responsibility than the one it was created from.
Data upload – Enabled attachment upload functionality for 11i.
Financial Statement – Balance calculation and drilldown can now supported for specified effective dates.
Financial Statement – Journal Criteria sheet is now available in Blitz FSG
Financial Statement – Blitz FSG can now be shared with users who have different responsibilities than the original sharer. This resolves the following web service errors: ISG_USER_RESP_MISMATCH in R12.2.x and FND_SOA_USER_RESP_MISMATCH in R12.1.3.
Financial Statement – Enhanced FSG error messages to distinguish cases of invalid accounts and parents without childs.
Financial Statement – Show balances instead of Error (Account) in case of child accounts incorrectly set up as parents.
Financial Statement – Prefix function names with br_, correction of statistical balance calculation.
Financial Statement – Enhanced GL report and FSG performance by automatically applying flexfield segment security only for responsibilities, which have at least one rule setup.
Discoverer import – Enhanced Discoverer import concurrent program to allow running it for multiple semicolon separated owner parameters.
Enhancing the AR Transaction Register and AR Adjustment Register reports to be run for multiple Ledgers or Operating Units.
Installation script – Added a list of mod_wl_ohs.conf configuration files available from the current node
Installation script – Added site name profile option value to the installation summary to easier detect the EBS instance purpose. Sometimes database name is not changed after cloning.
Installation script – Enhanced the WLS timeout check to check only the current node configuration file.
Installation script – Updated the required ISG consolidated patch number to a newer one with the same AD and TXK prerequisites.
Installation script – Added the detection of form personalizations that may hold SPECIAL30 tools menu entry which we use for Blitz.
Installation script – Created a test version of the script to copy the webservice artifacts to the additional apps nodes.
Installation script – Resetting the ISGADMIN EBS password in case it differs from the FND Vault value.
Installation script – A correction to the SIGNON_PASSWORD_LENGTH check.
Installation script – Automated the EBS cache clearning.
Installation script – Added ISG assigned roles information to the installation logfile.
Installation script – Added a check for WLIOTimeoutSecs which affects the FSG timeout.
Installation script – Added REST login webservice validation to install.sh.
Installation script – Added the ISGADMIN password validation and setting password_date to sysdate to avoid changing password prompt and ensuring that the rest login webservice test succeeds.
Installation script – Redeploying the xxen_webservice in case the version is the same to ensure that it works in cloned instances.
Installation script – Added warnings asking to disable Signon% profile options before running the ISG setup script.
Installation script – Added timeout and java heap size checks for optimal FSG performance.
Installation script – Added oafm_server.out file to the log files zip.
Installation script – Resetting the ISG datasource before deploying the webservice to avoid temporary ISGADMIN connection issues.
Installation script – Modified the installation script to distinguish different curl exit statuses while checking https certificates.
Installation script – Removing the ISG TLS configuration warnings from the error summary. In most cases this configuration is not required due to load balancers usage and also customers are reluctant to do it. Will run the configuration script only in case TLS related errors are found in the oafm server logs.
Installation script – Modified install.sh not to display the extension packages compilation errors on the screen and just to show one warning asking to review compilation_errors.log
Installation script – Enhanced the installation script to display the full path to the XXEN_WEBSERVICES class directory to copy to all the oafm nodes

Fixes

Report setup – Fixed forms error ORA-06502: PL/SQL: numeric or value error: character string buffer too small after deleting parameters with advanced required parameters defined.
Report setup – Fix for ORA-00060: deadlock detected while waiting for resource when adding ‘Order By’ SQL to a report containing Lexicals| fix for issue with using Filter Before Display in a self referenced column in the LoV query.
Report setup – Corrected parameter deletion routine to prevent orphan template exclusion and upload dependency records.
Report setup – Fixed Validate From List and Filter Before Display LOV properties not defaulted correctly, directly after creating a new parameter with LOV Oracle validation type.
Report setup – Fixed xml report import did not update all parameters at the first import.
Report run – Fix for ‘Invalid License: profile option ‘Blitz Report Access’ not set’ error message when having the access profile option only set on user but not on site level
Report run – Performance fix for report execution when having a large number of reports in the system
Report run – Fix to prevent incorrect opening of the next parameter’s LOV when the current parameter LOV contains only one value.
Report run – Report SQL in logfile was missing the last line/character, in case it was on a separate line, for example GL Balance (pivot).
Report run – Fixed ORA-06502: PL/SQL: numeric or value error: character string buffer too small, when opening reports with a parameter LOV query larger than 4000 characters.
Report run – Fixed ORA-22828 input pattern or replacement parameters exceed 32K size limit.
Report run – Fixed GL Balance and Account Analysis reports not showing the hierarchy columns automatically after upgrades or xml import.
Report run – Fixed ORA-00923: FROM keyword not found where expected, when running ONT Cancelled Orders without category set parameter values.
Report run – Performance fix for populate_id_and_value_ procedure due to incorrect push_pred hint syntax, for example affecting inv item report performance.
Report run – Fixed ORA-00923: FROM Keyword not found where expected in dff sql text when having more than one fields with the same prompt in one attribute context, for example three times a field with the name ‘Notes’.
Report run – Bug fixes in dff_columns function when attribute field prompts within the same context exceeds the maimum column length or when is used across different contexts.
Report run – Parameters with different display and id values incorectly translate the display values to id twice, resulting in incorrect parameter restrictions.
Report run – Corrected duplicate bind variable assignment to ensure that every :bind is mapped only once by function bindvar_name
Report run – Fixed required parameters no longer enforced, allowing to run reports without all required parameters.
Report template – Fixed Excel template upload getting stuck in infinite loop when uploading an empty file
Report template – Fix for warning message “This command requires at least two rows of source data. ..” with an uploaded template containing pivots, charts, and a modified data sheet, when no data is returned.
Upload setup – Fix for ORA-00001: unique constraint (XXEN.XXEN_UPLOAD_COLUMNS_U1) violated in parse_upload_columns.
Upload setup – Fixed performance issue when selecting Interface Table upload type
Upload setup – Corrected ORA-01086: savepoint ‘BEFORE_IMPORT’ never established in this session or is invalid, when importing upload XMLs and the upload view creation fails.
Data upload – Fix for ORA-01847: day of month must be between 1 and last day of month during upload processing.
Data upload – Fix for Norton antivirus flagging the upload xlsm file with the message Script:SNH-gen[Trj].
Data upload – Fix for “ORA-01790: expression must have same datatype”, when numeric columns are removed from the upload template.
Data upload – Correction of Autofill functionality not defaulting all rows, defaulting not working correctly for columns not set as validate from list.
Financial Statement – Resolved error for period range showing Invalid(Period) even for balance type CTD.
Financial Statement – Balance is not calculated for currency type entered and converted when the functional currency is passed. The balance drilldown fails to work for entered currency type.
Financial Statement – Fixed incorrect begin balance amount for YTD balance drilldown.
Financial Statement – Fixed incorrect balance amount when using summary templates with rollup groups.
Financial Statement – YTD Balance on drilldown does not display combination whose closing balance is zero.
Financial Statement – Fix for balance drilldown when the the number of rows returned is more than 5000 rows
Financial Statement – Correction of logic to derive the converted functional balance amount when currency type is C.
Financial Statement – Fix for error on click of view transaction when the ledger name contains a comma.
New profile option XXEN_REPORT_OUTPUT_FILENAME_LENGTH_LIMIT for limiting Blitz Report output filenames paths to avoid signal 11 when running FNDCPPUR.
Installation script – Fix for ORA-00001: unique constraint (XXEN.XXEN_UPLOAD_DEPENDENCIES_U1) violated, when installing or upgrading.
Installation script – Dropping all the XXEN% packages in upgrade_pre.sql to recreate them later and avoid FRM-30085 and PL/SQL ERROR 306 during the form compilation.
Installation script – Fix for ORA-00942: table or view does not exist, when upgrading from an older Blitz Report version such as 3.3.0
Installation script – Fixed ORA-06510: PL/SQL: unhandled user-defined exception, PLS-00201: identifier ‘XXEN_PA_UPLOAD.NOT_USE_FIRST_BLOCK’ must be declared, when running installation on environment where package XXEN_PA_UPLOAD did not compile due to an older patch level.
Installation script – Fix for FRM-40105: Unable to resolve reference to item due to incorrect XXEN_REPORT_TRANSLATIONS entry after upgrades.
Installation script – Fixed PLS-00201: identifier ‘XXEN_REPORT_ASSIGNMENTS.BLOCK_NAME’ must be declared, when upgrading Blitz Report after upgrading from 12.1 to 12.2
Installation script – Fix for ORA-01403: no data found, when re-running the installation script after the initial installation failed to compile the xxen_report package, for example due to lack of PGA memory.
Installation script – Fix for ORA-06519: active autonomous transaction detected and rolled back, when running install.sh or copying uploads.
Installation script – Corrected xml import to no longer update the Global Default flag during upgrades, if the global default was manually changed to a different, for example custom template.
Installation script – Corrected installation error ‘PLS-00201: identifier ‘XXEN_UTIL.BASE_LANGUAGE’ must be declared’.
Installation script – Fixed scheduled concurrent requests ending with Warning ‘Invalid value ‘Yes’ for parameter’ after 3.3.2 upgrade due to ‘Yes’ LOV change from display value to id
Installation script – Fix for ORA-12899: value too large for column “APPLSYS”.”FND_CONCURRENT_REQUESTS”.”ARGUMENT_TEXT”, when upgrading with scheduled blitz reports and multibyte parameters.
Installation script – Fix for 11i installation error ORA-00959: tablespace ‘APPS_TS_TX_IDX’ does not exist.
Discoverer import – Corrected duplicate :bind variable names in migrated discoverer reports.
Discoverer import – Fixed mising space between like and bind variable.
Discoverer import – Fixed import error ORA-00001: unique constraint (XXEN.XXEN_REPORT_PARAMETERS_U2) violated.
Corrected xxen_ssrs_xmls.xml column definition so that it no longer shows up in the EBS upgrade readiness checker: “Column Type must be a built-in type or non-editioned User Defined Type.”.
GL Account Upload – Fix bug with the upload validation incorrectly validating disabled accounting flexfield segments leading to ‘Missing value for segment’ validation error for unused segments
GL Journal Upload – Fix for Cross Validation checks not working correctly for excluded accounts, also cross validation rules not to be fired for existing combinations.
GL Journal Upload – Fix to prevent journal import being submitted for a group if any lines in the group failed upload, for example DFF validation.
GL Journal Upload – Added GL Journal Line DFF Attributes.
AR Customer Upload – Added missing party taxpayer_id column.
AR Customer Upload – Added validation to ensure SIte Number and Operating Unit are included in the template as a requirement for Site Level Updates. Some column have value to id upload queries which are dependent on the the Operaing Unit. If the Operating Unit is not included in the template the Value to ID mapping fails and the columns are nullified on update.
AR Customer Upload – Resolve bug: Upload of Custom Account fails if the default profile class used by Oracle is disabled. Resolve Bug: Party Tax Refrence is not updated from the default Tax Registration. Resolve Bug: Party: Paty Tax Reference and Party tax Profile Reporting Registration Number should not be updated by upload if a default Tax Registration exists
AR Customer Upload – Amendments to support the upload of File Attachments
AR Customer Upload – Implement changes to support creation of customer account and customer site in a single excel row whilst being able to select at which level (Account or Site) the Profile Class, Tax Registration, Bank Account, Contact, and Attachment should be associated with.
AR Customer Upload – Improvements to the Update External Bank Accounts logic. Changed to differentiate the Bank Account Update from the Bank Account Assignment Update in order to detect if the Bank Account has already been updated in a prior row to maintain the top down approach (first row changed takes precedence). Change the Bank Account Start and End Dates to Bank Account Assignment Start and End Date.
AR Customer Upload – Resolve bug with entered customer account number not being recognised for Operating Units using manaual account numbering. Extended the external bank account upload logic to allow for bank accounts shared across parties.
CST Item Cost Upload – Fix bug with the same Group ID being retained if the same excel is upload more than once. Many the item cost import concurrent request would pick up the already rejected records from the run.
INV Item Upload – Added excel validation function to ensure lov restricted column values are valid. In the scenario where the data is mass pasted into the excel, the excel LOVs do not fire allowing invalid data to be uploaded. Where a column also uses a value to id upload query, then the invalid value is mapped to null, and the column is nullified on upload with no indication to the user there was an issue with invalid data.
INV Item Upload – Removed restriction that Item Catalog cannot be changed in the Master Organization
INV Item Upload – Corrected bug in validation for Update in Create Mode where the Item exists already but it is a new Category Set Assignment for the Item, in which case no item update is done, but the new category assignment is allowed. Logic is changed to ensure the category set assignment for this item does not already exist. i.e. it is a new category set assignment and not an update to an existing category set assignment.
INV Item Upload – Added Item Catelog validations.
INV Item Upload – Extended ability to update an existing item on create action to the Update Upload Mode as well.
INV Item Upload – Change to allow the ‘Create’ action to update an existing item when the upload mode is ‘Create, Update’.
QP Price List Upload – Added functionality to allow Qualifier Groups to be attached to the the price list without the need to individually select each qualifier from the group. Added the qualifier DFF Attributes to the upload.
QP Price List Upload – Fixed bug for sites not using multi-currency conversion.
BOM Bill of Material Upload – Added the BOM, Component, and Substitute DFF Attributes. Corrected handling of null values in the upload.
AP Invoice Upload – added Liability Account and Document Category Code columns.
AP Invoice Upload – Amended functionality to allow entry of manual tax lines.
AP Invoice Upload – Improved error handling. in some error scenarios the interface records are flagged as Processed (or purged on success) even if a rejection is logged (e.g Document Category not required).
AP Supplier Upload – Pay Alone Flag at Supplier Level not being set when creating a new supplier.
AP Supplier Upload – Resolve bug with the fnd_api.g_miss_char being populated to some iby_external_payess_all columns due to a bug in ap_vendor_pub_pkg.update_vendor_public passing the incorrect columns to iby_disbursement_setup_pub.update_external_payee.
AP Supplier Upload – Resolve bug with Vendor/Site Bank Account not being processed if Account Name is left null.
AP Supplier Upload – Resolve bug with Remit To Delivery method, email, and fax not getting uploaded at Suppier and Supplier Site Levels. Added Allow Foreign Payments column to Supplier Bank Accounts and Supplier Site Bank Accounts.
AP Supplier Upload – Correction to the DFF Upload and Validation logic.
AP Supplier Upload – Reworked Upload External Bank Account API to align with AR Customer Upload including a number of Bug Fixes. Changes to allow the 4 mandatory columns which do not default a value via the standard API to be made optional by allowing default values to be specified in the Blitz Upload report parameters. This makes the creation of new suppliers much simpler as only the key identifying columns are now required in the template.
PO Purchasing Document Upload – Added Supplier Item, Global Agreement, exchange rate, document number, quote warning delay, deliver to person name and project related columns.
PO Purchasing Document Upload – Added columns note_to_vendor and note_to_receiver for PO headers, added column note_to_vendor for PO lines.
PO Purchasing Document Upload – Enabled passing creation_date with user provided date, to allow data migrations to preserve the original PO creation date.
PO Purchasing Document Upload – Added DFF validation.
PO Requisition Upload – Added DFF validation.
PO Requisition Upload – For Purchase Requisitions where Suggested Vendor details are passed, need to set the autosource_flag to P otherwise the auto-sourcing logic will not consider them and potentially overwrite the suggested vendor/vendor site.
PO Requisition Upload – Requisition Import does not process interface records if the Batch ID exceeds 10 digits (as per MOS Document 2840710.1).
MRP Sourcing Rule Upload – Added the DFF Mappings.
MRP Sourcing Rule Upload – Bug Fix for the Planning Active flagged not updated correctly. If not all lines of the sourcing rule are updated, then the API will unset the Planning Active flag as it calculatres the total allocations on the upload records only. Reworked the logic to set/unset the planning active flag in the post upload phase.
MRP Sourcing Rule Assignment Upload – Added the DFF Mappings.
GL Summary Account Upload – added Budgetary Control.
AR Transaction Upload – Added Invoice Header, Line, and Distribution DFF Columns.
PA Project Transaction Upload – Transaction Source validation was not looking at active sources only. Added a time check to clear the transaction source cache between excel saves.
FND User Upload – Added Person column, and LoV’s to User and Employee columns.

New Uploads

New Reports

Updated Uploads

Updated Reports

3.3.2 2024-07-17

New Features

Financial Statement – Stable release of Blitz FSG with various performance and functionality enhancements, including automated migration from GL Wand and Spreadsheet Server.
Report setup – New mass change functionality for sql, parameter or LOV query text updates.

Updates

Financial Statement – Automated FSG index creation in a new concurrent program 'Blitz Report Update GL Indexes'.
Installation script – Various enhancements to better detect ISG configuration issues.
Installation script – New custom functional index xxen_gl_code_combinations_n1 on gcc.concatenated_segments to enhance performance of upload account LOV display, upload processing and GL drilldown (FSG).
Installation script – Changed the TLS configuration script to get the certificate from the EBS url first as many customers use the certificates on Load balancer and do not store them in the EBS truststore.
Installation script – Added ISGADMIN user activation in case it's locked or expired.
Installation script – Resolved ORA-01418: specified index does not exist or ORA-00955: name is already used by an existing object.
Installation script – Corrected ORA-01408: such column list already indexed.
Installation script – Removed Blitz Report (Web) menu entry from HR OAF responsibilities.
Installation script – Enhancement to avoid a server restart even when using Blitz Report Web: Added the OAF classes comparison. The classes are copied and imported only if the shipped classes differ from the existing ones.
Report setup – Changed Matching and Default parameter LOVs to return ID instead of display value
Report setup – Removed Operating Unit assignment level to achieve better search performance, as it was rarely used by customers and the same assignment can be achieved using responsibilities instead.
Report setup – Enhanced forms integration to allow passing either id or value parameter passing, for example to pass organization_id, instead of organization_code from an Oracle standard form.
Report setup – Removed obsolete menu entries, pofile option value and all content export options, as these can better be loaded with the Blitz Upload functionality.
Report run – Enhanced multiple parameter values functionality to allow them in scenarios with &lexicals, for example allowing the 'FND Responsibility Access' report to be run for multiple function names.
Report run – Changed =HYPERLINK to HYPERLINK syntax to fix hyperlinks in google sheets.
Report run – Enhanced LOV and multiple values functionality to allow ID columns.
Report run – Changed parameter default values to store the ID instead of the display value, to allow template specific default values to work in different languages, for example.
Report run – Enhanced Web/HTM version with additional parameter like report name, template name and freeze to support defining functions for individual report template combinations.
Report run – Added $ variable to the logfiles for easier identification.
Report run – Moved shipping next step logic from ONT Order Headers and Lines to reusable function xxen_util.wsh_next_step.
Report run – Changed multiple values logic for parameters with LOVs and id column to use a multiple values string of ids, to allow using the xxen_util.contains function on them.
Report run – Increased character length limitation for saved parameter default values from 4000 to 32767 bytes to allow saving of long multiple values strings.
Report run – Extended maximum allowed parameter length from 240 to 32767 bytes to allow scheduling of reports with large multiple values strings.
Data upload – Automatically add hidden upload columns towards the end of the visible columns in the excel file.
Data upload – Added support for Descriptive Flexfield Attributes with LOV validation and different display and id values.
Data upload – Enhanced upload performance by result caching value to id conversions for all upload queries, for example for mass item updates.
Data upload – Enhanced performance by applying case sensitive search for key flexfield columns marked as filter before display when executing the Upload LoV webservice.
Data upload – New Excel menu for Blitz Upload with 'Autofill' functionality which enables defaulting across multiple rows and columns.
Data upload – Enhanced upload file creation performance.
Data upload – Enabled server connection from excel using mod_plsql in r12 controlled via new profile "Blitz Upload Use mod_plsql", for customers which cannot apply ISG patches if they are not on Oracle support.
Data upload – Performance enhancement for Autofill functionality in Upload Excel file.
Data upload – Performance enhancement in VBA when saving the upload excel with pre-validation API.

Fixes

Report run – Excel outputs corrupted when delivered via email.
Report run – Date parameters were not incremented for Blitz Report concurrent requests that were a part of request sets.
Report run – Fix for reports with date parameters in Blitz Report Web ending with ORA-01858 error.
Report run – Fixed ORA-06510: PLSQL: unhandled user-defined exception, when running a report with an invalid SQL query.
Report run – Fixed endless loop when clicking on the Run button while having an invalid parameter value with an LOV set to Filter Before Display.
Report run – Fix for scheduled reports with an incorrect template name completing with ORA-00900: invalid SQL statement.
Report run – Disabling Upload button for users without a Blitz Report Access profile option value.
Report run – Fixed Save Template Parameter Defaults menu entry not enabled if there was a parameter default saved for the report and user already.
Report run – Enabled saving null parameter default values for LOV type parameters with an Id column.
Report run – Fixed Error reading LOV value, ORA-01722, when opening a report with standard Oracle LOVs having dependencies on ID and value at the same time, such as XLA Subledger Period Close Exceptions.
Report run – Corrected Run Date not shown on parameters tab.
Report run – Corrected list of visible reports, which wasn't updated after assignment change.
Report run – Assignment exclusions did not work when accessing reports through the Forms assignment.
Report run – Fixed Invalid value '1' for parameter: Exchange Rate, when scheduling CST Inventory Value reports.
Report run – Resolved 'ORA-00907: missing right parenthesis' bug when displaying descriptive flexfield attributes in reports where the context code contains an apostrophe.
Report run – Fixed ORA-01422: exact fetch returns more than requested number of rows in AP Trial Balance report
Report run – Corrected ORA-01403: no data found, when running GL Financial Statement and Drilldown (FSG) report.
Report run – Fixed attribute values not displayed if the same dff prompt is used in different attribute contexts.
Report run – Fixed ORA-01722: invalid number, when opening reports based on imported concurrent programs with parameter default values and LOVs, where id and value are different.
Report run – Fixed ORA-00907: missing right parenthesis, when using DFF columns in combination with a 'group by' clause, for example in the AR Aging report.
Report setup – Fixed 'The LOV Query is not valid. ORA-00904: "X"."ID". invalid identifier, after removing the ID column from a parameter LOV.
Report setup – Report version history was only refreshed automatically when opening the history window for the first time, but not for subsequent report SQL updates.
Report setup – Fixed Application assignment no longer working on setup window > Tools > Assignments
Data upload – Fixed Upload ends in error with German numeric format, also consolidated multiple columns related sheets into one simplified sheet.
Data upload – Fix for leading zeroes cut off in item upload (copy item from) when pasting item number for the first time by formatting Char cells as text.
Data upload – Upload does not work if there is a template used with hidden columns, which were previously visible at the time of template creation.
Data upload – Fix for ORA-06502: PL/SQL: numeric error or error on a value: character string buffer too small in AP Supplier Upload for French language.
Data upload – Fix for ORA-01722: invalid number in AP Invoice Upload.
Data upload – Fixed bug in Submit Item Import post process, which was not being submitted if the upload only contained category set assignment updates and no item updates.
Data upload – Fix for LoV error 'ISG_SERVICE_EXECUTION_ERROR' when copying and pasting value from another excel file in the LOV search text box, added logic to check if authentication was already done in last 4 minutes before switching to Basic Authentication.
Data upload – Performance fix for dependent lov's set as Filter Before Display being executed unrestricted.
Data upload – Fix for Runtime error '13', Type Mismatch in the upload excel file when working with european number format.
Data upload – Fix for "Error in advanced required parameters expression ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion".
Installation script – Correction for ORA-04043: object XXEN_WEBSERVICES does not exist.
Installation script – Fix for ORA-00904: "FDG"."SECURITY_GROUP_ID": invalid identifier when running install.sh.
Installation script – Fix for installation error PLS-00201: identifier 'XXEN_MSC_REL_PLAN_API.UPDATE_PLAN_ORDER', when compiling package APPS.XXEN_MSC_UPLOAD.
Installation script – Resolved installation error: identifier 'XXEN_MSC_REL_PLAN_API.UPDATE_PLAN_ORDER' must be declared.
Installation script – Fix for upgrade error: ORA-00942: table or view does not exist.
Installation script – Corrected PL/SQL: ORA-00904: "XUD"."DEPENDENT_COLUMN_NAME": invalid identifier, when upgrading from 3.3.0.
Installation script – Added new views to the drop statement to avoid ORA-01720.

New Uploads

New Reports

Updated Uploads

Updated Reports

3.3.1 2024-02-20

New Features

Financial Statement – 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

3.3.0 2023-09-04

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

3.2.6 2023-02-26

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

3.2.5 2022-10-06

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

3.2.4 2022-05-24

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

3.2.3 2022-03-16

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

3.2.2 2022-02-03

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

3.2.1 2021-11-19

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

3.2.0 2021-09-27

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

3.1.10 2021-08-13

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

3.1.9 2021-06-13

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

3.1.8 2021-04-01

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

3.1.7 2020-12-29

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

3.1.6 2020‑10‑26

New Features

Forms assignment option to call Blitz Report from any Oracle standard form using the Zoom button
Import option for Enterprise Command Center dataset queries, allowing users unlimited real-time access to ECC data in Excel

Updates

Report setup – Added auto-requery for dynamic parameter translations in case there is a parameter change that they depend on, e.g for the segment parameters in the GL Account Analysis report when changing to a ledger with a different chart of accounts
Report execution – Added LOV for email delivery with all users’ and employees’ email addresses
Report library – Added package code for new reports: AR Aging – 7 Buckets – By Salesperson/Agent, AR Transaction Register, FA Tax Reserve Ledger, MSC Vertical Plan, MSC Horizontal Plan
Report migration – Added API for programmatic report export
Installation script – Enhanced error detection

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

3.1.5 2020-08-02

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

3.1.4 2020-06-12

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

3.1.3 2020-04-01

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

3.1.2 2020-03-09

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

3.1.1 2020-02-05

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

2.9.5 2019-11-25

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

2.9.4 2019-11-19

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

2.9.3 2019-09-24

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

Library

The Blitz Report online library – repository of reports

Download

Blitz Report™ is completely freeup to 30 different reports

Resources

Explore Blitz Report™tutorials and documentation

By continuing to use the site, I accept the use of cookies. Accept