GRANTS SECURITY - GM_DEPT_SEC_VW TABLE MISSING EFF DATED LOGIC
Last updated on OCTOBER 02, 2017
Applies to:PeopleSoft Enterprise FIN Grants - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms