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.
On : 9.1 version, AR Update - Posting
When running Receivables Update for maintenance worksheets, process fails with the following 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
The issue can be reproduced with the following steps:
- Enter online pending group for BU US001 and customer as 1002, with one debit item and one credit item.
- Enter another online pending group for BU US003 and customer as 1003, with one debit item and one credit item.
- 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.
- 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.
- Run ARUPDATE for BU US001. Process will fail at step AR_PGG_SERV.MNTCNTL.MNTCNT3C.
Cannot post maintenance worksheet.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms