My Oracle Support Banner

Is There a Fix for The SQL Definition For PS_SRV_IND_RS_SCTY? It causes issues with future effective-dated rows on PS_DEPT_TBL. (Doc ID 2572517.1)

Last updated on AUGUST 05, 2021

Applies to:

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


The effective-date logic in the view SQL of Record.SRV_IND_RS_SCTY causes an issue with future-dated rows. Can this be fixed?  Users are unable to see the service indicator/reason code for a department that has a future effective-dated row.


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.