EAR 9.2:SQL Inconsistency In AR_PGG SERV

(Doc ID 2244771.1)

Last updated on MARCH 17, 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, there is an error in AR_PGG_SERV.ARLNPREP.ITEM_DS3.DoSelect when you Unpost a transaction in AR concerning the join in the NOT EXISTS of the SQL.
Impacts are
- it can potentially have a unique constraint, because the NOT EXIST clause is not good
- performances are very bad.


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

  1. Unpost a transaction in AR
  2. Run ARUPDATE

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