My Oracle Support Banner

E1: 09: Overview of Account Balance to Transaction Integrity Report (R09705) (Doc ID 1383948.1)

Last updated on JANUARY 31, 2019

Applies to:

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

Purpose

Overview

The Account Balance to Transaction Integrity Report (R09705) assists in locating out-of-balance conditions in the system by identifying imbalances between the Account Balance F0902 and Account Ledger F0911 tables on a period-by-period basis.

Scope

This document provides an overview of the Account Balance to Transaction Integrity Report (R09705) including the overview, program functionality, setup, information on reviewing and resolving the integrity report, reasons for integrity and frequently asked questions.

Details

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
Purpose
 Overview
Scope
Details
 Functionality
 Setup
 Processing Options
 Data Selection
 With performance 9.1 Bug 17533200 applied or at release 9.2 and later:
 Reviewing the Report
 Resolving the Integrity
 Frequently Asked Questions
 Question 1: The R09705 integrity report is showing out of balance conditions in a multi-currency environment. After exporting F0911/F0902 data as per above instructions and during analysis found that the F0902 table has duplicate records for each fiscal year, one with CRCD=USD and one with CRCD blank. How did this happen and how can it be fixed?
 Question 2: Why were the processing options changed for the R09705 report beginning in 8.10?
 Question 3: What is the difference in functionality between the Account Balance to Transaction Report (R09705) and Repost Account Ledger Report (R099102)?
 Question 4: Why is the Account Balance to Transaction Report (R09705) printing "No Data Selected" when no integrity issue is found rather than just a blank page?
 Question 5: Why is R09705 failing with ERROR: Memory allocation failed?
 Additional Resources
References

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