EGL: Journal Is Locked But Cannot Unlock It After Failed Budget Check Process.
Last updated on SEPTEMBER 27, 2017
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.
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.
"The journal is currently locked for process. Please try it later. (5010,138)".
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms