Grants Accounting: List of Values on Various Forms Cannot be Limited by Security (Doc ID 275688.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Grants Accounting - Version 11.5.9 and later
Information in this document applies to any platform.

Symptoms

You need to able to limit List of Values to only those Awards and
projects for which the User is listed as Personnel.

GMS_SECURITY_EXTN is called by the following forms:
Award Management
Award Budgets
Revenue Review
Invoice Review
Funding Inquiry
Award Status Inquiry

PA_SECURITY_EXTN is called by the following forms:
Projects
Project Budgets
Capital Projects
Funding Inquiry
Revenue Review
Invoice Review
Project Status
Expenditure Inquiry
Standard Report Submission (Single Project LOV's)

However, even though these security extensions are called by the forms and they do limit view of underlying transactions and data, the complete list of Projects with descriptions and Awards with descriptions will still appear in the relevant List of Values. This is a potential security issue as the award and project descriptions can contain sensitive information.

Use of PA: Cross Project Responsibility is not an options as it has to be set to 'N' for Invoice and
Revenue forms to work correctly. (Otherwise it limits viewing access to only the Award Manager.)

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