EAR 9.1:ARUPDATE Runs To No Success At AR_PGG_SERV.MNTCNTL.MNTCNT3C For Maintenance Worksheet With Multiple Business Units. (Doc ID 1574483.1)

Last updated on NOVEMBER 12, 2015

Applies to:

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

Symptoms

On : 9.1 version, AR Update - Posting

When running Receivables Update for maintenance worksheets, process fails with the following error:

ERROR
-----------------------
12.08.16 Process 8475771 ABENDED at Step AR_PGG_SERV.MNTCNTL.MNTCNT3C (Action SQL) -- RC = 805
SQL Error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_PG_PENDST_TAO4' with unique index 'PS_PG_PENDST_TAO4'. The duplicate key value is (8475771, US001, 816562, US002, 10075768, CK 12652, 0, 0, 2, , , U

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

  1. Enter online pending group for BU US001 and customer as 1002, with one debit item and one credit item.
  2. Enter another online pending group for BU US003 and customer as 1003, with one debit item and one credit item.
  3. Enter maintenance worksheet with US001 and customer as 1002. Put credit and debit item entered in step 1 as MT. Adjust remaining credit amount as MC and put BU as US002. Put posting action as batch standard.
  4. Create another maintenance worksheet as US001 and customer 1003. Put both items created in step 2 as MT. Adjust remaining amount as MD. Put Anchor business unit as US003. Put posting action as batch standard.
  5. Run ARUPDATE for BU US001. Process will fail at step AR_PGG_SERV.MNTCNTL.MNTCNT3C.


BUSINESS IMPACT
-----------------------
Cannot post maintenance worksheet.

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