Batch Refund Running Slow (Doc ID 2269366.1)

Last updated on MAY 23, 2017

Applies to:

PeopleSoft Enterprise CS Student Financials - Version 9 and later
Information in this document applies to any platform.

Symptoms

On :Campus solutions 9 version, Refunding

ACTUAL BEHAVIOR
---------------
Batch refunding at one campus SOMETIMES run exceeding slow.  Sometimes at that campus they run without issue.   The issue is intermittent and sporadic.

  At other campuses Refunds  run without issue continually.

  The problem seems to be confined to refund  run controls  at the one campus that process financial aid parent loans as well as regular student refunds.
 
SFPREFND_S_BOTMAAI has been implicated as the slow running statement.


EXPECTED BEHAVIOR
-----------------------

Refunds normally run in a few minutes, at random times they will take hours .......for no apparent reason.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Student financials > refunds > create batch refunds.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run refunds unless they are prepared for a long wait and don't need them right away.

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