Support
Discussion Replies Created
This is primarily governed by the underlying Oracle security model. By implementing VPD policies, you ensure that even if a user is given access to the report definition, the database dynamically adds a predicate to the executed SQL, restricting the resulting rows to only what is authorized for that user’s security context.
The application of the security policy occurs at the database dictionary level. When a user executes the Blitz Report query, the database dynamically rewrites the query or applies a function to the sensitive column. Because this security is enforced at the earliest stage of data retrieval, the policy is respected automatically, ensuring the unauthorized user receives masked data.
`Mod_plsql` is a module included in the EBS 12.2 Apache web server, used for developing web applications with server PL/SQL. Enabling it involves taking specific steps to configure the web server component to define the Document Access Descriptors (DADs) and necessary security settings, integrating the PL/SQL gateway into the EBS technology stack.
This automated menu entry hiding is done through the CUSTOM.pll. It occurs when a user does not have a value for the ‘Blitz Report Access’ profile option.
Yes, Blitz Report helps with Simplifying DBA tasks. You can utilize the Database Health and Tuning reports, including updated AWR reports that function even in multitenant environments, to diagnose performance issues related to the ECC data load or concurrent processes triggered by ECC indexing.
Blitz Report fully supports the use of standard Oracle Virtual Private Database (VPD) policies at both the row and column level. Column-level security is often implemented using a masking function or a mechanism that ensures the sensitive column returns a null or masked value for unauthorized users, even when queried via SQL.
You can use the function **`XXEN_API.import_xml(p_xml in clob)`**. This function takes the report XML data as a CLOB input.
Configuration-based security, managed through Blitz Report definitions, complements the foundational security provided by Oracle VPD. VPD provides the ultimate row and column-level security enforced at the database level. Configuration allows you to control which responsibilities or users can even view or attempt to run reports containing that data in the first place.
The most efficient technical verification method involves using a customized Blitz Report that queries the status of patches using the database function AD_PATCH.IS_PATCH_APPLIED. This allows for a fast, centralized check of critical patches without having to navigate multiple tools.
Yes. While report assignment relies on standard Oracle Responsibilities , the capability to restrict sensitive data access is integrated. Sensitive data, such as Human Resources information, can be secured by configuration within the Blitz Report environment itself.
ECC upgrades, like the transition to V5, require careful application of numerous prerequisite patches. You must ensure all necessary ECC patches for the framework and applicable ECC module patches (Financials, Projects, SCM, etc.) are applied correctly and verify their status before proceeding.
The default derivation is the Email address from the user or, if not set, from the employee record.
Yes, you can specify a name along with the email address by putting the name first and providing the email address inside angle brackets. Example: `Enginatics GmbH `.
It is necessary because some email servers only allow sending from certain authorized email accounts.
You use the profile option ‘Blitz Report From Email Address’. This allows specifying the email address that Blitz Report emails are sent from.
Your DBA must increase the SGA memory allocation. After increasing the memory, you should rerun the installation script. Note that if you are on a test system and do not require the automated column translations feature immediately, this specific error *can* be ignored, but it points to an overall resource constraint.
No, user autonomy is maintained. A business user utilizing Blitz Report can add, reposition, or remove report columns with just a few clicks using the folder style template functionality. This significantly reduces dependence on IT for basic layout adjustments and contributes to faster user adoption since the UI matches EBS Forms.
Yes, in Edge and other browsers, enabled browser extensions can sometimes interfere with the download process and should be temporarily disabled for retesting if the primary fix doesn’t work.
The system streamlines IT management dramatically. All migrated report definitions reside in a version-tracked Blitz Report table. Critically, there are no new concurrent programs to register per report, reducing administrative overhead for the IT teams. The installation itself typically takes only about 20 minutes.
No, this error means your database’s SGA (Shared Global Area), specifically the large pool, is configured too small to handle the resource demands of the initial column translation load. The installation process requires sufficient memory for this operation.
This specific behavior in the Edge browser indicates a conflict with how it handles opening Office files. To resolve this, you must navigate to Edge Settings > Downloads and turn off the option ‘Open Office files in the browser’.
Yes, if you upgrade command centers, you should run the script `mass_delete_ecc_reports.sql` to remove all previously imported ECC Blitz Reports before re-importing Oracle’s latest dataset queries.
Yes, proper due diligence is essential. You should first run Discoverer analysis reports to determine which reports require migration. For the mass import utility, you can adjust the suggested mass import script using a parameter, such as modifying the ‘number of historical days’ to ensure you only import reports that were actively run, say, in the past 6 months.
The required input parameter is `p_dataset_key` (varchar2), which identifies the ECC dataset you wish to import.
Blitz Report is designed as a direct Discoverer replacement, and we offer mechanisms for both individual report imports and high-volume migration. The recommended approach involves using the mass import API utility. This utility is designed to handle large-scale worksheet migration efficiently.
Yes, you can use the API procedure **`xxen_api.import_ecc_dataset`** to programmatically import ECC dataset queries.
Precisely. Blitz Report simplifies DBA tasks. Our reports, including the updated AWR ones, are integrated directly into the EBS Forms interface. This means your DBA team uses a familiar environment to run these powerful Diagnostic Pack reports immediately, without relying on external tools or complex SQL*Plus maneuvers, keeping them organized and efficient.
In the DBA AWR SQL Performance Summary report, examine the ‘Concurrency Wait Time’ column, which totals the elapsed time from wait event class ‘Concurrency’ like ‘buffer busy waits’.
No, this Blitz Report has been extended to pull in additional data points, similar to what is displayed in the Project Status Inquiry Form.
The underlying challenge was the architectural change in AWR data storage itself. The updated reports ensure accurate data retrieval for solving performance issues in your multitenant databases. These specialized reports function by streamlining the diagnostic process, regardless of whether the performance metrics reside at the CDB level or within an individual PDB.
The Linux command is for non-interactive deployments, while the PLSQL function is used when you need to embed the import logic within existing PLSQL code or stored procedures.
Yes, use the DBA AWR Latch by Time report. Each row in this report shows the system-wide latch contention wait time per latch name for one AWR snapshot interval, allowing you to identify high contention periods at specific times.
Yes, the ‘Report Level’ parameter determines this. Setting it to ‘Project’ accumulates data at the project level, while ‘Task’ accumulates data at the task level.
Yes, this technique is used with the &lexical anchor, as that anchor type completely replaces the placeholder with the parameter SQL text at run-time.
The command requires the APPS password and the name of the XML file: `$XXEN_TOP/bin/import_xml $APPS_PWD blitz_report_filename.xml`.
You should use the DBA AWR Latch Summary report. This report provides a summary of latch statistics, including misses and wait times, for a specified AWR snapshot interval.
The PA Revenue, Cost, Budgets by Work Breakdown Structure report implements the standard Oracle ‘MGT: Revenue, Cost, Budgets by Work Breakdown Structure (XML)’ report (Short Name: PAXBUBSS_XML).
Yes, we recognize that the introduction of container databases (CDB) significantly changed the way Automatic Workload Repository (AWR) data is stored and accessed. Our team explicitly made adjustments to the Diagnostic Pack reports to account for these changes and address various issues encountered in multitenant environments.
The primary benefit is enabling you to purposefully enforce reparsing for different parameter values, which can be useful for advanced dynamic SQL features.
Yes, you can use the Linux command line utility located at **`$XXEN_TOP/bin/import_xml`**.
If you require the parameter value to show up as lexical text in the SQL, you must use the specific placeholder in the Parameter SQL text field.
The profile option ‘Blitz Report VPD Policy Rule’ can be used for tracking or potentially setting up access related to sensitive data protected through Blitz Report VPD policies . However, the documentation does not detail the exact reporting mechanisms available within Blitz Report itself to display the active VPD policy SQL applied to a user’s session .
The definition of which tables/columns are subject to VPD is managed within the Blitz Report lookup `XXEN_REPORT_VPD_POLICY_TABLES` . The activation of the policy is handled through a corresponding concurrent program, likely named ‘Blitz Report Update VPD Policies’ (based on context), which leverages the lookup configuration to apply the underlying database policy definitions . The complexity of the actual policy logic may still involve DBA input.
The key limitation is that using the Blitz Report method to secure data with VPD only enforces restrictions when data is accessed through the Blitz Report concurrent program itself . It explicitly does not secure data access if users try to run direct queries using database access tools like SQL Developer or Toad . This is crucial for managing security expectations.
For a detail extract, select the ‘Cash In Transit Detail’ template under the CE Cash in Transit report.
Use the CE Cleared Transactions report. This report offers equivalent functionality to the standard ‘Cleared Transactions Report’ (CEXCLEAR), with pivot summaries available for transactions and batches.
To implement VPD with Blitz Report, you must first define which tables or columns need securing . You configure this via the lookup `XXEN_REPORT_VPD_POLICY_TABLES` . Navigate to Application Developer > Application > Lookups > Application Object Library, query the lookup, and define an entry for each table or column, specifying the owner, table name, and the column name if needed . After setup, you typically run a concurrent program to activate the underlying database policies.
The CE Cash in Transit report provides equivalent functionality to the Oracle standard ‘Cash in Transit’ form and report (CEXCSHTR). It includes templates like ‘Pivot: Cash in Transit’ summarizing by Bank Account, In Transit Type, Operating Unit, and Third Party (Supplier/Customer).
For complete value discovery, you should use ‘Discover Down All’ (vertical) or ‘Discover Right All’ (horizontal).
There are two main options: you can either pre-format the Excel cells as Text (via Number Format > Text), or you can prefix the segment values with an apostrophe (e.g., enter ‘001).
Discovery requires that all segment values be in text format to preserve their formatting. If not formatted as text, Excel automatically converts them to numbers, resulting in the loss of leading zeros, which causes the discovery to fail.
All report SQL scripts are centrally housed with full version control. This is essential for maintaining data governance over financial report definitions.
Yes, runtime options generally inherit their default values from the setup window options, which themselves inherit from profile options.
If the user has not set a default template, the `XXEN_API.DEFAULT_TEMPLATE_` function should handle null or missing values gracefully, potentially returning a system default or null. Alternatively, you could hardcode a generic template name in the `XXEN_API.SET_RUNTIME_OPTION` call to ensure a template is always used, as shown in the example comment lines .
It allows offloading queries by running Blitz Reports on a standby database.
The apps owner must have the required permissions for directory creation, as the directory will be created if it does not exist.
The Excel output file is automatically opened with necessary filters applied. This saves the EBS user time and ensures immediate, actionable analysis upon extraction.
For running reports on a standby database, the `xxen_adg` database link needs to be created in the primary database APPS schema, pointing to the standby pluggable database.
Yes, our tool guarantees no volume limitations on the output. This capability is crucial for financial analysis with pivot tables, ensuring you can pull millions of transactional details without hitting the obsolete 65,536 row constraint faced by older Oracle tools.
Yes, the synchronous API call supports dynamic template selection . You can call `XXEN_API.DEFAULT_TEMPLATE_` within the `XXEN_API.SET_RUNTIME_OPTION` procedure to automatically retrieve and use the user’s default template (if one is defined) for the specified report . This ensures the output uses the user’s preferred layout .
That is the required resolution. Once the DB and application tier use the same character set, the problem should cease, as outlined in Oracle’s Globalization Guide.
The value must be a TNS descriptor. You must specify a TNS descriptor defined in `$TNS_ADMIN/tnsnames.ora` on the application server.
When dealing with hierarchies, Blitz Report aids by allowing you to define the required aggregation level upfront, for instance, utilizing the Parent Total (PT) option in the report parameters. The resulting flat file for the pivot table will contain the necessary descriptive segments and data elements, making it simpler to roll up or drill down within the pivot table itself.
You can check the database character set using the SQL query: select vnp.* from v$nls_parameters vnp where vnp.parameter = ‘NLS_CHARACTERSET’. The application tier setting is found by reviewing the Forms Server Environment Variables (via Help > About Oracle Applications) or by querying the context files directly.
The runtime option takes precedence over the profile option value. The runtime option, ‘Blitz Report Additional Output Directory’, inherits its default value from the profile option initially.
The process involves three main steps , : 1) Initialize the application context using `xxen_report.apps_initialize` . 2) Create a new unique run ID using `XXEN_API.CREATE_RUN_ID_`, specifying the report name . 3) Set all necessary report parameters and runtime options (e.g., Template Name, Operating Unit value) using `XXEN_API.SET_PARAMETER_VALUE_` and `XXEN_API.SET_RUNTIME_OPTION` against the newly created run ID .
After the database packages are valid, you must then rerun the frmcmp_batch.sh command on the application server to compile the XXEN_REPORTS.fmb form into an .fmx file.
You can execute the report synchronously using the PL/SQL API `XXEN_API.RUN_REPORT` . This procedure executes the report SQL and returns the Excel output directly in a BLOB output variable (`x_output_file`), along with the row count (`x_row_count`), generated filename (`x_filename`), and status details . This method is typically used when you want the results immediately, such as displaying a preview or integrating into a custom form action .
This specific forms error when editing reports often signals a character set mismatch between your Oracle Database and your application tier. Oracle requires these character sets to be identical.
Yes, template access is controlled specifically by this profile option.
Blitz Report fundamentally accelerates financial analysis by outputting the data as a clean, native Excel file. The process of generating perfectly formatted Excel reports is integrated , meaning the data, including date fields and currency figures, is formatted correctly for instant consumption by Excel’s pivot table features. The data extraction process itself won’t ‘break the bank’.
You need to manually recompile all Blitz Report packages. Run a SQL script as APPS executing commands like alter package XXEN_REPORT compile; and alter package XXEN_REPORT compile body; for all Blitz Report packages listed in the source.
Yes, ‘No Access’ prevents both creation and modification.
This error usually means that the required database packages (like XXEN_REPORT, XXEN_UTIL, etc.) are in an invalid state, preventing the form compilation process from succeeding.
You should set the profile option ‘Blitz Report Template Access’ to ‘No Access’. This ensures users can view and use, but not create templates.
Yes, if you specify the ‘Hold Name’ parameter, the report will only retrieve invoices that currently have an unreleased hold of that specified name. The report output also lists all current unreleased holds against the invoice in the ‘Holds’ column.
The profile option ‘Blitz Report VPD Policy Rule’ is then set to ‘Full access’ for those users or responsibilities that need to bypass the restriction.
You can use the ‘Invoice on Hold’ parameter. Set it to ‘Yes’ to retrieve only invoices that currently have an unreleased hold. If you leave it as ‘Null’ (the default value), the hold status will not be considered.
You should use the AP Invoices and Lines report. This report provides a detail Invoice Aging report that includes line item details and amounts.
The ‘Actual Costing’ report includes specific columns like prior costed quantity, prior cost, and new onhand quantity, which typically have zero or empty values in a Standard Cost organization. The Item Costing report is structured for broader applicability, including comparison against a selected cost type.
You must run the concurrent program ‘Blitz Report Update VPD Policies’. This program creates the policy function package `XXEN_VPD` and then creates the database policies for all tables and columns referenced in the lookup.
Yes, if you use parameter type LOV custom, the ad hoc LOV query you define is unique to that parameter and will not affect any other reports.
If the ‘Comparison Cost Type’ is not entered, the report defaults to using the Cost Type defined in the Primary Costing Method, such as Frozen, Average, FIFO, or LIFO.
First, you must define the tables or columns that need to be secured in the lookup `XXEN_REPORT_VPD_POLICY_TABLES`. The meaning should contain the owner, table, and optional column name.
If you are using dynamic translation rules, you must ensure they are included in the migration package . You would use the generic export function `XXEN_API.EXPORT_FILE_DATA` and specify the `p_type` parameter as ‘Dynamic Column Translation Rules’ , or include them when exporting the report by checking the appropriate box in the user interface .
If the ‘id’ column is not selected, then the ‘value’ column is used to bind the parameter restriction for report execution.
Use the CAC PO Receipt History for Item Costing report. This report shows PO Receipt History for a selected date range and is generally suitable for any discrete costing method.
The LOV query must select the two mandatory columns ‘value’ and ‘description’, and it may include an optional ‘id’ column at the beginning of the select clause. If the optional ‘id’ column is included, this value is used as the parameter’s :bind value for report execution.
The dynamic translation rules are applicable to both parameters and header columns within the report . This allows you to present a completely customized user experience, where the parameter prompts themselves reflect the terminology relevant to the selected organizational context (e.g., Ledger or Operating Unit) .
The output of a Dynamic Column Translation rule SQL must contain exactly two columns . The first column must return the original column or parameter name (the key to be translated), and the second column must return the desired translation text .
You need to use Dynamic Column Translation Rules . This feature allows for the dynamic translation of both report header column names and parameter names based on custom rule SQLs . For your GL example, the rule SQL would reference the selected ledger parameter to query the Chart of Accounts structure and dynamically return the column name alongside its corresponding translated prompt .
No, the SMTP profiles are specific to the Blitz Report Advanced Email Delivery feature.
If you are using SSL/TLS, you must also configure the ‘Blitz Report SMTP use SSL’ profile option.
The format can be set by this profile option for all columns, or for individual columns as described in the column translations section.
You must set the profile option ‘Blitz Report SMTP Port’. This defines the SMTP Port to use for Blitz Report advanced email delivery.
The default is ‘General’.
You should set the profile option ‘Blitz Report XLSX Number Format’. This defines the numeric column format string for Blitz Report XLSX output files.
By default (‘Yes’), `xxen_util.user_name(‘SYSADMIN’)` returns ‘SYSADMIN (System Administrator)’.
Yes, the Column Set’s Amount Type maps to Row 10 and Row 11, where the appropriate balance type (like PTD, YTD) is calculated based on the original Amount type.
This applies to Blitz Report’s record history columns and the result of the utility function `xxen_util.user_name`.
If the Offset is not defined, this row is equated to the Period Name LOV Cell.
Yes, the R12 version, AP Invoices and Lines, includes specific hold columns like ‘Hold PO References’ (identifying matching POs for PO Matching Holds) and ‘Hold Receipt References’ (identifying matching Receipts for Receipt Matching Holds).
You can set the profile option ‘Blitz Report Show User Description’. Setting it to ‘No’ prevents the additional FND user description (such as person first and last name) from being shown.
If network connectivity is confirmed, the next logical step is internal Weblogic configuration validation. You should check the `AdminServer.log` on the ECC side for detailed internal server failures . If the application URL (e.g., `/ecc/user/import`) is correct, the 404 suggests the managed server hosting the ECC application context may be incorrectly deployed or registered within the Weblogic domain .
Yes, the AP Invoice on Hold 11i report is available, based on the standard Invoice on Hold report (APXINROH_XML).
If an Offset is defined in the Column Set, the formula `br_period_offset` is used in accordance with that defined offset.
The use of the 404 code confirms that the server could not find the resource associated with the Request-URI . If security restrictions were blocking access, the server *should* use a 403 code instead . Therefore, the 404 status points more definitively toward a problem with network configuration, host resolution, or an internal Weblogic routing issue preventing the script from finding the necessary import application context .
The Offset definition from the Column Set maps to Row 12 (Periods) in the Excel template. This row handles the calculation of periods for the column.
Blitz Report resides in Oracle Forms and leverages existing EBS infrastructure. While the underlying EBS Forms and Java framework components require signing (the JAR files) , the Blitz Report SQL definitions themselves are stored securely in the database with version control, managed by EBS application security (VPD and responsibility assignment).
You should use the AP Invoices and Lines 11i report. It provides the detail Invoice Aging report with line item details and amounts for the 11i environment.
The most efficient way is through a custom Blitz Report leveraging the `AD_PATCH.IS_PATCH_APPLIED` function, run directly from the EBS Forms interface. This allows DBAs to quickly confirm the presence or absence of necessary security patches prior to the time-consuming HSM signing phase.
Yes, RAC environments using SCAN listeners have been implicated in connection issues during ECC setup . It is highly recommended to manually replace the SCAN entry with the Virtual IP (VIP) address in both the `EccConfig.properties` file and the generated `connection.dbc` file . This step ensures proper resolution and may resolve routing confusion that leads to the 404 error .
An HTTP Status 404 (Not Found) means that the server (in this case, the ECC server’s Weblogic component) successfully received the request but could not find anything matching the Request-URI (the path `/ecc/user/import/applications…`) . This often points to an incorrect URL or a failure in the routing or context path configuration . However, in ECC integration, it frequently indicates an issue with host or port resolution between the EBS server (where the script runs) and the ECC managed server .
A stuck `adop fs_clone` is a critical issue that must be resolved immediately, potentially requiring deep debugging (checking `fnd_nodes` or OS logs). If this occurs during a critical signing process, the integrity of the target file system (e.g., the patch file system) may be compromised, requiring careful verification of all applied patches and file signatures afterward.
Absolutely. Use the Blitz Report Text Search report. This report helps understand which reports, parameters, or LOVs contain a specific SQL text string, or which reports use a specific LOV.
Parent values appear in bold font, while regular font indicates child values.
Yes, the search supports using regular expressions. For your specific example of calling `wait_for_request` with an interval of zero, you can input a multi-line regex search value like: `fnd_concurrent.wait_for_requests*(s*request_ids*=>s*w+s*,s*intervals*=>s*0s*,`.
You can configure it to populate either Child values only or Parent values only.
You can download Blitz Report, which is free to use for up to 30 reports. This provides an immediate opportunity to create and test custom reports for HR or any other functional area requiring unique visualization solutions.
The ‘Module Name’ column shows either the translated EBS module display name or, for background sessions, the process name. This facilitates pivoting by application context.
Specific integration details for proprietary HSM solutions like DigCert KeyLocker with EBS are challenging to find, suggesting this is often a difficult implementation that requires specialized knowledge due to the complexity of integrating the HSM with Oracle’s existing code-signing process.
Use the DBA Text Search report. This report performs a full text search through source code objects like packages, procedures, functions, and triggers.
The program encourages Oracle EBS professionals with an interesting, creative solution for EBS reporting to enroll. It focuses on both technical excellence and creative problem-solving across functional areas, such as VAT reporting, Payroll Balance Listing, Preventative Maintenance Scheduling, or WIP Production Job Details.
We highly recommend using a pivot in Excel for ASH performance analysis, as drag-and-drop analysis is much faster than manual SQL querying. A typical use case is pivoting to analyze which EBS application user waited for how many seconds in which Forms UI.
The report itself extracts the data set required for visualization, often including calculated metrics. The visualization (e.g., Pivot Tables or Charts) is typically performed seamlessly in Excel afterwards, leveraging the clean, formatted data produced by Blitz Report.
Yes, the hierarchy discovery feature is configurable. You can adjust the Discover Level setting check box to control this level.
Immediately run the DBA SGA Active Session History report. This provides active session history directly from the SGA, offering a real-time view.
A highly useful tip for optimizing this process post-patching is to locate the list of modified Jar files. This list can be found in one of the subdirectories created during the `adop phase=prepare & apply` process, typically within `$NE_BASE/EBSapps/log/adop/`.
Yes, it must be inserted at the end of the event() procedure to correctly integrate with other forms functionality.
That is correct. If an item cost was directly entered into the Frozen Cost Type (allowed only if there are no onhand or intransit quantities), the ‘Cost Update Request Id’, ‘Cost Update Description’, ‘Cost Update Status’, and related cost update submission columns will be blank or empty.
The primary advantage is the combination of speed and flexibility. Traditional methods often require complex BI tools or manual data manipulation. Blitz Report extracts the exact dataset needed using optimized SQL , and outputs it immediately as a native Excel file. This Excel output can then be directly utilized for visualization, even integration with tools like Excel Bing Maps if geographic data is relevant.
Implementing HSM for EBS Jar signing is complex. It involves configuring the Java environment (Java/Jarsigner utilities) to interface securely with the HSM device using PKCS#11 libraries, managing the necessary keystores, and executing the `jarsigner` command sequence for mass signing of the EBS Jar files.
The Absence Visualization solution, developed through the Blitz Report Champion program , showcases how the tool can address unique customer problems. It leveraged Blitz Report’s ability to extract complex HR data via SQL and deliver it into a format (Excel) that facilitates easy visualization and analysis, transforming raw absence data into understandable metrics.
Yes, the report includes columns indicating whether BOMs, Routings, or (inventory organization) Sourcing Rules exist for the item. This helps validate the necessary controls are in place for accurate cost calculation.
You must open your CUSTOM.pll, attach the XXEN.pll library (located in the installer’s forms directory), and then insert a call to the function xxen_event(event_name); at the end of the event() procedure in the package body. Remember to recompile and deploy the modified CUSTOM.pll and .plx files afterward.
Access restriction is handled through standard EBS security mechanisms. The report creator can assign the report to a specific user, module, site, or responsibility. Furthermore, if VPD is active, the data returned will automatically be filtered based on the user’s operating unit context.
Run the CAC New Standard Item Costs report. This report shows items with recent cost changes, based on a required ‘Cost Update Date From’ and ‘Cost Update Date To’ date range.
Hi,
I have added the following 2 columns to the report
Trx Original Amount – the original transaction amount in entered currency
Trx Original Amount Acctd – the original transaction amount in functional currency
There was already a column in the report called Trx Original Amount, but this comes from the statement line rather than from the reconciled transactions, so this has been relabeled as
Line Original Amount – the original amount recorded on the statement line
Please find attached the updated report definition XML file you can import into Blitz Report.
Kind Regards,
Eric
Yes, procedures like `xxen_api.set_parameter_value_` can be called either by parameter name or by parameter ID.
That is correct. If that warning appears, you need to manually apply the required changes to your existing CUSTOM.pll to enable the Blitz Report Forms integration features, such as the Excel icon and Oracle standard form drill-down.
While non-developers can input SQL, best practice suggests that underlying complex joins should be validated by IT. However, the system operates with reduced processing overhead , and for performance diagnosis, DBAs can monitor the subsequent query performance using the AWR diagnostic reports available through Blitz Report.
For runtime options, you call **`xxen_api.set_runtime_option`**. You pass the name of the option (e.g., ‘EMAIL’, ‘OUTPUT_FORMAT’, ‘TEMPLATE_NAME’, or ‘ROW_LIMIT’) and the corresponding value, linked by the `p_run_id`.
While additional logging consumes resources, this profile is typically used temporarily during troubleshooting and testing to capture detailed processing steps.
After initiating the submission to get a `run_id`, you use dedicated setting procedures. For user parameters, use `xxen_api.set_parameter_value_`.
Blitz Report supports the migration of Discoverer reports. Crucially, since the output format (Excel) is superior and the interface is integrated within EBS Forms, it serves as a straightforward Oracle Discoverer replacement for end-users accustomed to running interactive queries.
Yes. The underlying data for Concurrent Request summaries typically includes metrics on the requested start date versus the actual start date, allowing you to calculate or see the average time spent waiting in the queue. For tuning concurrent manager waiting periods, remember to check manager definitions using FND Concurrent Managers.
The default value if not set is ‘No’.
A typical workflow involves logging on as a developer (or a user with appropriate privileges) and opening the Blitz Report form. The user pastes their SQL query, assigns version control details, adds parameters if necessary, and nominates a specific user or responsibility for testing the report.
Yes, set the profile option ‘Blitz Report Debug’ to ‘Yes’. This writes additional debug information, which is particularly useful for reviewing upload processing logs.
You can transition to the FND Concurrent Requests report. This report shows detailed information for historic requests, including execution timing, parameters, the status, and the currently executed SQL_ID and SQL text for running requests.
You must first call `xxen_report.apps_initialize` to set the session context, and then call `xxen_api.create_run_id_` to get a necessary `l_run_id` before setting parameters and calling `run_report`.
The main benefit is agility and simplicity. Traditional tools involve steep learning curves and significant overhead (templates, registration). Blitz Report only requires basic SQL proficiency and automatically delivers clean, perfectly formatted Excel output, enabling the user to bypass the lengthy IT request queue.
You use the procedure `xxen_api.run_report`. This executes the report synchronously and returns the output file content (like Excel) in the `x_output_file` parameter, which is of type BLOB.
You should utilize the FND Concurrent Requests Summary report. This report lists concurrent programs sorted by the sum of their historic execution times.
Blitz Report aims to overcome this intimidation, specifically catering to non-developers who possess basic SQL knowledge. The process is highly simplified: users work within the familiar EBS Forms interface, paste their SQL query, configure minimal settings, and execute.
The Blitz Report Monitor concurrent program performs the purging of outdated upload data.
The Snapshot tool converts the content of the cells to static values, but the Hide Zeros tool specifically controls the row visibility.
Yes, clicking ‘Unhide Zeros’ will show the rows previously hidden by the Hide Zeros feature.
No. The load of default assignments will not modify any custom created assignments.
You can use the ‘Hide Zeros’ tool. This feature is useful for streamlining reports by concealing rows that contain only zero values.
You must enter the mandatory ‘Transaction Date From’ and ‘Transaction Date To’ parameters, as well as the ‘Currency Conversion Type’ needed for converting foreign currency purchases into the general ledger currency.
The default is zero, meaning immediate deletion during the upload process.
The example file name for INV Aging suggests a ‘Default Pivot’ template is available, which implies pivot summarization capabilities for enhanced analysis, typically by key attributes like organization, subinventory, or item.
Yes, specific steps are required to enable `mod_plsql`. Your technical team should follow the dedicated documentation for the EBS 12.2 version to ensure successful configuration and enablement of your custom PL/SQL web applications.
To prevent the default assignments from being reloaded during upgrades, you should clear out the profile value or set it to ‘No’.
You must set the profile option ‘Blitz Upload Data Retention Days’ to a non-zero value. This defines the number of days to keep data in table `xxen_upload_data`.
Yes, the report covers this. The FOB point determines which internal transfer transaction gets the PPV. For FOB Shipment, PPV occurs on the Intransit Shipment transaction. For FOB Receipt, PPV occurs on the Intransit Receipt transaction.
This profile controls the tracing specifically within the Blitz Report session context.
Yes. While the concept of using `mod_plsql` for server PL/SQL applications remains consistent , the specific configuration steps within the Apache web server files often differ based on the EBS version, so we provide guidance for configuring `mod_plsql` in EBS 11i and EBS 12.1.3 , in addition to 12.2.
The loading of default assignments during upgrades is controlled by the profile option ‘Blitz Report Load Default Assignments during Upgrades‘.
Yes, for period close diagnostics, run the INV Period Close Pending Transactions report. This helps identify transactions preventing closure.
Yes, VPD is effective because it enforces security at the data layer itself, independent of the application that generates the SQL. It ensures that data governance rules are respected when securing developer SQL access, preventing the accidental or unauthorized exposure of data.
If the value is null, the trace is off.
Proper configuration of `mod_plsql` generally integrates with the existing EBS authentication mechanisms. For the reporting layer, Blitz Report operates as a Java form running from standard EBS menus and leverages the concurrent request framework. While securing the Web Tier (Apache, ISG) is essential , enabling `mod_plsql` for custom components runs alongside Blitz Report, which handles its data extraction through the database and Forms layer.
This is crucial for Oracle EBS implementation and project support consultants managing extensions or upgrades, as well as business users needing to validate reports. The VPD feature within the Blitz Report framework allows us to protect sensitive master data while still supporting flexible reporting needs.
The CAC Purchase Price Variance report is designed for this. It reports PPV accounting entries for external purchases, OSP, internal transfers, and consignment transactions. Crucially, it splits variances into the ‘PPV Cost Amount’ and the ‘PPV FX Amount’ columns.
Yes, discover features support automatic population of adjacent cells, which can be either down (vertical) or to the right (horizontal).
The INV Aging report is the correct tool for analyzing the age of your inventory.
Yes, `mod_plsql` is a module included in the EBS 12.2 Apache web server. It is utilized to develop web application pages using server PL/SQL.
You use the profile option ‘Blitz Report Trace Level’. You specify the desired trace level for the Blitz Report database session.
It allows you to populate Excel spreadsheets directly with chart of accounts values and period names, which helps streamline report building and segment value review processes.
For sensitive data, such as Human Resources information, access can be strictly secured by configuration within Blitz Report itself, beyond the VPD layer. However, the foundational security mechanism relies on VPD, ensuring that even if a developer with SQL access attempts to query a restricted table via Blitz Report, the database only returns data permitted by their security profile.
The policy function is dynamically applied by Oracle whenever the underlying table is accessed. If you define a VPD policy on a table accessed by a Blitz Report query, the policy function modifies the SQL statement *before* execution, typically by adding a dynamic `WHERE` clause (predicate).
The Discover Tools primarily enable you to extract segment information directly from Oracle and automatically populate Excel cells with the retrieved data.
Blitz Report is fully compatible with standard Oracle VPD security policies. This framework is the definitive way to control data visibility. You implement VPD policies at the database layer (row and column level) on the tables containing the sensitive data.
Oracle E-Business Suite reporting straight into Excel: 2,900+ ready-made reports, your own SQL, 150+ Excel uploads.