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
835 reports
| Description | Download | ||
|---|---|---|---|
| CAC OPM WIP Account Value | Report to show WIP values for process manufacturing (OPM), in summary by inventory organization and batch, with batch status, name and other details. The valuation accounts come from the cumulative WIP Valuation accounting entries, as processed by Create Accounting.
Parameters:
===========
Period Name: the inventory accounting period you wish to report (mandatory).
Include Lab Batches: enter Yes to include laboratory batches. Enter No to exclude them. Defaults to No (mandatory).
Show Batch Details: enter Yes to display the formula, routing and recipe numbers and versions. Defaults to… full description | Cost Management Enginatics, R12 only |  |
| CAC Receiving Expense Value (Period-End) | Report to show receiving value for expense locations and expense destination types, for expenses accrued at time of receipt. You may run this report for open or closed accounting periods. If run for a prior period the report automatically rolls back the quantities and values to the prior period's period end date. if run for a current period, the report shows the real-time quantities and values. This report displays both the receiving valuation account as well as the offset (expense or CapEx) account.
Parameters:
Period Name: the accounting period you wish to report (mandatory).
Category… full description | Cost Management Enginatics | |
| CAC Recost Cost of Goods Sold | Report to compare the "as transacted" cost of goods sold (COGS) transactions in Oracle Inventory with the "what if" costs from a simulation cost type. Use this report when you need to make manual journal entry corrections to your COGS entries, due to incorrect item costs. In addition to reporting the normal COGS entries for the COGS Recognition, Sales Order Issue, RMA Receipt and RMA Return transactions, you can also report user-defined material transactions such as Account Issues/Receipts, Miscellaneous Issues/Receipts and Account Alias transactions which could represent COGS entries from… full description | Cost Management Enginatics, R12 only | |
| CAC Standard Cost Update Submissions | Report to show the Standard Cost Update submissions, by Cost Update Date. Including the parameters used and the overall inventory and WIP adjustment values.
Parameters:
Cost Update Date From: starting cost update date, based on standard cost submission history (required).
Cost Update Date To: ending cost update date, based on standard cost submission history (required).
From Cost Type: enter the cost type implemented by the Standard Cost Update into the Frozen costs (optional).
Organization Code: enter the specific inventory organization(s) you wish to report (optional).
Operating Unit:… full description | Cost Management Enginatics | |
| CAC WIP Period Balances to Accounting Activity Reconciliation | Report to compare the monthly WIP Period Balances with the pre-Create Accounting WIP accounting entries for material, resource, overhead, outside processing, job close variance and standard cost update transactions. With WIP class, job status, name and other details. This report shows both WIP jobs which were open during the accounting period as well as jobs closed during the accounting period. If the stored WIP period balances agree to the period WIP accounting activity, the "Difference" columns have a zero amount.
//*… full description | Cost Management Enginatics | |
| CE Bank Statement Upload | CE Bank Statement Upload
========================
Loads bank statements (header and lines) into Oracle Cash Management through the bank statement open interface and runs Oracle's Bank Statement Import automatically after upload.
Optionally, AutoReconciliation runs in the same step to match the imported statement lines against AR receipts, AP payments and GL journal lines according to the bank account's transaction codes and matching rules, in the same way as the standard 'Bank Statement Import & AutoReconciliation' concurrent program.
Each row represents one statement line. Statement header… full description | Cash Management Enginatics, R12 only, Upload | |
| CE Bank and Branch Upload | CE Bank and Branch Upload
==========================
Creates or updates banks and bank branches in Oracle Cash Management (CE) using the ce_bank_pub API (TCA-based).
Each row represents one bank branch. If the bank does not exist it is created automatically. The branch is then created or updated within that bank.
Upload Mode
===========
Create
------
Opens an empty spreadsheet to enter new banks and branches.
Create, Update
--------------
Returns existing bank branches. Edit fields and re-upload to update.
Required Fields
===============
- Country: Country of the bank (e.g. United… full description | Cash Management Enginatics, R12 only, Upload | |
| CE Cash in Transit | Application: Cash Management
Description: Cash in Transit
Provides equivalent functionality to the following standard Oracle Forms/Reports
- Cash in Transit
Applicable Templates:
- Pivot: Cash in Transit - Pivot: Bank Account Currency, Bank Account, In Transit Type, Operating Unit, Third Party (Supplier/Customer) with drill down to details
- Cash In Transit Detail - Detail Extract
Source: Cash in Transit (CEXCSHTR)
DB package: CE_CEXCSHTR_XMLP_PKG (required to initialize security) | Cash Management Enginatics, R12 only | |
| CE Cleared Transactions | Application: Cash Management
Description: Transactions - Cleared Payment/Receipt Transactions
Provides equivalent functionality to the following standard Oracle Forms/Reports
- Cleared Transactions Report
Applicable Templates:
Pivot: Cleared Transactions Summary
Pivot: Cleared Batches Summary
Source: Cleared Transactions Report (CEXCLEAR)
DB package: CE_CEXCLEAR_XMLP_PKG (required to initialize security) | Cash Management Enginatics, R12 only | |
| CE Transactions Available for Reconciliation | Application: Cash Management
Description: Transactions - Transactions Available for Reconciliation
Provides equivalent functionality to the following standard Oracle Forms/Reports
- Transactions Available for Reconciliation Report
Applicable Templates:
Pivot: Transactions Available by Bank Account, Source and Type
Source: Transactions Available for Reconciliation Report (CEXAVTRX)
DB package: CE_CEXSTMRR_XMLP_PKG (required to initialize security) | Cash Management Enginatics, R12 only | |
| CST Department Overhead Rate Upload | CST Department Overhead Rate Upload
===================================
This upload can be used to
- Upload new Department Overhead Rates
- Download the current Department Overhead Rates for a Cost Type, update, and upload the amended rates
- Download the current Department Overhead Rates from a Source Cost Type and upload them to a different Target Cost Type
- Delete existing Department Overhead Rates
Department Overhead Rates associate Overhead sub-elements with Departments and specify the rate or amount charged, per basis (Item, Lot, Resource Units, or Resource Value). The rates are… full description | Cost Management Enginatics, R12 only, Upload | |
| CST Item Average Cost Upload | CST Item Average Cost Upload
============================
This upload supports the uploading of item average costs for organizations using the Average Costing Method.
The upload delivers equivalent functionality to the Average Cost Update form in Oracle EBS
(At this time the upload does not support value change quantity adjustments).
Upload Mode:
Use the “Create” upload mode to generate an empty excel into which you can paste the average cost updates to be uploaded.
Use the “Create, Update” upload mode if you wish to download the current average costs for a specified set of items into… full description | Cost Management Enginatics, Upload | |
| CST Item Standard Cost Upload | CST Item Standard Cost Upload
=============================
This upload can be used to
- Upload New Item Costs
- Download the current Item Costs, Update, and Upload the amended item costs for a specified Cost Type
- Download the current item Costs from one Source cost type, update, and upload the amended item costs to a different Target Cost Type
NOTE:
You can only upload costs to cost types that are not flagged as frozen and are flagged as updateable. This upload is used for updating cost types using the standard costing method.
Optionally, the upload can perform a Cost Rollup after the… full description | Cost Management Enginatics, R12 only, Upload | |
| CST Resource Overhead Association Upload | CST Resource Overhead Association Upload
========================================
This upload can be used to
- Upload new Resource Overhead Associations
- Download the current Resource Overhead Associations for a Cost Type and upload them to a different Target Cost Type
- Update the descriptive flexfield attributes of existing associations by re-uploading them in 'Remove and replace' mode
- Delete existing Resource Overhead Associations
Resource Overhead Associations link Resource or Outside Processing sub-elements to the Overhead or Material Overhead sub-elements they absorb. The… full description | Cost Management Enginatics, R12 only, Upload | |
| CST Resource Rate Upload | CST Resource Rate Upload
========================
This upload can be used to
- Upload new Resource Rates
- Download the current Resource Rates for a Cost Type, update, and upload the amended rates
- Download the current Resource Rates from a Source Cost Type and upload them to a different Target Cost Type
- Delete existing Resource Rates
Resource Rates apply to rate based Resource and Outside Processing sub-elements (sub-elements whose charge basis is not currency based). The rates are imported via the Oracle Cost Import Process.
NOTE:
You can only upload rates to cost types that are not… full description | Cost Management Enginatics, R12 only, Upload | |
| DBA ASM Disk Groups | Automatic Storage Management disk groups used by the database, with their redundancy, total and free space.
All sizes are shown in MB.
Usable File Mb is the space available for new files after mirroring. A negative value means that the disk group cannot restore full redundancy after a disk failure.
The report returns no rows when the database does not use ASM. | System Enginatics | |
| DBA Automated Maintenance Tasks | There are several automated jobs and 'advisors' running by default in an Oracle database that are often not required or should not run in Oracle EBS environments. Their status and history can be queried by the following SQLs:
select dao.* from dba_autotask_operation dao
select dajh.* from dba_autotask_job_history dajh
- Automatic Optimizer Statistics Collection
For EBS, the automated DB statistics collection must be deactivated by setting DB initialization parameter _optimizer_autostats_job=false, and concurrent 'Gather Schema Statistics' scheduled instead, see note KA1002… full description | System Enginatics | |
| DBA CPU Benchmark1 | Benchmark report to measure a database server's CPU speed, mainly for PLSQL processing.
This report generates an output file of 500000 out of a total of 561495 records from a cartesian product based on EBS standard FND tables. These tables contain the same data for all EBS clients and the report can be used as a benchmark to test the database server's CPU performance.
As the query itself should complete in less than a second, most of the execution time is spend in PLSQL code to generate the Blitz Report output file.
To measure meaningful results, there should be enough SGA memory assigned to… full description | System Enginatics | |
| DIS Converter Diagnostic Dump | Diagnostic dump of all metadata and flattened staging data needed to reproduce the xxen_xdo Discoverer-to-Blitz conversion logic offline.
Outputs a single result set with rows discriminated by the data_type column. Each row populates only the columns relevant to its data_type; all others are null. The dump is used by a Python parser to investigate why workbook or worksheets in discoverer eex files are not converted into Blitz templates or reports
Data types emitted: OBJECT_USE_KEY (one per object_use_key in scope, with link to existing Blitz report if imported), WORKBOOK_LINK… full description | Enginatics | |
| DIS Migration identify missing EulConditions | This report identifies the missing EUL conditions defined at the folder level. | Enginatics | |
| DIS Workbook Conversion Selection | Lists the Discoverer workbook xmls uploaded to Blitz Report (Setup>Tools>Import>XML Upload), enriched with information supporting the decision which workbooks to convert: latest run date, run count and distinct users from the end user layer's usage statistics, last update and creation date from the workbook definition, owner, description and sheet count.
Set Convert Workbook to Yes for each workbook that should be converted to Blitz Report and upload the file. The selection is stored on the staged workbook xml, and the 'Blitz Report Discoverer Import' concurrent program converts the selected… full description | Enginatics, Upload | |
| DIS Workbook Owner Export Script | This export of workbook owners is required to remotely export workbook XMLs on the Enginatics environments for customers requiring support when migrating from Discoverer to Blitz Report. | Enginatics | |
| EAM Asset Activity Association Upload | EAM Asset Activity Association Upload
=====================================
- Create new associations between an Activity item and an Asset Group, specific Asset Number (serial instance), or Rebuildable item.
- Update existing association attributes (dates, priority, owning department, WIP class, DFF, etc.).
- Deletion is not supported by the public API in v1.
Prerequisites
=============
- The Activity item (eam_item_type=2) must already exist in the maintenance organization. Use the INV Item Upload to create Activity items.
- For Asset Group associations, the Asset Group (eam_item_type=1)… full description | Manufacturing Enginatics, R12 only, Upload | |
| EAM Asset Attribute Upload | Create and update Oracle Enterprise Asset Management asset attribute values, the attribute group values of an asset or rebuildable number.
Attribute groups are assigned to an asset group (Enterprise Asset Management: Asset Groups, Attributes) and their values are entered per asset number in the Asset Attributes window. Each row uploads one attribute group of one asset number, so an asset with several attribute groups has one row per group.
The attribute columns follow the flexfield segments of the selected attribute group: Attribute 1-20 hold the character segments, Number Attribute 1-10… full description | Manufacturing Enginatics, Upload | |
| EAM Asset Number Upload | Create and update Oracle Enterprise Asset Management asset numbers (maintenance assets). Parent Asset Number places the asset in the asset hierarchy; clearing it on an existing asset removes the parent. Parent Asset Serial Number and Parent Asset Id follow the parent asset number and are read only.
An existing asset is identified by its Asset Id, so its Asset Number can be changed. Current Location Address lists the addresses of the TCA locations, as the Update Asset page does; an address that exists more than once carries the location id in brackets. | Manufacturing Enginatics, R12 only, Upload | |
| EAM Failure Codes Upload | Create, update, and delete EAM failure codes, cause codes, and resolution codes.
Upload Mode
===========
Create
------
Opens an empty spreadsheet to define new codes.
Create, Update
--------------
Downloads existing codes for review and modification, and allows adding new rows.
Code Type
=========
Determines which of the three code tables is affected:
- Failure Code (stored in eam_failure_codes)
- Cause Code (stored in eam_cause_codes)
- Resolution Code (stored in eam_resolution_codes)
Codes are global - not scoped to any operating unit.
Fields
======
- Code Type: Required.… full description | Manufacturing Enginatics, R12 only, Upload | |
| EAM Failure Sets Upload | EAM Failure Sets Upload
=======================
Creates and updates Oracle EAM (Enterprise Asset Management) Failure Sets, along with their Asset-Group Item Associations and Failure/Cause/Resolution Combinations.
One Set Name can own many child rows (Associations and Combinations). A SET row defines the header explicitly. For Create rows, the upload also creates the missing failure set header automatically from the first ASSOCIATION or COMBINATION row for that Set Name.
Row Type
--------
- SET: Creates or updates the failure set header (set_name, description, effective_end_date).
-… full description | Manufacturing Enginatics, R12 only, Upload | |
| EAM PM Schedule Upload | EAM Preventive Maintenance Schedule Upload
=========================================
Create or update Oracle EAM Preventive Maintenance schedule definitions, including:
- PM Schedule header (asset or asset group, activity, schedule name, set name, type, rescheduling point, etc.)
- Activity group (for Rule Based schedules: list of activities with interval multiples)
- Scheduling rules: Day Interval, Runtime / Meter, and List Date rules
- Optional Last Service info (per meter)
Row Model
=========
Each spreadsheet row can contain PM header values plus any populated child-object columns.… full description | Manufacturing Enginatics, R12 only, Upload | |
| EAM PM Schedule Upload 11i | EAM Preventive Maintenance Schedule Upload
=========================================
Create or update Oracle EAM Preventive Maintenance schedule definitions, including:
- PM Schedule header (asset or asset group, activity, schedule name, set name, type, rescheduling point, etc.)
- Activity group (for Rule Based schedules: list of activities with interval multiples)
- Scheduling rules: Day Interval, Runtime / Meter, and List Date rules
- Optional Last Service info (per meter)
Row Model
=========
Each spreadsheet row can contain PM header values plus any populated child-object columns.… full description | Manufacturing Enginatics, Upload | |
| EAM Work Orders 11i | Enterprise asset management work orders including asset and cost information | Manufacturing Enginatics | |
| FA Asset Impairments | Source: Asset Impairment Report
Short Name: FAXRASIM
DB package: | Assets Enginatics, R12 only | |
| FA Asset Inventory 11i | Imported Oracle standard asset inventory report
Source: Asset Inventory Report (XML)
Short Name: FAS410_XML
DB package: FA_FAS410_XMLP_PKG | Assets Enginatics | |
| FA Asset Inventory Report | Application: Assets
Source: Asset Inventory Report (Enginatics) | Assets Enginatics | |
| FA Asset Upload | Upload to create, update, and retire fixed assets using FA Public APIs.
New assets are created via fa_addition_pub.do_addition. Existing assets are updated via fa_asset_desc_pub.update_desc, fa_reclass_pub.do_reclass, and fa_adjustment_pub.do_adjustment.
Asset retirements are processed via fa_retirement_pub.do_retirement; after uploading retirements, run the Calculate Gains and Losses program to finalize them and post the gain/loss.
Use the Record Type column to select Addition or Retirement processing. Fully retired assets are excluded from the list unless Include Retired Assets is set to… full description | Assets Enginatics, Upload | |
| FA CIP Assets and Invoices | CIP (Construction in Progress) assets with invoice details.
Shows asset master information (category, location, tag, cost) alongside AP invoice lines that feed into CIP.
Run as-is for invoice-level detail,
or pivot/group in Excel for an asset-level summary - Use template Asset Summary
Covers the use cases of:
- Monthly CIP Report - Asset Details (CapEx)
- Monthly CIP Report - CIP Invoice Activity | Assets Enginatics | |
| FA Fixed Assets Book | Assets held in a depreciation book with their cost, depreciation and net book value as at the end of the selected period.
Replaces the Oracle standard RXi: Fixed Assets Book report. The rows are extracted by the same routine its RX-only: Fixed Assets Book data program uses, so cost and depreciation figures are identical. The two seeded RXi attribute sets, Default and Book Details, are shipped as the templates of the same names; each puts the asset detail on the report sheet and the RXi group subtotals on a pivot sheet beside it.
One row per asset distribution, so an asset split over several… full description | Assets Enginatics, R12 only | |
| FA Mass Additions Upload | Maintains Oracle Assets Prepare Mass Additions queue lines.
Use the Operation column to choose what each row does: Update (change fields and/or Queue), Create (add a new mass addition line), Merge, Split, Unsplit, Add to Asset or Undo Add to Asset.
Queue (Post, On Hold, Delete, On-Review) sets the posting status of the line on an Update.
Merge combines the lines that share a Merge Group label into the one row marked Primary Line = Yes; that line is kept as the asset and accumulates the cost of the other lines (and their units when Sum Units = Yes), and is set to On Hold.
The Attribute… full description | Assets Enginatics, Upload | |
| FA Mass Additions Upload 11i | Maintains Oracle Assets Prepare Mass Additions queue lines.
Use the Operation column to choose what each row does: Update (change fields and/or Queue), Create (add a new mass addition line), Merge, Split, Unsplit, Add to Asset or Undo Add to Asset.
Queue (Post, On Hold, Delete, On-Review) sets the posting status of the line on an Update.
Merge combines the lines that share a Merge Group label into the one row marked Primary Line = Yes; that line is kept as the asset and accumulates the cost of the other lines (and their units when Sum Units = Yes), and is set to On Hold.
The Attribute… full description | Assets Enginatics, Upload | |
| FND Attached Documents (Operating Unit Secured) | Attachments of operating unit striped documents: sales orders and lines, purchase orders, lines, shipments and releases, requisitions, AP invoices, AR transactions, projects and delivery details. Each row shows the document the attachment belongs to, its category, title, file name and a clickable download link for file attachments. Short text, long text and URL attachments are shown inline.
The report is secured by operating unit: only documents of the operating units accessible to the running responsibility (profile options MO: Security Profile or MO: Operating Unit) are returned, so it can… full description | System Enginatics, R12 only | |
| FND FNDLOAD Object Transfer | Generates FNDLOAD download and upload linux commands for automated setup transfer between environments | System Enginatics | |
| FND Flex Hierarchies (Rollup Groups) | Flex value sets with rollup groups | System Enginatics | |
| FND Flex Value Upload | Upload to create or update flex values for Independent, Dependent, Translatable Independent, and Translatable Dependent value sets.
Supports:
- Value creation and update (auto-detects via fnd_flex_values_pkg.load_row upsert)
- Enabled flag, start/end dates
- Summary flag (parent/child designation)
- Rollup group assignment for parent values
- Compiled value attributes (qualifier values for KFF segments, e.g. GL Account Type, Allow Posting)
- Hierarchy level
- Attribute sort order
- DFF attributes (ATTRIBUTE1..50)
- Translatable value meaning and description (for Translatable… full description | System Enginatics, Upload | |
| FND Lobs | Generic file manager lob data, such as attachments, help files, imported and exported Blitz Report files etc. | System Enginatics | |
| FND Lookup Upload | This upload allows the user to
- download and update lookup codes against existing Lookup Types.
- add new lookup codes to existing Lookup Types.
- create new Lookup Types and upload the lookup codes against these new Lookup Types.
The upload of FND Lookup Types and Lookup Codes is in the users current language.
Only User and Extensible Lookup Types can be maintained by this upload.
For Extensible Lookup Types, seeded Lookup Codes canot be updated.
For Creating/Updating Lookup Codes only against an existing Lookup Type, use template:
Lookup Codes - Create/Update Lookup Codes only
For… full description | System Enginatics, Upload | |
| FND Lookup Values Comparison between environments | Compares lookup values between the local and a remote database environment | System Enginatics | |
| FND Menu Entry Upload | Upload to create, update and delete menu entries in FND Menus.
Useful for adding entries to existing menus, e.g. during Supply Chain Hub installation.
Upload Modes
============
Create
------
Opens an empty spreadsheet where the user can enter new menu entries.
Create, Update
--------------
Downloads existing menu entries matching the Menu Name filter for review and update.
New rows can be added to create additional entries in the same upload.
Fields
======
- User Menu Name: Display-only. Shows the translatable menu name.
- Menu Name: Required. The internal menu name (e.g. INV_NAVIGATE).
-… full description | System Enginatics, Upload | |
| FND Menus | Lists all Oracle E-Business Suite menus (FND_MENUS) together with the number of responsibilities that reference each menu.
The Responsibility Count column shows the total number of responsibilities pointing at the menu; Active Responsibility Count excludes end-dated responsibilities.
Use the Assigned To Responsibility parameter to find the menu behind a specific responsibility, or Menus With Responsibilities Only to hide unused menus. Results are ordered by responsibility count so the most widely used menus appear first. | System Enginatics | |
| FND Profile Option Value Upload | Upload to create, update and delete profile option values on site, application, responsibility, server, operating unit and user level, as in the System Profile Values form. Levels that the profile option definition does not allow to update are not offered.
The Value column shows and accepts the visible value of profile options validated by a list of values, e.g. a responsibility name instead of its id. Its list of values is derived from each profile option's SQL validation. A stored value is accepted as well. A few validations cannot be evaluated outside the profile form, e.g. because they… full description | System Enginatics | |
| FND Responsibility Upload | Create and update Oracle E-Business Suite responsibilities, and maintain their menu/function exclusions, replicating the System Administrator Responsibilities form (FNDSCRSP).
Each row is one of two entity types, chosen in the Row Type column:
- Responsibility: creates or updates the responsibility definition (Name, Application, Key, Description, Effective Dates, Available From, Data Group, Menu, Request Group, Web Host/Agent Name). Responsibilities are identified by Application + Responsibility Key. A responsibility is created when that combination does not yet exist, otherwise it is… full description | System Enginatics, Upload | |
| FND Tables and Columns | Registered FND tables, columns, primary keys and their flexfields | System Enginatics | |
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…