Last updated on JUNE 18, 2015
Applies to:PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms