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 | ||
|---|---|---|---|
| PA Project Budget | Report of Standard Project Budgets. This report does not include Financial Plan Budgets.
In addition to the budget details, the report will also display the actuals matching the budget line datapoints.
Note: Inclusion of actuals data requires Blitz Report Build Data later than 04-APR-2025 03:21:50 | Projects Enginatics |   |
| 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. | Projects Enginatics, R12 only | |
| PA Project Status Summary | Project-level financial overview showing actual costs, revenue, labor hours, and commitments for each project with manager and status information. | Projects Enginatics | |
| PA Project Subledger Detail by Expenditure Type | Cost distribution lines summarized by project, task, expenditure type, and GL account showing raw cost, burden cost, and total cost for transferred and accepted lines. | Projects Enginatics | |
| PA Supplier Invoice Audit | AP invoices charged to projects showing vendor, invoice, cost distribution, and GL transfer details for supplier expenditure audit. | Projects Enginatics, R12 only | |
| PA Task Schedule | Summary project report showing operating unit, project, task, scheduled start date, scheduled finish date, created by, and last updated by. | Projects Enginatics | |
| PA Transaction Sources | Projects Enginatics | | |
| PAY Batch Element Entry | Batch Element Entry (BEE) batch lines with their batch header, line status, element, input values and validation or transfer messages.
Input Values lists the line's values with the input value names of the element in display sequence, which is the order in which BEE assigns Value 1 to Value 15.
Use Line Status Error to review lines that failed validation or transfer before correcting and revalidating the batch. | Payroll Enginatics | |
| PAY Costing Detail | Imported from Concurrent Program
Application: Payroll
Source: Costing Detail Report
Short Name: PAYRPCDR | Payroll Enginatics | |
| PAY Element Entries | Element entries and their input values valid at the Effective Date, for all assignments including non-primary assignments and the assignments of terminated employees whose entries are still valid at that date.
One row per element entry and input value, so that the values of an input value, for example Pay Value or Amount, can be filtered and summed across employees and elements. An entry without input values shows one row with blank input value columns.
Entry Value shows the meaning of lookup validated input values and dates in display format. Numeric Value holds the value of money, number,… full description | Payroll Enginatics | |
| PAY Payroll Element Details | Master data report showing HR payroll element details.
Elements are the units used to build all the earnings, deductions and benefits that companies can give to employees. | Payroll Enginatics | |
| PAY Payroll Process Summary | Payroll processes (payroll actions) of all action types with their assignment action counts by status, the number of messages and the first message, for monitoring payroll runs, prepayments, costing, transfers to the ledger and other payroll processes.
Messages counts the process level and assignment action level messages. First Message is the first process level message, or else the first fatal assignment action message.
Use Errors Only to list processes in error or with assignment actions in error, for example as a scheduled alert. | Payroll Enginatics | |
| PER Employee Assignments | Master data report showing the employee demographic information including name, gender SSN, birthdate, age, nationality, effective start date, and additional profile information.
Detail Level Costing adds one row per assignment cost allocation valid at the Effective Date, with the proportion, the total proportion of the assignment and the cost allocation flexfield. The individual cost segment columns are shown when a Business Group is selected. Assignments without assignment-level costing show blank costing columns.
Detail Level Extra Information lists one row per assignment extra… full description | Human Resources Enginatics | |
| PER Employee Grade Changes | List of employees with their grade changes. | Human Resources Enginatics | |
| PER Information Type Security | Human Resources Enginatics | | |
| PER Jobs and Positions | Positions valid at the Effective Date with their job, organization, status, valid grades, FTE, maximum persons, headcount and incumbent FTE, plus the jobs that have no position valid at the Effective Date, for enterprises that use jobs only.
Headcount counts the active and suspended employee and contingent worker assignments of the position, or for a job without positions, the assignments of the job without a position. Incumbent FTE sums their FTE assignment budget values. Vacancies is the maximum persons of the position, one if blank, minus its headcount.
Detail Level Incumbents adds one… full description | Human Resources Enginatics | |
| PER Organization Hierarchy | Master data report showing hierarchical list of human resource organization structures including subordinate orgs. | Human Resources Enginatics | |
| PER Organizations | Master data report showing organizations, classifications, address details and additional information attributes. | Human Resources Enginatics | |
| PER Position Hierarchy | Position hierarchy showing the reporting structure of positions with hierarchy level, organization, job, grade, location, budgeted vs actual headcount, vacancy count, and current incumbent names. Useful for position control, staffing analysis, and org chart construction. | Human Resources BI Publisher, Enginatics | |
| PER Security Profiles | Security profiles and operating units that they give access to. | Human Resources 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 Approval Assignments | Active PO document approval group assignments with HR jobs or positions | Purchasing Enginatics | |
| PO Approval Groups | PO approval groups and approval rules e.g. amount limits or account ranges | Purchasing Enginatics | |
| PO Approval History | Approval and action history of purchase orders, releases, agreements and requisitions: one row per entry of the document's action history (submit, forward, approve, reject, return, reserve, cancel, close, hold), in sequence.
The pending step of a document awaiting approval is shown with action Pending and the current approver as performer. Days Since Previous Action is measured from the previous history entry, for a pending step until today. Submitted Date is the latest submission up to that step.
For a release, Document Number is the number of its blanket agreement. | Purchasing Enginatics | |
| PO Approved Supplier List | Approved supplier list and attribute details such as source documents, supplier scheduling, planning constraints and inventory attributes. | Purchasing Enginatics | |
| PO Cancelled Purchase Orders | Application: Purchasing
Source: Cancelled Purchase Orders Report (XML)
Short Name: POXPOCAN_XML
DB package: PO_POXPOCAN_XMLP_PKG | Purchasing Enginatics | |
| PO Cancelled Requisitions | Application: Purchasing
Source: Cancelled Requisition Report (XML)
Short Name: POXRQCRQ_XML
DB package: PO_POXRQCRQ_XMLP_PKG | Purchasing Enginatics | |
| PO Document Types | PO document types setup | Purchasing Enginatics | |
| PO Headers | PO headers or releases with corresponding invoices and their payment status.
Example: To show all POs or releases which have an invoice but no receiving TRX yet, set following parameters:
Invoice exists=Yes
Receiving TRX exists=No | Purchasing Enginatics | |
| PO Headers and Lines | PO headers, lines, receiving transactions and corresponding AP invoices
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, CGST Rate, SGST Rate, IGST Rate, Custom Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code. | Purchasing Enginatics | |
| PO Internal Requisitions and Sales Orders | Report to display internal sales orders and requisition numbers, with aging dates and other useful information. | Purchasing Enginatics | |
| PO Internal Requisitions/Deliveries Discrepancy | Application: Purchasing
Description: Internal Requisitions/Deliveries Discrepancy Report
Source: Internal Requisitions/Deliveries Discrepancy Report (XML)
Short Name: POXRQSDD_XML | Purchasing Enginatics | |
| PO Invoice Price Variance | Imported Oracle standard Invoice Price Variance report
Application: Purchasing
Source: Invoice Price Variance Report
Short Name: POXRCIPV | Purchasing Enginatics, R12 only | |
| PO Printed Planning Schedule | Migration of the Oracle standard concurrent program Printed Planning Schedule (XML) (CHVPRSCH_XML) from Supplier Scheduling. Shows, for each confirmed planning/shipping schedule, the time-phased demand grid sent to the supplier - one row per schedule, item and time bucket - with forecast, released, total and cumulative (CUM+) quantities per bucket, plus the schedule header, item, CUM and authorization context. The horizontal schedule grid (chv_horizontal_schedules, up to 60 bucket columns) is un-pivoted into rows for analysis in Excel. | Purchasing Enginatics | |
| 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 | Purchasing Enginatics, R12 only | |
| PO Purchase Requisitions with PO Details | Purchase Requisitions Status with PO Details Report.
Lists purchase requisition headers, lines and distributions together with the purchase order they were converted into, including requisition and PO approval dates, the Converted To PO indicator and the PO total amount.
Set the Show Invoice and Payment Details parameter to Yes to additionally return the supplier invoices and payments matched to each purchase order shipment: invoice numbers, invoice date, invoiced amount, invoice amount paid, payment status, payment numbers, payment date and payment method. These columns are omitted by… full description | Purchasing Enginatics | |
| PO Receiving Transactions | Receiving transactions register: one row per receiving transaction (receive, accept, reject, transfer, deliver, return to supplier or receiving, correction) for purchase orders, internal requisitions, RMAs and inter-organization shipments, with the source document, item, quantity and PO price.
Quantity In Receiving and Days In Receiving are current values from the receiving supply, populated only on the receive, accept, reject or transfer transaction whose quantity still sits in receiving. Days In Receiving counts from the receipt date.
Amount is quantity times PO unit price and is blank… full description | Purchasing Enginatics | |
| PO Requisition Upload | Upload to create and update requisitions.
In the generated Excel, the user can amend the following columns for an existing requisition.
- Header Description
- Quantity
- Unit Price
- Need By Date
- Reference Number
- Supplier Item
- Buyer
- Note To Buyer
- Currency
- Conversion Type
- Conversion Rate
- Conversion Date
Additionally, the user can create a requisition by entering the below required fields.
- Line Type
- Source Type
- Item
- Item Description
- Category
- Unit of Measure
- Quantity
- Need By Date
- Destination Type
- Deliver To Requestor
- Destination… full description | Purchasing Enginatics, Upload | |
| 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. | Purchasing Enginatics, R12 only | |
| PO Vendor Service Performance Analysis | Imported from BI Publisher
Application: Purchasing
Source: Vendor Service Performance Analysis Report (XML)
Short Name: POXSERPR_XML
DB package: PO_POXSERPR_XMLP_PKG | Purchasing Enginatics | |
| 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 | |
| QP Customer Pricing Engine Request | QP Customer Pricing Engine Request
==============================
This report requests Item Selling Price information by Customer across Price Lists from the Pricing Engine.
The report also displays the Items Costs for the specified Organization and based on the Unit Selling Price and Item Cost, displays a Margin Analysis.
The report can be run in Summary or Detail Mode.
In Summary Mode, the report will display a summary of Applied Price Lists, List Price, Adjustment Amount, Final Unit Selling Price, Accrual Amount, Charge Amount, Item Cost, and Margin per Customer, requested Price List… full description | Order Management Enginatics | |
| 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 | Order Management Enginatics, R12 only | |
| QP Price Lists | Master data report showing the setup of price lists including item prices, calculation methods, terms and dates. | Order Management 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…