My Oracle Support Banner

TCSI: PSQL error in Exec. (2.280) in TCSI Apps/Offers/Preferences Page when the Application and Offer Year Setup is Missing (Doc ID 3051640.1)

Last updated on OCTOBER 04, 2024

Applies to:

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

Symptoms

While trying to access the page TCSI Apps/Offers/Preferences, for a student who has posted/transaction due for posting (with profile value assigned) an SQL error occurrs:

SQL error in Exec. (2.280) SSR_HEIMS_UTILITIES. UTIL AppsOffersPreferencesUtil. OnExecute Name:GetApplicationsElements PCPC:34727
Statement:477
Called from:SSR_HEIMS.Components.SSR_HM_CRSE_APPL.OnExecute Name:PopulateCurrentData Statement:534
Called from:SSR_HEIMS.Components.SSR_HM_CRSE_APPL.OnExecute Name:SSR_HM_WRK_SSR_DEEWR_PROFILE_FieldChange
Statement:38
Called from:SSR_HEIMS.Components.SSR_HM_CRSE_APPL.OnExecute Name:SSR_HM_CRSE_APPL Statement2
Called from:SSR_HM_CRSEAPPL GBL.PreBuild Sta
During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.


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

  1. Navigate to Records and Enrollment > Enrollment Reporting >AUS Regulatory Reporting >TCSI Transaction Maintenance >TCSI Apps/Offers/Preferences.
  2. Find a student who has posted/transaction due for posting (with profile value assigned).
  3. Observe the error.

Changes

 

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.