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 MAY 01, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.