Understanding Integration with Oracle Fusion Cloud Student Financial Planning

As an alternative to Oracle PeopleSoft Campus Solutions (CS) Financial Aid, you can opt to integrate with either Oracle Fusion Cloud Student Financial Aid (SFA) product:

  • Student Financial Planning (SFP) which includes ISIR processing, awarding, and disbursement features. SFP supports student financial aid programs in the United States, but can also be used globally.

  • Student Aid Eligibility (SAE) which is limited to ISIR processing features. The SAE product is for United States use only.

Neither SFA product supports financial aid localizations for Great Britain or Canada.

This topics describes integration with SFP. For information about integrating with SAE, see Understanding Integration with Oracle Fusion Cloud Student Aid Eligibility.

The integration between CS and SFP is an exchange of data in the form of sending and receiving specialized messages between the two systems.

CS uses five outbound messages to send data to SFP:

  • Student Initiation Event: Initiates new students in SFP with biographic information from CS. These messages are logged with Message Class of STIN.

  • Student Update Event: Sends updated biographic information from CS for students already established in SFP. If an emplid has a biographic or demographic update, CS allows the PERSON_BASIC_SYNC message to trigger the SFP’s Student Update Event message. These messages are logged with Message Class of STUP.

  • Student Academic and Financial Information (SAFI) Event: Sends Student Record (Academic Program, Enrolled Classes, Grades, and so on.), Student Financial (Charges, Student Resources), and Projected Course Units (SFP’s Packaging) information to SFP. Details of a student's academic program can be taken from either STNDT_CAR_TERM table or ADM_APPL_PROG table. These messages are logged with Message Class of SAFI.

  • Leaves of Absence and Breaks in Attendance Event: Sends Student Records Leave of Absence information to SFP. These messages are logged with Message Class of STLA.

  • Student Groups Event: Communicates the status of the Student Group associated with the student and defines whether a student group was added to or removed from the student. Data included in this message event is meant to provide a comprehensive list of Student Groups information for the student record and replaces, not appends to, any previous versions of this message. These messages are logged with Message Class of SGRP.

CS accepts seven inbound messages to receive data from SFP:

  • Disbursement Information Event: Provides SFP disbursement information to CS by populating SF Group Data Entry for follow on Group Post. To process SFP Plus loans, the FasPlusApplicationInformationRequest web service is invoked to obtain biographic and demographic data of the borrower or parent. The FasPlusApplicationInformationReply service is used to continue processing the Plus loan disbursement. These messages are logged with Message Class of DISB.

  • Return to Lender Event: Provides information about disbursed payments that have been reduced (triggered from repackaging, R2T4, etc.). The transactions update CS SF Group Data Entry for follow-on Group Post. These messages are logged with Message Class of RTLN.

  • Anticipated Aid Event: Provides information about students’ anticipated financial aid in SFP for possible use in Student Financial processes: Customer Account, Payment Plans, Billing, Aging, and Term/Class Cancellation. These messages are logged with Message Class of AAID.

    Note: SFP is the source of the awards and students should use the SFP Student Self Service UI for self service viewing and accepting awards.

  • Disbursement Cancellation Event: Provides information about Awards that have been cancelled due to student not attending and removes the Awards from PS_ANTICIPATED_AID record. The message is logged with Message Class DCAN.

  • Title 4 Data Needed: SFP sends a message that a R2T4 calculation is being made and requires data to be sent to use for this calculation. This message is sent if the SAFI is not created with the correct Return to Title IV elements. These messages are logged with Message Class of T4DN.

  • Notification Events: SFP sends a message containing SFP notification data that can be used in the CS Notification Framework. These messages are logged with Message Class of NTF.

  • Unsupported: SFP sends additional messages that do not automatically trigger CS system processes at this time. These messages are logged with Message Class of UNSP.