My Oracle Support Banner

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

Last updated on AUGUST 27, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.