ABENDED At Step PC_KK_TO_PC.PROCESS.Insert1 When PS_KK_SUBTYPE Has Duplicate Records
Last updated on FEBRUARY 09, 2018
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms