My Oracle Support Banner

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 APRIL 08, 2019

Applies to:

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


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.

The journal is currently locked for process. Please try it later. (5010,138)
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

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.

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.

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




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.