EGL9.2: GL_JP Process Abends at Step GL_JP_BOOKCD.Process.InsJrnlH When Run with Different Sources for the Same Run Control (Doc ID 2063369.1)

Last updated on OCTOBER 30, 2015

Applies to:

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

Symptoms

On 9.2 Image 13, PeopleTools 8.53

Journal Post Application Engine fails with unique constraint error when run with different sources for the same run control:


06.08.34 ........(GL_JP_BOOKCD.Process.InsJrnlH) (SQL)
INSERT INTO PS_JHDR_BKCD_TAO7 (PROCESS_INSTANCE, BUSINESS_UNIT, JOURNAL_ID,
JOURNAL_DATE, UNPOST_SEQ, LEDGER_GROUP, JRNL_HDR_STATUS, JRNL_PROCESS_REQST,
...
(BUDGET_HDR_STATUS = 'V' AND ' ' = 'Y'))
/
-- Row(s) affected: 0
-- 06.08.34 Process 1415 ABENDED at Step GL_JP_BOOKCD.Process.InsJrnlH (Action SQL) -- RC = 805
ROLLBACK
/
-- 06.08.34 SQL Error: ORA-00001: unique constraint (SYSADM.PS_JHDR_BKCD_TAO7) violated

Steps:
--------
1. Turn on Book Code in Overall Installation Options
2.  "Update Open Period" option should be set to "By Ledger Code"
3. Attempt to Post the Journal Entry and error is received


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