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

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

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.

ERROR
-----------------------
 
Payment Plan Group Post pgm (SFPSTDRV) starting on 2015-04-16 at 16.19.25.880000
 for Operator ID - PS
 & Run Control ID - MASS_CANCEL_PPL
Payment Plan program (SFPLNADJ) started on 2015-04-16 at 16.19.26.030000
 for Operator ID - PS
 & Run Control ID - MASS_CANCEL_PPL
Payment Plan Installment pgm (SFPLNINS) started on 2015-04-16 at 16.19.26.040000
Error W/ Payment Plan Installment pgm (SFPLNINS) 2015-04-16 at 16.19.26.040000 !!!!!
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 16.19.26.040000 !!!!!
PTPSQLRT - Error Encountered
No longer have connection to DB due to an error from previous
action: CLEAR-STMT. Bypassing current action: CLEAR-STMT.
Terminating


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

BUSINESS IMPACT
-----------------------
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

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