Budget Check Requisition With A Cancel Line Using Project ID Causes Unique Constraint Error
(Doc ID 2358781.1)
Last updated on FEBRUARY 01, 2021
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
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
7.Run Budget check
8.Pre-encumbrance liquidated to old value
9.Now increase the price on the line2 from 50 to 75
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
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