List Of Standard Reports In Oracle Ebs

List of Standard Reports in Oracle EBS.doc

Contents Contents .................................................................................................................................................... 1 List of Standard Reports - General Ledger........................................................................................... 2 Account Analysis Reports .................................................................................................................. 2 Budget Reports and Listings .............................................................................................................. 2 Chart of Accounts Reports and Listings........................................................................................... 2 Multi-Company Accounting and Consolidation Reports.............................................................. 2 Currency Listings ................................................................................................................................ 2 Financial Statement Generator Reports and Listings ..................................................................... 3 General Ledger Reports ...................................................................................................................... 3 Journal Reports .................................................................................................................................... 3 Trial Balance Reports .......................................................................................................................... 3 Execution Reports................................................................................................................................ 4 List of Standard Reports – Account Payables...................................................................................... 5 Supplier Reports .................................................................................................................................. 5 Invoice Reports .................................................................................................................................... 5 Payment Reports.................................................................................................................................. 6 Accounting and Reconciliation Reports ........................................................................................... 6 Listings .................................................................................................................................................. 6 List of Standard Reports – Accounts Receivable................................................................................. 7 Accounting Reports............................................................................................................................. 7 Collection Reports ............................................................................................................................... 8 Execution Reports................................................................................................................................ 8 Invoice Print Reports........................................................................................................................... 8 Listing Reports ..................................................................................................................................... 9 Other Reports ....................................................................................................................................... 9 List of Standard Reports – Fixed Assets ............................................................................................. 10 CIP Reports......................................................................................................................................... 10 Asset Listings ..................................................................................................................................... 10 Setup Data Listings............................................................................................................................ 10 Depreciation Reports......................................................................................................................... 10 Accounting Reports........................................................................................................................... 10 Additions Reports.............................................................................................................................. 11 Mass Additions Reports ................................................................................................................... 11 Transfers Reports............................................................................................................................... 11 Reclassification Reports .................................................................................................................... 11 Retirements Reports .......................................................................................................................... 11 List of Standard Reports – Cash Management .................................................................................. 12 Statements Reports ............................................................................................................................ 12 Transactions Reports......................................................................................................................... 12 List of Standard Reports – Inventory.................................................................................................. 13 List of Standard Reports – Purchasing ............................................................................................... 15 List of Standard Reports – Order Management ................................................................................ 17

Page 1 of 17

List of Standard Reports in Oracle EBS.doc

List of Standard Reports - General Ledger Account Analysis Reports 1. 2. 3. 4. 5.

Account Analysis Report Account Analysis Report with Payables Detail Account Analysis Report with Subledger Detail Foreign Account Analysis Report Foreign Account Analysis Report with Payables Detail

Budget Reports and Listings 6. 7. 8. 9. 10. 11. 12.

Budget Journals by Flexfield Report Budget Organization Listing Budget Organization Range Listing Funds Available Analysis Report Master/Detail Budget Report Summary/Detail Budget Report Unbudgeted Master/Detail Accounts Report

Chart of Accounts Reports and Listings 13. 14. 15. 16.

Account Hierarchy Report Chart of Accounts Listing Segment Values Listing Suspense Accounts Listing

Multi-Company Accounting and Consolidation Reports 17. Intercompany Transactions Detail Report 18. Intercompany Transaction Trial Balance 19. Unapproved Intercompany Transactions Listing

Currency Listings 20. Daily Conversion Rates Listing 21. Period Rates Listing

Page 2 of 17

List of Standard Reports in Oracle EBS.doc

Financial Statement Generator Reports and Listings 22. 23. 24. 25. 26. 27. 28. 29. 30.

Column Set Detail Listing Column Set Summary Listing Content Set Detail Listing Content Set Summary Listing Report Detail Listing Report Summary Listing Row Order Detail Listing Row Set Detail Listing Row Set Summary Listing

General Ledger Reports 31. Foreign Currency General Ledger Report 32. General Ledger Report

