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
215 reports
| Description | Download | ||
|---|---|---|---|
| BOM Bill of Material Structure | Description: Bill of Material Structure Report
Provides equivalent functionality to the the following standard reports:
- Bill of Material Structure Report
(Template 'Bill of Material Structure Report' with parameter 'Bills with Loop Errors Only' = No)
- Bill of Material Loop Report
(Template Bill of Material Structure Report with parameter 'Bills with Loop Errors Only' = Yes)
- Consolidated Bills of Material Report
(Template 'Consolidated Bill of Material Report')
Application: Bills of Material
Source: Bill of Material Structure Report GUI (XML)
Short Name: BOMRBOMSG_XML
DB package:… full description | Manufacturing Enginatics |   |
| BOM Calendar Exceptions | Master data report showing bill of material exceptions dates, exception types and organization code. | Manufacturing Enginatics | |
| BOM Calendars | Bill of material calendars and calendar dates | Manufacturing Enginatics | |
| BOM Routings | Master data report showing bill of material routings with item codes and sequences.
The report optionally shows the full routing detail matching the BOM Routing Upload: routing header attributes and revision, operation scheduling details, operation resources, substitute resources and flow routing operation networks. The detail levels are controlled by the Show Operations, Show Resources, Show Substitute Resources and Show Networks parameters, and the Record Type column identifies each row.
Descriptive flexfield attributes of the routing, routing revision and operation are shown as dynamic… full description | Manufacturing Enginatics | |
| EAM Assets | Enterprise asset management asset details such as location, department etc. | Manufacturing Enginatics, R12 only | |
| EAM Weekly Schedule | Based on Oracle standard's EAM Weekly Schedule report
Application: Enterprise Asset Management
Source: EAM Weekly Schedule report (XML)
Short Name: EAMWSREP_XML
DB package: EAM_EAMWSREP_XMLP_PKG | Manufacturing Enginatics, R12 only | |
| EAM Work Orders | Enterprise asset management work orders including asset and cost information | Manufacturing Enginatics, R12 only | |
| EAM Work Requests | Maintenance work requests with their asset, priority, requester and the work order created for them, one row per work request.
Days Open and Overdue apply to requests that are neither rejected nor complete. Overdue means the expected resolution date has passed.
Work order status is the system status of the linked work order. | Manufacturing Enginatics | |
| GMI Cycle Count Forms | Imported Oracle standard Cycle Count Forms Report of Oracle OPM PI report
Source: Cycle Count Forms (XML)
Short Name: PIR05_XML
DB package: GMI_PIR05_XMLP_PKG | Manufacturing Enginatics | |
| MRP End Assembly Pegging | Detail report for MRP pegging from final assembly to each component, including: planner, end demand pegged qty, demand and plan dates, supply quantity, and supply date. | Manufacturing Enginatics | |
| MRP Exceptions | Detail report for MRP Exception messages, including item, make or buy, default buyer, planner and exception message to use. | Manufacturing Enginatics | |
| MRP Financial Analysis | Imported from BI Publisher
Description: Financial Analysis Report
Application: Master Scheduling/MRP
Source: Financial Analysis Report (XML)
Short Name: MRPRPPIT_XML
DB package: MRP_MRPRPPIT_XMLP_PKG | Manufacturing Enginatics, R12 only | |
| MRP Horizontal Plan | MRP: Horizontal Plan from the Planners Workbench.
- The report can be run for multiple organizations and items within a selected plan
- The report can be used to explode BOMS and display the HP for all components
within the BOM
- Select a template to choose to either display the HP by individual components, or by
End Assemblies, Components. | Manufacturing Enginatics | |
| MRP Item Forecast | Detail report for item planning forecast, including forecast description, planner, item, bucket type, forecast start and end dates, current quantity, original qty, project related data, and confidence projection.
Show Consumption adds one row per sales order consumption of each forecast entry from the forecast consumption history: sales order, line, customer, ship-to, schedule date, order quantity, consumed quantity and the date the consumption was recorded. A negative consumed quantity reverses an earlier consumption, for example after an order line was cancelled or reduced.
With Show… full description | Manufacturing Enginatics | |
| MRP Item Forecast Upload | MRP Item Forecast Upload
================================
- Create New Item Forecast Entries.
- Update Existing Item Forecast Entries.
- Delete Existing Item Forecast Entries (Delete by setting the Forecast Quantity = 0).
Prerequisites/Restrictions
==========================
- Forecast Designators must be defined.
- Item Forecasts can only be uploaded to a Forecast, not a Forecast Set.
Upload Modes
============
Create
------
Opens an empty spreadsheet where the user can enter new Forecast Entries against any accessible Forecast.
Use the Organization Code, Forecast Set, Forecast Name… full description | Manufacturing Enginatics, Upload | |
| MRP Pegging | Detail report for MRP planning pegging showing the hierarchy from demand, including forecast, sales orders, work order to supply (WIP jobs, purchase orders and on hand stock) | Manufacturing Enginatics | |
| MRP Plan Orders | MRP: Export Supply and Demand Orders from the Planners Workbench. | Manufacturing Enginatics | |
| MRP Sourcing Rules and Bills of Distribution | Sourcing rules for all or a selected assignment set, along with with the item's make / buy flag and based on rollup flag for costing. You can either choose Organization or Vendor (Supplier) sourcing rules or get all sourcing rules by not selecting a sourcing rule type. | Manufacturing Enginatics | |
| OPM Batch Details and Status Summary | Oracle Process Manufacturing (OPM) batch details and status summary: one row per production batch showing batch status and type, recipe, primary product and planned/actual output quantity, planned versus actual start and completion dates, and whether the batch completed on time. Set a pending/released status with plan-date filters for a planned-production view. | Manufacturing Enginatics, R12 only | |
| OPM Batch Lot Cost Details | OPM Batch Lot Cost Details Report
This report shows the Batch Lot Costs details for completed batches in the specified from/to Date Range and for the specified Organization, Product, Formula Class (optional) and Batch (optional).
For each selected batch included in the report, the report details the lot cost details for that batch and for all child production batches consumed by that batch.
The quantities shown in the child batches are the actual quantities for that batch and it’s ingredients. This report does not apportion the child batch quantities based on the actual quantity consumed… full description | Manufacturing Enginatics, R12 only | |
| OPM Batch Lot Cost Trends | OPM Batch Lot Costing Trends Report
This report shows the Batch Lot Costs for the specified Organization and Product over a specified date range.
The report shows the Lot Cost for the batch product and explodes the batch to display all the lowest level ingredient lot costs involved in producing the batch.
Where an ingredient is sourced from another (child) batch, the (child) batch ingredient quantities are apportioned based on the actual usage of the ingredient in the batch consuming that ingredient.
By default, intermediate ingredients are not displayed in the report, so as not to… full description | Manufacturing Enginatics, R12 only | |
| OPM Batch Lot Genealogy | Oracle Process Manufacturing (OPM) batch lot genealogy as a multi-level tree, as shown in the Source and Where Used tabs of the Oracle Genealogy form.
Source walks from a lot through its producing batch to the ingredient lots, to any depth. Where Used walks from a lot through the consuming batches to the product lots. Each tree starts with its start lot at level 0.
Each row is a lot or batch with its level, lot status, grade, dates and the WIP issue or completion that created the link. Ended genealogy links are excluded.
Source, Supplier and Supplier Site show each lot's origination as in… full description | Manufacturing Enginatics | |
| OPM Batch Material Usage and Substitution Variance | Oracle Process Manufacturing (OPM) batch material usage and substitution variance: per-ingredient planned versus actual consumption per production batch, with usage variance, variance percentage, remaining quantity, scrap factor and a substitution indicator. Exposes over/under-consumption and material substitutions at the batch line level. | Manufacturing Enginatics, R12 only | |
| OPM Batch Steps and Resource Usage | Oracle Process Manufacturing (OPM) batch steps and resource usage: each production batch routing step with its status, planned versus actual step quantity and dates, and the planned versus actual usage, usage variance, count and UOM of each resource (machine / labor) on the step. Supports batch execution review and resource-efficiency analysis. | Manufacturing Enginatics, R12 only | |
| OPM Batch Yield Variance | Oracle Process Manufacturing (OPM) batch yield variance: compares planned versus actual product and by-product output quantities against total batch input, reporting quantity variance, variance percentage and planned/actual yield percentage - the key production yield KPI for completed batches. | Manufacturing Enginatics, R12 only | |
| OPM Detailed Subledger | OPM Financials Detailed Subledger Report showing transaction headers, extract lines with debit/credit amounts, and GL account distributions. Based on Oracle standard report GMFDSUR (Detailed Subledger Report). | Manufacturing Enginatics, R12 only | |
| OPM Formula Details | Oracle Process Manufacturing (OPM) Product Development formula details: the ingredient, product and by-product lines of each formula with quantities, UOM, scrap factor, scaling type, planned product percentage and yield contribution. Supports formulation review and data quality checks. | Manufacturing Enginatics, R12 only | |
| OPM Formula Where-Used | Oracle Process Manufacturing (OPM) formula where-used: lists which formulas consume a given ingredient item, with the ingredient quantity and UOM, the using formula and its status, the formula's primary product, and how many recipes use that formula. Supports ingredient impact analysis for substitution, supplier change and allergen / regulatory recall. | Manufacturing Enginatics, R12 only | |
| OPM Item Location Test Results | Oracle Process Manufacturing (OPM) Quality item/location test results: the QC test results recorded against inventory item, lot and subinventory samples, with the result value, the applicable specification minimum/target/maximum limits, an in-specification indicator and the sample disposition. The governing specification is resolved from the inventory spec validity rule effective for each sample's item, organization and lot. Answers what the lab results were for a given item or lot and whether they were in specification. | Manufacturing Enginatics, R12 only | |
| OPM Item Process and Recipe Attributes | Oracle Process Manufacturing (OPM) item attributes: for every process-manufacturing-enabled item, its recipe, process-execution, quality and costing enabled flags, grade control and default grade, lot / child-lot control, lot divisibility, and shelf-life control and days. Lets formulation and QA teams see which items are recipe and process enabled. | Manufacturing Enginatics, R12 only | |
| OPM Recipe Details | OPM (Process Manufacturing) recipe details combining recipe status, validity rules, preferences, formula product quantity and routing step / resource quantities. Supports data cleaning before cost roll up. Optionally shows an item category code via the Category Set parameter. | Manufacturing Enginatics, R12 only | |
| OPM Reconcilation | OPM Reconciliation Report.
Blitz Report implementation of the Oracle sql script: OPMRecon.sql
Reference MOS Document: OPM Inventory Balance Reconciliation (Doc ID 1510357.1) | Manufacturing Enginatics, R12 only | |
| OPM Specifications and Test Limits | Oracle Process Manufacturing (OPM) Quality specifications and test limits: every GMD specification with its version and status, the item and grade it applies to, and each specification test's minimum, target and maximum limits, UOM, certificate-of-analysis print flag and report precision. The master reference for an organization's quality standards. | Manufacturing Enginatics, R12 only | |
| QA Collection Plan Actions | Lists every action rule defined against an Oracle Quality collection plan - the trigger condition that fires the rule, the action it runs, the element it assigns, the alert it raises and the collection elements bound into its message - as a union of the rules attached to the collection plan itself and the rules defined on the collection element master, discriminated by an Action Level column. Trigger conditions that carry no action are listed too.
Oracle Quality evaluates these rules while quality results are entered. A rule is a trigger condition on one collection element - the element is… full description | Manufacturing Enginatics | |
| QA Collection Plan Element Values | Lists the allowed values behind every list-validated Oracle Quality collection element - the entries an operator can pick when entering quality results, and the collection element master values each plan was seeded from.
Oracle Quality holds these values in two independent places. A collection plan carries its own value list, and the collection element carries a master list. A plan is seeded from the master but is not tied to it afterwards: it can carry codes that were never in the master, override a master value's description, and leave master values out. The Value Level column says which… full description | Manufacturing Enginatics | |
| QA Collection Plan Elements | Every collection element assigned to an Oracle Quality collection plan, with the element's prompt and sequence on the plan, its element type, datatype, display length, decimal precision and unit of measure, the plan level and element level default values, and the Mandatory, Enabled, Displayed, Read Only, Information and Poplist flags. Collection plans that have no elements are listed too.
Oracle Quality stores every collection result generically in qa_results, whose character1 to character100 columns carry no meaning of their own: the element to column mapping is held per plan in… full description | Manufacturing Enginatics | |
| QA Collection Plan Relationships | Every Oracle Quality parent child collection plan relationship, at one row per parent element to child element mapping. Each row names both plans with their descriptions and plan types, the relationship type, the data entry mode and layout mode that govern how the child rows are presented, the automatic row count and default parent specification flag, and the element relationship operator that says what the parent value does to the child value, together with the plan level prompt of each mapped element. A relationship that has no element mapping yet is still listed, as a single row.
Oracle… full description | Manufacturing Enginatics | |
| QA Collection Plan Transactions | Every collection transaction an Oracle Quality collection plan is attached to, with the trigger conditions that decide whether collection actually fires, the Mandatory Collection, Background Collection and Enabled flags, and each trigger's field, database field, datatype, operator and low and high values. Attachments that collect unconditionally are listed too, with a blank Collection Trigger.
Attaching a collection plan to a transaction is what makes Oracle Quality collect anything at all: until a plan is attached to a transaction such as Receiving Transactions or Completion Transactions it… full description | Manufacturing Enginatics | |
| QA Collection Plans | One row per Oracle Quality collection plan, with the plan type, effective dates, instructions, specification assignment type, electronic signature mode and the template plan it was copied from, together with the names of the plan's generated results view and import view and counts of the elements, element values, transactions, transaction triggers, action rules, actions, child plans and parent plans that hang off it.
Oracle Quality stores every collection result generically in qa_results, and each plan gets its own dynamically generated results view and import view that map that plan's… full description | Manufacturing Enginatics | |
| QA Quality Results | One row per collection result and characteristic, so results from any number of collection plans stack in a single extract instead of one column per characteristic. Use Collection Plan like to pull a whole family of plans in one run, for example INC_MRC%.
Oracle Quality stores every element value as a string in a generic column of qa_results, and the plan's element definition decides which column holds which characteristic. Result is therefore text. Result Number carries the numeric conversion for Number elements so the values can be charted or averaged, and Date elements arrive as… full description | Manufacturing Enginatics | |
| WIP Account Distribution | Detail WIP report that lists resource transaction account distributions. | Manufacturing Enginatics | |
| WIP Discrete Job Shortage | WIP report that lists discrete job Open Requirements and/or Shortages.
Report Modes
==========
The report can be run in the following modes:
1. Open Requirements - Reports all Open Requirements
2. Shortage based on Net QOH - Reports requirements with shortages against Nettable Quantity Onhand
3. Shortage based on QOH - Reports requirements with shortages against Total Quantity Onhand
4. Shortage based on Supply Sub/Loc - Reports requirements with Shortages against Onhand Quantity in the same supply Subinventory/Locator as specified in the job requirement.
Shortages
=======
The report… full description | Manufacturing Enginatics | |
| WIP Entities | Detail WIP report that lists job, type, status, planner, item, item description, planning method, pegging type, entity, job Description, WIP resource transaction account distributions, project number, task, source code, source line item,Sales Order,Sales Order Line, WIP type, class code, scheduling dates, quantities, department, resource and organization.
Show Resources lists every resource requirement of an operation instead of its first resource only. Required units are the usage rate times the job start quantity less the operation's cumulative scrap for item basis, and the usage rate for… full description | Manufacturing Enginatics | |
| WIP Entities Summary | Overview of WIP entities of different types and their various statuses. | Manufacturing Enginatics | |
| WIP Move Transactions | WIP move transactions of discrete jobs, lot based jobs, repetitive schedules and flow schedules, one row per transaction, as shown in the View Move Transactions form.
The report covers the data of the Oracle standard Move Transaction Report (WIPTSMOV): from and to operation, department and intraoperation step, transaction and primary quantity, reason and reference, over-completion, scrap account and the employee who performed the move.
A repetitive move is shown once per repetitive schedule it was allocated to, with the schedule's first unit start date and the allocated quantity.
Quantity… full description | Manufacturing Enginatics | |
| WIP Outside Processing | Imported from BI Publisher
Description: WIP Outside Processing Report
Application: Work in Process
Source: WIP Outside Processing Report (XML)
Short Name: WIPLBOSP_XML
DB package: WIP_WIPLBOSP_XMLP_PKG | Manufacturing Enginatics, R12 only | |
| WIP Required Components | Detailed project WIP report that lists discrete jobs and required components. The parameter 'Show Shortage List' can be used to show a shortage list of existing discrete jobs (similar to Oracle's 'Discrete Job Shortage Report'.
| Manufacturing Enginatics | |
| WIP Resource Transactions | WIP resource, overhead and outside processing transactions, one row per transaction, as shown in the View Resource Transactions form.
Quantity is in the unit of measure the transaction was entered in, Primary Quantity in the resource's unit of measure.
Transactions still pending in the resource transaction interface are not included. | Manufacturing Enginatics | |
| 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 | |
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…