My Oracle Support Banner

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.