Journal Reports 33. 34. 35. 36. 37. 38. 39. 40.

Foreign Currency Journals Report Posted Journals Report Unposted Journals Report Error Journals Report Journal Batch Summary Report Journal Entry Report Journal Line Report Journals by Document Number Report

Trial Balance Reports 41. 42. 43. 44. 45. 46. 47. 48.

Budget Trial Balance Report Detail Trial Balance Report Encumbrance Trial Balance Report Expanded Trial Balance Report Foreign Currency Detail Trial Balance Report Foreign Currency Summary 1 Trial Balance Report Summary 1 Trial Balance Report Summary 2 Trial Balance Report

Page 3 of 17

List of Standard Reports in Oracle EBS.doc

Execution Reports 49. 50. 51. 52. 53. 54. 55. 56. 57.

AutoPost Execution Report Budget Spreadsheet Upload Execution Report Create Journal Entries Execution Report Delete Journal Import Data Execution Report Intercompany Transfer Program Execution Report Journal Import Execution Report Posting Execution Report Recurring Intercompany Transactions Execution Report Segment Value Inheritance Execution Report

Page 4 of 17

List of Standard Reports in Oracle EBS.doc

List of Standard Reports – Account Payables Supplier Reports 1. 2. 3. 4. 5. 6. 7. 8. 9.

Purchase Order Header Updates Report Supplier Audit Report Supplier Customer Netting Report Supplier Mailing Labels Supplier Merge Report Supplier Open Balance Letter Supplier Paid Invoice History Report Supplier Payment History Report Suppliers Report

Invoice Reports 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27.

Accrual Reconciliation Report Credit Memo Matching Report Expense Report Import Report Invoice Aging Report Invoice Approval Quick Release Report Invoice Audit Listing by Voucher Number Invoice Audit Report Invoice History Report Invoice on Hold Report Invoice Register Invoice Validation Report Matching Detail Report Matching Hold Detail Report Payables Open Interface Import Report Prepayments Applied Report (Expense Report Import) Prepayments Status Report Recurring Invoices Report Unrealized Gain/Loss Report

Page 5 of 17

List of Standard Reports in Oracle EBS.doc

Payment Reports 28. 29. 30. 31. 32. 33. 34. 35. 36. 37. 38. 39.

Cash Requirement Report E-mail Remittance Advice Final Payment Register Future Payment Maturity Date Report Missing Document Numbers Report Payment Audit by Voucher Number Payment Register Positive Pay Report Preliminary Payment Register Separate Remittance Advice Stopped Payments Report Void Payment Register

Accounting and Reconciliation Reports 40. 41. 42. 43. 44. 45. 46. 47. 48.

Payables Accounting Entries Report Accounts Payable Trial Balance Report Payables Account Analysis Report Payables Accounting Entries Report Payables Accounting Process Report Period Close Exceptions Report Posted Invoice Register Posted Payment Register Unaccounted Transactions Report

Listings 49. 50. 51. 52. 53. 54.

Bank Account Listing Distribution Set Listing Employee Listing Expense Report Template Listing Payment Terms Listing Payables Lookups Listing

Page 6 of 17

List of Standard Reports in Oracle EBS.doc

List of Standard Reports – Accounts Receivable Accounting Reports 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31.

Account Status Report Adjustment Approval Report Adjustment Register Aging - 7 Buckets By Account Report Applied Receipts Register AR Reconciliation Report Bad Debt Provision Report Credit Hold Report Customer Open Balance Letter Disputed Invoice Report Invoice Exception Report Invoices Posted to Suspense Journal Entries Report Journal with GL Details Report Miscellaneous Receipts Register Other Applications Report Other Receipt Applications Report Publish Actual Receipt Publish Transaction Check Receipt Analysis - Days Late Report Receipts Journal Report Receipt Register Receipts Awaiting Bank Clearance Receivables Standard Reports and Listings Receipts Awaiting Remittance Report Sales Journal By Customer Sales Journal by GL Account Transaction Reconciliation Report Transaction Register Unapplied and Unresolved Receipts Register Unposted Items Report

