My Oracle Support Banner

EAR 9.2: AR Update Suffers From Performance Degradation Issues Through Sub-Process AR_PGG_SERV On Several Steps From Delivered Sections CHK_RND And PAY_CASH (Doc ID 2433095.1)

Last updated on AUGUST 08, 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:

After a systems upgrade to PeopleSoft Enterprise FSCM 9.2 Image #26, the Functional Team has detected a drastic performance degradation on AR Update AE Program (AR_UPDATE), specially in the below listed sections of sub-program AR_PGG1 (under AR_PGG_SERV):

     - AR_PGG_SERV.CASH_INH.CHECKBNK.H
     - AR_PGG_SERV.CHK_RND.CHK_DST.H
     - AR_PGG_SERV.CHK_RND.CHK_DST.S
     - AR_PGG_SERV.CHK_RND.GET_RND.H
     - AR_PGG_SERV.PAY_CASH.CCOFFSET.H
     - AR_PGG_SERV.PAY_CASH.CC_USER.H
     - AR_PGG_SERV.PAY_CASH.CHECKBNK.H
     - AR_PGG_SERV.PAY_CASH.CHECK_CC.H
     - AR_PGG_SERV.PAY_CASH.CSHP2ML.S
     - AR_PGG_SERV.PAY_CASH.CSH_USER.H
     - AR_PGG_SERV.PAY_CASH.MLT_CASH.H
     - AR_PGG_SERV.PAY_CASH.SYSCASH2.S
     - AR_PGG_SERV.PAY_CASH.SYSCASHP.S
     - AR_PGG_SERV.PAY_CASH.SYSCSH2B.S
     - AR_PGG_SERV.PAY_CASH.SYSCSHML.S
     - AR_PGG_SERV.PAY_CASH.SYSCSHP2.S
     - AR_PGG_SERV.PAY_CASH.SYSLCSC2.S
     - AR_PGG_SERV.PAY_CASH.SYSLCSCP.S

REPLICATION STEPS:

     1.- Log into the FSCM Online Application as a Receivables User
     2.- Navigate to: Accounts Receivable > Receivables Update > Request Receivables Update
     3.- Create a new Run Control ID, define the processing options needed, and launch the request
     4.- The AR_UPDATE AE Program takes a long time to complete, specially around AR_PGG1 AE Program in several sections

ACTUAL RESULTS:

The AR Update AE Program (AR_UPDATE) is taking well over 7 hours to complete, which not only delays the processing of the involved transactions, but any other program that also needs to be completed.

EXPECTED BEHAVIOR:

The AR Update process, and its sub-programs, should be able to handle and process all transaction volumes in a timely manner.

 

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.