Oracle EBS Receivables Reports

30 ready-to-run SQL reports for Oracle E-Business Suite Receivables, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Receivables tables in these reports are hz_parties, hz_cust_accounts, hz_cust_site_uses_all, hz_party_sites, hz_cust_acct_sites_all, ra_customer_trx_all.

Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.

Receivables SQL Reports

Report Description
AR Adjustment Register Application: Receivables Source: Adjustment Register Short Name: ARRXARPB The report has now been enhanced to allow multiple accessible Ledgers or Operating…
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…
AR Aging Buckets and Interest Tiers Setup AR Aging Buckets and Interest Tiers Setup
AR Applied Receipts Application: Receivables Description: Receivables Applied Receipts Register Provided Templates: Default: Detail - Detail Listing with no Pivot Summarization…
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…
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.
AR Customer Credit Snapshot Application: Receivables Source: Customer Credit Snapshot (XML) Short Name: ARXCCSXML DB package: ARARXCCSXMLPPKG
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…
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…
AR Customer Statement Application: Receivables Source: Customer Statement Short Name: ARSTMTRPT DB package: ARTPSTMTPKG When India Localization is installed, the following GST…
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…
AR Disputed Invoice Imported Oracle standard disputed invoice report Source: Disputed Invoice Report (XML) Short Name: ARXDIRXML DB package: ARARXDIRXMLPPKG When India…
AR European Sales Listing Summary report listing sales by country and currency code, with transaction amount / currency and accounted amount/ currency
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…
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…
AR Miscellaneous Receipts Receivables Miscellaneous Receipts Imported from Concurrent Program Application: Receivables Source: Miscellaneous Receipts Register Short Name: ARRXMTRG
AR Open Balances Revaluation Report: AR Open Balances Revaluation Report Application: Receivables Source: AR Open Balances Revaluation Report Short Name: AROBRR
AR Open Items Revaluation Imported from BI Publisher Description: Open Items Revaluation Report Application: Receivables Source: Open Items Revaluation Report (XML) Short Name…
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…
AR Payment Terms Master data report showing the payment terms codes with their respective profile options.
AR Receipt Register Application: Receivables Description: Receivables Receipt Register Provided Templates: Default: Detail - Detail Listing with no Pivot Summarization Pivot…
AR Sales Journal By Customer Imported from BI Publisher Description: Sales Journal By Customer Application: Receivables Source: Sales Journal By Customer (XML) Short Name: RAXGLAXML DB…
AR Transaction Register Application: Receivables Source: Transaction Register Short Name: ARRXINVR The report has now been enhanced to allow multiple accessible Ledgers or Operating…
AR Transaction Types Imported from BI Publisher Description: Print a listing of the Transaction Types Application: Receivables Source: Transaction Types Listing (XML) Short Name…
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…
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…
AR Transactions and Payments Detail AR customer billing history including payments / cash receipts, excluding any entered or incomplete transactions. When India Localization is installed…
AR Unaccounted Transaction Sweep Imported from BI Publisher Application: Receivables Source: Unaccounted Transaction Sweep Short Name: ARTRXSWP DB package: arunaccountedtrxsweep
AR Unapplied Receipts Register Detail unapplied receipts report with receipt number, date and amount
AR to GL Reconciliation Imported from Concurrent Program Application: Receivables Source: AR to GL Reconciliation Report Short Name: ARGLRECR DB package:

← All Oracle EBS modules

© Enginatics GmbH