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 | ||
|---|---|---|---|
| INV Unit Of Measure Conversion Upload | INV Unit Of Measure Conversion Upload
=============================
In R12.2 and later:
This upload enables the user to
- upload new unit of measure conversions
- update existing unit of measure conversions.
The upload supports the following unit of measure conversion types:
- Standard, Intra-Class and Inter-Class, Lot Specific Inter-class
In R12.1:
The functionality is restricted to creating new Item specific Intra-Class and Inter-Class conversions only.
Update of existing unit of measure conversions is not supported in R12.1
Creation of Standard and Lot specific unit of measure… full description | Inventory Enginatics, Upload |  |
| INV Unit Of Measure Upload | INV Unit Of Measure Upload
======================
Note: This upload can only be used in R12.2 or later.
This upload can be used to create and update Unit of Measure Classes and Units of Measures | Inventory Enginatics, R12 only, Upload | |
| JA India - TDS Certificates | Imported from BI Publisher
Description: Form 16A report
Application: Asia/Pacific Localizations
Source: India - TDS Certificates (XML)
Short Name: JAINITCR_XML
DB package: JA_JAINITCR_XMLP_PKG | Enginatics, R12 only | |
| JA India GSTR-1 Return | Imported from BI Publisher
Description: India GSTR-1 Return Report in XML format
Application: Asia/Pacific Localizations
Source: India GSTR-1 Return Report(XML)
Short Name: JAIGSTR1_XML
DB package: JAI_GST_EXTRACT_PKG | Enginatics, R12 only | |
| JA India GSTR-2 Return | Imported from BI Publisher
Description: India GSTR-2 Return Report with XML Format
Application: Asia/Pacific Localizations
Source: India GSTR-2 Return Report(XML)
Short Name: JAIGSTR2_XML
DB package: JAI_GSTR2_EXTRACT_PKG | Enginatics, R12 only | |
| JA India GSTR-3B Return | Imported from BI Publisher
Description: GSTR-3B Return Report
Application: Asia/Pacific Localizations
Source: India GSTR-3B Return Report
Short Name: JAIGSTR3B
DB package: | Enginatics, R12 only | |
| JA India Third Party Registration Upload | JA India Third Party Registration Upload
=========================================
Use this upload to create or update India Localization Third Party Registrations for customers and suppliers, including tax/registration identifiers such as PAN, TAN, TIN, GST, Service Tax, and other India-specific registration numbers.
This upload also supports Reporting Codes linked to Third Party Registrations.
NOTE: If you are creating new records for a third party, enter and upload all Registration records first, and then enter and upload the Reporting Code records.
Available columns:
1.Record Type:… full description | Enginatics, R12 only, Upload | |
| MRP Master Schedule Upload | MRP Master Schedule Upload
==========================
- Create new MDS/MPS schedule entries.
- Create and Update existing schedule entries.
Each row stages one schedule entry into the MRP schedule interface (mrp_schedule_interface, process_status=2) for an existing schedule designator (MDS or MPS). The staged entries are loaded into the master schedule (mrp_schedule_dates) asynchronously by the customer's MRP Planning Manager.
Upload Modes
============
Create - opens an empty spreadsheet to enter new schedule entries against any accessible schedule designator.
Create and Update - downloads… full description | Manufacturing Enginatics, Upload | |
| MRP Sourcing Rule Assignment Upload | MRP Sourcing Rule Assignment Upload
=============================
- Upload new Assignment Sets and Sourcing Rule Assignments
- Update Existing Assignment Sets and Sourcing Rule Assignments
Notes:
If an Assignment Organization is specified, then this determines the selecatable items.
If an Assignment Organization is not specified, then the Master Organization determines the selectable Items.
The selectable Assignment Organizations is not restricted by the Master Organization.
This is the same logic as used in the Sourcing Assignments form | Manufacturing Enginatics, Upload | |
| MRP Sourcing Rule Upload | MRP Sourcing Rule Upload
====================
- Upload new Sourcing Rules
- Update Existing Sourcing Rules | Manufacturing Enginatics, Upload | |
| MSC Plan Order Upload | Report: MSC Plan Orders Upload
Description: Upload to action Plan Order recommendations.
This upload can be used to either select for release or release Plan Order Recommendations from ASCP planning instances.
Currently supported recommendations that can be actioned by this upload are:
- Planned Order Releases
- Reschedule In/Out recommendations
Additionally, it allows the user to amend the recommended Implement Date and/or Quantity.
In the generated Excel the user can amend the following columns:
- Implement Date
- Implement Quantity
- Update Release Status
Update Release Status can be… full description | Enginatics, Upload | |
| MSC Plan Orders | ASCP: Export Supply and Demand Orders from the Planners Workbench. | Enginatics, R12 only | |
| MSC Sourcing Rule Assignment Upload | MSC Sourcing Rule Assignment Upload
=============================
- Upload new Assignment Sets and Sourcing Rule Assignments
- Update Existing Assignment Sets and Sourcing Rule Assignments
Notes:
If an Assignment Organization is specified, then this determines the selecatable items.
If an Assignment Organization is not specified, then the Master Organization determines the selectable Items.
The selectable Assignment Organizations is not restricted by the Master Organization.
This is the same logic as used in the Sourcing Assignments form | Enginatics, Upload | |
| OKL Lease Contract Update Upload | Changes the bill to customer account and bill to site of Lease Management contracts through the Oracle public API okl_contract_pub.update_contract_header - the Bill To of the Lease Contract header.
One row per contract. Enter the Bill To Customer Account, the Bill To Site, or both; everything else on the row is context and is read only. A site that does not belong to the Bill To Customer Account on the row is rejected, so change both together when the account changes too.
A bill to change does not require a rebook: it was verified against Booked, Evergreen, Passed and Incomplete contracts.… full description | Enginatics, R12 only, Upload | |
| OKS Contract Termination Upload | Terminates service contracts (full termination), terminates individual contract lines and sublines (partial termination), and deletes lines from Entered contracts - the Terminate action of the Service Contracts Authoring form (okc_terminate_pub / okc_contract_pub).
Set Terminate Contract to Yes on any row of the contract for a full termination, Terminate Line to Yes to terminate that row's line or subline, or Delete Line to Yes to delete the line (Entered contracts only). Termination Date and Termination Reason are required for terminations.
A termination cannot be undone by this upload -… full description | Enginatics, R12 only, Upload | |
| OKS Service Contract Line Upload | This upload maintains the lines of existing Oracle Service Contracts through the standard Service Contracts public APIs: it updates header and line level values, adds new service and usage lines, and adds covered product or counter sublines.
Each row is one contract line or subline. Rows identified by the Line Number column update that line; sublines use the parent.child format, for example 1.2 for the second covered product of service line 1. Rows without a Line Number create a new line: leave Parent Line Number empty and enter Line Type, Item and the line dates for a top line, or enter a… full description | Enginatics, R12 only, Upload | |
| ONT Audit History | Order Management audit history report showing changes to order headers, lines, sales credits, and price adjustments with old/new values, change reasons, and the user who made the change.
Based on Oracle standard report OEXAUDHR_XML (Audit History Report). | Order Management Enginatics | |
| ONT Order Upload | Upload to Create, Update, Book and Cancel Sales Orders in Oracle Order Management.
Supports creating new orders, updating existing orders, adding new lines to existing orders, splitting lines, booking orders and cancelling orders.
To split a line, add a row for the order with the line to split in Split From Line and the new shipment's quantity in Ordered Quantity. The original line is reduced by that quantity unless its own row sets its new quantity. As in the Split Line window, the new shipment copies all other values from the original line, only Request Date, Warehouse and Ship To can… full description | Order Management Enginatics, Upload | |
| ONT Order to Cash Tracker | One row per sales order or quote line with the date of each step from quote to payment, and the accounting and GL posting of its invoice.
Invoice columns are those of the first invoice raised for the line; Invoiced Amount sums all its invoice lines. Amount Due Remaining is shown on the invoice's first order line only, so it can be summed. Paid Date is the date the invoice's last installment closed, Receipt Number the latest receipt applied to it.
Accounted Date is when final accounting was created for the invoice, GL Posted Date when its journal was posted. | Order Management Enginatics, R12 only | |
| ONT Orders and Lines 11i | 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 Sales Quote Close Upload | Bulk closes open Oracle Order Management sales quotes (documents in the Negotiation transaction phase) - useful for cleaning up large volumes of old draft quotes.
Download the open quotes, keep the rows you want to close, set a Close Reason, and upload. Each quote is driven to the Lost terminal (status Lost, no longer open) through the standard negotiation workflow, and the reason is recorded against the quote.
Quotes are identified by Quote Number and Operating Unit, so you can also paste those two values from an external list instead of downloading. Only open quotes are closed - an order… full description | Order Management Enginatics, 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 | |
| OTL Timecard Upload | OTL Timecard Upload
===================
Create, update and delete Oracle Time and Labor (OTL / HXC) timecards via the public TimeStore deposit API hxc_timestore_deposit, as an Excel-based alternative to self-service time entry.
Row model
=========
One spreadsheet row per timecard line and day: Employee, Date, classification and Hours. Rows are grouped into timecards by employee and the OTL timecard period (e.g. the weekly period from the employee's OTL preferences) containing the Date. Rows of the same employee and period must be contiguous and are deposited together as one timecard. The… full description | Enginatics, Upload | |
| OTL Timecard Upload 11i | OTL Timecard Upload
===================
Create, update and delete Oracle Time and Labor (OTL / HXC) timecards via the public TimeStore deposit API hxc_timestore_deposit, as an Excel-based alternative to self-service time entry.
Row model
=========
One spreadsheet row per timecard line and day: Employee, Date, classification and Hours. Rows are grouped into timecards by employee and the OTL timecard period (e.g. the weekly period from the employee's OTL preferences) containing the Date. Rows of the same employee and period must be contiguous and are deposited together as one timecard. The… full description | Enginatics, Upload | |
| PA Budget Upload | The PA Budget Upload supports the creation/update of standard project budgets.
At this stage it does not support the creation/update of Financial Plan Budgets.
The PA Budget Upload allows users to:
- Create new working budgets.
When creating a new working budget, any existing working budget for the specified Project and Budget Type will be overwritten.
The upload allows the user to create a working budget either by entering the data directly into an empty upload excel file, or by copying a prior version of the budget and modifying this in the upload excel file.
- Update existing… full description | Projects Enginatics, Upload | |
| PA Employee Activity By Organization | Labor hours summary by employee, project, and task showing total, billable, and non-billable hours with cost amounts for the expenditure organization. | Projects Enginatics | |
| PA Event Upload | PA Event Upload
===================
This upload can be used to create new Project Billing and Revenue Events against the Projects belonging to the Operating Units accessible to the current responsibility.
If the Operating Unit parameter is specified, then the upload will be restricted to Projects within the specified Operating Unit only. | Projects Enginatics, Upload | |
| PA Missing Timecards | Active employees who have not submitted timecards for a given week ending date, showing employee details, job, organization, and supervisor.
Timecard Source Project Expenditures lists employees without a project expenditure for the week ending date. OTL Timecards lists employees without an OTL timecard whose period contains the week ending date, including employees who do not charge projects. | Projects Enginatics | |
| PA Project Asset Upload | PA Project Asset Upload
======================
Create, update, or delete project assets and their task assignments for Oracle Projects capital projects, using the public API pa_project_assets_pub.
Supported Actions:
- Create / Update project asset (ESTIMATED or AS-BUILT types only — RETIREMENT_ADJUSTMENT is excluded)
- Add / Delete asset-to-task assignment (top-task rollup or leaf-task)
Row Structure (bundled parent-child):
- One row per (asset, assignment) pair
- Leave Assignment Task Number blank on a row to create/update just the asset header with no assignment
- For multiple assignments… full description | Projects Enginatics, Upload | |
| PA Project Upload | PA Project Upload
===================
Create and update Projects in Oracle Projects using the pa_project_pub API.
Create Mode:
- Select a Template to populate default values (project type, organization, billing setup, etc.)
- Template-specific required fields (customer, organization, completion date, etc.) are validated in Excel before upload
- Project Manager can differ from the template PM — the template PM is replaced post-creation
- PM Product Code determines which external PM system owns the project (default: Primavera). Do NOT use Microsoft Project — it blocks date updates due to… full description | Projects Enginatics, Upload | |
| PA Revenue, Cost, Budgets by Resources | This Blitz Report is the implements the following standard oracle reports.
- MGT: Task - Revenue, Cost, Budgets by Resources
- MGT: Revenue, Cost, Budgets by Resources (Project Level)
The 'Report Level' parameter determines if the report is run at the Project Level or Task Level
Report Level Parameter:
Project - equivalent to running the MGT: Revenue, Cost, Budgets by Resources (Project Level) report
Task - equivalent to running the MGT: Task - Revenue, Cost, Budgets by Resources report
The report has been extended to pull in additional datapoints as displayed in the Project Status… full description | Projects Enginatics, R12 only | |
| PA Revenue, Cost, Budgets by Work Breakdown Structure | This Blitz report implements the standard Oracle report: MGT: Revenue, Cost, Budgets by Work Breakdown Structure (XML)
The 'Report Level' parameter determines if the report is run at the Project Level or Task Level
Report Level Parameter:
Project - will pull back revenue, costs and budgets accumulated at the project level
Task - will pull back revenue, costs and budgets accumulated at the task level
The report has been extended to pull in additional datapoints as displayed in the Project Status Inquiry Form.
Application: Projects
Source: MGT: Revenue, Cost, Budgets by Work Breakdown… full description | Projects Enginatics, R12 only | |
| PA Task Upload | PA Task Upload
======================
Create new tasks or update existing task attributes within Oracle Projects using APIs pa_project_pub.add_task and pa_project_pub.update_task.
This upload does not create projects — it operates on tasks within existing projects.
Supported Actions:
- Create: Add new top-level tasks, child tasks under existing parents, or entire parent-child hierarchies
- Update: Modify attributes of existing tasks (organization, manager, work type, flags, schedules, etc.)
Report Parameters:
- Upload Mode: 'Create' for new tasks only, or 'Create, Update' for both
-… full description | Projects Enginatics, Upload | |
| PA Transaction Upload | PA Transaction Upload
===================
This upload can be used to upload transactions from external cost collection systems into Oracle Projects.
Transaction Import creates pre-approved expenditure items from transaction data entered in external cost collection systems.
If the 'Operating Unit' and/or 'Transaction Source' parameters are specified, then the upload excel will be restricted to the specified Operating Unit and/or Transaction Source.
If the 'Batch Name' parameter is specified, this will default as the Batch Name in the upload Excel.
If the 'All Negative Expend Unmatched'… full description | Projects Enginatics, Upload | |
| PAY Employee Payroll History | Payroll results per employee and payroll run date: run result Pay Values summed by element classification.
Net Pay is Earnings plus Supplemental Earnings minus Pre-Tax, Tax, Voluntary and Involuntary Deductions, which equals the prepayment amount of the US payroll. Imputed Earnings and Information elements do not count towards it.
Previous Net Pay is the employee's net pay of the preceding payroll run date within the selected run date range, so the first run date of an employee has no variance. Use Variance % Over to list only changes above a percentage. | Payroll Enginatics | |
| PAY Gross to Net Summary | Payroll gross-to-net summary per employee and pay period, showing gross pay (earnings), pre-tax deductions, involuntary deductions (tax), voluntary deductions, employer charges, and calculated net pay. Based on completed payroll run results. Useful for payroll reconciliation and compensation analysis. | Payroll Enginatics | |
| PAY Hire to Retire Tracker | One row per employee period of service that overlaps the period from Date From to Date To: new hires, leavers and everyone employed in between, with the date of each step from hire to the first payment, the termination dates, and the payroll processing exceptions of the period.
Assignment columns are those of the primary assignment on Date To, or on the termination date for a leaver. New Hire and Leaver mark a hire or termination date within the period.
Payroll Ready Date is the later of the hire date and the dates the payroll and the first approved salary were entered. First Period Cut Off… full description | Payroll Enginatics, R12 only | |
| PER Employee Absences | Employee absence and attendance records showing absence type, category, dates, duration in days and hours, reason, authorizing person, replacement person, and approval status. Useful for leave management, absence tracking, and compliance reporting. | Human Resources Enginatics | |
| PER Employee Contacts and Dependents | Employee contact relationships including dependents, beneficiaries, and emergency contacts. Shows contact person details (name, phone, email, address), relationship type, and flags for dependent, beneficiary, emergency contact, and third party payment. Useful for benefits administration, emergency preparedness, and employee records management. | Human Resources Enginatics | |
| PER Employee Length of Service | Active employees with calculated length of service in years and months, based on the adjusted service date (or hire date if not set). Shows milestone years (multiples of 5), next service anniversary, age, and current assignment details. Useful for recognition programs, benefits eligibility, and workforce tenure analysis. | Human Resources Enginatics | |
| PER Employee Salary Change | Query to get the last Salary change details for employees.
Can add:
whether to look at just the recent salary change?
or salary change history.... If yes, then the last condition in where clause to be dynamically added/removed | Human Resources Enginatics | |
| PER Headcount by Organization | Active employee and contingent worker headcount summarized by business group, organization, location, job, grade, and employment category. Includes gender breakdown and average service years and age. Use Excel pivot tables for flexible grouping and analysis. | Human Resources Enginatics | |
| PER Location Upload | Upload to create, update, and delete HR Locations.
Supports all country-specific address styles with address field validation.
Includes site flags (Ship-To, Bill-To, Receiving, Office, Internal) with autocorrection for Ship-To and Receiving flags based on the Ship-To Location relationship.
Includes the Descriptive Flexfield attributes with validation.
Business group security restricts downloaded locations to the user's current business group plus global locations. New locations can optionally be made local by assigning the location to the user's current business group. If not assigned to… full description | Human Resources Enginatics, Upload | |
| PER New Hires | Employees hired within a specified date range, showing hire date, organization, job, position, grade, location, supervisor, employment category, and probation details. Useful for onboarding tracking and new hire analysis. | Human Resources Enginatics | |
| PER Organization Upload | Upload to create and update organizations, organization classifications, and organization information types within Oracle HRMS.
Scope:
- Create new organizations, assign classifications and information types, and specify the information type attributes
- Update existing organization data, classifications (enable/disable), and the information type attributes
- Supports all organization classification types: Business Groups (excluding creation of new Business Groups), HR Organization, Operating Unit, GRE/Legal Entity, Company Cost Center, Inventory Organization, etc.
- Supports creation/update… full description | Human Resources Enginatics, Upload | |
| PER Payroll Element Entry Upload | PER Payroll Element Entry Upload
==================
Use this upload to upload new or update existing PER Payroll Element Entries, or to enter adjustment entries. | Human Resources Enginatics, Upload | |
| PER Person Assignment Upload | Upload to create and update employee assignments as in the Assignment window of the People form: organization, job, position, grade, payroll, location, status, categories, supervisor, probation and notice periods, standard conditions, statutory information, salary basis, people group and the Additional Assignment Details flexfield.
Changes are made as of the Effective Date. When Datetrack Mode is blank, the assignment is corrected if the Effective Date is its start date, and otherwise a change is inserted from the Effective Date (Update, or Update - Insert when later changes exist).
A new… full description | Human Resources Enginatics, R12 only, Upload | |
| PER Person Extra Information Upload | Upload to create and update Person Extra Information Types (EITs) within Oracle HRMS - the People form > Others > Extra Information > Extra Person Information window.
Scope:
- Generic upload covering all person extra information types. The Information Type parameter/column lists every enabled context of the Extra Person Info DDF flexfield (titled Extra Person Information), which holds the registered EIT types.
- The segment values are loaded as raw Information 1..30 columns (pei_information1..30), matching the order of the information type's flexfield segments.
- Create new person extra… full description | Human Resources 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…