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

Last updated on MARCH 08, 2017

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

Information Center: Overview of JD Edwards EnterpriseOne Fixed Assets > Information Center: Using JD Edwards EnterpriseOne Fixed Assets > Note 784320.1

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms