Performance Issue With The Creation of The Remittance File

(Doc ID 2375053.1)

Last updated on MARCH 16, 2018

Applies to:

PeopleSoft Enterprise CS Brazil - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

On Campus Solutions 9.0, with Brazil Localizations applied, a response time issue occurs with the generation of the Remittance file (ARBRLBC2.SQR). 1000 emplid processing takes 1 hour and 20 minutes.

ACTUAL BEHAVIOR
---------------
ARBRLBC2.SQR process does not process large volumes of data in a timely manner.

EXPECTED BEHAVIOR
-----------------------
The SQR process should process remittances in a timely manner.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Student Financials, Bank Collection Brazil, Load Items Bra;
2. Select a run control;
3. Complete the run control;
4. Submit the process to the process scheduler.



PeopleSoft Enterprise Campus Solutions Community  Support Blog  Information_Centers  Maintenance_Advisor 

 

 

Changes

 

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