EGL9.1: The Journal is Currently Locked for Process + Process ABENDED at Step IU_PROCESSOR.B200.Step02 (Action SQL) -- RC = 1407 When Running Journal Edit for Intraunit Journal Leaving Inter/IntraUnit Groups Blank (Doc ID 1563250.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

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

Symptoms

On : 9.1 version, Journal Edit

When attempting to run journal edit for an intraunit journal and leaving Inter/IntraUnit Groups blank the following error occurs.

ERROR
-----------------------
The journal is currently locked for process. Please try it later. (5010,138)
and
Process ABENDED at Step IU_PROCESSOR.B200.Step02 (Action SQL) -- RC = 1407 ROLLBACK
SQL Error: ORA-01407: cannot update ("EMDBO"."PS_JRNL_IUW2_TAO4"."BOOK_CODE") to NULL

SETUP
-------------
Required setup:

  1. 'Balance Sheet Indicator’ is active in Set Up Financials/Supply Chain > Install > Installation Options > Overall.
  2. Activate one default Account Balancing Group in Set Up Financials/Supply Chain > Common Definitions > Design Chartfields > Configure > Account Balancing Group.
  3. Navigate to General Ledger > Ledgers > Ledger Groups and go to tab 'Balancing'. Department is a balancing chartfield and 'IntraUnit Balancing Entries' is enabled.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Test 1: Enter Dept for Inter/IntraUnit Groups.


TEST 2: Do NOT click on ‘Inter/IntraUnit’.


Test 3: Do NOT enter Dept for Inter/IntraUnit Groups.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot edit intraunit journals when leaving Dept blank for Inter/IntraUnit Groups.

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