My Oracle Support Banner

ABENDED At Step PC_KK_TO_PC.PROCESS.Insert1 When PS_KK_SUBTYPE Has Duplicate Records (Doc ID 2359381.1)

Last updated on MAY 16, 2019

Applies to:

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


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.

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

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




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.