Budget Check Requisition With A Cancel Line Using Project ID Causes Unique Constraint Error (Doc ID 2358781.1)

Last updated on JULY 02, 2023

Applies to:

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 – USXX5
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

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.