My Oracle Support Banner

EAR 9.1+: ARUPDATE Abends At Step AR_PGG_SERV.ARLNPREP.ITEM_DST With Unique Constraint When Applying Payment (Doc ID 2222617.1)

Last updated on OCTOBER 09, 2023

Applies to:

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

Symptoms

On : 9.1 bundle 24 version, AR Update - Posting

When attempting to apply payment it fails.

ERROR
-----------------------
Process 389 ABENDED at Step AR_PGG_SERV.ARLNPREP.ITEM_DST (Action SQL) -- RC = 805
ROLLBACK
/
-- 13.58.59 SQL Error: ORA-00001: unique constraint (SYSADM.PS_PG_ITMDST_TAO4) violated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1.  Enable 'Update AR with PC Chartfield' checkbox on Billing - GL/AR  Installation Options.
  2.  Configure Billing Installation Options where GL Level = BI Create GL Acct Entries.
  3.  Configure Billing Installation Options where AR Level = Header is AR Open Item.
  4.  Configure Billing Installation Options where AR Option = Use Line for Distribution.
  5.  Enter Bill in Billing with over 3000 lines that have unique chartfield combinations. Use unique project/activity combination on each of the 3000 lines.
  6.  Send the Bill to AR and post in AR.
  7.  Apply Payment to the Item in AR and run ARUPDATE. ARUPDATE should fail at AR_PGG_SERV.ARLNPREP.ITEM_DST with unique constaint.

BUSINESS IMPACT
-----------------------
Cannot apply payment.

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


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