My Oracle Support Banner

EAR 9.2: AR Update failed at the Step AR_PGG_SERV.MNTCNTL.MNTCNT3C with error ORA-00001: unique constraint when Split Item is Used (Doc ID 2498459.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

FSCM 9.2 Image 26
PT 8.54.27
AR Update - Posting

Attempting to split an item into multiples and run AR Update.
AR Update failed at the Step AR_PGG_SERV.MNTCNTL.MNTCNT3C with error - "ORA-00001: unique constraint violated"


ERROR
-----------------------
ORA-00001: unique constraint (<OWNER>.<TABLENAME>) violated


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate Accounts Receivable > Customer Accounts > Item Information > Item Split
2. Add Item Lines to split the item
3. Set Worksheet to Batch Standard
4. Save
5. Run AR Update



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.