My Oracle Support Banner

EAR 9.2: ARUPDATE Sub-Process AR_PGG1 ABENDED at Step AR_PGG_SERV.MNTCNTL.MWC_MLA (Action SQL) RC = 805 for Maintenance Worksheet When There Are Multiple Receivable Lines and ChartField Inheritance Is Turned On. (Doc ID 2647174.1)

Last updated on MARCH 17, 2020

Applies to:

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

Symptoms


ARUPDATE sub-process AR_PGG1 ABENDED at Step AR_PGG_SERV.MNTCNTL.MWC_MLA (Action SQL) -- RC = 805


ERROR
-----------------------

      ARUPDATE sub-process AR_PGG1 ABENDED at Step AR_PGG_SERV.MNTCNTL.MWC_MLA (Action SQL) -- RC = 805
      SQL Error: ORA-00001: unique constraint (SYSADM.PS_PG_PENDST_TAO4) violated




Replication Steps

-----------------------

  1. Enter two items one is debit and one is replica to debit but it is a credit item.
  2. Make sure chartfield inheritance is turned ON, item has multiple AR DST_SEQ_NUM from 10001 to 24330 for each item.
  3. Create maintenance worksheet to offset Dr and CR, run arupdate.



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.