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