My Oracle Support Banner

EGL: What Are Some Recommendations For Correcting Journal vs. Ledger Integrity Problems (Journal vs Ledger Out of Sync) (Doc ID 607598.1)

Last updated on JULY 10, 2019

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

This document discusses some common scenarios on how to correct the problem of having the Ledger and journals out of sync?


This situation should not occur naturally but it may occurs sometimes due to the user error,  system bug, environmental issues(ie running out of tablespace, timeouts, power outages, network issues)

 

Since every integrity issue is unique to the customer and to the environment, It is recommended that you make a copy of the environment and test out any alternatives you identify for resolution and verify what options(as identified below or that you identify) works.

Once you test it out, you can follow the same steps in affected environment.

Solution

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
Goal
Solution
 General Guideline:
 
 Handling of Different Scenario
 
 I.  To correct journal line data in a posted journal not showing up in LEDGER.
 II.  To correct a double posted journal.
 III.  To Correct out of balance on Journal Vs Ledger Integrity report due to deletion of posted or unposted journal.
 IV.  Journal has posted status but ledger not updated.
 V.  Unposted InterUnit Journal deleted creates discrepancy between the ledger balance and the journal entries.
 VI.  Journal is Posted by one user at one workstation while in buffer at another workstation and then deleted.
References

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