EGL9.2: Journal Edit Abended at Step GL_JEHDR.PutCFBal.InsNonTL (SQL) -- RC = 805 When Running Journal Generator for Subsystem Journals. (Doc ID 1994905.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

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

Symptoms

On : 9.2 version, Journal Edit

When attempting to run Journal Generator having Journal Edit enabled for subsystem journals the following error occurs.

ERROR
-----------------------
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1625 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_JRNL_CF_BAL_TBL) violated Failed SQL stmt: INSERT INTO PS_JRNL_CF_BAL_TBL (BUSINESS_UNIT, JOURNAL_ID, JOURNAL_DATE, UNPOST_SEQ , LEDGER, BUSINESS_UNIT_BAL, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BU DGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, PROJ ECT_ID, BOOK_CODE, GL_ADJUST_TYPE, SETTLEMENT_DT, DATE_CODE, BUDGET_PERIOD, SCENARIO, BAL_SHEET_IND, CURRENCY_CD, FOREIGN_CURRENCY, JRNL_CNTL_DEBITS, JRNL_TOTAL_DEBITS, JRNL_CNTL_CREDITS, JRNL_TOT_CRE DITS, CTL_FOREIGN_DEBITS, TOT_FOREIGN_DEBITS, CTL_FOREIGN_CREDIT, TOT_FOREIGN_CREDIT, JRNL_CNTL_UNIT S, JRNL_NET_UNITS, JRNL_CNTL_LINES, JRNL_TOTAL_LINES, JRNL_ADJUST_LINES, PROCESS_INSTANCE) SELECT BU

Process 6027375 ABENDED at Step GL_JEHDR.PutCFBal.InsNonTL (SQL) -- RC = 805

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Navigate to General Ledger > Journals > Subsystem Journals > Generate Journals.
  2. Enable 'Edit' and run journal generator for subsystem transactions.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot generate, edit and post subsystem journals.

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