EGL: Journal Is Locked But Cannot Unlock It After Failed Budget Check Process. (Doc ID 1639730.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

9.2 version, Journal Post

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
-----------------------
The issue can be reproduced at will with the following steps:
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.




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