ABENDED At Step PC_KK_TO_PC.PROCESS.Insert1 When PS_KK_SUBTYPE Has Duplicate Records

(Doc ID 2359381.1)

Last updated on JUNE 26, 2018

Applies to:

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

Symptoms

On :  9.2 version, Commitment Control

ABENDED at Step PC_KK_TO_PC.PROCESS.Insert1 when PS_KK_SUBTYPE has duplicate records  

When run PC_KK_TO_PC process we are abending with duplicate records.   The problems seems to be with the KK_SUBTYPE table.

I am attaching the KK_SUBTYPE table and the code failing.   I can see the issue is with there being two subtypes for the same SETID, LEDGER_GROUP.   The process is not looking at subtype when selecting the KK_SUBTYPE table, just at the SETID and LEDGER_GROUP.

ERROR
------------------
-- 11:14:40.615 Process 819855 ABENDED at Step PC_KK_TO_PC.PROCESS.Insert1 (Action SQL) -- RC = 805
ROLLBACK
/
-- 11:14:40.632 SQL Error: ORA-00001: unique constraint (ADMIN.PS_INTFC_PROJ_RES) violated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. create KK budget definition with 2 diff rulesets in 2 diff eff dt. KK_SUBTYPE will have 2 SUB_TYPE for the same ledger group
2. Enter Budget journal
3. Post the budget journal
4. Run PC_KK_TO_PC


Changes

 

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