EAR9.1+: Performance Issue With PeopleCode DD_WORKSHEET.GBL.SavePostChange When Changing the Status of Several Direct Debits to No Action and Save the Page. (Doc ID 1912541.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

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

Symptoms

Statement of the issue:
-------------------------------
DD_WORKSHEET.GBL.SavePostChange has the following SQL that takes longer to execute.
UPDATE PS_ITEM
SET DD_STATUS = 'N'
WHERE EXISTS
(SELECT 'X'
FROM PS_DD_CONTROL D
WHERE D.DD_STATUS = 'N'
AND D.DD_WORKSHEET_ID = :1
AND D.DD_RQST_SEQUENCE = :2
AND PS_ITEM.DD_BU = D.DD_BU
AND PS_ITEM.DD_ID = D.DD_ID)

Expected Behavior:
--------------------
Above SQL should execute quickly.

Steps to Replicate:
------------------------

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