EAR 9.2: After Applying Fix For Bug 25926353 ARUPDATE Is Failing At Step AR_REV_EST.CADST.CA_RRT (SQL) -- RC

(Doc ID 2317937.1)

Last updated on OCTOBER 16, 2017

Applies to:

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

Symptoms

On : 9.2 version, AR Update - Posting

When attempting to run arupdate it is failing with the following error occurs.

ERROR
-----------------------
After applying fix for bug 25926353 arupdate is failing at Step AR_REV_EST.CADST.CA_RRT (SQL) -- RC
SQL Server]Cannot insert duplicate key row in object 'dbo.PS_RE_BI_DST_TAO4' with unique index 'PS_RE_BI_DST_TAO4'. The duplicate key value is (SC001, WTR00000213, WTRG-00000203, 1, 887640, 1, 0, SC001, WTRG-000


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply fix for bug 25926353.
2.Test the RRT scenario mentioned in bug 25926353.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot apply payment.

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