EAR9.1+: Performance Issue With PeopleCode DD_WRK.DD_WL_REMIT_PB.SAVEPOSTCHANGE When Changing the Status of Several Direct Debits to No Action and Saving the Page. (Doc ID 1914888.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_WRK.DD_WL_REMIT_PB.SavePostChange has the following SQL that takes longer to execute.

Update PS_ITEM
set DD_STATUS = 'N',
 DD_BU = ' ',
DD_ID = ' '
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:
------------------------

  1. Navigate to Accounts Receivable > Direct Debits > Administer Direct Debits > Update Direct Debits.
  2. Change the status of several Direct Debits to No Action and save the page.

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