My Oracle Support Banner

EAR 9.2: Regular Deposit Component Unable To Open A Deposit Group With Over 6,000 Payments, Suffers Performance Degradation And Eventually Times Out (Doc ID 2395044.1)

Last updated on MAY 04, 2018

Applies to:

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

Symptoms

ISSUE:

The Company uses Payment Interface Load process (AR_PAYLOAD) to generate Regular Deposits in the system, with a large volume of Payments (up to 6000 transactions per Regular Deposit).

When the Receivables Functional Team attempts to open such an existing Regular Deposit Group online, containing over 6000 Payments associated with it, the system eventually times out for the User.

This performance degradation is still happening even after implementing the fix from <Bug 26988956> (AR: Regular Deposit Payments Tab Times Out If Number Of Payments Is Over 100), delivered within PeopleSoft Enterprise FSCM 9.2 Image #27, and detailed in the below KM Document:

     <Document 2325913.1> - 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

REPLICATION STEPS:

     1.- Log into the FSCM Online Application as a Receivables User
     2.- Navigate to: Accounts Receivable > Payments > Online Payments > Regular Deposit
     3.- Search for a Regular Deposit Group that contains over 6000 Payment transactions within
     4.- Open the Regular Deposit listed
     5.- The system spins for a while, until eventually it times out, and kicks the User from the session

ACTUAL RESULT:

Receivables Users are unable to open such Deposit Groups. Additionally, timing out also means the Users need to re-log into the FSCM Online Application.

EXPECTED BEHAVIOR:

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

 

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.