GRANTS SECURITY - GM_DEPT_SEC_VW TABLE MISSING EFF DATED LOGIC
(Doc ID 2132801.1)
Last updated on MAY 16, 2019
Applies to:
PeopleSoft Enterprise FIN Grants - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When setting grant security and using lookup for DEPT, enter department id and we receive duplicate results for the exact same dept id
The view is GM_DEPT_SEC_VW. It needs EFFDT logic for the PS_DEPT_TBL.
Replication steps:
1. Add multiple effdt (effective date) rows for department chartfield
2. Go to Grants Security page GM_SEC_DEPT_OPR
3. Do lookup for the DEPARTMENT - it will show duplicate for the dept id that has multiple effective date.
Cause
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
Symptoms |
Cause |
Solution |
References |