EAR9.1: ARUPDATE Aborted By Duplicate Key Error At AR_PGG_SERV.CC_ROUN3.SUP_DS2 On 2 Scenarios (Doc ID 1559300.1)

Last updated on JUNE 07, 2013

Applies to:

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

Symptoms

ARUPDATE aborted by the error of "Cannot insert duplicate key row in object 'dbo.PS_PG_PENDST_TAO4' with unique index 'PS_PG_PENDST_TAO4'" at the step AR_PGG_SERV.CC_ROUN3.

Error
---------------
-- 12.53.03 Process 11299 ABENDED at Step AR_PGG_SERV.CC_ROUN3.SUSP_DS2 (Action
SQL) -- RC = 805
ROLLBACK
/
-- 12.53.03 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'

Step
---------------
This issue occurred on the following 2 scenarios;

<Scenario 1>

  1.  Create 6 items with amounts 1 USD and rate 88.45 for JPY.
  2. Run ARUPDATE to post 6 items.
  3. Create 1 payment with amounts 3 USD and rate 88.45 for JPY.
  4. Repeat to create 1 payment with amounts 3 USD and rate 88.45 for JPY.
  5. Apply 1 payment to 3 items on payment worksheet.
  6. Repeat to apply 1 (another) payment to another 3 items on payment worksheet.
  7. Run ARUPDATE to post 2 payment worksheets.
  8. Duplicate key error occurred at the step of AR_PGG_SERV.CC_ROUN3.SUSP_DS2.


<Scenario 2>

  1.  Create 1 deposit. (Amount is 2 USD, exchange rate is 198.4)
  2. Create 2 prepay items with each amount is 1 USD on Payment Worksheet.
  3. Run ARUPDATE to post items on Payment Worksheet.
  4. Duplicate key error occurred at the step of AR_PGG_SERV.CC_ROUN3.SUSP_DS2.


This issue will occur on the following conditions;

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