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
841 reports
| Description | Download | ||
|---|---|---|---|
| JTF Grid Datasources | JTF grid (CRM spreadtable) datasource and column definition | 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 | |
| MSC Exceptions | ASCP: Export Planning Exceptions from the Planners Workbench. | Enginatics, R12 only | |
| MSC Horizontal Plan | ASCP: Horizontal Plan from the Planners Workbench.
Note:
The number of Items included in the HP is restricted by the parameter ‘Item Restriction Limit’. This parameter defaults from the profile option ‘MSC: HP Maximum Displayed Item Count’ in the ASCP Planning Instance. The value set in the Item Restriction Limit parameter will override the value specified in profile option. | Enginatics, R12 only | |
| MSC Pegging Hierarchy | ASCP Pegging Hierarchy. This reports shows the pegging hierarchy from the Top Level Demand. | Enginatics | |
| MSC Vertical Plan | ASCP: Vertical Plan from the Planners Workbench. | Enginatics, R12 only | |
| OKC Contract Lines Summary | Summary of okc line style hierarchies, the jtf objects linked to each line level and the active and overall count of contract lines by status for each line type.
This is useful for developers to see how the oracle contracts line data is structured and how the link to external objects, e.g. installed base or counters for service contracts works | Enginatics | |
| OKL Termination Quotes | Information on lease termination quotes | Enginatics | |
| OKS Service Contracts Billing History | Service Contracts billing history with invoicing and accounting rules, bill action, billed period dates, amounts and counter reading details for usage billing.
When running service contracts billing, there is always a full set of records created in the following billing history tables:
oks_bill_cont_lines obcl
oks_bill_sub_lines obsl
oks_bill_sub_line_dtls obsld
oks_bill_transactions obt
oks_bill_txn_lines obtl
This set of records is complete down to subline level obsl/obsld, regardless if the billed contract line type has a subline or not.
For subscription lines (lse_id=46,… full description | Enginatics | |
| OKS Service Contracts Billing Schedule | Service Contracts billing schedule with invoicing and accounting rules, and detailed to be billed period dates and amounts from the stream level elements table oks_level_elements.
Column date_competed is used to identify open or already billed records and date_to_interface is used by the service contracts billing program to identify the records to be billed at any given date.
For advance billing, date_to_interface is set to the beginning of the billing period and for arrears, it is set to the end. When creating new billing schedule record for past periods (that should have been billed… full description | Enginatics | |
| ONT Blanket Sales Agreements | Blanket sales agreements, one row per agreement line, with the minimum and maximum quantity and amount, and the quantity and amount released, fulfilled and returned by the sales order lines that reference the agreement.
Remaining is the maximum plus the returned less the released quantity or amount, the limit that Order Management validates new releases against. Agreement level amounts are shown on the first line of each agreement only, so that they can be summed. Releases counts the sales orders with a not cancelled line released against the agreement line.
Use ONT Orders and Lines with… full description | Order Management Enginatics | |
| ONT Cancelled Orders | Imported from BI Publisher
Description: Cancelled Orders Report
Application: Order Management
Source: Cancelled Orders Report (XML)
Short Name: OEXOEOCS_XML
DB package: ONT_OEXOEOCS_XMLP_PKG | Order Management Enginatics | |
| ONT Defaulting Rules | Shows the complete Order Management defaulting rules setup | Order Management Enginatics | |
| ONT Order Holds | Detail Sales Order report with line item details for all order lines that are on hold and the reason for the hold. | Order Management Enginatics | |
| ONT Orders | Detail Sales Order or Quote header report, including status, amount and invoice status information. | Order Management Enginatics | |
| ONT Orders and Lines | Detail Sales Order or Quote header report with line item details including status, cost, project and shipping information.
Show Sales Credits adds one row per sales credit of each line, taken from the line, or from the order header for lines without sales credits of their own. Credited Amount is the line extended price times the credit percent and is shown once per line and credit, so it can be summed by salesperson; the other amount columns stay on one row per line.
Show Order to Cash Details adds the booked date and open holds of each line, and for the line's latest invoice the due date,… full description | Order Management Enginatics | |
| ONT Price Adjustments and Charges | Price adjustments applied to sales orders: discounts, surcharges, price breaks, promotional goods and freight and special charges, one row per adjustment of an order header or line.
Extended Amount is the unit adjustment times the ordered quantity, a lumpsum charge once per line. Discounts and credits are negative, and line amounts of return lines carry the reverse sign, as in ONT Orders and Lines.
Order level modifiers are stored once per order without a line. The line selling prices include their effect, but Oracle stores no amount for it, so Unit Adjustment and Extended Amount are blank… full description | Order Management Enginatics | |
| ONT Recurring Billing Plan | Profile report showing the Sales order recurring billing plan for header and line details including status, frequency, billing period, billing amounts and dates. | Order Management Enginatics, R12 only | |
| ONT System Parameters | Order Management Enginatics | | |
| ONT Transaction Types Listing | Imported Oracle standard Order Management transaction types listing, enhanced to show the setup across all operating units
Description: Transaction Types Listing Report
Application: Order Management
Source: Transaction Types Listing Report (XML)
Short Name: OEXORDTP_XML
DB package: ONT_OEXORDTP_XMLP_PKG | Order Management Enginatics | |
| ONT Transaction Types and Line WF Processes | Master data report showing the setup of order management transaction types and associated line types and workflow processes. | Order Management 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 | |
| PA Capital Project Summary with Asset Detail | Detail project report that shows the project asset details, and combined project level costs breakdown, along with the project assets details from the Capital Summary | Projects Enginatics, R12 only | |
| PA Cost Audit | Project cost distribution lines transferred to GL showing DR/CR accounts, amounts, transfer status, and GL dates for audit and reconciliation purposes. | Projects Enginatics | |
| PA Expenditure Types | Listing of project expenditure types with their category, type class, unit of measure, and active dates. | Projects Enginatics | |
| PA Invoice Review | Project draft invoices with line details showing invoice amounts, approval and release status, customer, GL date, and expenditure type breakdown. | Projects Enginatics | |
| PA Project Asset Details | Capital project asset information showing CIP costs, capitalized amounts, FA asset numbers, estimated and actual in-service dates, and asset line transfer status. | Projects Enginatics | |
| PA Project Billing Status | Project billing overview showing revenue, billed and unbilled amounts, funding totals, and available funding for each project. | Projects 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…