My Oracle Support Banner

TCSI: The SQL for SSR_HM_POST_EXAW Does not Return rows Because ADMIT_TERM in the Selection Clause is not Using Effective Dates (Doc ID 3045234.1)

Last updated on FEBRUARY 10, 2025

Applies to:

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

Symptoms

When the SQL for 'SSR_HM_POST_EXAW' for is executed with 'Admit Term' as part of the logic, the correct result with an expected single row of data is not being returned.

Changes

A change to the SQL Definition, 'SSR_HM_POST_EXAW', delivered in CS 9.2 PUM Image 30, added the field 'Admit Term' to the SQL.

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.