Budget Check Requisition With A Cancel Line Using Project ID Causes Unique Constraint Error

(Doc ID 2358781.1)

Last updated on FEBRUARY 08, 2018

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Created a two line requisition one using a project ID and one without a project ID. Budget checked the requisition. User then cancelled the line with the grant on it and budget checked the requisition again. Both times budget checking ended successfully. Now user try to change the amount on the open non-grant line. Save the change which creates a change order and then run budget checking. Budget checking now ends in "No Success" with error.

Steps To Replicate The Issue -

Created Funding Source and Added Expense and Revenue ledger groups to GL BU – US005
1.Created a requisition with two lines
Line1 with charfields – Account, Department and Project
Line 2 with chartfields – Account and Department
2.Save and Submit
3. Budget check
4.Pre-Encumbrance created for Line1
5.Cancelled Line1 from details page
6.Click Yes
7.Run Budget check
8.Pre-encumbrance liquidated to old value
9.Now increase the price on the line2 from 50 to 75
10.Click Yes
11.Run Budget Check
12.Process went to No success with unique constraint error -
File: e:\pt85516b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 805 - ORA-00001: unique constraint (EMDBO.PS_KK_ACT_LOG_FS) violated Failed SQL stmt: INSERT INTO PS_KK_ACT_LOG_FS (KK_TRAN_ID, KK_TRAN_DT, KK_TRAN_LN, REFERENCED_BUDGET , BALANCING_LINE, LEDGER_GROUP, LEDGER, FISCAL_YEAR, ACCOUNTING_PERIOD, SEQNBR, RVRSL_FLG, CLOSED_VA LUE, FUND_SOURCE, BUSINESS_UNIT, ACCOUNT, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PRO GRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHAR TFIELD3, BUSINESS_UNIT_PC, PROJECT_ID, ACTIVITY_ID, RESOURCE_TYPE, BUDGET_PERIOD, FOREIGN_CURRENCY, FOREIGN_AMOUNT, BASE_CURRENCY, MONETARY_AMOUNT, KK_BUDG_TRANS_TYPE, KK_GEN_PARENT, KK_AUTO_GEN, DTTM _STAMP_SEC) SELECT KK_TRAN_ID, KK_TRAN_DT, KK_TRAN_LN, REFERENCED_BUDGET, BALANCING_LINE, LEDGER_GRO

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