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 MAY 11, 2020
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