EGL 9.1: Budget Checking Abends at Step FS_BP_SHDR.NewHdrs.iKKSrcH with Unique Constraint Error for New Transactions After Upgrade to 9.1. (Doc ID 1106253.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 and later
Information in this document applies to any platform.
****Checked for Currency on Dec-7-2011****


Symptoms

ISSUE:
----------------------

9.1 version, KK-Budget Checking

When attempting to run Budget Checking,  the following error occurs:

ERROR
-----------------------
-- 13.30.20 .........(FS_BP_SHDR.NewHdrs.iKKSrcH) (SQL)
INSERT INTO PS_KK_SOURCE_HDR (KK_TRAN_ID, KK_TRAN_DT, KK_SOURCE_TRAN,.........
-- Row(s) affected: 0
-- 13.30.20 Process 5918482 ABENDED at Step FS_BP_SHDR.NewHdrs.iKKSrcH (Action SQL) -- RC = 805
ROLLBACK
/-- 13.30.20 SQL Error: ORA-00001: unique constraint (SYSADM.PSPKK_SOURCE_HDR) violated


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Complete upgrade from 9.0 to 9.1.
2. Budget check a new transaction in 9.1
3. Review trace file for error.

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