Support
Discussion Replies Created
The `SSLHandshakeException` typically indicates a certificate trust issue, specifically when the EBS instance is TLS enabled and the application importer script cannot validate the SSL connection. It is critical to ensure that when EBS is TLS enabled, all configuration steps regarding outbound connections are properly completed, not just the inbound configuration. You need to carefully review section 5.3, ‘Configure Loopback and Outbound Connections,’ in Oracle Support Document 1367293.1, ‘Enabling TLS in Oracle E-Business Suite Release 12.2’, because this section is frequently overlooked when inbound TLS is configured.
You can find this column in the DBA AWR SQL Performance Summary report, which gives an overview of top SQL load and performance issues.
The list displays all responsibilities you have access to in Oracle, including those with Account Inquiry functionality. The system defaults to the responsibility from which the report was initially run.
A value of ‘Y’ means the database might consider a different execution plan (Adaptive Cursor Sharing) based on different bind values. For typical Oracle EBS transactional SQLs, the execution path should generally remain stable. Therefore, ‘Y’ often indicates ‘instable’ SQL where the optimizer struggles to find the best execution path.
To calculate the functions on an entire sheet, you simply click the ‘Sheet’ refresh button while that sheet is selected.
Yes, you can hold Ctrl while selecting multiple ranges and then click the ‘Range’ refresh button to calculate only the selected cells.
Blitz Report is seeded with a library of operational reports covering core process areas such as R2R, O2C (Order to Cash), SCM, and P2P. If a report isn’t instantly available, users can browse the open source community reporting library, copy an existing solution, and adapt it, further reducing development time.
You should use the ‘Workbook’ refresh button to refresh all calculations throughout the entire workbook.
We gave Blitz Report the same look and feel as Oracle Forms to eliminate the steep learning curve associated with new tools. It is integrated via standard Oracle Forms and OAF pages , and it leverages familiar EBS commands and the standard security framework , ensuring minimum training is required.
To refresh only cells requiring recalculation, which are marked as ‘(pending)’, you should click the ‘Pending’ refresh button.
No, this is a key feature for end-user autonomy. While a business user cannot *create* the underlying SQL report itself, they have significant control over the output presentation. They can easily modify the report layout using the folder style template functionality. They can add, reposition, or remove report columns with just a few mouse clicks , thereby reducing IT dependency.
Absolutely. Blitz Report targets this exact issue, addressing the frustration that many Oracle EBS end users feel about IT requests. We provide tutorials specifically designed for non-developers, demonstrating how to quickly extract data using SQL directly into Excel.
Absolutely. Once you save the modified community query as a new Blitz Report, it is version-tracked , centrally managed, and ready for assignment to users or responsibilities. It also automatically runs through the concurrent request mechanism for optimized performance.
Blitz Report fundamentally relies on standard SQL queries. By enabling users to drop their tested SQL scripts directly into the tool , it maintains simplicity. The complex logic (like ECC dashboards or BI Publisher XML) is boiled down to the underlying query, allowing easy adoption and modification of community solutions.
Yes. If you don’t find the exact report you need in our standard library, you can browse the community reports, copy them into a new report definition, and then adapt the SQL accordingly for your business requirements. This dramatically accelerates time-to-delivery compared to starting from scratch.
A significant benefit of the Blitz Report ecosystem is the open source reporting library. This library is constantly growing, enhanced by requests from customers and suggestions from the Oracle EBS community. It’s designed specifically to help customers reduce reporting development time.
If the Period Name entered does not exactly match the format configured in Oracle (including case sensitivity, e.g., ‘JAN-2007’ versus ‘Jan-07’), the function will return no data and will likely trigger an ‘invalid (Period)’ message . Exact matching of Oracle’s configured format is mandatory for correct data retrieval .
If you leave a segment value field blank, or explicitly enter a percent sign (`%`), the function is instructed to include all possible values for that segment . This typically results in an ‘OR’ condition for lists, meaning all accounts matching any of the specified criteria will be returned .
Expansion simplifies maintenance, as the SQL can be modified directly in Blitz Report without requiring database view recompilation. ‘Custom’ means that only the SQLs of views starting with ‘XX%’ or those matching custom application short names (like ADS_%) are expanded during the import.
When using JED (Journal Effective Date), JEDU (Unposted JED), or JEDP (Posted JED), the Period Name parameter functions as a date parameter , accepting entries like a date range (e.g., `01/01/2007-05/01/2007`) . A crucial limitation is that the hyphen (`-`) serves as a range delimiter within Blitz FSG and cannot be used as the date separator within the date string itself (e.g., `01-01-2007` would be invalid if your regional settings use hyphens as date delimiters) . We recommend using slashes (`/`) as date separators and formatting the Excel cells as text to avoid regional setting conflicts .
For aggregating balances over a user-defined, non-standard period range, you must use the CTD (Custom-to-Date) Amount Type parameter . In the Period Name parameter of the `br_balance` function, you specify the range using a hyphen as the delimiter, such as `Feb-07-Aug-07` . This balance type specifically summarizes movement data across those defined periods .
For Discoverer folder import, the parameter is `p_expand_custom_view_sqls`. For Polaris RWB, it is `p_expand_view_sqls`. Both accept options like ‘All’, ‘Custom’, or ‘none’.
The CAC WIP Jobs Not Eligible for Closing report identifies jobs that exceed tolerances, have uncompleted assemblies, open requirements, or stuck transactions.
Yes, after successful relinking, you must bounce the concurrent managers so they pick up the corrected binary and begin generating output files again.
Both ‘Include Scrap Quantities’ and ‘Include Bulk Supply Items’ are required parameters. Setting ‘Include Scrap Quantities’ to ‘Yes’ counts scrapped assemblies with completed units, and setting ‘Include Bulk Supply Items’ to ‘No’ excludes bulk WIP supply types from the component requirements check.
Referencing best practices, the Oracle Workflow Administrator’s Guide is listed as a relevant resource for optimizing performance in that module.
You must relink the FND binary. Log in as the application owner (applmgr) and execute: adrelink.sh force=y ranlib=n “FND fndcpesr”.
You can use a custom Blitz Report based on the AD_PATCH.IS_PATCH_APPLIED function. This simplifies checking patch status quickly from the EBS forms interface, confirming if critical components related to JWS compatibility are correctly applied in your 12.2 instance.
The ‘Variance Amount Threshold’ (maximum absolute variance allowed) and the ‘Variance Percent Threshold’ (based on WIP Job Balance / WIP Costs In) are both required parameters.
This specific failure for host concurrent programs indicates that the FND binary responsible for output generation, $FND_TOP/bin/fndcpesr, is likely corrupted or zero bytes, often following maintenance.
Yes, Blitz Report provides specific guidance on How to add Blitz Report™ to your favorite form. This integration utilizes the underlying EBS forms technology, regardless of whether the form itself is launched via JWS, ensuring users have immediate access to highly formatted reports like those used for Supply Chain or Cost Accounting.
Yes, by default, the LOV of worksheets available for import shows only those that ran within the History Days timeframe.
You should use the CAC WIP Jobs Eligible for Closing report. This report specifically filters for jobs with status ‘Complete’, within variance tolerances, and without open requirements, unearned OSP charges, or stuck interface transactions.
To diagnose the underlying process status, use the WF Activity Status Summary report. This provides a summary of the activity status for workflows, helping pinpoint stalled activities.
You can use the WF Notifications report. This report lists the notifications, which is crucial for monitoring their status and history.
No, Blitz Report’s email functionality is available from EBS version R12 onwards only.
You use the PLSQL procedure `xxen_api.import_discoverer_worksheet`. This procedure requires identifying information including `p_workbook_owner_name`, `p_workbook_name`, and `p_worksheet_name`. It also takes `p_eul`, which defaults to ‘eul_us’.
To automate the Forms launch on Mac OS, you would create a script file named `open_forms.command` on the Desktop. The recommended command typically uses a standard shell command like `touch open_forms.command` or a similar utility to create the file and populate it with the required JWS execution instructions for automation. However, ensure your DBA enables JWS first, as confirmed in your previous communication.
Yes, developers can populate the default email field with an SQL statement returning one column containing email addresses. For example, a query returning the email address of the current EBS user.
The jnlp files should typically be deleted automatically after the session closes or times out. If cleanup issues persist, consult Section 6 of Using Java Web Start with Oracle E-Business Suite (Doc ID 2188898.1), which details browser user experience and configuration related to file cleanup.
The behavior suggests that while the Java environment might be running, the EBS form launch configuration may be incomplete. If you see only the copyright, it’s often a sign that the necessary Java Web Start (JWS) launch sequence isn’t fully executing. Crucially, you should confirm if JWS is enabled on your system as a prerequisite.
The default email address is derived following an order of precedence. The highest priority is the Default email setup on the report level. If that is not set, it falls back to the value defined in the Profile option ‘Blitz Report Default Email Address’.
To send the report output to multiple recipients, you must enter them as a comma-separated list in the Email field on the Options window.
This is a recognized issue, and the solution typically involves consulting the specific guidance outlined in MOS Doc ID 2924556.1, which addresses the inferior resolution of EBS Forms-based applications on Mac OS workstations. This solution focuses on adjustments related to the display settings impacting Java Forms.
Yes, once the cell is linked, you can press F4 to toggle between absolute and relative referencing, which is standard Excel behavior.
To bind a parameter to an Excel cell, you must click the Link button associated with that parameter field.
Required parameters are clearly indicated because the fields in the Function Form are highlighted yellow.
You use the ‘Layout Options’ menu to select the report and template for displaying the customized drilldown data.
Yes, profile settings determine the report used for each drilldown level (e.g., ‘GL Journal Attachment’ via the Blitz FSG Drilldown Report GJA profile).
Yes, clicking ‘Convert’ identifies the Oracle FSG report’s row set, column set, and content set, and automatically replicates a draft template.
Each of these drilldown reports has templates that define the columns displayed, their sequence, and sorting order. You can create custom templates in Blitz Report to customize the layout.
Drilldown data is extracted through the Blitz Reports ‘GL Journal (Drilldown)’ and ‘GL Account Analysis (Drilldown)’.
The Row Set’s Calculations map to Column I. However, these calculations require manual adjustment post-conversion.
The Row Set > Rows > Line Item maps to Column G (Description).
The Row Set > Rows > Account Assignments map to Column B to Column F in the converted template, based on your chart of account segments.
No, this method secures data access only through the Blitz Report concurrent program, not through direct queries using database access tools or standard Oracle EBS processes.
You should set the profile option ‘Blitz Report VPD Policy Rule’ to ‘Full access’ at the user or responsibility level for those who need access to run Blitz Reports on secured data.
For comprehensive PO data, use the PO Headers and Lines report. This links PO headers, lines, receiving transactions, and corresponding AP invoices.
You can optionally set the profile option ‘Blitz Report VPD Policy Rule’ to control data access on secured tables.
Yes, run the PO Internal Requisitions and Sales Orders report. This displays internal sales orders and requisition numbers, including aging dates.
The underlying issue relates to the consistency of FND_DATE output. Temporarily reverting the ICX: Date format mask profile option back to DD-MON-RR on the relevant responsibility or user level should allow the reports to run again.
Enginatics in How to create a Delivery in Full On Time metric in Oracle E-Business Suite using Blitz Report™ Yes, since the output is perfectly formatted, native Excel , the data is immediately usable for advanced analysis tools like pivot tables, suitable even for financial performance reviews.
Enginatics in How to create a Delivery in Full On Time metric in Oracle E-Business Suite using Blitz Report™ After adding your new calculated columns to the user template, you can make the report available immediately for testing. Furthermore, reports can be assigned to a specific user or responsibility for immediate testing and validation before general rollout.
Use the PO Purchase Requisitions with PO Details report. It provides the Purchase Requisitions Status along with the associated PO Details.
This is a recognized inconsistency in date output mask handling when moving away from the default format. The most likely cause is that you are missing Oracle patch 12678526.
Enginatics in How to create a Delivery in Full On Time metric in Oracle E-Business Suite using Blitz Report™ Blitz Report facilitates internal change control. It automatically records the necessary change control information whenever applicable during the report modification process, maintaining an audit trail and version history within EBS.
Enginatics in How to create a Delivery in Full On Time metric in Oracle E-Business Suite using Blitz Report™ Yes. If your system tracks changes to the promise date (assuming the necessary audit setup parameters are configured), you can review the Audit capability using Blitz Report. This allows you to track master data changes accurately, providing governance over the source data used for the KPI calculation.
Yes, Blitz Report leverages all of the standard EBS functionality, including security. Additionally, sensitive data access can be controlled using Oracle Virtual Private Database (VPD) policies at the row and column level.
If you initially define the parameter using the ‘LOV Custom’ type, you can save it as a shared LOV for reuse across multiple reports . After setting up the query, click the ‘Save as shared LOV’ button in the LOV definition window . If you reference an existing shared LOV (type ‘LOV’) and later modify its query, those changes will immediately affect *all* other parameters referencing that shared LOV .
Enginatics in How to create a Delivery in Full On Time metric in Oracle E-Business Suite using Blitz Report™ First, modify the Blitz Report copy and give it a meaningful name, such as ‘ONT DIFOT’. Second, revise the underlying query to incorporate the logic for DIFOT calculation, and test the revised SQL. Third, modify the user template to show only the specific columns required for the DIFOT metric, improving readability and focus.
Blitz Report is engineered for efficiency with reduced processing overhead, ensuring performance is incredibly fast. By running optimized SQL through the Concurrent Request mechanism , you achieve maximum visibility into your inventory data without exacerbating existing system performance issues.
All Blitz Report List of Values queries must select two mandatory columns: `value` and `description` . Optionally, the LOV SQL may also include an `id` column at the beginning of the `SELECT` clause . If an `id` column is selected, that `id` value is used to bind the parameter restriction for the main report execution; otherwise, the `value` column is used as the bind value .
Yes, the runtime option ‘Disable Column Translations’ provides the same functionality at the moment of report execution.
Enginatics in How to create a Delivery in Full On Time metric in Oracle E-Business Suite using Blitz Report™ Creating the DIFOT metric involves understanding your promised date and order date types as the first step. You should start by copying a seeded Order Header and Lines Blitz Report to leverage existing joins and then modifying the copied report.
Yes, the PO Purchase Price Variance report is the imported Oracle standard report equivalent (Short Name: POXRCPPV_XML).
No, the automated IN-clause replacement will not work for complex SQL text or if a different comparison operator is used, such as `>=:bind_variable` . For the multi-value functionality to be available, the parameter SQL text must strictly adhere to the requirement of having the table column on the left side and the `:bind` variable on the right side of the comparison operator .
If an error occurs, you should review the report concurrent logfile. The logfile shows error messages, the executed SQL, user-entered parameter values, and corresponding bind variables.
By default, SQL column headers get translated automatically to strings defined in Tools > Column Header Translations.
If you are using LOV Custom, you can click on the Save as shared LOV button within the LOV Query field window to promote that ad hoc query into a reusable, shared LOV definition.
For 361012 seconds, the function returns ‘4d 4h 16m 52s’.
Yes, Blitz Report is seeded with operational reports covering core process areas like Supply Chain Management (SCM). We also provide demonstrations and video overviews covering the specific functionality for Inventory Period-End optimization. You can try this optimization immediately as the software is free for your first 30 reports.
For specific receipt statuses, use the AP Matched and Modified Receipts report. This report is imported from BI Publisher.
The result is a string showing the number of days, hours, minutes, and seconds, formatted as ’67d 14h 45.3s’ in one of the examples.
Yes, if you want to give your outbound interface report an additional level of protection and allow modifications only by users with the ‘System’ access profile, you can set its Type to ‘Protected’.
The Validate From List checkbox, when checked, enforces selection of a record from the LOV and does not allow the use of wildcards. The Filter Before Display setting is specifically used to avoid performance issues for large LOVs. If its checked, the user is prompted to enter a partial value before the LOV displays, preventing a slow initial query of all possible values.
You need to set the profile option ‘Blitz Report Disable Column Translations’ to ‘Yes’. This is used to disable the translation of the report’s header, which is often required for interface needs.
Yes, the PO Headers and Lines 11i report provides the same functionality for older environments, including the linkage of PO headers, lines, receiving transactions, and AP invoices.
Yes, Blitz Report offers automated Multiple Values functionality . If the parameter SQL text uses a bind variable restriction with an ‘equal’, ‘not equal’, or ‘like’ operator (e.g., `column_name =:bind_variable` or `upper(column_name) like upper(:bind_variable)`), and the user checks the ‘Multiple Values’ checkbox, the restriction is automatically replaced with an `IN-clause` during SQL execution , . This automation is only available for parameters using `1=1` or `&lexical` anchors, not simple `:bind` anchors .
You must override the default behavior using the profile option ‘Blitz Report Suppress Empty File Delivery’. To ensure that empty files are also sent for scheduled reports, set this profile option value to ‘No’.
The function **`XXEN_UTIL.TIME(p_seconds in number)`** converts a number of seconds into a time string.
The PO Headers and Lines report provides this level of detail. It links PO headers, lines, receiving transactions, and corresponding AP invoices.
If you modify a shared LOV’s query via the parameter definition, the changes affect all parameters referencing it. To modify it for the current parameter only, you should switch the parameter type to LOV Custom before modifying the query. This creates an ad hoc LOV unique to your report.
New operational reports can be created within minutes. You simply input the SQL that identifies the stuck transactions (which might be causing a backlog of running concurrent requests ) into Blitz Report, and the tool rapidly produces a formatted Excel report ready for immediate resolution.
By default, if a scheduled Blitz Report retrieves zero rows, it does not send an empty output file. File delivery through Oracle standard’s delivery options is suppressed.
Hi Peter,
There was a difference in how the accounted amounts are rounded between the standard oracle report and the Blitz report. This has now been resolved. Please find attached the amended version of the Blitz AR Open Items Revaluation report.
When dealing with parameter dependencies where the parent parameter supports multiple selections, you must use the `xxen_util.contains` function within the dependent LOV query . The standard dependency syntax, `:$flex$.parameter_or_lov_name`, is used to reference the parent parameter (e.g., `:$flex$.operating_unit`) . The `xxen_util.contains` function ensures that the dependent LOV query correctly filters results by checking if each potential supplier’s operating unit ID is present within the comma or semicolon-separated list of multiple values passed by the parent parameter .
Blitz Report is highly beneficial for optimizing critical processes like Oracle EBS Inventory Period-End. It provides a superior way to quickly identify and report on data issues. Specifically, our diagnostic and General Ledger reporting toolkit is excellent for solving problems like a multitude of stuck transactions in the sub-ledgers.
The LOV query must select the two mandatory columns value and description. It may also include an optional id column at the beginning of the select clause. If the optional id column is included, this value takes precedence and is used as the parameters `:bind` value for report execution; otherwise, the value column is used for binding.
Hello,
Just to clarify, I see from the install logs we have for you, you are running EBS 12.2.6 and Blitz Report v3.3.0. Is this correct?
From the error screenshot you sent that the LOV is referring to a view ‘XXEN_GL_LEDGERS_V’ which would not exist in your instance as this is only created for clients installing Blitz into an 11i environment. Which means you have some incorrect LOV definitions referring to the 11i views. These are not included in the downloads from our library so I am not sure how they would have been imported into your instance.
Please import the attached report definition. This one contains the LOV definitions for Blitz running in an R12 instance.
Kind Regards,
Eric
Indeed. This centralized approach, combined with the ability to categorize the report (e.g., ‘Toolkit – Business Operations’) for quick retrieval, streamlines management for development and support teams significantly.
The system automatically manages this. When you create or modify a report by pasting a new SQL query into the Blitz Report form, the system tracks the version control number automatically, ensuring that changes are logged and previous versions can be reviewed. This feature is part of the project implementation and upgrade toolkit functionality.
Set the parameter ‘Show Bind Values’ to ‘Yes’ in the DBA SGA SQL Performance Summary report. This will help you identify the SQL and example bind variables needed to reproduce the exact execution path in a database access tool.
Hello,
Apologies, I was reviewing the change history for this report, and the reason we unlinked from the XML Publisher is that we have clients that want to be able to run the report across multiple Operating Units. If it is linked to the XML Publisher Report (which is OU specific) then the OU context is restricted to a single OU.
So with that in mind I took another look at the query and there is indeed a missing join that meant transactions that use a transaction type which is common across the accessible OUs within the responsibility would be repeated for each accessible OU.
The same join is missing in the standard code, but as the standard report runs within the context of a single OU, it is not an issue,
I have fixed the underlying issue, and retained the ability for the Blitz Report to be run across multiple Operating Units.
Please find attached the amended version of the report (also available for download from the Enginatics Library https://www.enginatics.com/reports/ar-open-items-revaluation/).
Blitz Report incorporates full version control. This is a core feature that tracks modifications to your custom SQL scripts. It ensures that reports are not duplicated and provides a comprehensive audit/version history of all changes made to the report definitions.
Yes. Navigate to the UI functionality or run the program first, and immediately after, execute the report. You can then restrict results by the ‘Module Name’ parameter and sort by the ‘Last Active Time’ column to find the recent executions associated with that module.
Yes, you can enable the profile option ‘Blitz Report XLSX Use Long Date Format’ to show leading zeroes for the day and the full year.
You should use the DBA SGA SQL Performance Summary report. The purpose of this report is specifically to retrieve SQL statements from the Shared Global Area (SGA) that might not have been written to AWR because they ran too recently or their performance impact was too small.
If it is not set, the value from the standard Oracle profile ‘ICX: Date format mask’ is used.
You set the profile option ‘Blitz Report XLSX Date Format’. This allows you to define the date format mask for Blitz Report XLSX output files.
You can refer to standard documentation like the Oracle Workflow Administrator’s Guide for general tuning guidance.
You should use the WF Notifications report for monitoring notification status and history.
Yes. We offer a complimentary, three-month ‘Proof of Concept’ license when you download and install Blitz Report in your EBS environment. The software is free to use for up to 30 different reports.
Use the WF Activity Status Summary report. This report provides a summary of the activity status for workflows.
Local customizations are protected by the built-in full version control. This feature tracks all changes and provides an audit history, ensuring stability even with ongoing core product enhancements and rapid report creation cycles.
Recent enhancements include core features such as delivering the required data as native Excel files , ensuring incredibly fast performance due to reduced processing overhead , and providing column templates that allow users to customize any report instantly by removing or reordering columns so they only receive the data they need.
We treat customer feedback as an excellent opportunity to enhance the library. Each new suggested report is meticulously analyzed and developed to ensure it will be valuable to the widest possible audience of EBS customers. This community-driven development ensures broad utility.
Yes, they serve different, complementary purposes. While ISG handles machine-to-machine data exchange, Blitz Report allows developers and business users to quickly define and run SQL queries for ad-hoc, high-volume data extraction directly from EBS to Excel. It provides rapid visibility into the data sets that might be feeding or being updated by your ISG integrations.
To allow administrative login to the core Solr application from additional hosts, you need to configure the Weblogic Connection Filter . This is done in the Weblogic Admin Console under Security > Filter, where you must add an allow rule for the specific IP address of the administrative host, ensuring protocols like `http`, `https`, `t3`, and `t3s` are permitted on the managed server port (e.g., 7776) .
We maintain a strong commitment to service and support. A key part of this commitment is the ongoing development of the Blitz Report Library. This library continues to grow based directly on requests from customers and suggestions from the Oracle EBS community.
No, it is generally understood that it is not possible to directly combine the ECC security handlers with Oracle VPD policies , . VPD works strictly at the table level within the Oracle database . Since ECC data is loaded out of the Oracle database and stored/indexed separately using Apache Lucene technology, the VPD policies cannot be directly applied during the user query phase in ECC .
Security is mandatory. You must follow the detailed instructions for configuring TLS/HTTPS for Oracle EBS Integrated SOA Gateway (ISG) in 12.2. Configuring HTTPS ensures encrypted communication, protecting your EBS instance from attacks through unsecured HTTP channels.
ISG provides a crucial interface for facilitating communication between your custom external applications and Oracle EBS. Properly configuring the REST services allows for modern, standardized data exchange and system interactions.
Yes, for manual custom application setup, you must ensure both steps are completed: registering the database user (XXEN) and linking the application to the correct Data Group for the responsibility.
A typical JSON filter condition for MOAC security would target the organization ID . The structure would include the `key` being restricted (e.g., ‘ORG_ID’), the `operator` (e.g., ‘in’), and the `values` (the list of allowed ORG IDs) . For example: `{‘filters’:[{‘values’:[‘204′],’operator’: ‘in’,’key’:’ORG_ID’, ‘minValue’:’null’, ‘maxValue’:’null’}]}` .
The Integrated SOA Gateway component is already included in your Oracle E-Business Suite installation. However, it absolutely requires specific configuration steps to be enabled and fully functional, particularly for exposing REST services.
You must navigate to System Administrator > Security > ORACLE > DataGroup. Find the data group used by your responsibility (often ‘Standard’) and add an entry for the Enginatics Custom Application, ensuring it is linked to the Oracle ID APPS.
It is superior to ECC’s native export, which often produces limited CSV files. Blitz Report ensures high-volume data sets, whether derived from Discoverer replacement efforts or ECC SQLs, are extracted cleanly and efficiently for BI consumption.
The integration method is deliberately straightforward, documented under ‘How to add Blitz Report™ to your favorite form’. By leveraging the native Zoom feature, you avoid complicated custom code deployment in forms. The benefit is immediate access to detailed data relevant to the current form record, using simple SQL logic implemented and managed entirely within Blitz Report.
When a user logs into ECC, the security handlers are responsible for translating the user’s EBS-based privileges (e.g., their assigned `ORG_ID` access) into JSON conditions . These JSON filters are then constructed and passed to the ECC data retrieval layer (Solr/Lucene) to restrict the data available for the user . This method is necessary because the data is retrieved from files indexed by Apache Lucene, not directly from the Oracle Database tables .
This error occurs because there is a missing Data Group entry linking the custom Blitz Report application (Enginatics Custom Application / XXEN) to the responsibility you are using.
Yes, Blitz Report enables seamless integration of reports directly into standard EBS forms by utilizing the Oracle Forms’ built-in Zoom functionality. This method makes the reports context-aware, meaning they run based on the data displayed in the form at that moment.
The security of the extracted data set is maintained by the underlying EBS security framework and Oracle VPD policies. For the extracted files themselves, the reports can be distributed through enhanced delivery options via the Concurrent Request mechanism , ensuring only authorized users receive the output.
The output format is defined as part of the report parameterization or execution profile within the Blitz Report interface, allowing flexibility per execution. Crucially, the process of bringing over the underlying SQL via the automated Discoverer migration features significantly speeds up the time to production readiness.
The ‘Super User’ access level allows users to create private and shared templates, and critically, modify other owner’s templates.
Your ability to create templates depends on the profile option ‘Blitz Report Template Access’. If set to ‘Private only’, users can create only private templates. If set to ‘No Access’, users can only view and use existing templates.
No. When exporting data via the Blitz Report engine, there are no volume limitations. This capability is critical for supporting mass data imports required by large-scale BI implementations, ensuring reliability far beyond the constraints of previous tools.
Templates can be shared across three levels: Site (all users in the system), Responsibility (users having the specified responsibility), or User (inclusion or exclusion by specific user).
Yes. While Blitz Report is famous for its native Excel output , a user can also report data to CSV or other file types suitable for importing to Tableau or Microsoft Power BI. This capability makes Blitz Report an ideal bridge for moving data out of EBS and into your modern BI ecosystem, replacing Discoverer effectively.
Assuming you have developer access, you can set the template as the default for all report users by checking the ‘Global Default’ checkbox within the template layout window. This is an option available for developers only.
Reports covering this specific topic are available in our materials, highlighting overlooked performance metrics. Using the Blitz Report toolkit allows your DBA team to proactively assess system performance, pinpointing any pre-existing bottleneck processes or user waits.
Yes, for updating SQL text or List of Values across all reports simultaneously, you must use the Mass Change functionality, accessible via Blitz Report Setup > Tools > Mass Change . This utility allows you to enter a find-and-replace update across the entire SQL base . Always use the Preview button first to see the list of changed objects before applying the changes .
Report creation is incredibly fast; new reports can often be created in minutes, sometimes even under 10 minutes for perfectly formatted Excel output. Critically, Blitz Report delivers the required data as native Excel files with formatting and filters applied automatically. There is no volume limitation like with BI Publisher, and no complex XML formatting is required to produce the final Excel report.
Custom number formats are defined in the lookup `XXEN_REPORT_NUMBER_FORMATS` . This lookup stores the internal Microsoft style IDs, which must be a numeric value above 200 (as lower IDs are reserved for Microsoft’s standard formats) . Once defined, you can reference these formats either for all columns in a report, or for individual columns using column translations .
Yes, our Diagnostic Pack reports have been explicitly updated to ensure they work correctly with pluggable databases (PDB) within the container database (CDB) structure. This guarantees accurate performance metrics retrieval, addressing the technical changes introduced by the multitenant architecture.
The scale percentage applies to the overall automatically calculated column width, regardless of whether the alignment mode is header, data, or both.
You should only use the `p_include_columns` option if you have mandatory column configurations to migrate . Specifically, this includes cases where you have defined optional multi-language column translations or implemented column-specific number format settings that differ from the site or report defaults . If your environment only uses default formats or English column headers, you should omit this option .
AWR data is essential for diagnosing database bottlenecks, user waits, and pre-existing performance issues. Our AWR monitoring toolkit reports are designed to remove the complexity out of database tuning. They function as a simpler, immediate reporting mechanism integrated right into the EBS Forms interface, avoiding the need for external tools or database command line access.
Absolutely. The Blitz Report tool is specifically designed for Oracle EBS end users who are often intimidated by traditional report creation methods, addressing the frustration of waiting on IT. We offer tutorials geared toward non-developers showing them how to easily use SQL for Excel reporting directly from EBS. The learning curve is minimal, as it resides within the familiar Oracle forms interface.
The default scale is 100.
You can use the profile option ‘Blitz Report XLSX Column Width Scale Percentage’. This allows adjusting the automatically calculated column width, in case the cell content does not fit the width on certain client screen resolutions.
Including column details (translations and number formats) via the `p_include_columns` parameter significantly impacts performance because it forces the database to perform an extra step for every report being exported . The database must explicitly parse all exported report SQLs in order to identify every single column name included in the query . This process is computationally intensive, especially for complex or voluminous SQLs, leading to a substantial slowdown of the export utility .
Blitz Report offers specialized tools for EBS Tuning, particularly relevant when running EBS on Cloud. We advise utilizing the Database Health and Tuning reports, which include a comprehensive suite of AWR (Automatic Workload Repository) and FND (Foundation) reports.
To review the accounts used for existing intercompany parameters and relationships across operating units, use the CAC Intercompany Relationship Setup report.
When a JNLP file is downloaded (e.g., when launching a form menu), the user may be prompted on the first run to provide the path to the `javaws` executable . Its precise location can vary depending on the operating system and installation structure . Users should locate the `javaws` binary within their client-tier JRE installation path to correctly associate the JNLP file , .
No, this report is unique in that it has no parameters.
You can correlate the login and session data with the detailed concurrent request monitoring reports, which track request execution status and parameters. By correlating session information (derived from FND tables) with concurrent processing details, you gain a powerful security and performance diagnostic tool.
Unfortunately, Oracle no longer supports the Look and Feel options of previous releases after applying critical ATG patches (like R12.ATG_PF.C.Delta.5 and higher) . If your UIX version upgraded to 12.2.6 or later during the JWS migration, Oracle only supports the ‘Alta Look and Feel’ with Java Web Start . Customization to revert to SWAN or SKYROS is not supported .
Blitz Report is known for its reduced processing overhead and exceptional speed. By optimizing the execution of these diagnostic SQL queries, it allows frequent running of reports without unduly impacting overall EBS performance.
Run the CAC Shipping Networks Missing Interco OU Relationships report. This report specifically shows missing inventory intercompany operating unit relationships.
You should examine the output of the query `select support_db D, support_cp C, support_admin A, support_forms F, support_web W, node_name, webhost from apps.fnd_nodes order by node_id` . Pay close attention to the `webhost` column and the `support_forms` column (labeled ‘F’) . Ensure that the `webhost` reflects the publicly accessible address (Load Balancer or hostname) and that the `support_forms` flag is correctly set for all nodes intended to serve JWS forms .
Yes, run the CAC Inventory Periods Not Closed or Summarized report. It finds periods that are open or closed but not summarized, which impacts efficient month-end reporting.
The ‘Period Name (Closed)’ parameter is mandatory, as it specifies the closed inventory accounting period you wish to report.
This issue points to a configuration discrepancy between your nodes, likely related to hostname registration or the Forms Launcher profile . You must first inspect the value of the `ICX: Forms Launcher` system profile to ensure it is correctly pointing to your load balancer or the designated access URL, not an individual node’s internal address . Secondly, run a SQL query against the `apps.fnd_nodes` table .
Since Blitz Report eliminates the need for registering Concurrent Programs, and the report structure is straightforward (SQL definition and parameter setup), implementation is fast. The tool supports rapid creation and sharing of SQL-based reports with role-based access.
Use the mandatory parameter ‘Minimum Value Difference’. By default, it is set to one, but you can enter a larger value like 100 to restrict the output to significant differences. To see all differences, enter a value of zero (0).
The underlying SQL query in this specific Blitz Report leverages the standard EBS tables utilized by Oracle Applications DBAs to record session information and client connection details, including the client IP address. The Blitz Report simply organizes this raw technical data into an actionable report format.
You should run the CAC Inventory Out-of-Balance report. This report shows differences between the cumulative inventory accounting entries and the onhand valuation of subinventories and intransit stock locations, compared against the period end snapshot.
You can integrate this extracted data directly with visualization tools in Microsoft Excel. The resulting Blitz Report output can be used for EBS logins geolocation tracking with Blitz Report and Excel Bing Maps. This leverages Excel’s mapping capabilities for security monitoring.
Yes, Blitz Report facilitates finding the IP address and geolocation of EBS clients’ logins. This feature is part of the DBA toolkit, allowing operational and security teams to monitor user activity effectively within EBS R12 environments.
Because the hyperlink construction is part of the core SQL logic, any changes saved to that report definition benefit from full version control and audit history automatically managed by Blitz Report.
Yes, once the prerequisite tablespace is created as `sysdba`, you should rerun `adsplice`.
They serve different stages of analysis. The Zoom function integrates the report execution *into* the EBS Forms experience for contextual access. Hyperlinks, conversely, allow users operating *outside* of EBS (within the exported Excel file) to click back into a specific record or document, providing traceability and immediate access post-export.
Yes, this is a dependency issue specific to running `adsplice` on Oracle E-Business Suite version 11i. You need to follow Oracle note 444524.1 and manually create the tablespace `APPS_TS_TOOLS` using a command like: `create tablespace apps_ts_tools datafile ‘tools1.dbf’ size 500m extent management local autoallocate;`
Yes, the profile option ‘Blitz Report Disable Column Translations’ can be set to ‘Yes’ to disable automated column header translations system-wide.
Since the calculation of the hyperlink URL is handled within the SQL query itself, the impact on performance is generally negligible, as the Blitz Report engine is optimized for high-speed SQL execution. The ability to deliver the required data as native Excel files contributes to this speed.
Run the Blitz Report Parameter Custom LOV Duplication Validation report. It identifies custom LOVs with the same query used more than once, suggesting they should be converted and set up as a shared LOV instead.
Yes, you can select the ‘Exclude Column Headers’ option. This removes the header column completely from the output file, also typically used for interface requirements.
The underlying SQL query must be crafted to construct the necessary URL string, often concatenating the EBS base URL, the function parameters (like form name, primary key ID), and the relevant field. Blitz Report recognizes this structured output and renders it as a clickable hyperlink in the resulting Excel file.
After migration, often slow LOVs contain `distinct` clauses which hinder performance. The recommendation is to correct errors and change slow ‘distinct’ style queries to faster SQL statements.
Yes, hierarchical reporting is simplified through flexible parameter handling. For instance, in an account analysis report, you can utilize the Parent Total (PT) option in the run-time parameters to easily generate reports aggregated based on the parent account level. Key users can select from existing Oracle or Enginatics report parameters to simplify this setup.
Yes, Blitz Report fully supports hyperlink functionality. This is a powerful feature that turns static reports into dynamic navigation tools, enabling deep drill-down features directly from the Excel file back into the source data within Oracle EBS or linking to external systems or document management.
Yes, disabling column translations is commonly used to meet external interface requirements by ensuring column headers remain static and untranslated.
You should use the Blitz Report LOV SQL Validation report. This report specifically validates Blitz Report LOV SQLs for valid syntax, which is crucial after mass migrations from tools like Discoverer.
For cross-organizational and cross-currency cost comparison, use the CAC Item Cost Comparison report. It converts the source organization’s cost into the comparison organization’s currency.
You need to use the ‘Disable Column Translations’ option in the Options window. Enabling this option prevents the report’s header translation from occurring, even if a multi-language setup is active.
Blitz Report is designed to simplify and clarify Oracle EBS Financial Accounting data, supporting detailed GL Account Analysis. It excels by providing immediate, perfectly formatted Excel output from your SQL query. The report output is automatically opened with necessary filters applied, and crucial data types like currency figures are correctly formatted during Excel file generation.
That is correct. The manager’s operational context must be re-initialized. If you choose to create a new application, you must plan downtime for this specific step.
Absolutely. The Operational reports category within the toolkit covers core processes like Record to Report and Purchase to Pay, and specifically allows for the replacement of Discoverer and BI Publisher reports using the import functions provided.
The ‘Cost Type’ parameter is mandatory; you must enter the cost type(s) you wish to report against.
Yes, the Date Format profile sets the mask, and the Long Date Format profile allows the showing of leading zeros for the day, month, and the full year.
The default value is ‘No’, meaning it does not enforce the long date format.
Yes, this is a known consequence. Creating a new application via `adsplice` requires running `autoconfig` and then a definitive Concurrent Manager restart (bouncing the application tier services). The restart is essential to enable the manager to pick up and process concurrent requests for the newly created application.
Yes, you can filter using the optional parameters ‘Make or Buy’ (enter ‘Buy’ to restrict to purchased items) and ‘Item Status to Exclude’ (which defaults to ‘Inactive’).
By providing instant report creation from simple SQL without requiring standard concurrent program registration, reporting delivery time is significantly reduced. The reports are also accessible directly in Oracle Forms, simplifying usage for functional users.
You must set the profile option ‘Blitz Report XLSX Use Long Date Format’ to ‘Yes’. This ensures dates in Blitz Report output XLSX files show the full year and a leading zero for single-digit days.
The CAC Items Without This Level Material Overhead report is exactly what you need. It shows item costs which do not have this level material overhead for any cost type.
The toolkit includes Time Critical reports geared specifically towards mass exporting volume data. Furthermore, the Blitz Report engine is designed to export mass data from *any* EBS form by using its Excel export engine, overcoming limitations and ensuring reliable output, whether you have 5 million records or fewer.
No, both the sheet and the custom properties are essential for the proper functioning of the report’s linked data and drilldown capabilities.
Good practice recommends that report names be short and descriptive, so keeping the prefix short is advised.
Create a custom Blitz Report leveraging the AD_PATCH.IS_PATCH_APPLIED database function. This allows the DBA to input a list of critical bug numbers and instantly verify their application status across the required EBS application tops.
Oracle E-Business Suite reporting straight into Excel: 2,900+ ready-made reports, your own SQL, 150+ Excel uploads.