EAR9.2 ARUPDATE fails at Step IU_PROCESSOR.U400.U400-010 (SQL) -- RC = 805 (108,524) (Doc ID 1912272.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, image 9.2.005 -- AR Update - Posting

ARUPDATE process failing with Unique Constraint Error
Process 1087988 ABENDED at Step IU_PROCESSOR.U400.U400-010 (SQL) -- RC = 805 (108,524)

File: e:\pt85307c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PG_PENDST_TAO4) violated Failed SQL stmt: INSERT INTO PS_PG_PENDST_TAO4 (PROCESS_INSTANCE, GROUP_BU, GROUP_ID, BUSINESS_UNIT, CUST_ID, ITEM, ITEM_LINE, GROUP_SEQ_NUM, DST_SEQ_NUM, LEDGER_GROUP, LEDGER, PRIMARY_LEDGER, BUSINES S_UNIT_GL, BUSINESS_UNIT_TO, ACCOUNT, ALTACCT, 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, RESOURCE_CATEGORY, RESOURCE_ SUB_CAT, ANALYSIS_TYPE, BUDGET_DT, STATISTICS_CODE, MONETARY_AMOUNT, STATISTIC_AMOUNT, CF_EDIT_STATU S, JRNL_LN_REF, LINE_DESCR, SYSTEM_DEFINED, ACCOUNTING_DT, FOREIGN_CURRENCY, FOREIGN_AMOUNT, RT_TYPE

 

ERROR
-----------------------
805 - ORA-00001: unique constraint (SYSADM.PS_PG_PENDST_TAO4) violated Failed SQL stmt




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Run ARUPDATE

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot process any AR transactions

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