Effective Date Problem For Department Table In Service Indicator Reason Code View SRV_IND_RS_SCTY
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.
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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms