My Oracle Support Banner

Batch Refund Running Slow (Doc ID 2269366.1)

Last updated on SEPTEMBER 14, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.