My Oracle Support Banner

EAR 9.2: AR_AUTOMNT Is Going To No Success Due to Unique Contraint Error (Doc ID 2526966.1)

Last updated on MARCH 09, 2020

Applies to:

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

Symptoms

On : 9.2 Image #30
Automatic Maintenance

Updating to PUM 30. Auto Maintenance worked successfully prior to the update but now ends with an error.


ERROR
-----------------------
Error Position: 0 Return: 805 - ORA-00001: unique constraint

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 805 - ORA-00001: unique constraint (PRFS.PS_PENDING_ITEM) violated Failed SQL stmt: INSERT INTO PS_PENDING_ITEM (GROUP_BU, GROUP_ID, BUSINESS_UNIT, CUST_ID, ITEM, ITEM _LINE, GROUP_SEQ_NUM, ENTRY_TYPE, ENTRY_REASON, ENTRY_AMT, ENTRY_EVENT, ACCOUNTING_DT, ASOF_DT, POST _DT, DUE_DT, CR_ANALYST, SALES_PERSON, COLLECTOR, DISPUTE_STATUS, DISPUTE_DT, DISPUTE_AMOUNT, PO_REF , PO_LINE, DOCUMENT, DOCUMENT_LINE, POSTED_FLAG, PYMNT_TERMS_CD, DISC_AMT, DISC_AMT1, DISC_DT, DISC_ DT1, DISC_DAYS, DUE_DAYS, ALLOW_DISC, DST_ID_AR, DUN_DT, ST_DT, FC_DT, FC_AMT, OC_ADMIN_DT, OC_ADMIN _AMT, OC_PNLTY_DT, OC_PNLTY_AMT, OVERDUE_CHG_LINE, AR_ERROR_CD, ENTRY_USE_ID, DST_BAL_ITEM, COLLECTI ON_STATUS, COLLECTION_DT, BILL_OF_LADING, SUBCUST_QUAL1, SUBCUST_QUAL2, ENTRY_CURRENCY, RT_TYPE, RAT



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit Auto Maintenance


Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.