Blitz Report™ Library
Module GL 143 AP 146 AR 123 FA 138 CE 25 PO 116 INV 130 OM 89 MFG 215 COST 175 PA 131 HR 182 PAY 152 SYS 162
837 reports
| Description | Download | ||
|---|---|---|---|
| AR HSBC FAA Asset File (France) | Extracts completed Receivables invoices and credit memos in the HSBC FACTORING FRANCE FAA file format, for invoice discounting. One 532 character record per document.
The report is implemented from the HSBC specification document "HFF - Invoice Discounting - Asset File IT Protocol.pdf" dated 09/09/2025, and its output has been validated against both the field table in that document and the sample file supplied with it. The 31 zones are, in order, each followed by a semicolon: File type FAA (3), Seller account number (5), File creation date YYYYMMDDHHMM (12), Debtor's Seller Identifier (15),… full description | Receivables Enginatics, R12 only |  |
| AR Refund Upload | Bulk-refund customer credit balances in AR. Each row refunds either an open credit memo or the unapplied/on-account portion of a customer cash receipt by applying it against the operating unit's Credit Memo Refund Receivables Activity, via AR_CM_APPLICATION_PUB.Activity_application or AR_RECEIPT_API_PUB.Activity_application.
WHEN TO USE EACH REFUND SOURCE
- Credit Memo - the customer has an open credit memo (e.g. overpayment recorded as a CM) and wants the money back.
- Unapplied Receipt - the customer paid more than they owed, or paid against the account with no specific invoice. The… full description | Receivables Enginatics, R12 only, Upload | |
| AR Transaction Update Upload | Updates the post completion header fields of Receivables transactions in the same way as the Transactions workbench: comments, special instructions, print option, purchase order details, salesperson, remit to address, late charges exemption, ship via, FOB, waybill, cross reference and the transaction descriptive flexfield.
The transaction is identified by Operating Unit and Transaction Number. A hidden transaction id links downloaded rows exactly; pasted rows resolve by number, and a number existing under more than one transaction source is rejected with a request to download the transaction… full description | Receivables Enginatics, R12 only, Upload | |
| AR Transaction Upload | This upload can be used to create Invoices, Debit Memos and Credit Memos. Credit memos can be created On Account, or created and applied directly to an existing transaction (an applied credit memo).
The 'Upload Trx Identifier' column is used to uniquely identify each individual transaction (invoice, credit memo, debit memo) to be uploaded.
If the selected batch source uses manual transaction numbering, the Upload Trx Identifier will be copied to the Transaction Number column (the Oracle Transaction Number), but this can be overridden in the upload excel.
If the selected transaction type uses… full description | Receivables Enginatics, Upload | |
| AR Transactions and Lines 11i | Detail AR transaction report with line level details and special columns for service contracts (OKS) and lease contracts (OKL) data
Show Sales Credits lists each line once per salesperson credit, with the revenue and non-revenue split. Transaction and line amounts are shown on the first row of a transaction or line only, so they can be summed.
Revenue As Of Date adds the accounting rule and the deferred revenue position of each line: Revenue Recognized is the sum of the revenue distributions with a GL date up to that date, and Unearned Balance is the line amount less that, for lines with an… full description | Receivables Enginatics | |
| AR Unaccounted Transaction Sweep | Imported from BI Publisher
Application: Receivables
Source: Unaccounted Transaction Sweep
Short Name: ARTRXSWP
DB package: ar_unaccounted_trx_sweep | Receivables BI Publisher, Enginatics, R12 only | |
| BOM Bill of Materials Upload | Report: BOM Bill of Materials Upload
Description:
This upload can be used to create and/or update existing standard BOMs, including
- BOM Header
- BOM Components
- BOM Component Substitutes
The functionality supports the creation and update of Alternate Bills.
The functionality does not support the creation and update of Common Bills. | Manufacturing Enginatics, Upload | |
| BOM Common Bill of Materials Upload | BOM Common Bill of Materials Upload
============================================
The upload can be used to create Common BOM from the BOMS defined in the specified source organization in one or more target organizations as determined by the Scope Parameter:
All - All Organizations
BOMs will made Common to all other Organizations that share the same Master Organization as the Source Organization and to which the current responsibility has access to.
Hierarchy – Organization Hierarchy
BOMs will made Common to all Organizations the current responsibility has access to and which are below the… full description | Manufacturing Enginatics, Upload | |
| BOM Item Where Used GUI | Description: Item Where Used GUI Report
Provides equivalent functionality to the the following standard reports:
- Item Where Used Report GUI
Application: Bills of Material
Source: Item Where Used Report GUI (XML)
Short Name: BOMRWUITG_XML
DB package: BOM_BOMRWUIT_XMLP_PKG | Manufacturing Enginatics | |
| BOM Routing Upload | Report: BOM Routing Upload
This upload can be used to create and/or update existing manufacturing BOM Routings.
- Create new Standard, Flow, and Lot Based (Network) Routings
- Update or Delete existing Standard, Flow, and Lot Based (Network) Routings
- Upload new Common Routing Assignments | Manufacturing Enginatics, Upload | |
| BOM Standard Operations Upload | Report: BOM Standard Operations Upload
This upload can be used to create and/or update BOM Standard Operations.
Standard operations are reusable operation templates that routings can reference. The upload covers:
- Standard operation header (code, type, line, department, attributes, EAM and OSFM extensions)
- Primary resource assignments to the standard operation
- Substitute (alternate) resource assignments
- Descriptive flexfield attributes on the header and primary resources
Each Excel row represents one resource of a standard operation. Header columns repeat across resource rows of the… full description | Manufacturing Enginatics, R12 only, Upload | |
| Blitz Report Add-in Environment Setup | Generates connection configuration for the Blitz Report Excel Add-in. Open the output file in Excel with the add-in installed to auto-configure the environment. | Enginatics | |
| Blitz Report Assignment Upload | Upload to maintain Blitz Report assignments.
The upload support creating, deleting or copying assignment and can be run with the following modes:
-Create with 'Create Empty File'=Yes:
Opens an empty Excel file to enter new assignments.
-Create with 'Create Empty File'=blank:
You can query a list of reports that you want create assignments for by report name, category or report type.
-Create, Update:
Allows querying existing assignments, which can be deleted, or copied to a different assignment level.
A frequent use case for customers having custom responsibilities linked to custom… full description | Enginatics, R12 only, Upload | |
| Blitz Report Assignment Validation | Lists every Blitz Report with the number of assignments it has at each assignment level, so you can validate that all reports are assigned.
Each level column counts the distinct included assignment targets at that level (Site, Application, Request Group, Responsibility, User, Form, Function, Report). The Excluded column counts exclusion assignments. The zero_to_null function leaves a blank cell where there is no assignment, so reports missing an assignment stand out at a glance - a row that is completely blank across the assignment columns is not assigned to anyone.
Use the Category, Not in… full description | Enginatics | |
| Blitz Report Category Assignment Upload | Upload to maintain Blitz Report category assignments - the categories that reports and uploads are grouped under.
Run modes:
- Create with 'Create Empty File' = Yes: opens an empty Excel file to enter new report and category rows.
- Create with 'Create Empty File' = blank: queries a list of reports (by name, category or type) as blank rows to assign categories to.
- Create, Update: queries existing category assignments, which can be removed by setting the Delete column to Yes.
Enter any Category name. If the category does not exist yet, it is created automatically in all installed… full description | Enginatics, Upload | |
| Blitz Report Column Number Fomat Comparison between environments | Shows differences in Blitz Report column translations between the local and a remote database server | Enginatics | |
| Blitz Report Column Translation Comparison between environments | Shows differences in Blitz Report column translations between the local and a remote database server | Enginatics | |
| Blitz Report Column Translation Upload | Upload to maintain the Blitz Report column translations and number formats, which control how a report column heading is displayed in each language and how its values are formatted in Excel.
Translations are matched to reports by column name at run time, so one row here applies to every report producing a column of that name.
The Language parameter is required, because a single language already covers around twenty thousand column names.
Run modes:
- Create, Update: downloads the existing translations of the chosen language for editing. Set Delete to Yes to remove a translation.
- Create… full description | Enginatics, Upload | |
| Blitz Report Custom Reports Converter | Lists Oracle EBS concurrent programs that are candidates for conversion to Blitz Report - RDF reports, BI Publisher reports, and other data-extract concurrent programs - with usage statistics. Select the programs to convert with the Convert Program column, then upload the file. The upload submits a host concurrent program that gathers each selected program's source artifacts (.rdf, .ldt, data definition, template, related packages and custom dependencies) into a single zip file for analysis by Enginatics.
With Select All Programs set to Yes, every listed row is downloaded with Convert… full description | Enginatics, Upload | |
| Blitz Report Dynamic Column Rules | Enginatics | | |
| Blitz Report History | History of Blitz Report executions | Enginatics | |
| Blitz Report History Summary | Count and performance summary of historic Blitz Report executions | Enginatics | |
| Blitz Report LOV Comparison between environments | Requires following view to be created on the remote environment to avoid ORA-64202: remote temporary or abstract LOB locator is encountered
create or replace view xxen_report_parameter_lovs_v_ as
select
xrplv.*,
dbms_lob.substr(xxen_util.clob_substrb(xrplv.lov_query,4000,1)) lov_query_short
from
xxen_report_parameter_lovs_v xrplv; | Enginatics | |
| Blitz Report Parameter Comparison between environments | Shows Blitz Report parameter differences between the local and a remote database server.
Requires following view to be created on the remote environment to avoid ORA-64202: remote temporary or abstract LOB locator is encountered
create or replace view xxen_report_parameters_v_ as
select
xrpv.*,
dbms_lob.substr(xxen_util.clob_substrb(xrpv.sql_text,4000,1)) sql_text_short,
dbms_lob.substr(xxen_util.clob_substrb(xrpv.lov_query,4000,1)) lov_query_short,
length(xrpv.sql_text) sql_length,
count(*) over (partition by xrpv.report_id) parameter_count
from
xxen_report_parameters_v xrpv; | Enginatics | |
| Blitz Report Parameter Comparison between reports | Compares the paramaters of two reports for differences | Enginatics | |
| Blitz Report Parameter Default Value Validation | Lists report parameters whose LOV returns an id that differs from the displayed value, and shows whether the parameter's default value is stored as that id or as the display text.
Default Value Correct is the id the LOV resolves the stored default to. Where it differs from Default Value, the default was entered as the display value instead of the id. Use the 'Show non matching defaults only' parameter to list those cases.
The framework binds the id for such LOVs, so a report level default given as display text only works through a fallback validation, which costs an additional LOV execution… full description | Enginatics | |
| Blitz Report Parameter Link Validation | Lists orphaned parameter rows: additional-anchor (sub) parameter rows - those without a display sequence - that do not link to a visible parameter of the same name in the same report (parameter_id not in xxen_report_parameters_link_v).
These are typically left behind by an incomplete parameter rename (e.g. 'Show DFF Attributes' to 'DFF Display'), leaving the old-named multi-anchor sub-rows dangling.
The run-time SQL is assembled solely from xxen_report_parameters_link_v, so an unlinked sub-row is never injected and is harmless at run time, but it clutters the parameter setup and would… full description | Enginatics | |
| Blitz Report Template Sharing | Lists the sharing records for Blitz Report templates - who each template is shared with at Site, Responsibility or User level. The Owner column shows the user who owns each template.
For a Responsibility-level share the Shared With column shows the responsibility name and the Application column shows its owning application; for a User-level share it shows the user name; a Site-level share is available to everyone.
For Responsibility-level shares the Menu Name column shows the responsibility's menu and Blitz Report Menu Entries counts the Blitz Report menu functions already on that menu… full description | Enginatics | |
| Blitz Report Template Sharing Upload | Upload to maintain Blitz Report template sharing - which users, responsibilities, or the whole site can see and use a report template (Excel layout).
The upload can be run in the following modes:
-Create with 'Create Empty File'=Yes:
Opens an empty Excel file to enter new template shares.
-Create with 'Create Empty File'=blank:
Query the templates you want to share, filtered by report name, category or sharing level.
-Create, Update:
Query existing template shares, which can be deleted or copied to a different sharing level.
Sharing levels:
-Site shares the template with the whole system… full description | Enginatics, Upload | |
| Blitz Report Text Search | This report can be used to understand which reports, parameters or LOVs contain a certain SQL Text string, or which reports currently use a specific LOV.
It is used to preview all records that would be changed through the Blitz Report mass change functionality in Setup Window>Tools>Mass Change | Enginatics | |
| Blitz Report Web Service Sessions | Blitz Report runs that execute inside a web service call, from the Excel add-in or a Blitz FSG drilldown, and are still active, with the Oracle EBS user and responsibility that started them.
Running Minutes is the run time of the current database call. The Excel clients stop waiting after 15 minutes. A run that is still active after that has no client reading its result, but its database session and the middle-tier thread serving it stay busy until the query ends.
Kill Session holds the command that ends the session. Temp Used is in MB.
Schedule the report with Running Minutes From to be… full description | Enginatics | |
| Blitz Upload Example (API with no parameters) | Example upload, which can be used as a template by copying (Tools>Copy Report) to create new uploads using an API with no parameters. This API will be called just once by the upload framework and all the uploaded records can be accessed within the API by selecting them from the Data View eg: select * from xxen_blitz_upload_examp_9718_u xu where xu.status_code_=xxen_upload.status_valid | Enginatics, Upload | |
| Blitz Upload Example (API without parameters) | Example upload, which can be used as a template by copying (Tools>Copy Report) to create new uploads using an API without parameters.
This API will be called just once by the upload framework and all the uploaded records can be accessed within the API by selecting them from the Data View eg: select * from xxen_blitz_upload_examp_9718_u xu where xu.status_code_=xxen_upload.status_valid | Enginatics, Upload | |
| Blitz Upload Example (API) | Example upload, which can be used as a template by copying (Tools>Copy Report) to create new uploads using an API. | Enginatics, Upload | |
| Blitz Upload Example (Interface Table) | Sample upload to be used as a template by copying (Tools>Copy Report) to create new uploads using Interface Table. | Enginatics, R12 only, Upload | |
| CAC AP Accrual Accounts Setup | Report to show the valid A/P Accrual Accounts which have been set up in the Select Accrual Accounts Form. Showing the Ledger, Operating Unit, Accrual Accounts, Creation Date, Created By and Last Updated By. The A/P Accrual Load Program uses these accounts to find the Payables, Receiving and Inventory accounting accrual entries for the A/P Accrual Load results.
Parameters:
===========
Operating Unit: enter the specific operating unit(s) you wish to report (optional).
Ledger: enter the specific ledger(s) you wish to report (optional).
/*… full description | Cost Management Enginatics, R12 only | |
| CAC AP Accrual IR ISO Match Analysis | Use this report to match the A/P Accrual entries for internal order inventory receipts with the internal order payables invoices, by the internal sale order and line number. If run in Detail Mode, shows inventory receipts and payables invoices on separate lines with detailed information, if run in Summary Mode, the sales order line is summarized into one row.
Parameters:
===========
Report Mode: you can get a summary by sales order and line or a detailed report, enter Detail or Summary (mandatory).
Transaction Date from: enter the IR/ISO beginning transaction date you wish to report… full description | Cost Management Enginatics, R12 only | |
| CAC AP Accrual Reconciliation Load Request | Report to show when the A/P Accrual Reconciliation Load program was run and by whom, including the Ledger, Operating Unit, Build Id, Request Id, Creation Date and Last Updated By.
Parameters:
===========
Beginning Creation Date: enter the starting creation date to report, based on the operating unit for your session's inventory organization (optional).
Operating Unit: enter the specific operating unit(s) you wish to report (optional).
Ledger: enter the specific ledger(s) you wish to report (optional).
/* +=============================================================================+
-- |… full description | Cost Management Enginatics, R12 only | |
| CAC AP Accrual Reconciliation Summary by Match Type | Use this report to summarize the A/P Accrual entries from the Accrual Reconcilation Report tables, by operating unit, accrual match type and inventory organization. Use this report for summary reconciliation purposes, to justify the "at time of receipt" accrual balances for your inventory and expense A/P accrual accounts.
Parameters:
===========
Transaction Date From: enter the accrual starting transaction date you wish to report. Defaults to the earliest date found (mandatory).
Transaction Date To: enter the accrual ending transaction date you wish to report. Defaults to the latest… full description | Cost Management Enginatics, R12 only | |
| CAC Cost Type Costs Not in Period Close Inventory Snapshot | Report comparing the month-end items, balances and costs against any entered Cost Type, showing which item numbers in your month-end inventory which are not in your Cost Type. You automatically save off your month-end quantities and values when you close the inventory accounting period.
Parameters:
==========
Period Name (Closed): the closed inventory accounting period you wish to report (mandatory).
Cost Type: enter a Cost Type to compare against the stored month-end items, quantities and values (mandatory).
Item Number: enter the specific item number(s) you wish to report… full description | Cost Management Enginatics | |
| CAC Inactive Items Set to Roll Up | Report to show items which are set to roll up even though these items have an inactive status. The Cost Rollup uses the Based on Rollup Flag to control if an item is rolled up, as opposed to the item status.
Parameters:
===========
Cost Type: enter the cost type to report (mandatory). Defaults to your Costing Method cost type.
Inactive Item Status: enter the item statuses which should not be rolled up (mandatory). Defaults to 'Inactive'.
Category Set 1: any item category you wish, typically the Cost or Product Line category set (optional).
Category Set 2: any item category you wish,… full description | Cost Management Enginatics | |
| CAC Inventory Lot and Locator OPM Value (Period-End) | Report showing amount of inventory at the end of the month for Process Manufacturing (OPM) inventory organizations, for both onhand and intransit inventory. If you enter a cost type this report uses the item costs from the cost type; if you leave the cost type blank it uses the item costs from the month-end snapshot. In either case this report uses the month-end quantities, based on the entered period name, calendar code and period code. As these quantities come from the month-end snapshot, this also also allows you to specify the lot number and locator (row/rack/bin) for your onhand… full description | Cost Management Enginatics, R12 only | |
| CAC Inventory Pending Cost Adjustment - No Currencies | Report showing the potential standard cost changes for onhand and intransit inventory value which you own. If you enter a period name this report uses the quantities from the month-end snapshot; if you leave the period name blank it uses the real-time quantities. The Cost Type (Old) defaults to your Costing Method Cost Type (Average, Standard, etc.); and the To Currency Code and the Organization Code default from the organization code set for this session. Unlike the CAC Inventory Pending Cost Adjustment report, this version does not display any cost differences due to changes in foreign… full description | Cost Management Enginatics | |
| CAC Items Without This Level Material Overhead | Report to show item costs which do not have this level material overhead, for any cost type. For one or more inventory organizations.
Parameters:
===========
Cost Type: enter the cost type(s) you wish to report (mandatory).
Make or Buy: enter Buy, Make or leave blank to get all items (optional).
Based on Rollup: enter Yes to get the rolled up items, No to get the non-rolled-up items (optional).
Basis Type: enter the basis type you wish to report, such as Item, Lot, Res Units, Res Value, or Ttl Value (optional).
Item Status to Exclude: enter the item status you wish to exclude,… full description | Cost Management Enginatics | |
| CAC Last Standard Item Cost | Report to show the last standard item cost as of a specified cost update date; expecially useful if you have not saved off your Frozen costs at year-end, before updating to your new standard costs for the following year. Including various item controls, last cost update submission, last standard item cost and current (Frozen) item cost. And whether or not BOMs, routings or (inventory organization) sourcing rules exist for the item as of the specified cost update date. And as allowed with no onhand or intransit quantities, if an item cost has been directly entered into the Frozen Cost Type,… full description | Cost Management Enginatics | |
| CAC Manufacturing Variance | Report your summary or detail manufacturing variances for open and closed WIP jobs. If the job is open the Report Type column displays "Valuation", as this WIP job and potential variances are still in your WIP inventory balances. If the job has been closed during the reporting period, the Report Type column displays "Variance", as this WIP job was written off on a WIP Job Close Variance transaction. You can report prior periods and the report will automatically adjust the assembly completion, assembly scrap, component issue and resource quantities to reflect the reported accounting period,… full description | Cost Management Enginatics | |
| CAC Material Account Alias with Lot Numbers | Report to display the material account alias transactions by lot number. Specify Yes for Show Lot Number to split out the transaction quantities and amounts by transaction lot number. And if processed by Create Accounting, the Create Accounting column shows "Yes".
Parameters:
===========
Transaction Date From: enter the starting transaction date (mandatory).
Transaction Date To: enter the ending transaction date (mandatory).
Show Lot Number: enter Yes to see transactions by lot number, enter No to exclude lot information (mandatory).
Account Alias: enter the account alias to report… full description | Cost Management Enginatics, R12 only | |
| CAC New Standard Item Costs | Report to show items which have recent item cost changes, including various item controls, last cost update submission, new standard item cost, prior item cost and current (Frozen) item cost, by cost update date. And whether or not BOMs, routings or (inventory organization) sourcing rules exist for the item. As allowed with no onhand or intransit quantities, if an item cost has been directly entered into the Frozen Cost Type, the Cost Update Request Id, Cost Update Description, Cost Update Status and related cost update submission columns will be blank or empty.
Parameters:
Cost Update… full description | Cost Management Enginatics | |
| CAC OPM Batch Material Summary | Report showing Batch materials in summary for each product, byproduct and ingredient. Displaying batches which were open during the monthly inventory accounting period or batches which were closed during the monthly inventory accounting period. If you enter a cost type this report uses the item costs from the cost type; if you leave the cost type blank it uses the item costs from the month-end item costs.
Parameters:
==========
Period Name: enter the monthly inventory accounting period you wish to report (mandatory).
Cost Type: enter a Cost Type to value the quantities using the Cost… full description | Cost Management Enginatics, R12 only | |
| CAC OPM Costed Formula | eport showing OPM formulas and item costs, by OPM Cost Component Class. The report automatically displays the first thirty Cost Components, sorted by Usage Indicator (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc), then by the Cost Component Class. With the "Other Costs" column summing up any other non-displayed Cost Component Classes. For a different selection of Cost Component Classes, you may override any of the defaulted Cost Component Classes. If you have fewer than thirty Cost Components the report automatically displays "Not Available", for the succeeding Cost Component… full description | Cost Management Enginatics, R12 only | |
No reports match. Try fewer words or categories.
Also found in SQL, tables and columns
These reports don't mention the search in their name or description, but their SQL does.
Searching SQL…