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
123 reports
| Description | Download | ||
|---|---|---|---|
| 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 | |
| AR Transactions and Lines | AR transaction report.
Can be run at Header, Line and/or Distribution Level
Display Level Lines and Sales Credits lists each line once per salesperson credit, with the revenue and non-revenue split. Transaction and line amounts are shown on the first row of a transaction or line only, so they can be summed.
Revenue As Of Date adds the accounting rule and the deferred revenue position of each line: Revenue Recognized is the sum of the revenue distributions with a GL date up to that date, and Unearned Balance is the line amount less that, for lines with an accounting rule or with revenue… full description | Receivables Enginatics | |
| AR Transactions and Payments | Detail AR customer billing history including payments / cash receipts, excluding any entered or incomplete transactions.
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 | |
| AR Unapplied Receipts Register | Detail unapplied receipts report with receipt number, date and amount | Receivables Enginatics | |
| AR to GL Reconciliation | Imported from Concurrent Program
Application: Receivables
Source: AR to GL Reconciliation Report
Short Name: ARGLRECR
DB package: | Receivables Enginatics, R12 only | |
| 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 | |
| AR HSBC FAA Asset File (France) | Extracts completed Receivables invoices and credit memos in the HSBC FACTORING FRANCE FAA file format, for invoice discounting. One 532 character record per document.
The report is implemented from the HSBC specification document "HFF - Invoice Discounting - Asset File IT Protocol.pdf" dated 09/09/2025, and its output has been validated against both the field table in that document and the sample file supplied with it. The 31 zones are, in order, each followed by a semicolon: File type FAA (3), Seller account number (5), File creation date YYYYMMDDHHMM (12), Debtor's Seller Identifier (15),… full description | Receivables Enginatics, R12 only | |
| AR Refund Upload | Bulk-refund customer credit balances in AR. Each row refunds either an open credit memo or the unapplied/on-account portion of a customer cash receipt by applying it against the operating unit's Credit Memo Refund Receivables Activity, via AR_CM_APPLICATION_PUB.Activity_application or AR_RECEIPT_API_PUB.Activity_application.
WHEN TO USE EACH REFUND SOURCE
- Credit Memo - the customer has an open credit memo (e.g. overpayment recorded as a CM) and wants the money back.
- Unapplied Receipt - the customer paid more than they owed, or paid against the account with no specific invoice. The… full description | Receivables Enginatics, R12 only, Upload | |
| AR Transaction Update Upload | Updates the post completion header fields of Receivables transactions in the same way as the Transactions workbench: comments, special instructions, print option, purchase order details, salesperson, remit to address, late charges exemption, ship via, FOB, waybill, cross reference and the transaction descriptive flexfield.
The transaction is identified by Operating Unit and Transaction Number. A hidden transaction id links downloaded rows exactly; pasted rows resolve by number, and a number existing under more than one transaction source is rejected with a request to download the transaction… full description | Receivables Enginatics, R12 only, Upload | |
| AR Transaction Upload | This upload can be used to create Invoices, Debit Memos and Credit Memos. Credit memos can be created On Account, or created and applied directly to an existing transaction (an applied credit memo).
The 'Upload Trx Identifier' column is used to uniquely identify each individual transaction (invoice, credit memo, debit memo) to be uploaded.
If the selected batch source uses manual transaction numbering, the Upload Trx Identifier will be copied to the Transaction Number column (the Oracle Transaction Number), but this can be overridden in the upload excel.
If the selected transaction type uses… full description | Receivables Enginatics, Upload | |
| AR Transactions and Lines 11i | Detail AR transaction report with line level details and special columns for service contracts (OKS) and lease contracts (OKL) data
Show Sales Credits lists each line once per salesperson credit, with the revenue and non-revenue split. Transaction and line amounts are shown on the first row of a transaction or line only, so they can be summed.
Revenue As Of Date adds the accounting rule and the deferred revenue position of each line: Revenue Recognized is the sum of the revenue distributions with a GL date up to that date, and Unearned Balance is the line amount less that, for lines with an… full description | Receivables Enginatics | |
| AR Unaccounted Transaction Sweep | Imported from BI Publisher
Application: Receivables
Source: Unaccounted Transaction Sweep
Short Name: ARTRXSWP
DB package: ar_unaccounted_trx_sweep | Receivables BI Publisher, Enginatics, R12 only | |
| AR Account Status | Imported from BI Publisher
Description: Account Status Report
Application: Receivables
Source: Account Status Report (XML)
Short Name: ARXASR_XML
DB package: AR_ARXASR_XMLP_PKG | Receivables BI Publisher | |
| AR Accounting Rules Listing | Application: Receivables
Source: Accounting Rules Listing Report (XML)
Short Name: RAXARL_XML
DB package: AR_RAXARL_XMLP_PKG | Receivables BI Publisher | |
| AR Adjustment Approval | Application: Receivables
Source: Adjustment Approval Report (XML)
Short Name: ARXCTA_XML
DB package: AR_ARXCTA_XMLP_PKG | Receivables BI Publisher | |
| AR AutoCash Rules | Imported from BI Publisher
Description: AutoCash Rules Report
Application: Receivables
Source: AutoCash Rules (XML)
Short Name: ARXPAR_XML
DB package: AR_ARXPAR_XMLP_PKG | Receivables BI Publisher | |
| AR Billing History | Imported from BI Publisher
Description: Billing History
Application: Receivables
Source: Billing History (XML)
Short Name: ARXCBH_XML
DB package: AR_ARXCBH_XMLP_PKG | Receivables BI Publisher | |
| AR Commitment Balance | Application: Receivables
Source: Commitment Balance Report (XML)
Short Name: RAXCBR_XML
DB package: AR_RAXCBR_XMLP_PKG | Receivables BI Publisher | |
| AR Cross Currency Exchange Gain/Loss | Imported from BI Publisher
Description: Cross Currency Exchange Gain/Loss Report
Application: Receivables
Source: Cross Currency Exchange Gain/Loss Report (XML)
Short Name: ARXFXGL_XML
DB package: AR_ARXFXGL_XMLP_PKG | Receivables BI Publisher | |
| AR Customer Open Balance Letter | Application: Receivables
Source: Customer Open Balance Letter (XML)
Short Name: ARXCOBLX_XML
DB package: AR_ARXCOBLX_XMLP_PKG | Receivables BI Publisher | |
| AR Customer Relationships Listing | Application: Receivables
Source: Customer Relationships Listing (XML)
Short Name: ARXCURLL_XML
DB package: AR_ARXCURLL_XMLP_PKG | Receivables BI Publisher | |
| AR DNB Global Data Products Request | Application: Receivables
Source: DNB Global Data Products Request Report (XML)
Short Name: ARHGDPRQ_XML
DB package: AR_ARHGDPRQ_XMLP_PKG | Receivables BI Publisher | |
| AR Duplicate Customer | Application: Receivables
Source: Duplicate Customer Report (XML)
Short Name: RAXMRP_XML
DB package: AR_RAXMRP_XMLP_PKG | Receivables BI Publisher | |
| AR Duplicate DUNS | Application: Receivables
Source: Duplicate DUNS Report (XML)
Short Name: ARHDUNDP_XML
DB package: AR_ARHDUNDP_XMLP_PKG | Receivables BI Publisher | |
| AR Incomplete Invoices | Application: Receivables
Source: Incomplete Invoices Report (XML)
Short Name: RAXIIR_XML
DB package: AR_RAXIIR_XMLP_PKG | Receivables BI Publisher | |
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…