Mass Contract Select Will Not Select Correct Population of Students When Multiple Run Controls Exist For One Contract (Doc ID 2194028.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

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

Symptoms

On Campus Solutions 9 Payment Plans/Deferral Contract/Third Party Contracts

ACTUAL BEHAVIOR
---------------
When more than one run control exists for the Mass Contract Select (in PS_SSF_RUN_PS_TPC) using the same Contract Number, the wrong data is selected by Pop Select and the App Engine SSF_PS_TPC.


STEPS
-----------------------

  1. In order to replicate this issue you must first create 2 Pop Select queries that join to the SSF_PS_TPC_BND table that select 2 different groups of students for clarity

query 1:

Select a.emplid from ps_ssf_ps_tpc_bnd a, ps_account_sf b where (a.emplid in (‘0040’, ‘0041’, ‘0042’) and b.emplid = a.emplid and b.account_type_sf = ‘TUT’)

query 2:

Select a.emplid from ps_ssf_ps_tpc_bnd a, ps_account_sf b where (a.emplid in (‘0030’, ‘0031’, ‘0032’) and b.emplid = a.emplid and b.account_type_sf = ‘TUT’)
  1. Setup 2 separate Run Controls,  Student Financials > Payment Plans > Mass Contract Select
      • The run controls should use your Pop Select queries
      • Both run controls point to the same Third Party Contract.
      • One of the run controls should be set to activate students
      • One of the run controls should be set to cancel students.
  2. Save both run controls
  3. Run the ACTIVE run control and see no students selected  by the app engine

 

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