Page 7 of 17

List of Standard Reports in Oracle EBS.doc

Collection Reports 32. 33. 34. 35. 36. 37. 38. 39. 40. 41. 42. 43. 44. 45. 46. 47. 48. 49. 50. 51. 52. 53. 54. 55.

Account Status Report Aging - 4 and 7 Bucket Report Aging Reports Applied Receipts Register Automatic Receipt Batch Management Automatic Receipts Awaiting Confirmation Bad Debt Provision Report Billing and Receipt History Billing History Report Call Actions Report Collections by Collector Report Collector Call History Report Collector’s Follow Up Report Credit Hold Report Customer Credit Snapshot Report Customer Follow Up History Report Journal Entries Report Past Due Invoice Report Receipt Analysis - Days Late Report Receipt Promises Report Receipt Register Receipts Awaiting Bank Clearance Receipts Awaiting Remittance Report Remittance Batch Management Report

Execution Reports 56. AutoAdjustment Reports 57. AutoInvoice Reports 58. Posting Execution Report

Invoice Print Reports 59. 60. 61. 62.

Invoice Print Preview Report Invoice Batch Sources Listing Invoice Exception Report Print Invoice Reports

Page 8 of 17

List of Standard Reports in Oracle EBS.doc

Listing Reports 63. 64. 65. 66. 67. 68. 69. 70. 71. 72. 73. 74.

Accounting Rules Listing Report AutoCash Rules Listing Customer Listing Detail/Summary Customer Profiles Report Customer Relationships Listing Duplicate Customer Report Incomplete Invoices Report Ordering and Grouping Rules Listing Payment Terms Listing Receipts Without Sites Report Standard Memo Lines Listing Transaction Types Listing

Other Reports 75. 76. 77. 78. 79.

Audit Report by Document Number Deposited Cash Applied and Open Detail Report Setup Details Report Supplier Customer Netting Report Transaction Detail Report

Page 9 of 17

List of Standard Reports in Oracle EBS.doc

List of Standard Reports – Fixed Assets CIP Reports 1. 2.

CIP Assets Report CIP Capitalization Report

Asset Listings 3. 4. 5. 6. 7. 8. 9. 10. 11. 12.

Fixed Assets Book Report Asset Description Listing Asset Inventory Report Asset Listing by Period Asset Register Report Asset Tag Listing Assets by Category Report Fully Reserved Assets Report Physical Inventory Comparison Report Physical Inventory Missing Assets Report

Setup Data Listings 13. Asset Category Listing 14. Depreciation Rate Listing

Depreciation Reports 15. Depreciation Projection Report 16. Unplanned Depreciation Report 17. What-if Depreciation Report

Accounting Reports 18. 19. 20. 21. 22. 23. 24. 25. 26. 27.

Account Reconciliation Reserve Ledger Report Accumulated Depreciation Balance Report Asset Cost Balance Report CIP Cost Balance Report Cost and CIP Detail and Summary Reports Cost Clearing Reconciliation Report Cost Clearing Reconciliation Report (Variable Format) Journal Entry Reserve Ledger Report Reserve Detail and Summary Reports Reserve Ledger Report

Page 10 of 17

List of Standard Reports in Oracle EBS.doc

Additions Reports 28. 29. 30. 31. 32. 33. 34. 35.

Additions by Date Placed in Service Report Additions by Period Report Additions by Responsibility Report Additions by Source Report Annual Additions Report Asset Additions by Cost Center Report Asset Additions Report Asset Additions Responsibility Report

Mass Additions Reports 36. 37. 38. 39. 40. 41. 42. 43.

Mass Additions Delete Report Mass Additions Create Report Mass Additions Invoice Merge and Split Reports Mass Additions Posting Report Mass Additions Purge Report Mass Additions Report Mass Additions Status Report Unposted Mass Additions Report

