Blitz Report™ Library
Module GL 143 AP 143 AR 123 FA 138 CE 25 PO 116 INV 129 OM 89 MFG 213 COST 175 PA 131 HR 182 PAY 151 SYS 162
3,150 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. | System Enginatics, R12 only |   |
| AD Applied Patches | AD applied patches, patch runs, included bugs, filenames and actions | System Enginatics | |
| AD Applied Patches R12.2 | Check if a specific patch is applied in 12.2 | System Enginatics | |
| 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. | System Enginatics, R12 only | |
| AD Patch Task Timing | Run time of each job of an adpatch, adop or upgrade session from AD_TASK_TIMING, to identify the jobs that took longest.
Session Percentage is the job's share of the total elapsed time of all jobs in the session. Jobs run in parallel by several workers, so the session's wall clock time is shorter than the sum of the job times. | System Enginatics | |
| ALR Alerts | System Enginatics | | |
| 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 | Payables 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 | Payables 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. | Payables Enginatics, R12 only | |
| AP Expense Policy Violations | Expense report policy violations showing violation type, allowable amount, exceeded amount and expense line details for each violation. Based on Oracle iExpense policy enforcement. | Payables Enginatics | |
| 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. | Payables 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. | Payables 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 | Payables Enginatics, R12 only | |
| 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.
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,… full description | Payables Enginatics | |
| AP Invoice Upload | AP Invoice Upload | Payables Enginatics, Upload | |
| AP Invoice and Payment Audit by Voucher Number | Lists every voucher number of the Payables invoice and payment document sequences with its status: Entered, Deleted (the number was issued, but the invoice or payment no longer exists) or Not Entered (the number is missing from the sequence audit trail).
Replaces Oracle's Invoice Audit by Voucher Number (APXINVAD) and Payment Audit by Voucher Number (APXPAYAD). Unlike Oracle's payment report, a voided payment is listed as Entered with its void date, and a payment number without a payment as Deleted instead of Not Entered.
Missing numbers are the gaps between the numbers recorded in the… full description | Payables Enginatics | |
| AP Invoice on Hold | Based on Oracle standard Invoice on Hold report
Source: Invoice on Hold Report (XML)
Short Name: APXINROH_XML
When India Localization is installed, the following GST columns are also included: GST Registration No, Supplier GSTIN (Invoice Date), GST PAN No, GST TAN No, CGST Amount, SGST Amount, IGST Amount, CESS Amount, CGST Rate, SGST Rate, IGST Rate, CESS Rate, Custom Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code, Days Since Invoice, Amount Settled, Amount Unpaid, ITC Reversal Due, ITC Reversal Exposure. | Payables Enginatics | |
| AP Invoices and Lines | Detail Invoice Aging report with line item details and amounts
Parameter explanation:
- Invoice on Hold (LOV: Yes/No)
Default Value = Null (Hold Status not considered as per current behaviour)
Yes - Only Invoices that currently have an unreleased hold will be retrieved
No - Only Invoices that do not currently have an unreleased hold will be retrieved
- Hold Name (LOV: AP Hold Names)
Default Value Null
If specified - only Invoices that currently have an unreleased hold of the specified name will be retrieved
Hold column explanation:
- Holds - a list of the current unreleased… full description | Payables Enginatics | |
| AP Invoices and Lines 11i | Detail Invoice Aging report with line item details and amounts.
The Approval Status column and parameter show and filter the status of the invoice in the Invoice Approval Workflow.
On withholding tax distributions, the withholding columns show the withholding tax and rate, the tax authority supplier and site of the tax, the gross amount subject to withholding, the payment that created the withholding when it was calculated at payment, and the invoice raised to the tax authority. | Payables Enginatics | |
| 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. | Payables 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 | Payables 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 | Payables 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. | Payables 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. | Payables Enginatics, R12 only | |
| AP Suppliers | AP suppliers (po vendors) including supplier sites, contact and bank account information on vendor and site level
When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, GST TAN No.
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… full description | Payables Enginatics | |
| AP Suppliers Revenue Summary | AP suppliers (po vendors) revenue summary across different operating units | Payables Enginatics | |
| AP Suppliers Revenue by Period | AP invoice amount per supplier and invoice currency, with one column per GL period from Period From to Period To.
An invoice is counted in the period of its invoice GL date. Periods are taken from the ledger's accounting calendar, excluding adjustment periods, and each column is named after the month the period falls in. | Payables Enginatics | |
| 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. | Payables Enginatics, R12 only | |
| AP Trial Balance Report Definitions | Accounts Payable Trial Balance Report Definitions | Payables 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. | Receivables 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 | Receivables Enginatics, R12 only | |
| AR Aging Buckets and Interest Tiers Setup | AR Aging Buckets and Interest Tiers Setup | Receivables Enginatics | |
| 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 | Receivables Enginatics, R12 only | |
| AR Autoinvoice Interface | Lines in the Autoinvoice interface table, one row per interface line, with all errors of the line from the last Autoinvoice run concatenated in Error Messages and Invalid Values.
Interface Line Id is assigned by Autoinvoice, so lines that it has not picked up yet have none and cannot have errors.
With Show Distributions and Sales Credits, each line is repeated per interface distribution and sales credit, and its quantity, amount and Line Count of 1 are shown on the first of these rows only.
The template Autoinvoice Interface Summary totals the lines per operating unit, batch source,… full description | Receivables Enginatics | |
| AR Customer Credit Limits | Master data report for customer setup audit of credit amount limits and GL accounts for customer credit management and dunning notices. | Receivables Enginatics | |
| AR Customer Credit Snapshot | Application: Receivables
Source: Customer Credit Snapshot (XML)
Short Name: ARXCCS_XML
DB package: AR_ARXCCS_XMLP_PKG | Receivables Enginatics, R12 only | |
| AR Customer Profiles | Customer account and site level profile details such as profile class, payment terms, statement, dunning, collector and credit settings, including the profile amount limits per currency.
Application: Receivables
Source: Customer Profiles Report (XML)
Short Name: ARXCCP_XML
DB package: AR_ARXCCP_XMLP_PKG | Receivables Enginatics | |
| 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. | Receivables Enginatics, R12 only | |
| AR Disputed Invoice | Imported Oracle standard disputed invoice report
Source: Disputed Invoice Report (XML)
Short Name: ARXDIR_XML
DB package: AR_ARXDIR_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, 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, Taxable Value, HSN SAC Code. | Receivables Enginatics | |
| AR European Sales Listing | Summary report listing sales by country and currency code, with transaction amount / currency and accounted amount/ currency | Receivables Enginatics, R12 only | |
| AR Incomplete Transactions | Detail incomplete transaction report
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, CGST Recoverable, CGST Non-Recoverable, SGST Recoverable, SGST Non-Recoverable, IGST Recoverable, IGST Non-Recoverable, Reverse Charge Flag, Place of Supply, Ship From State. | Receivables Enginatics | |
| AR Miscellaneous Receipts | Receivables Miscellaneous Receipts
Imported from Concurrent Program
Application: Receivables
Source: Miscellaneous Receipts Register
Short Name: ARRXMTRG | Receivables Enginatics | |
| AR Open Balances Revaluation | Report: AR Open Balances Revaluation Report
Application: Receivables
Source: AR Open Balances Revaluation Report
Short Name: AROBRR | Receivables 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 | Receivables BI Publisher, Enginatics, R12 only | |
| AR Past Due Invoice | Detail past due AR invoice report with invoice number, days past due, amount past due and currency code
When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, CESS Amount, CGST Amount, Custom Amount, IGST Amount, SGST Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code, CESS Rate, CGST Rate, IGST Rate, SGST Rate, CGST Non-Recoverable, CGST Recoverable, IGST Non-Recoverable, IGST Recoverable, SGST Non-Recoverable, SGST Recoverable, Reverse Charge Flag. | Receivables Enginatics | |
| AR Payment Terms | Master data report showing the payment terms codes with their respective profile options. | Receivables Enginatics | |
| 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 | Receivables 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. | Receivables 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 | Receivables Enginatics, R12 only | |
| AR Transaction Types | Imported from BI Publisher
Description: Print a listing of the Transaction Types
Application: Receivables
Source: Transaction Types Listing (XML)
Short Name: RAXTTL_XML
DB package: AR_RAXTTL_XMLP_PKG | Receivables 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…