My Oracle Support Banner

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 FEBRUARY 04, 2019

Applies to:

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


On : 9.2 version, AR Update - Posting

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

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

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.

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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.