EAR 9.1 Performance Issue on Express Page When Creating Several Payments with Commitment Control (Doc ID 1961069.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

ENVIRONMENT
-------------------------
9.1 bundle 30 UAT

Statement of Issue
-----------------------------------
Performance Issue on Express Page When Creating Several Payments with Commitment Control

Expected Behavior
-----------------------------------
Express Deposit should save in a considerable time

Actual Behavior
--------------------------------
When Saving several payments (6 for instance) it takes at least 30 seconds to save The express payment is saved each time the payment is added. At the point of adding more payments example would be on the 6th payment and then save, it is taking a long time to complete the save. Issue happens to be with PS_AR_CAGL_VW being accessed for all item reference each time payment is saved

Business Impact
---------------------------------------
Issue affects AR users as it takes time to complete express deposit

Steps to Replicate
----------------------------
1. Create several invoices (6) from billing and budget check.
2. Send them over to AR
3. Create an express deposit and add 6 payments saving the deposit each time.

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