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
30 reports
| Description | Download | ||
|---|---|---|---|
| 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 | |
| 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 | |
| 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 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 | |
| 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 | |
| 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 | |
| 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 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 | |
| OPM Formula Upload | OPM Formula Upload
==================
Create or update Oracle Process Manufacturing (OPM / GMD) Formulas via the public API GMD_FORMULA_PUB / GMD_FORMULA_DETAIL_PUB.
Row model
=========
One spreadsheet row per formula LINE. The header columns (Organization Code, Formula, Formula Version, Description, Class, Owner, Header Scale Type, Status, header attributes) repeat on every line of the same formula. Each line carries its Line Type (Ingredient / Product / By-Product) plus its item, quantity, UOM, scale, and line attributes. Rows of the same formula (Organization Code + Formula + Formula… full description | Manufacturing Enginatics, R12 only, Upload | |
| OPM Recipe Upload | Manufacturing Enginatics, R12 only, Upload | | |
| OPM Routing Upload | OPM Routing Upload
==================
Create or update Oracle Process Manufacturing (OPM / GMD) Routings via the public API GMD_ROUTINGS_PUB / GMD_ROUTING_STEPS_PUB.
Row model
=========
One spreadsheet row per routing STEP. The header columns (Organization Code, Routing, Routing Version, Description, Class, UOM, dates, owner, header attributes) repeat on every step of the same routing. Each step carries its Step No, Operation (No + Version), Step Quantity, Release Type, and step attributes. Rows of the same routing (Organization Code + Routing + Routing Version) must be contiguous. Every… full description | Manufacturing Enginatics, R12 only, Upload | |
| WIP Material Transaction Upload | Issues components to, and returns components from, WIP work orders.
The download returns one row per component requirement of the selected work orders, with the operation, department, supply subinventory and locator already filled in, and the required, issued and still open quantities shown. Enter a Transaction Type and a Quantity on the rows you want to transact and leave the rest blank.
Quantity is always entered as a positive number; the Transaction Type decides the direction.
Discrete jobs, lot based jobs and maintenance work orders are supported. Repetitive schedules are not.
Rows… full description | Manufacturing Enginatics, R12 only, Upload | |
| WIP Value Summary | Report to get the WIP and Material accounting distributions, by WIP job,period, Org .
It displays detailed information from both sources WIP and Material Transactions
Parameters:
===========
Period: To pull the transactions based on specific inventory period ( transaction_date).(mandatory)
Source: enter the source "WIP","Material" or "Both" you wish to report (mandatory).
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, typically the Inventory category set (optional).
Category Set 3: any… full description | Manufacturing 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…