My Oracle Support Banner

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 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  


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.