My Oracle Support Banner

Mass Contract Select To CANCEL Student Off A Payment Plan That Had No Charges Fails (Doc ID 2002563.1)

Last updated on OCTOBER 23, 2020

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


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.