Effective Date Problem For Department Table In Service Indicator Reason Code View SRV_IND_RS_SCTY

(Doc ID 1554403.1)

Last updated on NOVEMBER 01, 2017

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.

Goal

The view SRV_IND_RS_SCTY was modified in CS Bundle 27 and has a problem with the Effective Dating logic for the Department Table (DEPT_TBL) that causes Service Indicator Reason Codes to be unavailable if they are tied to Departments with future-dated rows. Any Service Indicator Reason Codes tied to Departments that have a future-dated row (in addition to earlier effective-dated rows) cannot be used on the Manage Service Indicator (Student) page.

In the SQL for this view, the last line of the sub-select for the Effective Date is "AND d.effdt

 
This needs to be "AND d1.effdt  

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms