My Oracle Support Banner

EGL: Cannot Unlock A Journal That Failed Budget Checking While Unposting (Doc ID 1639730.1)

Last updated on JUNE 20, 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

Issue:
-------

Tried to unpost a journal but it failed budget checking.  Receive message that journal was locked, however when trying to unlock journal via the Journal Unlock page,  journal was not showing up  on page to unlock.

Was able to override the transaction and run budget checking again but where journal went to valid status,  however journal was still locked. 
The field JOURNAL_LOCKED = 'Y' on record JRNL_HEADER for this journal ID where UNPOST_SEQ = 1 (UNPOST_SEQ = 0 is fine). The record JRNL_EDIT_LOG is empty.

Error:
------
"The journal is currently locked for process. Please try it later. (5010,138)".


Steps to Replicate:
---------------------

1. Review journal to unpost.
2. Mark Journal for unposting and have budget check fail.
3. Navigate to unlock the journal: General Ledger->Monitor Background Process->Journal Unlock.


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.