My Oracle Support Banner

EGL92: How to Fix A Partially Unposted Journal With Reversal So the Rest Of It Can Be Posted (Doc ID 2454270.1)

Last updated on MAY 27, 2019

Applies to:

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

Symptoms

After unposting a journal for 1/31/2018 with reversal for 3/1/2018, where Period containing 3/1/2018 was not open - journal headers ended up with the following statuses along with journal error, "journal date not in an open period".

  Journal ID     Journal Date  Unpost Seq  Reversal Cd  Jrnl Hdr Status  Jrnl Process Reqst
  TRN0543700  1/31/2018           0               D                   U                   N
  TRN0543700  1/31/2018           1               D                   V                   P
  TRN0543700  3/01/2018           0               R                   D                   N

Since journal header with Unpost Seq '1' still has journal status V, when try to post this journal get the below error on the page. How to resolve?

ERROR
-----------------------
Journal cannot be modified or deleted because it is modified by another process ( 5010,393)
This journal has already been modified by other process so the journal cannot be modified or deleted.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enter journal dated 1/31/2018 with reversal for 3/1/2018
2. Edit and Post the journal, while period with 3/1/2018 is not open
3. Unpost the journal
4. Since reversal journal dated 3/1/2018 had not yet been posted, it went to status D
5. For journal dated 1/31/2018, the Seq No '0' got status U, however the Seq No '1' got stuck in status V

Changes

 

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.