Transfers Reports 44. 45. 46. 47.

Asset Transfers Report Asset Transfer Reconciliation Report Asset Disposals Responsibility Report Transfers Report

Reclassification Reports 48. Asset Reclassification Report 49. Asset Reclassification Reconciliation Report 50. Reclassifications Report

Retirements Reports 51. 52. 53. 54.

Asset Retirements by Cost Center Report Asset Retirements Report Reinstated Assets Report Retirements Report

Page 11 of 17

List of Standard Reports in Oracle EBS.doc

List of Standard Reports – Cash Management Statements Reports 1. 2. 3. 4. 5.

AutoReconciliation Execution Report Bank Statement Detail Report Bank Statement Loader Execution Report Bank Statement Summary Report GL Reconciliation Report

Transactions Reports 6. 7. 8.

Cash in Transit Report Cleared Transactions Report Transactions Available for Reconciliation Report

Page 12 of 17

List of Standard Reports in Oracle EBS.doc

List of Standard Reports – Inventory 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. 35. 36. 37. 38. 39. 40. 41. 42. 43. 44. 45. 46. 47. 48.

Inactive Items Report Item Reservations Report Lot Transaction Register Material Account Distribution Detail Move Order Pick Slip Report Material Account Distribution Summary Serial Number Transaction Register Transaction Historical Summary Report Transaction Register Transaction Source Type Summary Shortages Summary Report Shortage Parameter Report Global Transaction Purge Open Period Status Control Close Period Status Control Expired Lots Report Item Categories Report Item Cross-References Listing Item Definition Detail Item Definition Summary Item Demand History Report Item Relationships Listing Item Statuses Report Item-Subinventory Report Item Template Listing Serial Number Detail Supplier Lot Trace Report Customer Item Commodity Codes Listing Customer Item Cross References Report Customer Items Report Item Organization Assignment Report Period Close Value Summary Forecast Rule Listing Item Replenishment Count Report PAR Replenishment Count Worksheet Min-Max Planning Report ABC Assignments Report ABC Descending Value Report Cycle Count Entries and Adjustments Report Cycle Count Hit/Miss Analysis Cycle Count Listing Physical Inventory Item Accuracy Report Physical Inventory Adjustments Report Physical Inventory Counts Report Cycle Count Open Requests Listing Cycle Count Unscheduled Items Report Cycle Counts Pending Approval Report Physical Inventory Tags

Page 13 of 17

List of Standard Reports in Oracle EBS.doc 49. 50. 51. 52. 53. 54. 55. 56. 57. 58. 59. 60. 61. 62. 63. 64. 65. 66. 67. 68. 69. 70. 71.

Physical Inventory Tag Listing Physical Inventory Missing Tag Listing Physical Inventory Trend Report Physical Inventory Summary Report Print Cycle Count Entries Open Interface Data Purge Cycle Count Entries Open Interface Data Import Cycle Count Entries from Open Interface Cycle Count Schedule Requests Report Item Quantities Summary Report Locator Quantities Report Subinventory Quantities Report Account Alias Listing Freight Carrier Listing Inter-organization Shipping Information Listing Locator Listing Organization Parameters Listing Planner Listing Status Attributes Listing Subinventory Listing Units of Measure Listing Intercompany AR Invoices Report Intercompany AP Invoices Report Inventory Charges and Product Usage Report

Page 14 of 17

List of Standard Reports in Oracle EBS.doc

List of Standard Reports – Purchasing 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. 35. 36. 37. 38. 39. 40. 41. 42. 43. 44. 45. 46. 47.

