EAR 9.2: Regular Deposit Payments Tab (Page PAYMENT_DATA2) Suffers A Performance Degradation And Eventually Times Out If The Number Of Included Payments Is Over 100

(Doc ID 2325913.1)

Last updated on NOVEMBER 08, 2017

Applies to:

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

Symptoms

ISSUE:

When the Receivables Functional Team attempts to create a brand new Deposit Group online, containing a large number of Payments associated with it (in the order of 100+), the Payments tab (Page PAYMENT_DATA2) eventually times out for the User.

This seemed to work back on PeopleSoft Enterprise FSCM 9.2 Image #11, but since a systems upgrade to Image #23 was completed, this performance problem started being noticed. Some of the below PeopleCode codeline are being executed exponentially more times than before:

     - PAYMENT_ID_ITEM.ENTRY_TYPE.SavePreChange
     - PAYMENT_ID_ITEM.REF_QUALIFIER_CODE.FieldDefault
     - PAYMENT.MISC_PAYMENT.FieldChange
     - PAYMENT_ID_ITEM.REF_VALUE.RowInit
     - PAYMENT_ID_ITEM.DEPOSIT_BU.RowInit

REPLICATION STEPS:

     1.- Log into the FSCM Online Application as a Receivables User
     2.- Navigate to: Accounts Receivable > Payments > Online Payments > Regular Deposit
     3.- In the Totals tab, enter all the relevant information for this new Deposit Group, including a Control Count of around 100
     4.- Proceed to to Payments tab, and fill in the information for about 100 Payments
     5.- When trying to save, or further edit, the system times out

ACTUAL RESULT:

Receivables Users are loosing all the transaction entered in the system after a long manual data entry session. The system times out, and such Deposit Groups become un-editable. Timing out also means the Users need to re-log into the FSCM Online Application.

EXPECTED BEHAVIOR:

The system should allow Users to edit and save Depot Groups with a large number of Payments associated to it, without timing out.

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