EGL 9.2: Budget Close Fails at Statement FSPYCLOG_I_CALCSRC With Return Code 805 - Duplicate Insert Error (Doc ID 2292247.1)

Last updated on JULY 31, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms


Issue
-------------
KK Budget Close failed with Return code 805 (duplicate insert)

07:15:32.729 40913 0.000 0.000 #1 RC=0DYNAMIC Stmt=FSPYCLOG_I_CALCSRC
07:15:32.733 40914 0.000 0.000 #1 RC=0 COM Stmt=INSERT INTO PS_KK_CLOSE_CALC_S(PROCESS_INSTANCE,REQUEST_NBR,SEQUENCE_NBR_9,BUSINESS_UNIT,LEDGER,KK_BUDG_TRANS_TYPE,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,FUND_SOURCE,ENTRY_EVENT,CURRENCY_CD,STATISTICS_CODE,POSTED_TOTAL_AMT,DTTM_STAMP_SEC) SELECT 0000052148,0001,0,A.BUSINESS_UNIT,A.LEDGER,'N',A.ACCOUNT,A.DEPTID,A.OPERATING_UNIT,A.PRODUCT,A.FUND_CODE,' ',' ',A.BUDGET_REF,A.AFFILIATE,A.AFFILIATE_INTRA1,' ',A.CHARTFIELD1,A.CHARTFIELD2,' ',A.BUSINESS_UNIT_PC,A.PROJECT_ID,A.ACTIVITY_ID,A.RESOURCE_TYPE,A.BUDGET_PERIOD,' ',' ','USD',A.STATISTICS_CODE,SUM(A.POSTED_TOTAL_AMT),SYSTIMESTAMP FROM PS_LEDGER_KK A,PS_CFV_SEL001 B WHERE A.BUSINESS_UNIT = 'SFGOV' AND A.CURRENCY_CD = 'USD' AND A.LEDGER IN ('BD','EX','EN','PR') AND A.FISCAL_YEAR = 2017 AND B.CFV_SET='XXXXX' AND B.CHARTFIELD='ACCOUNT' AND B.SETID='SHARE' AND A.ACCOUNT=B.CHARTFIELD_VALUE GROUP BY A.BUSINESS_UNIT,A.LEDGER,A.ACCOUNT,A.DEPTID,A.OPERATING_UNIT,A.PRODUCT,A.FUND_CODE,A.BUDGET_REF,A.AFFILIATE,A.AFFILIATE_INTRA1,A.CHARTFIELD1,A.CHARTFIELD2,A.BUSINESS_UNIT_PC,A.PROJECT_ID,A.ACTIVITY_ID,A.RESOURCE_TYPE,A.BUDGET_PERIOD,A.STATISTICS_CODE
07:15:33.020 40915 0.280 0.000 #1 RC=805 EXE
07:15:33.027 40916 0.000 0.000 #1 RC=0 Rollback

Environment
----------------------
FSCM 9.2
PeopleTools 8.54

Steps to replicate
-------------------------
1. Navigate to Commitment Control > Close Budget > Process Budget Close
2. Run FSPYCLOS process

Changes

 Chartfields were activated

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