My Oracle Support Banner

E1: 12: Fixed Asset Integrity Balance Issue with Account Ledger GLBRE Incorrect (Doc ID 784320.1)

Last updated on MAY 22, 2023

Applies to:

JD Edwards EnterpriseOne Fixed Assets - Version XE and later
Information in this document applies to any platform.
R09801 - General Ledger Post
P1202 - Depreciation Information
P0911 - Journal Entries (JE, J/E)
R12800 - Post G/L Entries to Fixed Assets
R12301 - Unposted Fixed Asset Transactions
R127013 - G/L to Fixed Assets Integrity (GL,GA, G/A, GA, FA or F/A)
R127011 - Fixed Assets to G/L Integrity
System Code: 09-Accounting & Financials
System Code: 12-Fixed Assets




Symptoms

An out-of-balance situation is usually discovered by the regular review of the Integrity Reports, or by noticing that the Cost Summary account totals do not total to the Account Inquiry detail records (F0911).

With correct setup, the functional nature of the Fixed Asset posting cycle provides every Account Ledger record (F0911) posting to one of the period buckets (FLAN01-FLAN14) in the Fixed Asset Master Account Balance (F1202) file, and associated update of the General Account Detail Ledger (F0911) GLBRE field with an asterisk.

This document will help Fixed Asset users and Information Technology Department employees determine if a problem exists between the F0911 and F1202 files.  Users need access to the F0911 and F1202 file and possibly a data base utility program.

Changes

This situation does not occur often and might be caused by unique circumstances including power outage, the system powering down when a program is still running, or multiple user postings.

Cause

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
Symptoms
Changes
Cause
Solution
References

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