Exchanging Data with Oracle Student Financial Planning Cloud Service

This section discusses how to process Student Financial Planning (SFP) transactions.

Page Name

Definition Name

Navigation

Usage

Process SFP Messages

SCC_RUNCNTL_VOC

Campus Community > Student Fin Planning Interface > Process SFP Messages

Use this page to send messages to and receive messages from SFP.

SFP Message Log

PS_SCC_SFA_MSG_MAP

Campus Community > Student Fin Planning Interface > SFP Message Log

Use this page to view all SFP inbound/outbound messages.

Access the Process SFP Transactions page (Campus Community > Student Fin Planning Interface > Process SFP Messages).

Field or Control

Definition
Message Class

Select which Message Class you want to process:

  • Anticipated Aid

  • Disbursement Information

  • Return to Lender

  • Notification

  • Student Academic and Fin Info (student academic and financial information)

  • Student Initiation

  • Student Leave of Absence

  • Student Update

  • Title IV Data Needed

  • Unsupported
Query Name

For outbound Message Classes (Student Academic and Fin Info, Student Initiation, Student Leave of Absence, and Student Update), you may select a query using the SCC_SFP_OUT_BND BIND Record to select the students for which you want to process Transactions. There are four sample delivered queries:

  • QA_CS_CC_SFP_STUDENTINITIATION

  • QA_CS_CC_SFP_SAFI

  • QA_CS_CC_SFP_STUDENT_INIT_2

  • QA_CS_CC_SFP_STUDENT_UPDATE

Two Application Engines are used by this process:

  • SCC_VOC_INTF: Used to push CS data to SFP using the Student Academic and Fin Info, Student Initiation, Student Leave of Absence, and Student Update Message Classes.

  • SFP Message Pull: Used to pull Anticipated Aid, Disbursements, and Return to Title IV transactions from SFP to CS.

    The Anticipated Aid Message Class (FasFinancialPlanOutboundV2Event) populates the ANTICIPATED_AID table.

    The Disbursement Information and Return to Lender Message Classes create a Student Financial Group Data Entry. SFP Fund Codes are mapped to SF Item Types. See Mapping Financial Transactions between CS Student Financials and Student Financial Planning.

    Note: Disbursements for a student must be posted prior to processing the return to lender transactions.  The return to lender process will not create the Group Control and Group line entries if the disbursement is not found on the PAYMENT_TBL.

The CS-SFP pull process for FasDisbursementInformationEvent looks at the refund indicator and if a borrower exists, the FasPlusApplicationInformationRequest web service is invoked to retrieve the biographic and demographic information of the borrower. The FasPlusApplicationInformationReply service provides the information to CS. The Constituent Transaction Management (CTM) framework is triggered. After the borrower has been found or created, a relationship between the student and borrower is created where the Relationship value is PL (PLUS loan borrower).

Image: Plus loan disbursement process

Plus loan disbursement process

PLUS loan disbursement process

SFP Notification Events will be pushed to the CS Notification Framework and CS Batch Notification will generate the email, as shown in this diagram.

Image: SFP Notifications through the CS Notification Framework

SFP Notifications through the CS Notification Framework

SFP Notifications through CS Notification Framework

To set up the notifications framework, use these:

  • Generic template definition: SFP_NOTIFICATION

  • Notification setup for generic template: SCC_SFP_NOTIFICATION

  • Notification consumer setup: SFP Notifications Consumer

  • Sample Pop select query: QA_CS_CC_SFP_NOTIFICATIONS

For details, see Setting Up and Consuming the Notifications Framework.

These SFP message events contain notification data:

  • FasStudentNotificationEvent

  • FasDocumentRequestEvent

  • FasDocumentRejectedEvent

  • FasLetterInformationRequest (web service)

  • FasLetterInformationReply (web service)

  • FasStudentLetterListRequest (web service)

This table explains the notification types.

SFP Notification Type

SFP Notification Trigger

(* Notification trigger criteria is configurable)

SFP Notification Message

(** Notification message text is configurable)

FAFSA

SDI is received and no ISIR exists for any open FAFSA award year OR student continues into a new award year and no ISIR exists.

FAFSA for 18/19 Award Year is due. Please go to www.fafsa.ed.gov to complete.

MPN (per Type: Sub/Unsub, PLUS or Grad PLUS)

Student is Repackaged *

Please complete your Direct Sub/Unsub Loan master promissory note at www.studentloans.gov. **

Entrance Counseling (per Type: Sub/Unsub, Grad PLUS)

Student is Repackaged *

Please complete your Direct Sub/Unsub Loan entrance counseling at www.studentloans.gov. **

PLUS Application (per Type: PLUS or Grad PLUS)

Student is Repackaged *

Please complete your Graduate PLUS Application at www.studentloans.gov. **

TEACH Grant Counseling

Student is Repackaged *

Please complete your TEACH Grant entrance counseling at www.studentloans.gov. **

Ability to Service (ATS) Acknowledgement

Student is Repackaged *

Please complete your ATS acknowledgement at www.studentloans.gov. **

Exit Counseling (Loans or TEACH for Graduating or Withdrawn Students)

Student withdraws or graduates and has disbursements from the institution of Title IV loans or TEACH grants. *

Please complete your Title IV Loan exit counseling at www.studentloans.gov. **

R2T4 Refund

Student withdraws and an R2T4 calculation is triggered that results in a refund of funds.

A refund is due based on the Return to Title IV calculation determined for the student.

Grant Overpayment (per Grant Type: Pell, FSEOG, TEACH or IASG)

Student withdraws and an R2T4 calculation is triggered that results in a grant overpayment amount due from the student.

A grant overpayment was issued and requires repayment. You owe $<Grant Overpayment Amount>.

Access the Process SFP Transactions page (Campus Community > Student Fin Planning Interface > SFP Message Log).

Field or Control

Definition
Process Instance

Select the Process Instance identifier for the SFP exchange.
Transaction ID

Select the Universal Unique Identifier (UUID) of the transaction.
Status

Select “Error” to view error messages.

The SFP Message Log provides a view into the table holding all the SFP inbound and outbound messages (PS_SCC_SFA_MSG_MAP). Search criteria allow the user to select specific transactions and display the results.

If an SFP inbound message fails, use the Resubmit option after correcting the error.