Mass Contract Select To CANCEL Student Off A Payment Plan That Had No Charges Fails

(Doc ID 2002563.1)

Last updated on MAY 01, 2018

Applies to:

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


Campus solutions 9 version, Payment Plans/Deferral Contract/Third Party Contracts

When attempting to Cancel the student from a payment plan using mass contract select
the following error occurs.

Payment Plan Group Post pgm (SFPSTDRV) starting on 2015-04-16 at
 for Operator ID - PS
 & Run Control ID - MASS_CANCEL_PPL
Payment Plan program (SFPLNADJ) started on 2015-04-16 at
 for Operator ID - PS
 & Run Control ID - MASS_CANCEL_PPL
Payment Plan Installment pgm (SFPLNINS) started on 2015-04-16 at
Error W/ Payment Plan Installment pgm (SFPLNINS) 2015-04-16 at !!!!!
Application Program Failed
In Pgm Section :
With Return Code: 00000
Error Message : ORA-00942: table or view does not exist
  at pos 00021
Error W/ Payment Plan program (SFPLNADJ) 2015-04-16 at !!!!!
PTPSQLRT - Error Encountered
No longer have connection to DB due to an error from previous
action: CLEAR-STMT. Bypassing current action: CLEAR-STMT.

The issue can be reproduced at will with the following steps:
1. Student Financials > Payment Plans > Mass Contract Select

The issue has the following business impact:
Due to this issue, users cannot students cannot be cancelled from their payment plans thru mass contract select


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