EGL: Budget Checking Process Creating 2 different KK_TRAN_ID for Same Voucher
Last updated on MAY 11, 2017
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 8.9 to 9 [Release 8.9 to 9]
PeopleSoft Enterprise FIN General Ledger - Version 8.9 to 9 [Release 8.9 to 9]
Information in this document applies to any platform.
This document was previously published as Customer Connection Solution 201019548
****Checked for Currency on 03-30-2010****
****Checked for Currency on 05-04-2015****
****Checked for Currency on 11-MAY-2017****
Budget Checking process creating 2 different KK_TRAN_ID for same voucher causing subsequent Batch Budget Checking process to abend.
SQL error. Stmt #: 1604 Error Position: 0 Return: 805 - [M icrosoft][ODBC SQL Server Driv er][SQL Server]Cannot insert d uplicate key row in object 'PS _BP_APV_S_TAO5' with unique index
9:57:02AM INSERT INTO PS_BP_APV_S_TAO5 ( PROCESS_INSTANCE, BUSINESS_UNI T, VOUCHER_ID, VOUCHER_LINE_NU M, DISTRIB_LINE_NUM, BUSINESS_ UNIT_PO, PO_ID, LINE_NBR, SCHE D_NBR, PO_DIST_LINE_NUM, LEDGE R_GROUP, LEDGER, KK_TRAN_ID, K K_TRAN_DT, KK_TRAN_LN, BUDGET_ DT, SUBTYPE, KK_PROCESS_PRIOR,
9:57:02AM Process 5847 ABENDED at Step FS_BP_STAO.iSrcTAO.iSrcTAO (SQL) -- RC = 805
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms