EAR 9.2 Performance Issue on Payment Worksheet Select Items Saving

(Doc ID 2139106.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Performance issue on Payment Worksheet select items saving
"UPDATE PS_PAYMENT_ITEMTMP SET ITEM_SELECTED='N', PAYWS_INELIGIBLE='D'
WHERE DEPOSIT_BU=:1 AND DEPOSIT_ID=:2 AND PAYMENT_SEQ_NUM=:3 AND
(ITEM_SELECTED='Y' OR ITEM_SELECTED='X')
AND EXISTS ( SELECT 'X' FROM PS_PAYMENT_ITEM A , PS_INSTALLATION_AR B
WHERE A.ITEM_SELECTED = 'Y' AND ( (A.DEPOSIT_BU = PS_PAYMENT_ITEMTMP.DEPOSIT_BU AND A.DEPOSIT_ID = PS_PAYMENT_ITEMTMP.DEPOSIT_ID
AND A.PAYMENT_SEQ_NUM <> PS_PAYMENT_ITEMTMP.PAYMENT_SEQ_NUM AND A.BUSINESS_UNIT=PS_PAYMENT_ITEMTMP.BUSINESS_UNIT
AND A.CUST_ID = PS_PAYMENT_ITEMTMP.CUST_ID AND A.ITEM = PS_PAYMENT_ITEMTMP.ITEM
AND A.ITEM_LINE = PS_PAYMENT_ITEMTMP.ITEM_LINE) OR (A.DEPOSIT_BU <> PS_PAYMENT_ITEMTMP.DEPOSIT_BU
AND A.DEPOSIT_ID <> PS_PAYMENT_ITEMTMP.DEPOSIT_ID AND A.BUSINESS_UNIT=PS_PAYMENT_ITEMTMP.BUSINESS_UNIT
AND A.CUST_ID = PS_PAYMENT_ITEMTMP.CUST_ID AND A.ITEM = PS_PAYMENT_ITEMTMP.ITEM
AND A.ITEM_LINE = PS_PAYMENT_ITEMTMP.ITEM_LINE) OR (A.DEPOSIT_BU <> PS_PAYMENT_ITEMTMP.DEPOSIT_BU AND A.DEPOSIT_ID = PS_PAYMENT_ITEMTMP.DEPOSIT_ID
AND A.BUSINESS_UNIT=PS_PAYMENT_ITEMTMP.BUSINESS_UNIT AND A.CUST_ID = PS_PAYMENT_ITEMTMP.CUST_ID
AND A.ITEM = PS_PAYMENT_ITEMTMP.ITEM AND A.ITEM_LINE = PS_PAYMENT_ITEMTMP.ITEM_LINE) OR (A.DEPOSIT_BU = PS_PAYMENT_ITEMTMP.DEPOSIT_BU
AND A.DEPOSIT_ID <> PS_PAYMENT_ITEMTMP.DEPOSIT_ID AND A.BUSINESS_UNIT=PS_PAYMENT_ITEMTMP.BUSINESS_UNIT
AND A.CUST_ID = PS_PAYMENT_ITEMTMP.CUST_ID AND A.ITEM = PS_PAYMENT_ITEMTMP.ITEM AND A.ITEM_LINE = PS_PAYMENT_ITEMTMP.ITEM_LINE) )
AND B.CHECK_PENDING_SW='Y' )"

EXPECTED BEHAVIOR
-----------------------
Worksheet should be built in timely manner

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Payment Worksheet build worksheets
2. Select items and save

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot apply payments in a timely manner.

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