EAR 9.2: A Performance Degradation Has Been Detected At Payment Predictor Application Engine Program (AR_PREDICT) (Doc ID 2184983.1)

Last updated on SEPTEMBER 25, 2016

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 delivered Receivables Payment Predictor Application Engine Program (AR_PREDICT) suffers from a performance degradation on several steps here below listed:

     - Application Engine Program, Section, and Step: AR_PREDICTOR2.DEFCUST.CLEANTMP.S 3610 0.020 3610 1384.400 0 0.000 1384.420
     - Application Engine Program, Section, and Step: AR_PREDICTOR2.DEFCUST.FILLBU.S 3610 0.100 3610 3367.160 0 0.000 3367.260
     - Application Engine Program, Section, and Step: AR_PREDICTOR2.DEFCUST.FILLCUST.D 3610 0.040 3610 1010.970 3610 0.000 1011.010
     - Application Engine Program, Section, and Step: AR_PREDICTOR2.PGEN.UPDDSTI2.S 24141 3.300 24141 5727.140 0 0.000 5730.440
     - Application Engine Program, Section, and Step: AR_PREDICTOR2.PUPD_WS.UPD_PTIM.S 1 0.000 1666 28389.720 0 0.000 28389.720
     - Application Engine Program, Section, and Step: AR_PREDICTOR2.UPDTLTLR.BU_PYMT.S 3610 0.140 3610 1910.880 0 0.000 1911.020
     - Application Engine Program, Section, and Step: AR_PREDICTOR2.UPDTLTLR.CUST_PMT.S 3610 0.150 3610 1753.690 0 0.000 1753.840

The problem is not a system matter, but a coding issue (AR_PREDICTOR2) SQL statement(s). Some of the SQL coding forces the system to do full table scans, which really slows down processing, (specially since there are over 1M Deposits tied to roughly 4M Payments).

REPLICATION STEPS:

     - Log into the FSCM Online Application as User ID VP1
     - Navigate to: Accounts Receivables > Receivables Update > Request Receivables Update
     - Define a Run Control ID, and launch AR_UPDATE AE Program
     - Among all the sub-programs being called, AE Program ARPREDCT takes a long time to complete

ACTUAL BEHAVIOR:

The severe performance issues detected are delaying further transaction processing, specially i the matching of Items with Payments, and posting the Accounting Entries needed.

EXPECTED BEHAVIOR:

Changes in Application Engine structural features, more efficient SQL, and some strategically defined indexes should significantly improve the performance. The Payment Predictor process should be able to handle large volume of transaction data 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