PO Budget Check (FS_BP) Abended at FS_BP_PEOD.ActLogC.iActLog With Unique Constraint (Doc ID 1948885.1)

Last updated on JANUARY 13, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.1 and later
Information in this document applies to any platform.

Goal

PO Budget Check abended with the following error:

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1620 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_KK_ACTIVITY_LOG) violated
Failed SQL stmt:INSERT INTO PS_KK_ACTIVITY_LOG (KK_TRAN_ID, KK_TRAN_DT, KK_TRAN_LN, REFERENCED_BUDGET, BALANCING_LINE, LEDGER_GROUP, LEDGER, FISCAL_YEAR, ACCOUNTING_PERIOD, SEQNBR, RVRSL_FLG, CLOSED_VALUE, BUSINESS_UNIT, ACCOUNT, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, BUSINESS_UNIT_PC, PROJECT_ID, ACTIVITY_ID, RESOURCE_TYPE, BUDGET_PERIOD, FOREIGN_CURRENCY, FOREIGN_AMOUNT, BASE_CURRENCY, MONETARY_AMOUNT, STATISTICS_CODE, STATISTIC_AMOUNT, KK_QUANTITY, ENTRY_EVENT, EE_PROC_STATUS, EXPIRED_YEAR, KK_BUDG_TRANS_TYPE, KK_GEN_PARENT, KK_AUTO_GEN, ACTIVITY, DTTM_STAMP_SEC, ACCOUNTING_DT) SELECT A.KK_TRAN_ID, A.KK_TRAN_DT, A.KK_TRAN_LN, A.REFERENCED_BUDGET, A.BALANCING_LINE, A.LEDGER_GROUP, A.LEDGER, A.FISCAL_YEAR, A.ACCOUNTING_PERIOD, A.SEQNBR, A.RVRSL_FLG, A.KK_CLOSE_FLAG, A.BUSINESS_UNIT, A.ACCOUNT, A.DEPTID, A.OPERATING_UNIT, A.PRODUCT, A.FUND_CODE, A.CLASS_FLD, A.PROGRAM_CODE, A.BUDGET_REF, A.AFFILIATE, A.AFFILIATE_INTRA1, A.AFFILIATE_INTRA2, A.CHARTFIELD1, A.CHARTFIELD2, A.CHARTFIELD3, A.BUSINESS_UNIT_PC, A.PROJECT_ID, A.ACTIVITY_ID, A.RESOURCE_TYPE, A.BUDGET_PERIOD, A.FOREIGN_CURRENCY, A.FOREIGN_AMOUNT, A.BASE_CURRENCY, A.MONETARY_AMOUNT, A.STATISTICS_CODE, A.STATISTIC_AMOUNT, A.KK_QUANTITY, A.ENTRY_EVENT, A.EE_PROC_STATUS, A.EXPIRED_YEAR, A.KK_BUDG_TRANS_TYPE, A.KK_GEN_PARENT, A.KK_AUTO_GEN, A.ACTIVITY, CAST(SYSTIMESTAMP AS TIMESTAMP), A.KK_ACCOUNTING_DT FROM PS_BP_ACT_TAO5 A WHERE A.KK_TRAN_ID=:1 AND A.KK_TRAN_DT=TO_DATE(:2,'YYYY-MM-DD') AND A.PROCESS_INSTANCE=:3 AND A.KK_BKOUT_FLG <> 'Y' AND LIQ_FLG='N' AND SKIP_FLAG <> 'Y'

Process 258410 ABENDED at Step FS_BP_PEOD.ActLogC.iActLog (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
 

Solution

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