Blitz Report™ Library
238 reports
| Description | Download | ||
|---|---|---|---|
| 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 Vertical Plan | ASCP: Vertical Plan from the Planners Workbench. | Enginatics, R12 only | |
| 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. | 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. | 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 | 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 | 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. | 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. | 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. | 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). | 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. | 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. | 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. | 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. | 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. | 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) | 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. | 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 | Enginatics, R12 only | |
| PA Project Expenditure Items with WIP and INV Detail | Project expenditure items showing WIP and inventory transaction details including transaction types, quantities, WIP job, assembly, department, resource, and inventory item information. | Enginatics, R12 only | |
| PA Supplier Invoice Audit | AP invoices charged to projects showing vendor, invoice, cost distribution, and GL transfer details for supplier expenditure audit. | Enginatics, R12 only | |
| PER Security Profiles | Security profiles and operating units that they give access to. | Enginatics, R12 only | |
| PN Schedule Approval Status Upload | Property Management - Schedule Approval Status Upload
This upload allows users to Approve (Approved status), Un-Approve (Draft status), or place On Hold Payment and Billing Schedules in Property Management. This upload offers the same functionality as the Oracle Authorize Payments and the Authorize Billings forms.
Upload Mode
=================
When run in “Create, Update” mode, the Payment/Billing Schedules matching the criteria specified in the report parameters will be downloaded into Excel where the user can review and amend the Payment/Billing Approval Status and, for approved… full description | Enginatics, R12 only, Upload | |
| PO Invoice Price Variance | Imported Oracle standard Invoice Price Variance report
Application: Purchasing
Source: Invoice Price Variance Report
Short Name: POXRCIPV | Enginatics, R12 only | |
| PO Purchase Price Variance | Imported Oracle standard Purchase Price Variance report
Source: Purchase Price Variance Report (XML)
Short Name: POXRCPPV_XML
DB package: PO_POXRCPPV_XMLP_PKG | Enginatics, R12 only | |
| PO Supplier Scheduling On-Time Delivery | Supplier on-time delivery (OTD) based on the Oracle Supplier Scheduling (CHV) module instead of the purchase order form. For each firm scheduled release the report compares the scheduling-module requested delivery date against the actual goods receipt date and reports the delivery delay, ordered vs received quantity, and a partial-delivery flag. Designed for environments where the blanket PO holds only a skeleton (with placeholder dates) and the real call-off dates arrive via EDI into Supplier Scheduling. First-pass draft - see version comments for open scoping items. | Enginatics, R12 only | |
| QP Modifier Details | Imported from BI Publisher
Description: Modifier Details Report for QP
Application: Advanced Pricing
Source: Modifier Details (XML)
Short Name: QPXPRMLS_XML
DB package: QP_QPXPRMLS_XMLP_PKG
he Modifier Details (columns) are repeated across all rows pertaining to the Modifier
The List Line Details (columns) are repeated across all rows pertaining to the List Line
For a given modifier the row sequence is:
- Modifier Level Qualifiers (sorted by qualifier group, qualifier grouping number)
- Modifier List Lines (sorted by list line number)
For each Modifier List the row sequence is:
- List… full description | 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 | Enginatics, R12 only | |
| XLA Distribution Links Summary | Summary of subledger distribution links for developers to understand which source_ids are populated for which subledger table sources.
The link to subledger tables for different source_distribution_type values is described e.g. MOS Doc IDs for:
AP KB202448 https://support.oracle.com/support/?kmContentId=813968
FA KB721213 https://support.oracle.com/support/?kmContentId=2002464
PA KB160029 https://support.oracle.com/support/?kmContentId=1274575
For GMF, there is
AP and PO Accrual Reconciliation Report Debugging from OPM Financials KB775263… full description | Enginatics, R12 only | |
| XLA Entity ID Mappings | Shows the column link between table xla_transaction_entities and subledger source tables such as and AP invoice_id or AR customer_trx_id, used when writing queries linking GL to subledger such as the GL Account Analysis report www.enginatics.com/reports/gl-account-analysis/ | Enginatics, R12 only | |
| XLA Entity Types and Event Class Attributes | Subledger event types and their attributes, for example reporting view | Enginatics, R12 only | |
| XLA OPM Event Type Summary | Enginatics, R12 only | | |
| XLA Subledger Accounting Rules Detail Listing | Lists the complete Subledger Accounting rule setup in one flat grid, combining the seven separate queries of the Oracle standard XLASARDLR Subledger Accounting Rules Detail Listing BI Publisher report.
There is one row per journal line type and account derivation rule priority, so the accounting method, application accounting definition, event class and type, journal line definition, journal line type, segment, derivation rule, its priority, condition and derived value all sit on the same row and can be filtered and pivoted directly.
Journal line type and account derivation rule conditions… full description | Enginatics, R12 only | |
| XLA Subledger Period Close Exceptions | Imported from BI Publisher
Description: This report extracts all those events which are either untransferred or are not accounted for.
Application: Subledger Accounting
Source: Subledger Period Close Exceptions Report
Short Name: XLAPEXRPT
DB package: XLA_PERIOD_CLOSE_EXP_PKG | Enginatics, R12 only | |
| XLE Establishment and Legal Entity Associations | Master data report showing the legal entity associations to other business entities such as:
- Legal Entities
- Operating Units
- Inventory Organizations
- Inventory Locations
- Bill To Locations
- Ship To Locations
- Balancing Segment Values | Enginatics, R12 only | |
| XLE Legal Entities | Legal entities, establishments, jurisdictions and registrations | Enginatics, R12 only | |
| ZX Financial Tax Register | Imported from Concurrent Program
Description: Rx-only: Financial Tax Register
Application: E-Business Tax
Source: RX-only: Financial Tax Register Report
Short Name: RXZXPTEX | Enginatics, R12 only | |
| ZX Lines Summary | Tax lines summary to understand the different applications, entity codes and events that generate tax lines | Enginatics, R12 only | |
| ZX Party Tax Profiles | E-Business Tax party tax profiles and tax registration details | Enginatics, R12 only | |
| ZX Tax Accounts | E-Business Tax account configuration for all ledgers and operating units, setup on either tax, jurisdiction or rate level | Enginatics, R12 only | |
| ZX Tax Regimes | E-Business Tax tax regime and party subscription setup | Enginatics, R12 only | |
| AP Distribution Set Upload | Creates and updates Payables distribution sets and their lines - the Excel equivalent of the Distribution Sets form (Setup > Invoice > Distribution Sets).
Each row is one distribution set line, with the distribution set header columns repeated on every line. The header values are taken from the first row of each distribution set. Leave the line columns blank to create or update a distribution set header only.
Each distribution set is processed as a whole: the percentages of all its lines, including existing lines not in the upload file, must add up to 100 (Full) or to 0 (Skeleton),… full description | Enginatics, R12 only, Upload | |
| AP Intercompany Invoice Details | AP Intercompany Invoice Details When India Localization is installed, the following GST columns are also included: CGST Amount, SGST Amount, IGST Amount, Custom Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code, CGST Rate, SGST Rate, IGST Rate, GST Supplier Registration No, GST Registration No, GST PAN No, GST TAN No. | Enginatics, R12 only | |
| AP Invoice Hold Upload | Releases and places AP invoice holds in bulk - the Excel equivalent of the Invoice Workbench Holds tab.
Download the open holds with the download parameters, pick a Release Name (and optionally overwrite the defaulted Release Reason) on the rows to release, and upload. Each hold row is released through the same Oracle logic as the form, including the invoice holds workflow abort, the hold business event and the E-Business Tax synchronization. To place a new manual hold, add a row with the invoice reference and a Hold Name, leaving the Release Name blank.
Holds are identified by Operating… full description | Enginatics, R12 only, Upload | |
| AP Invoice Payment Upload | Records Manual and Quick payments of open Payables invoices and voids payments - the Excel equivalent of entering a payment and its invoices in the Payments window.
Each row is one invoice installment paid, with the payment columns repeated on every row. Rows with identical payment columns are paid by one payment. Amount Paid and Discount Taken default to the full amount remaining less the discount available at the Payment Date, and can be reduced to pay an installment partially.
Each payment is processed as a whole: when any of its rows fails validation, none of its rows are saved. A… full description | Enginatics, R12 only, Upload | |
| AP Invoices with PO, Intercompany and SLA Details | AP Invoices with PO, Intercompany and SLA Details
When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, GST TAN No, CGST Amount, SGST Amount, IGST Amount, CESS Amount, Custom Amount, Unclassified Tax Amount, Non-Recoverable GST, Taxable Value, HSN SAC Code, CGST Rate, SGST Rate, IGST Rate, CESS Rate, CGST Recoverable, CGST Non-Recoverable, SGST Recoverable, SGST Non-Recoverable, IGST Recoverable, IGST Non-Recoverable, Reverse Charge Flag, Place of Supply, Ship From State. | Enginatics, R12 only | |
| AP Period Close Exceptions | Based on Oracle standard Period Close Exceptions Report
Source: Period Close Exceptions Report (XML)
Short Name: APXPCER
DB package: ap_period_close_pkg | Enginatics, R12 only | |
| AP Posted Invoice Register | Application: Payables
Description: Payables Posted Invoice Register
This report provides equivalent functionality to the Oracle standard Payables Posted Invoice Register report.
For scheduling the report to run periodically, use the relative period from/to offset parameters. These are the relative period offsets to the current period, so when the current period changes, the included periods will also automatically be updated when the report is re-run.
Templates
- Pivot: Summary by Account, Invoice Currency
Equivalent to standard report in Summarize Report = Yes Mode
- Pivot: Summary by… full description | Enginatics, R12 only | |
| AP Posted Payment Register | Application: Payables
Description: Payables Posted Payment Register
This report provides equivalent functionality to the Oracle standard Payables Posted Payment Register report.
For scheduling the report to run periodically, use the relative period from/to offset parameters. These are the relative period offsets to the current period, so when the current period changes, the included periods will also automatically be updated when the report is re-run.
Templates
- Pivot: Summary by Account
Equivalent to standard report in Summarize Report = Yes Mode
- Pivot: Summary by Account, Bank… full description | Enginatics, R12 only | |
| AP Prepayments Status | Prepayments with an unapplied amount and the open, that is unpaid or partially paid, invoices, credit and debit memos of the suppliers holding such a prepayment, one row per invoice.
Equivalent to the Oracle standard Prepayments Status Report (APXINPSR). Amount Remaining is in the invoice currency: for a prepayment the amount not yet applied, for other invoices the unpaid payment schedule amount converted at the payment cross rate. Net Amount Remaining nets paid temporary prepayments (negative) against open invoices and permanent prepayments; an unpaid prepayment counts as zero.
Show… full description | 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…