EGL: Transactions Do Not Show Up On The Commitment Control >Review Budget Check Exceptions> Source Header Unlock Page, After Online Journal Processing Time Out. (Doc ID 1665791.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

CUSTOMER ENVIRONMENT
Release 9.2

ISSUE
The journal was created as a result of the journal generation process and budget checked. The KK_PROCESS_STATUS is 'I' but it still does not display on the Unlock KK Source Header page in order for the user to Unlock and budget check again. 

We believe the issue occurs after journal generation from an external source with a large number of lines in the transaction.  The user processed the transaction from the journal entry page running journal edit that then calls the budget check.

 

REPLICATION 

Can not be replicated on demand from within the delivered pages.

  1. Journal generate large external journal
  2. Process through edit/budget check from journal entry page(General Ledger > Journals > Create Journals
  3. Page time out
  4. Try to navigate back to journal or to review budget exceptions, find transaction locked
  5. Navigate to Commitment->Review Budget Check Exceptions->Source Header Unlock
  6. Update manually via SQL KK_PROCESS_STATUS field to 'I' on tables KK SOURCE HEADER, KK_SHDR_GLJRNL and KK_BP_LOG. Since not updated, the journals can not be open , but do not show up on Commitment->Review Budget Check Exceptions->Source Header Unlock
  7. Still does not show up on Source Header Unlock page

 

 

EXPECTED RESULTS

If processing does not complete and a journal is left in a locked condition, the journal should show up on the unlock page.

 

ACTUAL RESULTS

Some journals end up in locked condition that do not show up on the unlock page

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