Effective Date Problem For Department Table In Service Indicator Reason Code View SRV_IND_RS_SCTY
(Doc ID 1554403.1)
Last updated on MAY 06, 2019
Applies to:
PeopleSoft Enterprise CS Campus Community - Version 9 and laterInformation 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
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
| Goal |
| Solution |
| References |