EGL: Budget Checking Process Creating 2 different KK_TRAN_ID for Same Voucher

(Doc ID 649501.1)

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****

Symptoms

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

'PS_BP_APV_S_TAO5'.    
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

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