Accrual Reconciliation Report Accrual Write–Off Report Advanced Shipment Notice Discrepant Receipts Report ASL Upgrade Process Backordered Internal Requisitions Report Blanket and Planned PO Status Report Buyer Listing Buyer’s Requisition Action Required Report Cancelled Purchase Orders Report Cancelled Requisitions Report Confirm Receipts Workflow Select Orders Process Contract Status Report Country of Origin Report (by Item) Country of Origin Report (by Supplier) Create Internal Sales Orders Process Create Releases Process Encumbrance Detail Report Expected Receipts Report Fill Employee Hierarchy Process Financials/Purchasing Options Listing Internal Requisition Status Report Internal Requisitions/Deliveries Discrepancy Report Invoice Price Variance Report Invoice Price Variance by Supplier Report Item Detail Listing Item Summary Listing Location Listing Matching Holds by Buyer Report New Supplier Letter Report Open Purchase Orders Report (by Buyer) Open Purchase Orders Report (by Cost Center) Overdue Supplier Shipments Report Overshipments Report Payment on Receipt Printed Change Orders Report (Landscape) Printed Change Orders Report (Portrait) Printed Purchase Order Report (Landscape) Printed Purchase Order Report (Portrait) Printed RFQ Report (Landscape) Printed RFQ Report (Portrait) Printed Requisitions Report Purchase Agreement Audit Report Purchase Order Commitment by Period Report Purchase Order Detail Report Purchase Order Distribution Detail Report Purchase Order and Releases Detail Report Purchase Price Variance Report

Page 15 of 17

List of Standard Reports in Oracle EBS.doc 48. 49. 50. 51. 52. 53. 54. 55. 56. 57. 58. 59. 60. 61. 62. 63. 64. 65. 66. 67. 68. 69. 70. 71. 72. 73. 74. 75. 76. 77. 78. 79. 80. 81. 82. 83. 84. 85. 86. 87. 88. 89. 90. 91.

Purchase Requisition Status Report Purchase Summary Report by Category Purchasing Activity Register Purchasing Database Administration Purchasing Documents Open Interface Purchasing Interface Errors Report Purge Purchasing Open Interface Processed Data Quality Code Listing Quotation Action Required Report RFQ Action Required Report Receipt Accruals – Period–End Process Receipt Adjustments Report Receipt Traveler Receiving Account Distribution Report Receiving Exceptions Report Receiving Interface Errors Report Receiving Transaction Processor Receiving Transactions Register Receiving Value Report Receiving Value Report by Destination Account ReqExpress Templates Listing Requisition Activity Register Requisition Distribution Detail Report Requisition Import Process Requisition Import Exceptions Report Requisitions on Cancelled Sales Order Report Reschedule Requisitions Process Savings Analysis Report (by Buyer) Savings Analysis Report (by Category) Send Notifications for Purchasing Documents Standard Notes Listing Substitute Receipts Report Supplier Affiliated Structure Listing Supplier Price Performance Analysis Report Supplier Purchase Summary Report Supplier Quality Performance Analysis Report Supplier Service Performance Analysis Report Supplier Volume Analysis Report Suppliers on Hold Report Tax Code Listing Uninvoiced Receipts Report Unit of Measure Class Listing Unit of Measure Listing Unordered Receipts Report

Page 16 of 17

List of Standard Reports in Oracle EBS.doc

List of Standard Reports – Order Management 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31.

Comprehensive Order Detail Report Order/Invoice Detail Report Orders by Item Report Sales Order Acknowledgement Sales Order Workflow Status Report Credit Order Detail Report Credit Order Discrepancy Report Credit Order Summary Report Credit Limit Usages Report Credit Exposure Report Orders On Credit Check Hold Report Lines on Credit Check Hold Report Payment Receipt Hold Source Activity Report Sales Order and Purchase Order Discrepancy Report-Drop Shipment Internal Order and Purchasing Requisition Discrepancy Report Order Discount Detail Report Order Discount Summary Report Unbooked Orders Report Unbooked Orders Detail Report Cancelled Orders Report RetroBilling Report Returns by Reason Report Cancelled Orders Reasons Detail Report Agreement Activity Report Orders Summary Report Order/Invoice Summary Report Salesperson Order Summary Report Defaulting Rules Listing Report Processing Constraints Listing Transaction Types Listing Report

Page 17 of 17