Support
Discussion Replies Created
If the profile option is not set, the default is ‘No access to run reports’.
Yes. If you have the patch zip, you can unzip it, navigate to the `ctx/data/enlx` directory within the patch contents, and copy all files (like droldUS.dat) to `$ORACLE_HOME/ctx/data/enlx` on all database nodes.
A profile setting of ‘User’ grants access to run assigned reports or uploads only. This is the standard setting for business users who consume a license.
This indicates that the Oracle Text Knowledge Base files necessary for linguistic initialization are missing from your database home. You should follow Oracle note 557239.1 to install them.
The profile can be set at any level (Site, Responsibility, User) depending on the scope of the performance issue.
The default value is ‘No’ (meaning security checks are run).
Yes, you should use the profile option ‘Blitz Report Disable GL Flex Value Security’. This allows disabling the GL flex value security, which is intended for customers experiencing slow performance of GL Balance or GL Account Analysis reports, provided they do not use security rules.
The FND Request Groups report shows the FND request groups and their assigned units, such as concurrent programs, request sets, or applications.
Run the FND User Responsibilities report. This report is similar to the ‘Active Users’ report and shows inactive/end-dated user responsibilities, whereas the FND Access Control reports typically only show currently active assignments.
If ‘Is Bind Sensitive’ is ‘Y’, it means the DB might consider a different explain plan for different bind values (Adaptive Cursor Sharing). For EBS transactional SQL, the path usually shouldn’t change, so ‘Y’ often indicates ‘instable’ SQL where the optimizer is struggling to find the best path.
Use the FND Responsibilities report.
That is correct. You have the `text search` by typing into the report name field and the `query` method using F11 and Ctrl+F11 for finding reports.
The ‘Plan Hash Value’ is an identifier for one particular execution plan. A change indicates that the optimizer chose a different path (e.g., stopping using an index and starting a full table scan), even if the SQL text itself hasn’t changed.
You are correct; `adsplice` typically handles this. If created manually, this step is often missed, as some Oracle notes describing manual custom application creation omit it. You must add an entry in the ‘Installations’ form for the Enginatics Custom Application and Oracle user XXEN.
The F11/Ctrl+F11 functionality typically operates on the fields visible in the form, such as the report name or description. The ‘text search’ by typing directly into the field is the one that executes a full text search across the SQL, parameters, and templates.
You have two main options, depending on when the slow run occurred. Use DBA AWR SQL Execution Plan History for past runs, or DBA SGA SQL Execution Plan History for recent runs currently in memory. Both retrieve the plan history for a particular SQL_ID.
This issue means the necessary link between your custom application (XXEN) and its Oracle database username is missing in the EBS setup. You need to configure this under Alert Manager > System > Installations.
For the version that shows the Sales and COGS accounts, use the CAC Margin Analysis Account Summary report. This report shows the accounts, although note it might only show the first COGS account if you have custom Subledger Accounting configurations.
First, press F11 to enter query mode, then enter your pattern (like ‘GL%’) in the relevant field, and finally press Ctrl+F11 to execute the query and retrieve the matching reports.
The mandatory prerequisite is that you must first run the ‘Margin Analysis Load Run request’ to populate the standard Oracle Margin table (`cst_margin_summary`).
Yes, the Super User role allows modification of any template, which would affect all users accessing that template.
Yes, you can run a query on the report name or description fields. This uses the standard Forms functionality.
Use the CAC Margin Analysis Summary report. This report provides the margin based on the standard Oracle Margin table, `cst_margin_summary`, without showing the COGS and Sales Accounts (unlike the Account Summary version).
Not necessarily. While Developers can create/modify templates (depending on template access), the Super User template access profile can be used to designate specific users as ‘Super User’ solely for template layout control.
Yes. If your system experiences slow performance on GL Balance or GL Account Analysis reports and you do not use security rules, you may consider setting the profile option ‘Blitz Report Disable GL Flex Value Security’ to ‘Yes’.
Yes, there is the GL Account Analysis 11i report, which provides a detail GL transaction report with one line per journal line, including all segments and amounts in both currencies.
You must set the profile option ‘Blitz Report Template Access’ to ‘Super User’. This grants the ability to create private and shared templates, and crucially, to modify other owner’s templates.
Yes, setting the profile option ‘Blitz Report Show Log Instead of Output’ to ‘Yes’ is specifically designed to streamline the debugging process . When this profile is active, the system automatically opens the logfile upon report completion instead of the Excel output, allowing developers to immediately inspect the detailed execution status and errors without navigating to the Concurrent Requests screen .
You need the GL Account Analysis report. It provides a detailed GL transaction report with one line per transaction, including all segments and subledger data, showing amounts in both transaction currency and ledger currency.
Yes, the upgrade concurrent program automatically disconnects active sessions and sets the ‘Blitz Report Maintenance Mode’ profile option to prevent user access during the upgrade.
We recommend using Firefox instead of Internet Explorer to access Oracle EBS because Firefox generally offers better performance and supports the automated download and opening of output files without repeatedly prompting for confirmation . However, please note that for newer Firefox versions, you may need to use Java Web Start (JWS), or use an older supported 32-bit ESR version like version 52, which was the last to support NPAPI plugins .
Yes, the profile value is removed after the upgrade is completed.
The format depends on the parameter type set in the Blitz Report setup . If the type is ‘Date’, the value is bound as midnight of the date entered, without timezone conversion . If the type is ‘DateTime’, and timezone conversions are enabled, the value is converted to server time before binding . Reviewing the logfile will show the entered parameter value, allowing you to manually test the `TO_DATE` conversion in your external SQL tool to ensure it matches what the database expects.
You should take the extraction SQL directly from the concurrent logfile and execute it using a standard database development tool like Toad or SQL Developer . This allows you to bypass the EBS concurrent manager environment and receive immediate, detailed Oracle error messages, such as ORA-XXXXX, which facilitates debugging . Ensure you manually substitute the bind variables with the actual parameter values shown in the logfile to replicate the exact runtime query .
This profile option is set to ‘Yes’ by the `install.sh` script. Its purpose is to ensure that Blitz Report is not used during the upgrade.
The message ‘Blitz Report output file creation failed.’ is typically a wrapper for an underlying error encountered during SQL execution . The crucial first step in debugging is to review the report’s concurrent logfile . The logfile captures the exact SQL statement that was attempted, along with the user-entered parameter values and their corresponding bind variables, providing essential clues about syntax issues or data conversion failures .
The worksheets that use the same folder combination are converted into individual Blitz Report templates. If a folder combination was used by only one worksheet, the imported Blitz Report name will be ‘Workbook Name: Sheet Name’.
Reports launched directly from custom forms, such as via the custom icon (e.g., on a `when-button-pressed` trigger), typically utilize a PL/SQL API call that returns a BLOB output, often bypassing the standard concurrent program submission , . If the execution fails, the resulting error message or status is captured by the API wrapper (e.g., `x_return_status` and `x_msg_data` in the `XXEN_API.RUN_REPORT` procedure) and would need to be handled and displayed by the custom form’s error logic , . If you are using the setup procedure provided, the report execution status would appear in the output.
Yes, the ‘Discoverer Folders’ import option is specifically designed for this. It imports distinct folder or view object combinations only, significantly decreasing the number of Blitz Reports you need to maintain.
Yes, rerun the `install.sh` script, and check the log files to ensure the `xxen_webservices` webservice has been deployed successfully.
You use the Block Restriction field in the assignment setup . If you enter the name of the navigation block (e.g., ‘GL_JE_LINES’), the report will only be accessible when the user is positioned within that block . If you leave the Block Restriction field empty, the Blitz Report will be available on *all* blocks of the assigned form, assuming the passed parameter values are identical across blocks .
The source defines the profile as setting the Footer, suggesting it accepts the text you want displayed.
Yes, the maximum column width for Blitz Report XLSX output files is controlled by the profile option ‘Blitz Report XLSX Max Column Width’ . The default maximum column width is 60 .
You must manually change the EBS ISGADMIN password via the System Administrator > Security > User > Define form. First, query and temporarily adjust profile options like ‘Signon Password Hard To Guess’ and ‘Signon Password Length’ for ISGADMIN, update the password to the value retrieved from `fnd_vault.get(‘ISG’,’ISGADMIN’)`, and then revert the profile options.
The documentation specifies that the automatic removal of the prefix/suffix characters (`=”` and `”`) occurs when the report is run in XLSX output format . While CSV format also preserves alphanumeric data, the specific automated cleaning process is noted for the XLSX format . If using CSV, you should verify if the raw CSV output still retains the extra quotes/equals signs.
Once configured successfully, the Blitz Report is accessed from the Oracle standard form through a custom icon . When the user clicks this icon, the report launches with the parameters (such as GL Batch and Journal names) automatically defaulted based on the record they currently have focused on in the EBS form . This enables instant, context-sensitive drilldown.
The default setting is null (no footer).
This typically means the password stored in the FND vault for ISGADMIN is not working correctly in EBS. You can verify this by checking if the query `select fnd_web_sec.validate_login(‘ISGADMIN’,fnd_vault.get(‘ISG’,’ISGADMIN’)) from dual` returns ‘N’.
You must use the Form assignment feature . First, identify the standard form name (e.g., ‘GL Enter Journals’) and the specific block names containing the data items (like Batch Name/Journal Name) by navigating through Help > About Oracle Applications > Current Form . Then, in the Blitz Report setup for the ‘GL Account Analysis’ report, you assign the form name and define the parameter passing logic . You configure the parameter default values to pull values from the specific form item names .
No, if you apply this specific SQL workaround and run the report in the recommended XLSX output format, Blitz Report is designed to automatically remove the redundant prefix (`=”`) and suffix (`”`) characters from the data upon generation . This ensures the content displays correctly as alphanumeric text in Excel .
To prevent Excel’s automatic type detection from treating alphanumeric data with numeric content as a number, you must explicitly format the column output in the SQL to enforce text formatting . The workaround involves prefixing the column data with an equal sign and enclosing it in double quotes . The SQL should look like this: `’=”‘ || cii.serial_number || ‘”‘ serial_number` .
You set the profile option ‘Blitz Report XLSX Sheet Footer’. This defines the footer text in Blitz Report XLSX sheets.
Yes, when included in a list, Parent values automatically include their hierarchies.
By default, if a scheduled Blitz Report retrieves zero rows, the system will suppress the delivery of an empty output file when using Oracle standard concurrent delivery options. If your business requirement dictates that empty files *must* be sent for scheduled reports, you need to change the profile option ‘Blitz Report Suppress Empty File Delivery’ and set its value to ‘No’.
Lists always function as OR conditions (e.g., ‘1110;1210’ returns accounts matching either value).
If you are hosting the ECC schema within your EBS database, both the `EBS_DB_URL` and `ECC_DB_URL` parameters in the `EccConfig.properties` file will point to the same database connection string, for example: `jdbc:oracle:thin:@demo.enginatics.com:1521:EBSDB`. This configuration allows the ‘Database Setup’ step (Option 1 of `envSetup.sh`) to create the dedicated ECC user and schema within the specified EBS database instance. If you encounter a JNDI connection issue later, always re-verify the hostname in these URLs is resolvable from the ECC server.
Exclusions are defined by using a tilde (~) prefix combined with the inclusion format, such as ‘1100-1300;~1200’.
You can specify a secondary location to save a copy of the report output file in the ‘Additional Out. Directory on DB Server’ field under Report Options. This functionality is typically restricted to users with Developer access. The list of available directories is fetched from the `dba_directories` table, and similar to the Output Filename, tokens can be used here to create a dynamic path based on runtime parameter values.
The final output filename that is downloaded to the client desktop is controlled separately in the Report Options section under the field ‘Output Filename’. In this field, you can define a naming convention that utilizes tokens to dynamically generate the name. Useful tokens include “, “, “, and parameterized values like “ or formatted dates using “. If you use the token “, all spaces are automatically replaced with underscores.
Yes, integrating an HTTPS-enabled EBS instance with an HTTP-only ECC instance is supported, provided you follow the configuration guidelines carefully. You need to utilize Doc ID 2496445.1, ‘Enabling TLS for Oracle Enterprise Command Center Framework,’ but specifically configure the EBS parameters for TLS (HTTPS) while keeping the ECC parameters configured for NO TLS (HTTP). However, you must ensure you are comfortable with the traffic between EBS and ECC not being encrypted, which is typically acceptable if the servers are located within a secure, internal network protected by a VPN.
There are four primary accepted formats: Single value (e.g., ‘1110’), Range (inclusive span using hyphen, e.g., ‘1100-1300’), and List (multiple values separated by semicolons, e.g., ‘1500;1510;1590’).
The `:sheet_name` mechanism is managed through the parameter definition itself and does not require injection into the main report SQL like the `n=n` or `&lexical` anchors. The parameter definition identifies the `:sheet_name` anchor, and the corresponding default value you define is used to set the name of the Excel data sheet when the report runs. By default, if this parameter is not used, the Excel output’s data sheet name is simply the same as the report name.
The resource allocation needs careful consideration, as ECC is resource-intensive, especially during concurrent data loads. Since the minimal requirement for a small environment is already 2 cores and 5 GB of memory [Source check: This detail was in the initial response preamble, not the current batch of sources, but referencing performance/resources is valid based on troubleshooting]. You must assign enough CPU and memory to simultaneously support all four running ECC instances, otherwise, startup performance will suffer drastically. Monitoring the swap space usage during startup is particularly important, as relying on swap due to insufficient RAM can significantly slow down the application start process.
To set a custom Excel sheet name dynamically, you must utilize the `:sheet_name` anchor. Although this anchor can be configured as a visible parameter, you can easily hide it by assigning a negative value to its display sequence. To make the sheet name dependent on the ‘Operating Unit’ parameter, you should define a default value using the `:$flex$.parameter_name` token notation. For instance, the default value could be set as `:$flex$.operating_unit||’ suppliers’` to concatenate the selected operating unit value with the word ‘suppliers’ for the sheet name.
Ideally, assigning a separate physical or virtual server for each of your four ECC instances is the best practice for performance and isolation. However, if resource limitations dictate, you *can* set up multiple ECC instances on a single server. If you proceed with this plan, you must ensure that each instance uses separate OS accounts (e.g., `ecctst`, `eccuat`) with different `ECC_BASE` directories for installation. Crucially, you must verify that all four ECC instances use a unique and different set of WebLogic ports on the server, specifically the `ECC_ADMIN_PORT` (default 7775) and `ECC_MANAGED_PORT` (default 7776), to avoid any port conflicts during startup.
For a quick desktop workaround, users can go to Control Panel > Java > Advanced > Security > Mixed code and select ‘Enable – hide warning and run with protections’.
The best solution is to migrate to Java Web Start, as the warning typically appears when using the older Java Plug-in. Alternatively, you can include the custom Blitz Report images (like `xxen_report.gif`) directly within the `fndaol.jar` file by modifying `$FND_TOP/java/make/fndjar.dep` and regenerating product JAR files.
Yes, the root cause is often the custom Blitz Report gif images used for the Forms assignment feature, which trigger the mixed-code warning (Doc ID 1120573.1).
Best practices for tuning Concurrent Managers involve adjusting the queue size, tuning the sleep cycle, and tuning the number of processes. Remember the myth that ‘More Concurrent Managers are better’ is often false; keep it simple and use only a few well-tuned managers.
The report provides the same details as the standard Concurrent Manager administration forms. For tuning purposes, one best practice is to check for a high number of requests. A common script used to identify queues with 20 or more pending requests is detailed in the tuning documentation.
You should use the FND Concurrent Managers report. This report displays the concurrent managers’ setup and current status, showing information like processes running and the number of requests that are running or pending.
That is the required solution. Aligning the DB and application tier character sets resolves this concurrency validation error.
Key parameters include `p_table_name` and, importantly, `p_table_alias` (e.g., ‘msiv’ instead of ‘msib’). The function automatically generates SQL text that uses the DFF’s form left prompt as the column alias, such as `msiv.attribute15 “Invoice UOM”`.
You can verify the database setting using `select vnp.* from v$nls_parameters vnp where vnp.parameter = ‘NLS_CHARACTERSET’`. The application tier setting can sometimes be viewed via Help > About Oracle Applications > Forms Server Environment Variables, or by querying context files using SQL provided in the troubleshooting section.
Yes, you should use the function `XXEN_UTIL.DFF_COLUMNS`. This function returns a SQL text snippet suitable for `&lexical` replacement.
This is generally a sign of a severe setup issue: a character set mismatch between your Oracle Database and your application tier. Oracle’s Globalization Guide requires the APPL_TOP character set to be identical to the database character set.
Yes, you can export previous SQL versions. You would set the `p_type` parameter in `XXEN_API.EXPORT_FILE_DATA` to ‘SQL Versions’ . This functionality is further refined by the optional parameter `p_creation_date`, which can be used to filter SQL versions based on when they were created , .
The provided documentation does not explicitly state that the export API restricts data access based on the ‘Blitz Report Template Access’ profile option . The API is intended for administrative or developer use, suggesting it operates at a privileged level. Template access controls (No Access, Private only, Private and shared, Super User) are typically enforced through the user interface when accessing templates via the run window . You should ensure the user running the export script has the necessary privileges to extract all required data.
When exporting a subset of objects, you use the `p_ids` parameter, which is of type `fnd_table_of_number` . You must populate this collection (`l_ids`) with the unique ID numbers of the templates you wish to export . The `p_ids` parameter is applicable when `p_type` is set to ‘Reports’, ‘Templates’, ‘LOVs’, ‘Assignments’, or ‘SQLs’ .
After completing manual adjustments, you must delete any temporary rows and columns that were added solely for reference or template construction before finalizing the template.
That is correct. You must manually replicate these calculations using the supporting information provided from the Oracle FSG definition.
Yes, the generic API function `XXEN_API.EXPORT_FILE_DATA` is designed to handle various object types beyond just reports . To export all templates, you would set the input parameter `p_type` to the value ‘Templates’ . This function returns a CLOB containing the XML definition of all template objects . Other supported non-report types include ‘LOVs’, ‘Assignments’, ‘Profile Option Values’, and ‘All Contents’ .
They can reference rows either by sequence number (e.g., `Row 37 Column I = 27+22` for rows 22 through 27) or by Row Name (e.g., `Row 49 Column I = OpenM/TExp`).
The calculations defined for the Oracle FSG Row Set need to be done manually within the Excel template.
For flex value sets and rollup groups, refer to the FND Rollup Groups report.
Yes, for the Approved Supplier List setup, you should use the PO Approved Supplier List report.
Use the PO Approval Groups report. This report details PO approval groups and their approval rules, including amount limits or account ranges.
Yes, the inclusion of the user description can be deactivated globally by setting the profile option **‘Blitz Report Show User Description’** to ‘No’.
There are overloaded versions that accept either the `p_user_name` (varchar2) or `p_user_id` (pls_integer) as input parameters.
Yes, the function **`XXEN_UTIL.USER_NAME`** converts a user name or user ID to the full description of the user. For instance, ‘SYSADMIN’ is converted to ‘SYSADMIN (System Administrator)’.
The functions check for differences in time zones between the client and server based on the profile values and perform the conversion accordingly.
Yes, if you only want to export the SQL text, you would use the `XXEN_API.EXPORT_FILE_DATA` function and set the `p_type` parameter to ‘SQLs’ . Alternatively, if you want the history of old SQL texts, you would use ‘SQL Versions’ , optionally filtered by `p_creation_date` .
For the reverse operation, use `XXEN_UTIL.SERVER_TIME(p_date in date)`. This function converts a date from the client timezone back to the server timezone if a difference is detected.
You should use the function `XXEN_UTIL.CLIENT_TIME(p_date in date)`. It takes a date in the server’s timezone and converts it to the client’s local timezone, provided the ‘Server Timezone’ and ‘Client Timezone’ profile options are set.
If the SGA retrieval is unreliable, you can use the seeded Blitz Report called ‘DBA SGA SQL Performance Summary’ . You would run this report, restricting it by the module type ‘Concurrent Request’ and the module name of the specific concurrent program you are interested in, to identify the SQL statements executed by that program . This provides the query text necessary for manual import.
If your extraction SQL exceeds the standard Oracle Forms limit of 32767 characters, you must use the specialized ‘Upload Large SQL’ functionality found under the Tools menu in Blitz Report Setup. This feature opens a browser window where you can select and upload a SQL file, which must be uploaded in UTF-8 encoding if it contains non-ANSI characters. This ensures your comprehensive report logic can be stored and executed correctly, bypassing the Forms character limitation.
You could set the profile to a template like `_` to overwrite the same file with refreshed data every time the scheduled request runs.
Yes, the `&lexical` anchor is perfect for dynamically changing the columns in the `SELECT` list. You can define a parameter that uses the utility function `XXEN_UTIL.DFF_COLUMNS` to retrieve the SQL text corresponding to enabled Descriptive Flexfield columns for a specified table, such as `mtl_system_items_b`. This utility dynamically generates the necessary column aliases (e.g., `msiv.attribute1 “Late Demands Penalty”`) which are then injected into the main report SQL at the position of the `&flexfield_columns` lexical anchor.
For simple filtering like restricting the Ledger Name, the `n=n` anchor is often preferred, assuming your main query includes `where 1=1`. When the user provides a value for the Ledger Name parameter, the parameter’s corresponding SQL text (e.g., `gl.name = :ledger_name`) is inserted in place of or adjacent to the ‘1=1’ anchor at runtime, resulting in clean, parameterized SQL for standard filtering. Using `n=n` for standard `WHERE` clauses is simpler than setting up a lexical anchor.
Yes, tokens include “, which uses the actual run date in the specified Oracle date format string.
Access rights for different functionalities and access profiles are documented in a comprehensive table.
There is a helpful workaround . If you run the target concurrent program (e.g., the Oracle standard report) immediately before executing the Blitz Report import option, the Blitz Report code attempts to retrieve the program’s largest SQL statement directly from the database memory (SGA) . While this is not 100% reliable, it can capture the extraction query, which you can then copy and refine for your Blitz Report definition .
The parameter definition associated with the `&lexical` anchor must contain SQL text that, when executed, returns the precise comma-separated list of quoted period names and their corresponding aliases expected by the `PIVOT` clause. For example, if the parameter logic is designed to derive periods up to a specified month, the resulting SQL text inserted at runtime might look like ` ‘Jan-20’ jan_2020 , ‘Feb-20’ feb_2020 , … , ‘total’ total `. This dynamic substitution is what allows the pivot table structure to change based on the user’s input without altering the core report SQL definition.
Tokens can be used to build a file name template dynamically, for example, based on report parameter values.
Yes, ‘Developer’ access users can run reports of type ‘Protected’.
Yes, the ‘Concurrent Program’ import option is designed specifically for this task . This feature allows you to import the parameter definitions, associated Lists of Values (LOVs), and Request Group assignments from any standard Oracle concurrent program . This significantly simplifies the migration process, especially for technologies like Oracle Reports (.rdf files) where the actual report SQL usually cannot be imported automatically .
For dynamically changing the structure of your SQL query, such as generating columns for a pivot table, you must use the `&lexical` anchor. This type of anchor is highly versatile because it allows you to inject arbitrary SQL snippets, including dynamic tables, columns, `ORDER BY` clauses, or even complete subselects, which goes far beyond simple `WHERE` clause restrictions. In your specific case involving pivoting, the lexical anchor, such as `&gl_period_pivot`, would be placed inside the `PIVOT` clause of your main report SQL.
Developers typically have their access profile set to ‘Developer’ on user level.
You can use the WIP Required Components report. It is a detailed project WIP report that lists discrete jobs and required components, and you can enable a ‘Show Shortage List’ parameter.
You define the naming convention using the profile option ‘Blitz Report Additional Output Filename’. This applies to files written to a directory on the DB or APPS server if the corresponding directory profile is set.
Yes, the INV Item Demand History report is the imported BI Publisher equivalent of the standard Item Demand History report (Short Name: INVPRFDH_XML).
No. Reports of type ‘Protected’ or ‘System’ are visible to Developer access users, but they may only be edited by users with their access profile set to ‘System’.
The JNLP files should generally be deleted automatically by the system . You can refer to Section 6: Browser User Experience and Configuration in Oracle Support Document 2188898.1 for details on how the browser experience and configuration should handle these temporary files .
Yes, Blitz FSG supports drilling down from multiple selected balances simultaneously . You select the desired cell range containing the balances and then choose the Next Level Drilldown option (e.g., Journal or Subledger) from the ribbon . Similarly, on the Balance/Journal Drilldown sheet, you can select multiple rows, right-click, and choose the next-level drilldown option .
When running `adadmin` after applying the JWS patches, you must explicitly choose to force regeneration of all JAR files . When the system prompts ‘Do you wish to force regeneration of all jar files? [No]’, you must answer ‘Yes’ to ensure a complete and successful migration . After regeneration, the entire `adop` cycle (actualize_all, finalize, cutover, cleanup) must be completed .
The four main drilldown levels whose underlying Blitz Reports are managed by dedicated profiles are : 1) GL Journal (Profile: `Blitz FSG Drilldown Report GJ`), 2) GL Full Journal (Profile: `Blitz FSG Drilldown Report GFJ`), 3) GL Journal Attachment (Profile: `Blitz FSG Drilldown Report GJA`), and 4) Subledger Details (Profile: `Blitz FSG Drilldown Report SD`) .
The INV Item Supply/Demand report provides Inventory Item Supply/Demand data exactly as per the standard Inventory Item Supply/Demand form.
The specific Blitz Report used for each drilldown level is linked via system profile options . For instance, the profile option ‘Blitz FSG Drilldown Report GJ’ specifies the report used for the GL Journal drilldown level . An administrator must update these profiles to reference your custom Blitz Report name, ensuring the FSG tool calls your report instead of the default .
Oracle certifies JWS with specific JRE releases . You should refer to Doc ID 2188898.1 to find the minimum JRE release required on the client tier . It is recommended to install the latest certified JRE version, such as JRE 8 Update 211 mentioned in the migration context, to ensure compatibility and access to the newest features like multiple Forms session support .
Yes, the drilldown data (for levels like GL Journal and GL Account Analysis) is extracted using specific underlying Blitz Reports . These reports have templates that define the displayed columns, their sequence, and sorting order . Users can create custom templates for these drilldown reports to add, remove, sort, or reorder the columns as required . You access this customization via the Layout Options feature in Blitz FSG .
The inability to run multiple Forms sessions after migrating to JWS is a known issue that requires specific patches and configuration settings . To enable Multiple Forms Session Support using Java Web Start, you must consult Oracle Support Document 2188898.1 , . This document outlines the exact required patches (e.g., `29024389:R12.FWK.C`) and necessary user preference settings that must be implemented , .
This profile only controls visibility in the Run window; template creation rights are governed by the ‘Blitz Report Template Access’ profile option.
After importing the zipped EEX file, you must run ‘Blitz Report Discoverer Import’ and then verify the migration result by running reports including ‘Blitz Report LOV SQL Validation’ to correct errors and change slow SQLs.
The default setting is ‘No’, which only shows templates specifically for the currently selected report, minimizing user confusion.
Run the Blitz Report Parameter Custom LOV Duplication Validation report. It identifies parameters using custom LOVs that share identical queries, prompting you to consolidate them into shared LOVs.
You can use the profile option ‘Blitz Report Show All Templates’. Set this profile to ‘Yes’ to display all templates for all reports in the LOV.
You can take the SQL_ID and immediately run the DBA SGA SQL Execution Plan History report, entering the SQL_ID to see the execution plan currently loaded in the SGA.
The dedicated Blitz Report LOV SQL Validation report is essential here. It validates LOV SQLs for valid syntax, helping flag issues that prevent efficient execution. Also look for slow ‘distinct’ style queries that need conversion.
Enginatics in Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 I am happy to hear that your installation and configuration were successful. Feel free to leverage the extensive features of Blitz Report for ongoing ECC administration and reporting needs.
While the automatic refresh is running, the request status is displayed on the output button. Once the report is complete, the button can be used to re-download the file.
No, only ‘Developer’ and ‘System’ users can edit licensing information.
Enginatics in Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 Yes, Blitz Report allows you to develop EBS reports using the Oracle Enterprise Command Center SQLs directly, often in under five minutes. This facilitates the export of enriched dashboard data to Excel for deeper analysis or archival.
You can use the parameter ‘Scheduled or Running’ within the FND Concurrent Requests report to specifically filter for all currently scheduled or active requests.
Enginatics in Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 The quickest diagnostic method is to use a customized Blitz Report to verify patch application status. Your DBA team can run an instantaneous check using the AD_PATCH.IS_PATCH_APPLIED function directly from EBS, bypassing SQL*Plus access latency.
They have view only access to report SQL and setup, meaning they cannot create or modify reports, uploads, or system/protected reports.
The default refresh interval is 1 second. If you set the value to zero, no automatic refresh is done.
Use the FND Concurrent Requests report. For performance analysis of running requests, this report provides the Session ID (SID), the currently executed SQL_ID and SQL text, and the distribution of wait time across different wait classes.
User Admins can create or modify report assignments.
Enginatics in Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 That specific `400 Bad Request` error is commonly linked to missing security grants or functional exclusions for the ECC dashboards. You should check the corresponding MOS document, Error 400 Bad Request ‘No function from’ Is Appearing For Procurement ECC Dashboard (Doc ID 2660547.1), to ensure the responsibility ID has the necessary permissions and functions assigned.
The ‘User Admin’ profile allows the user to access and run all reports in the system, regardless of report assignments.
You control this using the profile option ‘Blitz Report Output Button Refresh Interval’. This sets the refresh interval in seconds.
Enginatics in Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 While basic integration steps like running autoconfig confirm profile option values and OHS configuration , the `patchEccFiles.pl` script runs post-database object application. The issue suggests a preceding database patch application failure or an environmental setup issue that prevented the necessary PL/SQL packages from compiling correctly in the APPS schema.
Template visibility is controlled by the ‘Blitz Report Show All Templates’ profile, which is separate from creation/modification rights.
Enginatics in Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 The `ORA-00904` error during `patchEccFiles.pl` execution, particularly referencing `FND_ECC_UTIL_MLS_PVT.CONVERTORALANGCODETOBCP47`, indicates that necessary database objects or prerequisite code (often related to multilingual support or base ECC objects) are either missing or invalid. This typically points to an issue where core ECC or required FND patches have not been fully or correctly applied, compiled, or loaded into the database.
‘Private only’ users can only create private templates, restricting their ability to create shared templates.
We recommend using slashes (‘/’) as date separators. Additionally, format the dates as text in Excel to prevent regional settings from causing automatic format conversion issues that could reintroduce hyphens.
The highest level is ‘Super User’, which allows the user to modify templates owned by others.
The hyphen (‘-‘) is internally reserved by Blitz FSG as the range delimiter. Using it as a date separator would lead to incorrect parsing of the date range.
Template modification rights are controlled by the ‘Blitz Report Template Access’ profile. If set to ‘No Access’, the user can view and use, but not create templates.
Yes, date formatting is critical for JED balance types, which accept date ranges (e.g., ’01/01/2007-05/01/2007′). You must avoid using the hyphen (‘-‘) as a date separator.
Yes, the Period Name input must exactly match the format configured in Oracle, regardless of the offset or range parameters.
Hi,
This means that someone ran the VPD policy creation program for Blitz Report in your environment.
Could you find out who ran it and for which purpose?
If you keep your concurrent request history in an archive table somewhere, you could query it for the concurrent program ‘Blitz Report Update VPD Policies’.
Or you could check if someone has updated the example records in lookup type XXEN_REPORT_VPD_POLICY_TABLES via report FND Lookup Values.
In case this was done by mistake, we can easily remove the Blitz Report policies by running the program ‘Blitz Report Remove VPD Policies’.
Regards,
Andy
Hi,
The email to Sharepoint is an option, but has the email server attachment file size limitation.
Alternatively, there seem to be third party synchronization tools (https://rclone.org/) available, which can synchronize linux folder content with a sharepoint folder.
This would allow using the additional output file options to send report output to the file system and synchronize it from there to sharepoint.
Our colleague Alex has done research on this in the past, but from what I remember, he had security concerns using third party tools like this.
Regards,
Andy
If the base period is Mar-08 with an offset of -2, the function would return ‘Jan-08-Mar-08’.
Hi,
This could happen if you have a custom database policy created on that table column.
Maybe someone has used the Blitz Report VPD feature to prevent users from seeing the national identifier data?
In that case, you can use the profile option ‘Blitz Report VPD Policy Rule’ to individually grant access to that data through Blitz Report.
Can you please run the following query and let us know the results:
select dp.* from dba_policies dp where dp.object_name=’PER_ALL_PEOPLE_F’
Thanks and regards,
Andy
That is correct. It points to a known database issue (described in Oracle note 2031953.1 and 1586704.1) affecting CTXSYS synchronization.
Hi,
There is only one value for the Operating Unit in your current responsibility, so that the LOV would not open and the cursor navigates to the next record, which is the customer name, and then incorrectly shows that LOV instead.
I could just reproduce this in our environments as follows:
1. Try to open the LOV of the Operating Unit if there is only one value in the LOV: Nothing happens as expected
2. Try to open the LOV again: Now the LOV of the next parameter (Customer Name in this case) incorrectly opens.
We will see how we can prevent this from happening and let you know when we have a fix.
Regards,
Andy
Hi,
Please find attached the Blitz Report definition XML zipped file for the Blitz implementation of the Standard Oracle Periodic Inventory Value Report.
You can import this from the Blitz Report Setup form using the Tools – Import menu option and selecting XML Upload as the upload type.
In regards to making the Cost Group parameter multiple values enabled, the following changes were made:
1. Cost Group Parameter
This was changed from a bind parameter to a lexical parameter. With it being made a lexical parameter, multiple values is then enabled for the parameter
So as not to impact the :p_cost_group_id parameter used in the before report trigger of the standard Oracle Package (to select the cost group name from the specified parameter) the bind variable used in the lexical was change to :p_cost_group_id2
2. Since the standard Oracle Package before report trigger will error if the :p_cost_group_id bind is not populated, a new dummy hidden parameter has been created using the :p_cost_group_id bind as the anchor.
This will default from the visible Cost Group parameter. In the event multiple cost groups are selected in the Cost Group parameter, the hidden parameter will default to one of the selected cost groups:
select
ccg.cost_group_id
from
cst_cost_groups ccg
where
xxen_util.contains(:$flex$.cost_group,ccg.cost_group_id) = ‘Y’ and
rownum <= 1
This is only used in the Oracle package beforereport trigger to get the cost group name, which is not used in the Blitz Report, the value passed is not significant. The Blitz Report query has been modified to retrieve the cost group instead.
3. Category Organization parameter which was dependent on the Cost Group parameter.
The LOV for this parameter has been changed from an Oracle LOV to a custom LOV and the LOV query modified to change the where clause:
from
and ccg.cost_group_id = :$flex$.CST_SRS_PAC_COST_GROUP
to
and xxen_util.contains(:$flex$.cost_group,ccg.cost_group_id)=’Y’
this takes account of the fact the Cost Group parameter may have multiple values
Other Changes made to the report:
1. The Report Option (Summary/Detail) parameter has been hidden.
The report will always run in detail mode and the use can now select the output content through the available Detail or Summary Templates:
2. When run in detail mode, the header level cost and value columns are included against the first row for each item only. They are not repeated against each detail row. This will allow users to build pivots on the dataset without any aggregations against the header level costs/values being overstated which they would be if they are repeated on each line in the report.
I have only been able to do limited testing of the report due to the fact that we do not have much available data in our demo instance. I have verified the report reconciles to the standard oracle report. But I have not been able to any volume testing to verify the performance is ok etc.
Please review and let me know if this satisfies your requirements.
Kind Regards,
Eric
Hi,
I have added the Item Catalog column to the upload.
The upload will allow you to specify an Item Catalog
– to new Items in the Master Organization
– to existing Items in the Master Organization if a catalog has not yet been assigned
You cannot remove or change an existing item catalog assignment from an existing item using the upload.
In order to obtain this enhancement, it will be necessary to reinstall the latest Blitz Report installation file available from the Enginatics Website.
Kind Regards,
Eric
Hi
I searched the Web to check if the situation improved.
But it seems to be the same and exactly like Andy described: it is required to use a 3rd party tool like rclone to mount a Sharepoint Online folder to Linux.
It may be a security concern.
Also we do not have a customer using rclone that has shared the feedback with us.
So I can not tell how reliable this tool is.
Thank you,
Alex
Hi,
Thanks for the confirmation.
That’s good to hear that it works as expected :-)
Regards,
Andy
Hi,
This means that after the patch application, we would need to re-run the Blitz Report installation script, as it would need to recompile the compatible package version with the Blitz Report additions.
We hope that we will get a custom hook as an enhancement from Oracle at some point in the future, but for now, we have this dependency on certain patch activities.
Regards,
Andy
Hi,
We have the Blitz Report PO Purchase Requisitions with PO Details which may be helpful.
Kind Regards,
Eric
Hi,
We will analyze this and get back to you.
Regards,
Andy
Yes, the API includes `x_report_id` and `x_message` output parameters to confirm the result of the import.
Hi,
Yes, we have exactly this, the ability for users to add formula columns to the end (or maybe even allowing to add them in between) of the data sheet in Excel, on our todo list.
We will add it at some point, but didn’t find the time to complete it yet.
Regards,
Andy
Hi,
Adding to Mrugesh’s comment about the Error (Account(3)) message:
This appeared so far in two scenarios:
1. The account segment value passed to the function is invalid as there is no matching flex value found
2. The passed account segment value is set up as a parent, but it does not have any child account values (either no child ranges are defined or no accounts are matching the defined ranges)
As we saw that customers often have flex values incorrectly set up as parents without defining any ranges, we are changing our code now to ignore such cases, or to show a more descriptive message.
Regards,
Andy
Hi,
We have seen this occasionally, in case the Compile Security did not synchronize the Blitz Report menu entry into the table fnd_compiled_menu_functions.
Please execute the following query:
select
fme.menu_id
from
fnd_form_functions fff,
fnd_menu_entries fme
where
fff.function_name=’XXEN_REPORTS’ and
fff.function_id=fme.function_id and
(fme.function_id, fme.menu_id) not in (select fcmf.function_id, fcmf.menu_id from fnd_compiled_menu_functions fcmf where fcmf.grant_flag=’Y’);
If it returns any records, please run the Compile Security concurrent program from the System Administrator responsibility and let us know if it resolves the issue.
If the Compile Security does not resolve it, please send us the output of the Blitz Report Assignments report, and let’s schedule a call to investigate.
Regards,
Andy
Hello,
The reported issue where the Pivot was not enabled and the charts did not display anything has been fixed. The issue was reported for INV Onhand Quantities and BOM Routings.
Can you please get the latest version of Blitz Report downloaded and arrange for an upgrade in your environment.
Thanks & Regards,
Mrugesh
Hi,
Can you please download and import the latest version of the report from the Enginaticss Library (AR Customers and Sites). I have checked this and the parameters are correct.
Kind Regards,
Eric
Hi,
I am currently looking at this and will provide you with a Blitz version of the standard report tomorrow and will also highlight the changes I have made in regards to allowing multiple values for the Cost Group ID parameter.
Kind Regards,
Eric
Hi,
We recently made some fixes to this report INV Material Transactions that should resolve the issue. Additionally, we introduced a new function, xxen_util.item_category_columns, which is used in the category set parameters of the report. This means that simply importing the report XML from our website won’t be enough. To ensure you have the latest version of the xxen_util package, including the item_category_columns function, you’ll need to either upgrade to the latest Blitz Report code version or download and compile the new package version separately using this link.
If you choose the second option (compiling the package version separately), you can then download and import the XML using this link: INV Material Transactions
Thanks and Kind Regards,
Piyush
Hi,
This has been done. Please download and install the latest report definition here: AR Transactions and Lines
Kind Regards,
Eric
Hi,
I compared the sql with our latest code version and there were significant changes meanwhile.
I would assume that this was a bug in the older version that you have currently in prod, and we should have it resolved meanwhile.
Would it be possible to upgrade and retest?
And the invoices were created successfully btw., as the loading concurrent program (program name: Blitz Upload) completed successfully, and the problem happened only in the blitz report that shows the result of the load at the end.
Regards,
Andy
Hi @Andy, correct me if I am wrong or missing something.
Does Sharepoint just operate like another folder on your laptop like Microsoft One Drive or Google Drive? The Blitz Reports are downloaded to whatever you have defined as the download folder in your browser settings. So you could change this to the Sharepoint Folder, but this would apply to all downloads from the browser. Alternatively you change the browser settings to choose the folder at the time of each download.
If you have Sharepoint mapped as a directory on your Application Server, then it would be possible to specify this directory as an alternative location for specific Blitz Reports.
Kind Regards,
Eric
Hello,
This data is available in the report already.
I see you are using a custom excel based template (Tax Register pro month) which does not have the requested data, and I also notice you run the report with ‘Column Translations’ switched off.
I have created a new Blitz Report Template called Tax Register pro month V2 which is a copy of the excel you have sent me with these additional columns included (in the source data worksheet). I have not amended your pivot table at all.
BILLING_TP_NUMBER
BILLING_TP_TAXPAYER_ID
BILLING_TP_COUNTRY
SHIPPING_TP_NAME
SHIPPING_TP_NUMBER
SHIPPING_TP_TAX_REG_NUM
SHIPPING_TP_TAXPAYER_ID
SHIPPING_TP_COUNTRY
Please import the attached amended report definition XML and review. If you are happy with the template then you can delete your original template and rename this template the same as the original.
This involved a change to the report template only – to make data already available in the report visible in the template. This is something you or your user who created the template can also do, and I have attached a pdf illustrating the steps I went through to make this change.
Kind Regards,
Support
Hi,
These errors can be ignored if the report works correctly when running it separately.
The reason for the errors is that these reports use &lexical parameters to compose dynamic SQL, and the value for these lexicals depend on parameter values, which would be entered by the user at runtime.
When the Blitz Report SQL Validation report runs however, it cannot correctly replace these lexicals, as it doesn’t have the user entered parameter values, for example:
Regards,
Andy
Hi,
To access the upload button, you would either need to have an assignment for the upload, or alternatively have the Blitz Report Access profile option set to the highest value ‘System’:
https://www.enginatics.com/blitz-report-developer-guide/#security-and-user-profiles
Let me know if you get it working.
Thanks and regards,
Andy
Hi,
We could add the results row count in the parameters tab, and we have included this in our list of enhancements. However, since this can already be achieved using the template features, it is a lower priority at the moment. I’ll aim to have this included within the next month.
Regarding the second requirement, we discussed it, and we don’t believe adding “the last modified date of the Blitz program/SQL” would be a widely applicable use case across companies. There are several other ways to address this, including:
1. Scheduling and emailing the report output.
2. Utilizing the version history maintained in all reports.
3. Our “Blitz Reports” already has a “Last SQL Update Date” column to provide this information.
4. The SQL shown in the parameter tab can also be compared with earlier reports to determine if it has been updated.
Thanks & Regards,
Mrugesh
If you reach 55 users, the 56th one would see a ‘license exceeded’ message instead of the data in the generated excel file.
To check which users are currently active, you can double click on the active user count, or you can run the Blitz Report License Users report.
Regards,
Andy
Hi,
We have meanwhile corrected our upgrade script to include corrections of parameter values for scheduled blitz reports if required due to LOV changes from display value to id as we had here.
In case you did not upgrade your production environment yet, you could download the latest installation file and it should no longer cause this problem.
Regards,
Andy
Hi,
It seems we only exposed the Country of Origin in the Item Details Tab and not in the Items Tab Grid:
But please see the attached document which outlines the 2 steps required to add it as a custom column to the Items Grid.
Kind Regards,
Eric
Hi,
Do you mean sending just one single email with one report attached to a dynamically derived distribution list of emails?
Or do you mean sending individual emails with different report output files to individual email addresses?
The latter functionality is called ‘bursting’ in Oracle standard, and we do not have it implemented in our standard solution yet, but it could be accomplished with a custom concurrent program using the Blitz Report concurrent program API to submit one report for every email to be sent.
We had the bursting functionality request a few times from customers already, which is why we have it on our near future enhancement list.
Regards,
Andy
You must set the Return Range parameter to ‘Yes’. This formats the result as a period range spanning from the offset period to the base period.
Hi,
For the Upload functionality, you would either require the Blitz Report Access profile option to be set to the highest level ‘System’, or if you are a User, you would need to have an assignment for the specific Upload that you would like to use.
Let me know if it works for you..
Thanks and regards,
Andy
Hi,
Thanks for spotting this.
This was caused by a change from display to id values, which we did to better support customers with multiple language requirements.
We missed the update of scheduled request parameters and will add that to our upgrade script.
Regards,
Andy
Thanks for this idea. We have enhancements like this already on our list, including exporting the file and preparing the data by one user and responsibility, and loading it by someone else.
Some of the uploads and updates however, currently rely on internal hidden id columns, which is why we currently have these restrictions, and we will need to think a little more about how we make this more flexible.
Regards,
Andy
Hi,
Thank you for reporting it.
I will enhance the installation script to avoid this error in the future.
The fix you did was correct.
But I have also noticed that the Integrated SOA Gateway (ISG) is not configured in your instance.
ISG is required for Blitz Upload and Financial statements with drilldown features.
Those features are already covered by your Blitz license.
Please let me know if you want to configure ISG to use all the Blitz toolkits?
Thank you,
Alex
Hi,
This error indicates that the value provided to the balance function parameter ‘Account’ (Segment 3) either doesn’t exist or is incorrectly configured for the selected ledger.
We are currently in the process of developing a comprehensive user guide, which is not yet published. In the meantime, I would be happy to schedule a call with you to walk you through the functionalities and address any specific issues you are encountering.
Thanks & Regards,
Mrugesh
Yes, these two errors are related to an issue with incorrect context index (CTXSYS) synchronization code within your database version. Both problems are resolved by applying the instructions detailed in Oracle note 1586704.1.
Hi,
For performance reasons, the dependent columns are automatically populated only when you modify a single cell. However, in case you paste multiple records, you can click on the Autofill button in the Blitz Upload ribbon after pasting the records which should populate the dependencies.
Thanks & Regards,
Ashish
Hi,
It looks like we are missing the ledger relationships in the GL Account Analysis report LOVs.
We need some more time to analyze this and let you know when we have a solution.
Regards,
Andy
Hi,
Please take the updated CUSTOM.pll.
Copy it to the apps server, replace **** to the APPS password and recompile using the following command:
export FORMS_PATH=$AU_TOP/$APPLFRM/US:$FORMS_PATH
frmcmp_batch.sh module=$AU_TOP/resource/CUSTOM.pll userid=APPS/****** output_file=$AU_TOP/resource/CUSTOM.plx module_type=library compile_all=yes
Thank you,
Alex
Correct. You specify the `p_application_short_name` and `p_concurrent_program_name`. There are example scripts like `mass_import_excel4apps_reports.sql` available for scripted mass migration.
Hi,
Regarding the double quotes: Excel standard only adds these if they are required due to special characters in the data, such as comma or upper quotes. This is also the approach that Blitz Report uses. Here is an example:
And regarding the second filename question:
You (currently) cannot use a dynamic SQL function for the output filename, but you could use a workaround using a dependent hidden parameter having a dynamic default value like this:
Would this work for your requirement?
Regards,
Andy
The DBA toolkit specifically focuses on Database Health and Tuning reports, which include the comprehensive suite of AWR and Foundation (FND) reports.
Hi,
As we found out yesterday, the Period Name LOV was blank, as you did not have a connection when re-opening the Excel from your file system.
We are also investigating how we could integrate with SSO solutions to provide an automated log-in, but this will take more time.
See you soon in Las Vegas!
Andy
Hi,
The default email subject is stored in FND message XXEN_REPORT_EMAIL_SUBJECT, and you can create your own custom messages and change the default via profile option ‘Blitz Report Email Subject Message’.If you would only like to change the subject for individually scheduled reports, you can edit the subject message via the Oracle standard delivery options screen.
Let me know if this works for you.
Thanks and regards,
Andy
Hi
Yes, it’s correct.
Regards,
Alex
Oracle E-Business Suite reporting straight into Excel: 2,900+ ready-made reports, your own SQL, 150+ Excel uploads.