My Oracle Support Banner

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

Last updated on DECEMBER 06, 2019

Applies to:

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


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.

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 !!!!!

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 






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

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