My Oracle Support Banner

E1: 09: Overview of General Accounting Integrity Reports (R007021/R007031/R007011/R097001/R09706/R007032/R097011/R09705/R099102/R097041/R097031/R097021/R09707) (Doc ID 664780.1)

Last updated on JANUARY 07, 2022

Applies to:

JD Edwards EnterpriseOne General Ledger - Version XE and later
JD Edwards EnterpriseOne Accounts Receivable - Version XE and later
JD Edwards EnterpriseOne Accounts Payable - Version XE and later
Information in this document applies to any platform.



Why you should run Integrity Reports?

Integrity reports are an integral part of the JD Edwards EnterpriseOne General Accounting system. Running integrity reports helps you:


When you should run Integrity Reports?

You should run integrity reports at these times:

NOTE: Integrity reports have no "as of" capability, as they provide information that is current at the time you run them. Consequently, the more often you run them, the easier it will be to determine when a problem occurred.

Preferred Order to Run Integrity Reports

The integrities should be run in following sequential order:

  1. Transactions to Batch Headers (R007021)
  2. Batch to Detail & Out of Balance (R007031)
  3. Unposted Batches (R007011)
  4. Companies in Balance (R097001)
  5. Company by Batch Out of Balance (R09706)
  6. Batches Out of Balance (R007032)
  7. Intercompany Accounts in Balance (R097011)
  8. Account Balance to Transactions (R09705)
  9. Repost Account Ledger (R099102)
  10. Accounts without Business Units (R097041)
  11. Account Balance without Account Master (R097031)
  12. Transactions without Account Master (R097021)
  13. Foreign Account Balances (R09707)


This document provides an overview of the General Accounting Integrity Reports, why and when to run the General Accounting integrity reports, the preferred order in which to run the reports, suggestions for preventing integrity issues, a brief overview of the functionality of each report and links to more detailed documents for each Integrity Report.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Why you should run Integrity Reports?
 When you should run Integrity Reports?
 General Accounting Integrity Reports
 Batch Header Reports
 Out-of-Balance Reports
 Suggestions for Preventing Integrity Issues

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.