Enrollment Cancellation Class by Class Within Session May Not Cancel Correct Classes When Enrollment Control Session is Used. (Doc ID 2784366.1)

Last updated on APRIL 14, 2022

Applies to:

Symptoms

Based on your Term Session Table you may experience one of 3 situations when you run Enrollment Cancellation using the option of Class by Class within Session.
   Issue 1:  Not all unpaid students are being dropped from their classes when we run class cancellation SFPCLCAN.CBL 

   Issue 2:  Some students are dropped from classes in sessions we never ran class cancellation for.

   No Issue 3:  In  yet other situations every student is correctly dropped.

Required setup to demonstrate all three issues.

1. At Setup sa cr > Foundation Tables > Term Session Table (session table tab)  Create 3 sessions for your term Regular , 8W1, 8W2
2. Mark the 8W1 session with control session Regular.
3. Mark the 8w2 session with 8w2 with Control session 8w2 
4. Mark the Regular session as it's own control session.
5. Create 2 classes in each session (or use existing 3 credit classes)
6. Setup a term fee at 100 per unit for the term tied to a tuition group.   Be sure the billing and due calendar populates a due date of yesterday.

Steps to replicate

Problem 1: (Not all unpaid students are being dropped from their classes when we run class cancellation SFPCLCAN

1. Use a new student and enroll him in the same 6 classes.
2. Check your setup and review PS_STDNT_ENRL to see that the 8W1 classes have the REGULAR session marked as their SESSN_ENRL_CNTL
3. Calculate tuition at 100 per billing unit. Ensure the billing and due date  are past due (Enrollment Cancellation requires past due charges) 1800 in charges should calc and post. (Do not try to use student posted charges as enrollment cancellation is going to call tuition calc at some point)
4. Create your  run control at Student Financial > Tuition and Fees > Cancellation > Enrollment Cancellation
5. Use the following settings:   CLASS BY CLASS WITHIN SESSION. Your term/ 8W1 SESSION, 1 day past due, Initial amount $100 , subsequent amount $99  Selection criteria ALL
6. On the 2nd page populate CHARGE ITEM GROUP  = ALL ,From term/To term will be your term.   You can leave everything else blank  (...possibly turn on the completed classes if you're testing in a term that has ended.)
7. Save and RUN
8. Click DISPLAY CANCELLATION  to find your test student and their  TERM_WD_REQUEST_ID number. (note the session on this page as well)
9. Navigate to Records and Enrollment > Term processing > Withdraw and Cancellation > Term Withdraw/Cancel and run your TERM_WD_REQUEST_ID

 Note that when it's finished the student is not cancelled from ANY classes.   

This is a because a session withdrawal is created for 8W1 and the student has no classes in STDNT_ENRL where 8W1is the enrollment control session and there is no row in PS_STDNT_SESSION for 8W1

Problem  2: (Some students are dropped from classes in sessions we never ran the process for.)

1. Enroll your student in 6 classes (2 classes in each of the 3 sessions)
2. Review PS_STDNT_ENFL to see that the 8w1 classes have the REGULAR session marked as their SESSN_ENRL_CNTL
3. Calculate tuition 
4. Create your 2st run control at Student Financial > Tuition and Fees > Cancellation > Enrollment Cancellation
5. Use the following settings: CLASS BY CLASS WITHIN SESSION,  Your term/ REGULAR SESSION, 1 day past due, Initial amount $100 , subsequent amount $99 ,Selection criteria ALL
6. On the 2nd page populate Charge Item Group  = ALL, From term/To term will be your term.  You can leave everything else blank (...possibly turn on the completed classes if you're testing in a term that has ended.)
7. Save and RUN
8. Click DISPLAY CANCELLATION  to find your test student and their  TERM_WD_REQUEST_ID number. (note the session on this page as well)
9. Navigate to Records and Enrollment > Term processing > Withdraw and Cancellation > Term Withdraw/Cancel and run your TERM_WD_REQUEST_ID

Note that when it's finished the student is cancelled from all his classes in the REGULAR and 8W1 Sessions (not just the classes in the REGULAR session you intended) 

This is because the with session withdrawal is dropping the student from all classes in the REGULAR enrollment control session.

No Problem 3: In yet other situations every student is correctly dropped from ONLY the correct classes.   Enrollment cancellation appears to be working just  right!!!

1. Use a new student and enroll him in the same 6 classes.
2. Check PS_STDNT_ENRL to see that the 8w2 classes have the 8W2 session marked as their SESSN_ENRL_CNTL
3. Run tuition calc to post his fees.
4. Create a 3rd run control at Student Financial > Tuition and Fees > Cancellation > Enrollment Cancellation
5. Using the following settings: CLASS BY CLASS WITHIN SESSION, Your term/ 8W2 session , 1 day past due, Initial amount $100 , subsequent amount $99 ,Selection criteria ALL
6. On the 2nd page charge item group = ALL, from term/to term will be your term. You can leave everything else blank (...possibly turn on the completed classes if you're testing in a term that has ended.)
7. Save and Run your enrollment cancellation for session 8W2
8. Click DISPLAY cancellation to find your test student and their TERM_WD_REQUEST_ID number. (note the session on this page as well)
9. Navigate to Records and Enrollment > Term processing > Withdraw and Cancellation > Term Withdraw/Cancel and run your TERM_WD_REQUEST_ID

Note that when it's finished your student is cancelled from only his 8W2 classes.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.