GRANTS SECURITY - GM_DEPT_SEC_VW TABLE MISSING EFF DATED LOGIC (Doc ID 2132801.1)

Last updated on APRIL 29, 2016

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