Blitz Report™ Library
238 reports
| Description | Download | ||
|---|---|---|---|
| AD ADOP Sessions | Online patching (adop) sessions of Oracle EBS 12.2 with one row per node and phase, showing the status, start and end time and duration of each phase.
Phases that do not apply to a session, for example all phases but apply in a hotpatch session, are not shown. The Patches column lists the patches applied in the session's apply phase. | Enginatics, R12 only |   |
| AD Code Levels | Code level and baseline of each Oracle EBS product and product family, as maintained by the patching utilities in AD_TRACKABLE_ENTITIES.
Patch readme files and My Oracle Support notes state prerequisites as code levels, for example R12.AD.C.Delta.15 for AD code level C.15. | Enginatics, R12 only | |
| AP 1099 Payments | 1099 Payments report showing payments made to 1099 reportable suppliers.
This is the Blitz Report equivalent of the Oracle standard 1099 Payments Report (APXTRRVT).
The report lists suppliers from the 1099 tape data (vendors processed for 1099 reporting) along with their payment totals within the specified date range.
Key features:
- Uses ap_1099_tape_data to filter vendors processed for 1099 reporting
- Validates against Tax Reporting Entity and balancing segments
- Calculates payment amounts using Oracle AP_UTILITIES_PKG.Net_Invoice_Amount
- Determines tax reporting site (site with… full description | Enginatics, R12 only | |
| AP Accounted Invoice Aging | Application: Payables
Report: Accounts Payable Accounted Invoice Aging Report
Pre-requisite: XLA_TRIAL_BALANCES should be populated before running this report.
Description.
Report details Aging of outstanding amounts at a specified point in time for Accounted Invoices and relies mainly on the data in XLA_TRIAL_BALANCES table for the accounting information.
XLA_TRIAL_BALANCES data is inserted by the Open Account Balances Data Manager.
The Open Account Balances Data Manager maintains reportable information for all enabled open account balance listing definitions. This program is submitted… full description | Enginatics, R12 only | |
| AP Cash Requirement | Detail cash requirement report showing all unpaid or partially paid amounts, where the invoice is neither on hold nor cancelled, including invoice currency amount, exchange rate, and currency code
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 Expenses | Detail AP expense report listing corresponding AP invoices with status, line details, expense type and expense justification. Including projects task related expenses.
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 Approval Status | Imported from Concurrent Program
Application: Payables
Source: Invoice Approval Status
Short Name: APXAPRST
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, 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 Invoice Audit Listing | Imported Oracle standard 'Invoice Audit Listing' report
Application: Payables
Source: Invoice Audit Listing
Short Name: APXINLST
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… full description | Enginatics, R12 only | |
| AP Matched and Modified Receipts | Imported from BI Publisher
Description: Matched and Modified Receipts Report
Application: Payables
Source: Matched and Modified Receipts Report (XML) - Not Supported: Reserved For Future Use
Short Name: APXMTMRR_XML
DB package: AP_APXMTMRR_XMLP_PKG
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. | Enginatics, R12 only | |
| AP Negative Supplier Balance | Application: Payables
Source: Accounts Payable Negative Supplier Balance
Short Name: APXNVBAL
DB package: XLA_TB_AP_REPORT_PVT | Enginatics, R12 only | |
| AP Open Balances Revaluation | Description: AP Open Balances Revaluation Report
This report is in the same format as the AP Open Balances Revaluation Report which is no longer supported and should no loinger be used. The data source for this report is the same as the AP Open Items Revaluation report.
Application: Payables
Source: Open Items Revaluation Report (XML)
Short Name: APOPITRN
DB package: AP_OPEN_ITEMS_REVAL_PKG
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,… full description | Enginatics, R12 only | |
| AP Open Items Revaluation | Imported from BI Publisher
Description: Open Items Revaluation Report
Application: Payables
Source: Open Items Revaluation Report (XML)
Short Name: APOPITRN
DB package: AP_OPEN_ITEMS_REVAL_PKG
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. | Enginatics, R12 only | |
| AP Supplier Statement | Application: Payables
Source: Supplier Statement
Short Name: APTPSTMT
DB package: AP_TP_STMT_PKG
When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, GST TAN No, CESS Amount, CESS Rate, CGST Amount, CGST Non-Recoverable, CGST Recoverable, CGST Rate, Custom Amount, IGST Amount, IGST Non-Recoverable, IGST Recoverable, IGST Rate, Reverse Charge Flag, SGST Amount, SGST Non-Recoverable, SGST Recoverable, SGST Rate, Unclassified Tax Amount, Taxable Value, HSN SAC Code. | Enginatics, R12 only | |
| AP Trial Balance | Application: Payables
Source: Accounts Payable Trial Balance
Short Name: APTBRPT
DB package: XLA_TB_AP_REPORT_PVT
For scheduling the report to run periodically, use the 'as of relative period close' offset parameter. This is the relative period offset to the current period, so when the current period changes, the period close as of date will also be automatically updated when the report is re-run.
Requires custom package XXEN_XLA package to be installed to initialize the hidden parameters removed from the report to simplify scheduling of the report. | Enginatics, R12 only | |
| AP Trial Balance Report Definitions | Accounts Payable Trial Balance Report Definitions | Enginatics, R12 only | |
| AR Adjustment Register | Application: Receivables
Source: Adjustment Register
Short Name: ARRXARPB
The report has now been enhanced to allow multiple accessible Ledgers or Operating Units to be selected in the Reporting Context parameter. Additionally, the Reporting Context parameter has been made optional. Leaving it null will allow the report to be run across all accessible Ledgers or Operating Units. | Enginatics, R12 only | |
| AR Aging | The AR Aging report allows users to review information about their open receivables items at a specified point in time (the As of Date). The report will show the aging of the open receivables items based on the selected aging bucket.
- The report includes detailed (Transaction Level) or summary (Customer Level) information about customers current and past due invoices, debit memos, and chargebacks.
- Optionally the report can include details of credit memos, on-account credits, unidentified payments, on-account and unapplied cash amounts, and receipts at risk.
- Optionally the report allows… full description | Enginatics, R12 only | |
| AR Applied Receipts | Application: Receivables
Description: Receivables Applied Receipts Register
Provided Templates:
Default: Detail - Detail Listing with no Pivot Summarization
Pivot: Summary by Apply Date - Summary by Balancing Segment, Receipt Currency, Apply Date
Pivot: Summary by Batch - Summary by Balancing Segment, Receipt Currency, Batch
Pivot: Summary by Customer Name - Summary by Balancing Segment, Receipt Currency, Customer with drilldown to details
Pivot: Summary by Debit Account - Summary by Balancing Segment, Account Segment, Debit Account, Receipt Currency
Pivot: Summary by GL Date - Summary by… full description | Enginatics, R12 only | |
| AR Customer Credit Snapshot | Application: Receivables
Source: Customer Credit Snapshot (XML)
Short Name: ARXCCS_XML
DB package: AR_ARXCCS_XMLP_PKG | Enginatics, R12 only | |
| AR Customers and Sites | Master data report of customer master data including address, sites, site uses, payment terms, Salesperson, price list and other profile information.
Payment terms are reported from each of their own sources: Account Profile Payment Term and Site Profile Payment Term from the customer profile at account and site level, and Site Use Payment Term from the site use Order Management terms.
When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No. | Enginatics, R12 only | |
| AR European Sales Listing | Summary report listing sales by country and currency code, with transaction amount / currency and accounted amount/ currency | Enginatics, R12 only | |
| AR Open Balances Revaluation | Report: AR Open Balances Revaluation Report
Application: Receivables
Source: AR Open Balances Revaluation Report
Short Name: AROBRR | Enginatics, R12 only | |
| AR Open Items Revaluation | Imported from BI Publisher
Description: Open Items Revaluation Report
Application: Receivables
Source: Open Items Revaluation Report (XML)
Short Name: ARXINREV_XML
DB package: AR_ARXINREV_XMLP_PKG | BI Publisher, Enginatics, R12 only | |
| AR Receipt Register | Application: Receivables
Description: Receivables Receipt Register
Provided Templates:
Default: Detail - Detail Listing with no Pivot Summarization
Pivot: Summary by Receipt Date - Summary by Balancing Segment, Receipt Currency, Receipt Date
Pivot: Summary by Receipt Status - Summary by Balancing Segment, Receipt Status
Pivot: Summary by Batch - Summary by Balancing Segment, Receipt Currency, Batch
Pivot: Summary by Customer Name - Summary by Balancing Segment, Receipt Currency, Customer
Pivot: Summary by Debit Account - Summary by Balancing Segment, Account Segment, Debit Account, Receipt… full description | Enginatics, R12 only | |
| AR Sales Journal By Customer | Imported from BI Publisher
Description: Sales Journal By Customer
Application: Receivables
Source: Sales Journal By Customer (XML)
Short Name: RAXGLA_XML
DB package: AR_RAXGLA_XMLP_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, Custom Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code, HSN Length Warning, CGST Rate, SGST Rate, IGST Rate, CESS Rate. | Enginatics, R12 only | |
| AR Transaction Register | Application: Receivables
Source: Transaction Register
Short Name: ARRXINVR
The report has now been enhanced to allow multiple accessible Ledgers or Operating Units to be selected in the Reporting Context parameter. Additionally, the Reporting Context parameter has been made optional. Leaving it null will allow the report to be run across all accessible Ledgers or Operating Units.
When India Localization is installed, the following GST columns are also included: IGST Amount, IGST Recoverable, IGST Non-Recoverable, CGST Amount, CGST Recoverable, CGST Non-Recoverable, SGST Amount, SGST… full description | Enginatics, R12 only | |
| AR to GL Reconciliation | Imported from Concurrent Program
Application: Receivables
Source: AR to GL Reconciliation Report
Short Name: ARGLRECR
DB package: | Enginatics, R12 only | |
| Blitz Upload Dependencies | Enginatics, R12 only | | |
| CAC Deferred COGS Out-of-Balance | Report to find the out-of-balance deferred COGS entries by organization, item and sales order number. You do not need to run Create Accounting as this report uses the pre-Create Accounting material accounting entries.
/* +=============================================================================+
-- | Copyright 2019 - 2020 Douglas Volz Consulting, Inc. |
-- | All rights reserved. |
-- | Permission to use this code is granted provided the original author is |
-- | acknowledged… full description | Enginatics, R12 only | |
| CAC Interface Error Summary | Use this report to view your transactions that are pending or have errors in the Oracle interface tables. Across both Financial and Supply Chain Applications. This includes interfaces that would prevent closing the inventory accounting period, as suggested by the report titles, Resolution Required and Resolution Recommended. Similar to the Inventory Account Periods Close form (checking open receipts, pending shipments, failed inventory, WIP, etc.).
Notes:
1) Supply Chain queries check for the period close timezone of the legal entity, just like the Inventory Account Periods Close form… full description | Enginatics, R12 only | |
| CAC Inventory to G/L Reconciliation (Restricted by Org Access) | For Discrete Costing, this report compares the General Ledger inventory balances with the perpetual inventory values (based on the stored month-end inventory and WIP balances, generated when the inventory accounting period is closed, plus a calculated month-end receiving value). Inventory balances includes Receiving, Onhand Inventory (Stock), Intransit and Work in Process (WIP). This report automatically discovers your valuation accounts based on your setups, such as the Cost Method (Standard, Average, FIFO or LIFO Costing), and also if using Project Manufacturing (PJM - Cost Group… full description | Enginatics, R12 only | |
| CAC Invoice Price Variance | Report to display the Invoice Price Variances (IPV), Exchange Rate Variances (ERV) and A/P Accrual Write-Off Variances for an entered date range. IPV is the difference between the PO unit price and the invoice unit cost times the quantity invoiced. ERV is the difference between the purchase order exchange rate and the exchange rate used by the A/P invoice. For a given invoice line, both the IPV and ERV amounts will be shown on the same row, in separate columns. These entries have the Type "IPV-ERV". The A/P Accrual Write-Off Variances appear as separate rows with the Type "INV WO" for… full description | Enginatics, R12 only | |
| CAC OPM Item Cost Detail | Oracle Process Manufacturing (OPM) item cost detail: the costed value of each item broken out by cost component class (material, labor, burden, overhead) and cost analysis code, per cost calendar, period and method. Answers what makes up an item's OPM cost. | Enginatics, R12 only | |
| CAC Receiving Activity Summary | Especially for companies who do not use separate inspection receipt processes, this report nets the initial purchase order receipt into receiving against the delivery into stock and WIP outside processing (OSP), for the entered transaction date range. By comparing the Purchasing Receipt transactions with the Purchasing Delivery transactions (for the purchasing receipts, material deliveries and WIP OSP deliveries). Enter the date range you wish to compare, typically a monthly date range. Differences may be due to the initial receipt occurring in the prior month, not running Create… full description | Enginatics, R12 only | |
| CAC WIP Material Usage Variance | Report your material usage variances for your open and closed WIP jobs. This report replicates the Material Variance Section for the Oracle Discrete Job Value - Standard Costing report.
If the job is open the Report Type column displays "Valuation", as this WIP job and potential material usage variance is still in your WIP inventory balances. If the job has been closed during the reporting period, the Report Type column displays "Variance", as this WIP job was written off on a WIP Job Close Variance transaction. You can report prior periods and this report will automatically adjust the… full description | Enginatics, R12 only | |
| CE Bank Account Balances | Application: Cash Management
Description: Bank Accounts - Balances Report
Provides equivalent functionality to the following standard Oracle Forms/Reports
- Bank Account Balances OAF Page
- Bank Account Balance Range Day Report
- Bank Account Balance Single Date Report
- Bank Account Balance Actual vs Projected Report
Single (As Of) Date Report
- Specify the required Date in the As Of Date parameter
- Specify Yes in the 'Bring Forward Prior Balances' if you want to roll the most recent prior balance entries forward if a balance does not exist on the specified As Of Date
- Specify No in the… full description | Enginatics, R12 only | |
| CE Bank Branches | This Report is the repository of all bank branches covering both internal and external bank accounts and will list the bank branches along with an indication of usage:
-Internal
-Supplier
-Customer | Enginatics, R12 only | |
| CE Bank Statement Import Execution | Application: Cash Management
Source: Bank Statement Import Execution Report
Short Name: CEIMPERR
DB package: CE_CEXINERR_XMLP_PKG | BI Publisher, Enginatics, R12 only | |
| CE Bank Statement and Reconciliation | Application: Cash Management
Description: Bank Statements - Bank Statement Details and Reconciliation
Provides equivalent functionality to the following standard Oracle Forms/Reports
- Bank Statements and Reconciliation Form
Applicable Templates:
Pivot: Bank Statement by Transaction Type
Bank Statement Detail
Bank Statement Detail with Reconciled Trxs
- Bank Statement Summary Report
Applicable Templates:
Pivot: Bank Statement by Transaction Type
Bank Statement Summary
- Bank Statement Detail Report
Applicable Templates:
Pivot: Bank Statement by Transaction Type
Bank… full description | Enginatics, R12 only | |
| CE Bank Transaction Codes Listing | Imported from BI Publisher
Description: Bank Transaction Codes
Application: Cash Management
Source: Bank Transaction Codes Listing
Short Name: CEXTRXCD
DB package: CE_CEXTRXCD_XMLP_PKG | Enginatics, R12 only | |
| CE General Ledger Cash Account Usage | Application: Cash Management
Description: Cash Account Usage
This report details the General Ledger Cash Accounts assigned to Bank Accounts, and their usage.
The following templates are available:
Pivot: Bank Accounts, Assigned Cash Accounts - Pivot by Bank Account, Cash Account showing cash account usage within each bank account.
Pivot: Cash Account, Assigned Bank Accounts - Pivot by Cash Account, Bank Account, showing cash account usage within each bank account. | Enginatics, R12 only | |
| CE General Ledger Reconciliation | Application: Cash Management
Description: Bank Statements - General Ledger Reconciliation
Provides equivalent functionality to the following standard Oracle Forms/Reports
- General Ledger Reconciliation Report
Applicable Templates:
Pivot: Reconciliation Summary
Source: General Ledger Reconciliation Report
Short Name: CEXRECRE
DB package: CE_CEXRECRE_XMLP_PKG | Enginatics, R12 only | |
| CSI Counter Readings | Counter and meter readings, one row per reading, with the item instance or maintainable asset and the service contract the counter belongs to.
Reading Change is the net reading minus the net reading of the counter's previous enabled reading, so it shows the usage since the last reading, also across resets and adjustments. It is blank for the first reading of a counter.
Work Order is the maintenance work order on whose completion the reading was recorded. Contract Number lists the contract of a counter attached to a contract line, or the contracts whose usage lines cover the counter. | Enginatics, R12 only | |
| CST AP and PO Accrual Reconciliation | Imported from Concurrent Program
Application: Bills of Material
Source: AP and PO Accrual Reconciliation Report
Short Name: CSTACRAP | Enginatics, R12 only | |
| CST COGS Revenue Matching | Imported from Concurrent Program
Application: Bills of Material
Source: COGS Revenue Matching Report
Short Name: CSTRCMRX
The COGS/Revenue Matching Report displays earned and unearned (deferred) revenue, and cost of goods sold amounts for sales orders issues specified in the report's run-time parameters.
The report displays shipped sales order and associated sales order lines and shows the accounts where the earned and deferred COGS were charged.
The report is based on the Revenue and COGS Matching functionality delivered in Oracle EBS R12. Please refer to the following documentation… full description | Enginatics, R12 only | |
| CST Inventory Value Report - by Subinventory (Item Cost) | Imported Oracle standard inventory value subinventory report by item cost
Source: Inventory Value Report - by Subinventory (XML)
Short Name: CSTRINVR_XML
DB package: BOM_CSTRINVR_XMLP_PKG | Enginatics, R12 only | |
| CST Miscellaneous Accrual Reconciliation | Imported from Concurrent Program
Application: Bills of Material
Source: Miscellaneous Accrual Reconciliation Report
Short Name: CSTACRMI
DB package: | Enginatics, R12 only | |
| CST Periodic Inventory Value | Imported from BI Publisher
Description: Periodic Inventory Value Report
Application: Bills of Material
Source: Periodic Inventory Value Report (XML)
Short Name: CSTRPICR_XML
DB package: BOM_CSTRPICR_XMLP_PKG | Enginatics, R12 only | |
| CST Subinventory Account Value - Multi-Org | Report: CST Subinventory Account Value - Multi-Org
Description:
Shows onhand inventory value broken down by GL account and cost element across multiple organizations.
For each subinventory, the report unpivots inventory value into separate rows per cost element (Material, Material Overhead, Resource, Outside Processing, Overhead), each showing the GL account where that cost element is recorded.
Asset subinventories show 5 rows per item (one per cost element).
Expense subinventories show 1 row per item with total cost under the expense account.
Account determination follows Oracle standard… full description | Enginatics, R12 only | |
| CST Supply Chain Indented Bills of Material Cost | This report is based on the (static) Oracle Supply Chain Indented Bills of Material Cost Report and merely sums up the available information from the Cost Type. It does not do a Cost Rollup and as a result, the "Extended Cost" column might not add up to the total item cost for the assembly especially if changes have been made to the bills of material, routing or item costs, since the last cost rollup. If this is the case, run a Supply Chain Cost Rollup in Pending or some other cost type (such as Current) for reporting purposes, to synchronize the cost information and then use this report,… full description | BI Publisher, 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…