EAR9.0+: ARUPDATE Abends at The Step IU_PROCESSOR.U400.U400-010 (SQL) with Unique Constraint When Posting a Transfer Worksheet and a Payment Worksheet

(Doc ID 1473183.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.
*** Checked for Relevance on Thu 05-Feb-2015 ***

Symptoms

 Statement of the issue:
------------------------------
ARUDPATE fails at Step IU_PROCESSOR.U400.U400-010 (SQL) when the job runs with a transfer worsheet and a payment worksheet.

Error Message:
----------------------
SQL error. Stmt #: 1603  Error Position: 0  Return: 805 - OR A-00001: unique constraint (SY SADM.PS_PG_PENDST_TAO4) violated. INSERT INTO PS_PG_PENDST_TAO4 (PROCESS_INSTANCE, GROUP_BU, G ROUP_ID, BUSINESS_UNIT, CUST_I D, ITEM, ITEM_LINE, GROUP_SEQ_ NUM, DST_SEQ_NUM, LEDGER_GROUP , LEDGER, PRIMARY_LEDGER, BUSI NESS_UNIT_GL, BUSINESS_UNIT_TO , ACCOUNT, ALTACCT, DEPTID, OP ERATING_UNIT, PRODUCT, FUND_CO..    Process 514447 ABENDED at Step IU_PROCESSOR.U400.U400-010 (SQL) -- RC = 805

Steps to Replicate:
--------------------------
1. Create a transfer worksheet and a payment worksheet.
2. Run ARUPDATE.

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