Batch Refunding (SFPREFND) Fails With Error 'Unable to Find Charge Refund Rate'

(Doc ID 2348298.1)

Last updated on JANUARY 12, 2018

Applies to:

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

Symptoms

On Campus Solutions,Batch Refunding fails with the following error message:

The Batch Refunding run control has the 'Calc Tuition if Required' box checked on.

ERROR
-----------------------
Calling SFPSTDNT to gather student's info.

End of Call SFPSTDNT.

Calling SFPGRPCL to verify criteria.

Read Criteria from database.

Criteria: XXXXX

Criteria not matches.

Error / Warning: W
Message Set Nbr: 0000014815
Message Nbr: 0000000028

End of Call SFPGRPCL.

Warning: Unable to find Term Fee record.
Term Fee Code: ZZZZZZ

Calling SFPGRPCL to verify criteria.

Read Criteria from database.

End of Call SFPGRPCL.

Error: Unable to find charge refund rate.
Adjustment Code: YYYYY


End of Call SFPFECAL.

Application Program Failed
In Pgm Section : RB100-CALC-EMPL-TERM (DUPL KEY)
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_CALC_EMPL_TERM) violated


Error W/Batch Refund program on YYYY-MM-DD at HH.MM.SS.ssssss !!!!!


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Student Financials, Refunds, Process Batch Refunds, Create Refunds;
2. Select a run control;
3. Populate the run control as required, checking the Calc Tuition if Required box on;
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