My Oracle Support Banner

After On-Line Disbursement, Clicking Messages Link on Disburse Aid Page Shows 'SQL error after posting the Item - Select failed for Installation table' (Doc ID 2937035.1)

Last updated on JANUARY 25, 2024

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On the Disburse Aid (or Disburse Aid with Override) component, after clicking the 'Disbursement' button to complete the disbursement of an item type, then clicking the 'Messages' link, there is the normal message row indicating 'Award Disbursed', but the following additional message is also displayed:

As indicated by the 'Award Disbursed' message, the disbursement process itself worked normally.

The issue can be reproduced at will with the following steps:

  1. Navigate to Financial Aid > Disbursement > Disburse Aid > Disburse Aid for any student, term and item type that is eligible to be disbursed (or have the previous disbursement adjusted).
  2. Click 'Authorization' button then 'Disbursement' button.
  3. Click 'Messages' link to see the messages.

Changes

The issue occurs after applying the fix for <Bug 34645758> - SFP: ADD LOGIC TO ENSURE POSTING CREATES A 1:1 RELATIONSHIP BETWEEN SFP AND SF PAYMENT_ID_NBR. 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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