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
837 reports
| Description | Download | ||
|---|---|---|---|
| QP Pricing Agreements | Report detailing QP Pricing Agreements | Order Management Enginatics |   |
| QP Pricing Attribute Definitions | Lists the Pricing and Qualifiers Attributes defined for use by Advanced Pricing | Order Management Enginatics | |
| WF Activity Status Summary | Summary counts of stuck and errored workflow activities to monitor required housekeeping activities | Enginatics | |
| WF Business Events and Subscriptions | Workflow business event and subscription details | Enginatics | |
| WF Queue Backlog | Number of messages per Workflow Business Event System queue table, correlation id and state, with the age of the oldest message.
A large number of Ready messages with an old Oldest Message shows that the agent listener, notification mailer or Workflow Background Process serving the queue is down or cannot keep up. The correlation id contains the business event or notification message name, and for WF_DEFERRED_TABLE_M the item type processed by the Workflow Background Process. | Enginatics | |
| WF Service Components | Workflow service components, such as the notification mailer, agent listeners and web services agents, with their status, startup mode and the concurrent manager container running them.
Show Parameters lists the component's configuration parameters, for example the mailer's SMTP and IMAP servers, reply-to and test address. Encrypted values such as passwords are masked.
Schedule the report with Not Running only to get an email when the notification mailer or an agent listener stops. | Enginatics | |
| WIP Account Distribution | Detail WIP report that lists resource transaction account distributions. | Manufacturing Enginatics | |
| WIP Discrete Job Shortage | WIP report that lists discrete job Open Requirements and/or Shortages.
Report Modes
==========
The report can be run in the following modes:
1. Open Requirements - Reports all Open Requirements
2. Shortage based on Net QOH - Reports requirements with shortages against Nettable Quantity Onhand
3. Shortage based on QOH - Reports requirements with shortages against Total Quantity Onhand
4. Shortage based on Supply Sub/Loc - Reports requirements with Shortages against Onhand Quantity in the same supply Subinventory/Locator as specified in the job requirement.
Shortages
=======
The report… full description | Manufacturing Enginatics | |
| WIP Entities | Detail WIP report that lists job, type, status, planner, item, item description, planning method, pegging type, entity, job Description, WIP resource transaction account distributions, project number, task, source code, source line item,Sales Order,Sales Order Line, WIP type, class code, scheduling dates, quantities, department, resource and organization.
Show Resources lists every resource requirement of an operation instead of its first resource only. Required units are the usage rate times the job start quantity less the operation's cumulative scrap for item basis, and the usage rate for… full description | Manufacturing Enginatics | |
| WIP Entities Summary | Overview of WIP entities of different types and their various statuses. | Manufacturing Enginatics | |
| WIP Move Transactions | WIP move transactions of discrete jobs, lot based jobs, repetitive schedules and flow schedules, one row per transaction, as shown in the View Move Transactions form.
The report covers the data of the Oracle standard Move Transaction Report (WIPTSMOV): from and to operation, department and intraoperation step, transaction and primary quantity, reason and reference, over-completion, scrap account and the employee who performed the move.
A repetitive move is shown once per repetitive schedule it was allocated to, with the schedule's first unit start date and the allocated quantity.
Quantity… full description | Manufacturing Enginatics | |
| 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 | |
| WIP Required Components | Detailed project WIP report that lists discrete jobs and required components. The parameter 'Show Shortage List' can be used to show a shortage list of existing discrete jobs (similar to Oracle's 'Discrete Job Shortage Report'.
| Manufacturing Enginatics | |
| WIP Resource Transactions | WIP resource, overhead and outside processing transactions, one row per transaction, as shown in the View Resource Transactions form.
Quantity is in the unit of measure the transaction was entered in, Primary Quantity in the resource's unit of measure.
Transactions still pending in the resource transaction interface are not included. | Manufacturing Enginatics | |
| WMS Control Board Tasks | List All the Warehouse Control Board Tasks
------------------------------------------------------------------------
Parameters:
Task Type: Filter by Task Type
User Task Type: Filter by selected user task type based on task.
Task Status : Filter by Task Statuses.
Excluded Task Status: Filter the tasks excluding status like "Completed"
Task Creation Date From and To : Filter based on task creation date
Show WIP Material Movements: In case WIP details to be extracted corresponding to tasks
Show Sales Order Movements: In case Sales Order details to be extracted corresponding to… full description | Enginatics | |
| WSH Commercial Invoice | Shipping commercial invoice report showing delivery details including shipped items, quantities, unit costs, extended costs, ship-from/ship-to addresses, freight information, and bill of lading details.
Blitz version of the Oracle standard Commercial Invoice (XML) concurrent program WSHRDINV_XML.
DB package: WSH_WSHRDINV_XMLP_PKG | Order Management Enginatics | |
| WSH Shipping/Delivery Transactions | This report provides details of Warehouse Shipping Transactions and Deliveries.
To review details of deliveries only, set the Assigned to Delivery Parameter = 'Yes'
To review details of shipping transaction not yet assigned to a delivery, set the Assigned to Delivery Parameter = 'No'
Set the parameter to null to review all shipping transations regardless of delivery assignment status. When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, CGST Amount, SGST Amount, IGST Amount, CESS Amount, Custom Amount, Unclassified Tax Amount,… full description | Order Management Enginatics | |
| XDO Publisher Data Definitions | XML Publisher data definitions or sources, associated concurrent programs, executables and templates.
To include complete template information, enter a template name or wildcard % in the template name parameter field.
This report also includes the source data SQL statement extracted from the publisher data template XML file which is quite useful to quickly access and review the SQL from Oracle standard XML reports and use them as templates for new blitz report creations.
Parameter 'Data Definition Search Text' performs a full text search through the data template file so that you could for… full description | System Enginatics | |
| 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 | General Ledger 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/ | General Ledger Enginatics, R12 only | |
| XLA Entity Types and Event Class Attributes | Subledger event types and their attributes, for example reporting view | General Ledger Enginatics, R12 only | |
| XLA OPM Event Type Summary | General Ledger 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 | General Ledger 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 | General Ledger 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 Listing | Payables distribution sets and their lines with account, percentage, income tax type, tax classification and project details, one row per distribution set line.
Equivalent to the Oracle standard Distribution Set Listing (APXGDGDL). The Status parameter evaluates active or inactive as of the Effective Date. | Payables Enginatics | |
| 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 | Payables 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. | Payables 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 | Payables 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 | Payables Enginatics, R12 only, Upload | |
| AP Invoice Payments 11g | 11g-compatible version of AP Invoice Payments.
Supplier invoice payment details.
There can be multiple payments per invoice and one document/check can be used to pay different payments and invoices. To allow reconciling payment with invoices and checks, invoice and check level amounts are shown on the last payment record only and are blank for multiple/duplicate records. | Payables Enginatics | |
| 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. | Payables 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 | Payables 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 | Payables 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 | Payables 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 | Payables Enginatics, R12 only | |
| AP Supplier Upload | This upload can be used to create and/or update Suppliers, Supplier Sites, Supplier Bank Accounts, and Supplier Contacts
Upload Mode Update only allows changes to existing Suppliers, Sites, Contacts and Bank Accounts. A row that would create any of them is rejected, including a bank or bank branch.
Add Existing Bank Acct assigns a bank account the supplier already owns to another level, as the Add button on the supplier Banking Details page does. The account is assigned exactly as it stands, so the bank, branch and bank account columns are left blank on that row.
The bank and branch… full description | Payables Enginatics, R12 only, Upload | |
| AP Suppliers 11i | AP suppliers (po vendors) including supplier sites and contact information
Duplicate Match restricts the output to suppliers sharing a match key with at least one other supplier and lists the shared keys. Names are compared in upper case without punctuation, spaces and legal form suffixes (Inc, Ltd, GmbH, SA and similar), the other keys without punctuation and spaces. Bank accounts are shown masked.
Spend Last 12 Months is the total of the supplier's invoices dated in the last twelve months, excluding cancelled invoices, in each operating unit's functional currency. | Payables Enginatics | |
| AR AutoAccounting Upload | Creates and updates the Receivables AutoAccounting definitions - the Excel equivalent of the Automatic Accounting form (Setup > Transactions > AutoAccounting).
Each row is one segment of the chart of accounts of an AutoAccounting type, with the operating unit and type repeated on every row. Enter either a Table Name, from which AutoAccounting takes the segment value, or a Constant.
Each type is saved as a whole: after the upload, every enabled segment of the chart of accounts must have a table name or constant, and a dependent segment must use the table name of its parent segment or a… full description | Receivables Enginatics, R12 only, Upload | |
| AR Cash Receipt Upload | Upload to create AR cash receipts and optionally apply them to open invoices.
Each row creates one receipt (if it does not already exist) and optionally applies it to one invoice.
To apply one receipt to multiple invoices, enter multiple rows with the same Receipt Number - the receipt is created only once on the first row, and each subsequent row generates one application against the existing receipt.
Receipt Application options:
- Leave Invoice Number blank: receipt is created as Unapplied
- Enter Invoice Number: receipt is applied to that invoice
- Set Apply on Account = Yes: receipt… full description | Receivables Enginatics, Upload | |
| AR Credit Memo Application Upload | Applies open on account credit memos to invoices and debit memos, and unapplies existing credit memo applications - the Applications action of the Transactions workbench (ar_cm_api_pub).
The download lists the operating unit's open credit memos (Apply To Invoice empty) and their existing active applications (one row per application). To apply, enter Apply To Invoice on an open credit memo row. To unapply, set Unapply to Yes on an application row.
An existing application cannot be changed in place: unapply it, then enter the new application on the credit memo's open row. | Receivables Enginatics, R12 only, Upload | |
| AR Customer Open Balances Period Lookback | Report: AR Customer Open Balances Period Lookback
Application: Receivables
Description:
Customer Open Balances summary showing
- Open Balances as of the specified 'As of Date' and as of periods prior to the 'As of Date' period.
- Maximum Open Balance in the prior periods prior to the 'As of Date' period
All balances are show in the functional currency.
Parameters:
As of Date - the report will be run as of this date. Defaults to the current system date.
Look Back periods - number of periods prior to the 'As of Date' period to show
Max Open over last Periods - number of periods prior to… full description | Receivables Enginatics | |
| AR Customer Statement | Application: Receivables
Source: Customer Statement
Short Name: ARSTMTRPT
DB package: AR_TP_STMT_PKG
When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, CGST Amount, SGST Amount, IGST Amount, CESS Amount, 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, Custom Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code. | Receivables Enginatics, R12 only | |
| AR Customer Upload | AR Customer Upload
This upload can be used to create and/or update Customer Accounts, Customer Sites and/or Customer Site Uses.
Additionally, the upload supports:
- the creation/update of the Customer Profiles and Customer Profile Amounts at Customer and Customer Site Level
- the creation/update of bank Accounts at the Customer and Customer Site Level
- the creation/update of Contact information at the Customer and Customer Site level
The following parameters determine the behaviour of the upload.
Upload Mode
===========
Create – In this mode the user starts with a blank Excel. Use this… full description | Receivables 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…