EGL 8.4: Budget Check (FS_BP) Abends at Step FS_BP_PEOD.ActLog.iActiLOg with Unique Constraint When Inserting Into PS_KK_ACTIVITY_LOG. (Doc ID 865706.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.4 and later
Information in this document applies to any platform.
***Checked for relevance on 19-Sep-2012**

Symptoms

ISSUE
=======
Budget was not working for one particular account. The budget check status was staying at 'N' when budget checking a Purchase Order. 

Also found that the account does not work when budget checking from any other transaction types such as Voucher and General Ledger Journal.

When running budget check using that same account in Journal entry,  get unique constraint violation error in PS_KK_ACTIVITY_LOG.


ACTUAL BEHAVIOR
==============
When using the particular expense account, budget fails with error: Cannot insert duplicate key row in object PS_KK_ACTIVITY_LOG.

SPECIFIC ERROR MESSAGE (if applicable)
===========================
SQL error. Stmt #:1603 Error Position: 0 Return: 805 Cannot insert duplicate key row in object 'dbo.PS_KK_ACTIVITY_LOG' with unique index 'PS_KK_ACTIVITY_LOG'.

ABENDED at Step FS_BP_PEOD.ActLog.iActiLOg(SQL)—RC = 805 (108,524)]

STEPS (Sequence of Events)
===================
By following these steps the issue can be reproduced:
1. Create Transaction such as General Ledger Journal.
2. Use the specific account in transaction that will be budget check.
3. Run Edit and Budget check online or via the Batch process.
4. Process will error with Unique Constraint violation in KK_ACTIVITY_LOG.

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