My Oracle Support Banner

When A Single User Assigned Two Roles Getting Error While Accessing Queues ,Data Is Not Fetching For The User (Doc ID 2989436.1)

Last updated on DECEMBER 01, 2023

Applies to:

Oracle Banking Payments - Version 14.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 14.5.0.0.0 version, Implementation Support

OBP-14.5.0.0.0 -PROD -When a single user assigned two roles getting error while accessing queues

Steps :
1.Create two roles PAYROLL_MAKER and REMITTANCE_MAK
2. In PMDROLQAR provided all network access to REMITTANC_MAK and only WPS/NWPS access to PAYROLL_CHECKER
3. Created user REMIT02 and assigned role PAYROLL_MAKER and REMITTANCE_MAK .
4. While accessing queue, data is not fetching for the user.
Observations:
We are unable to access data in any of the queues using REMIT02 user but able to access using other users.

As per initail analysis we have found that cursor picks up only PAYROLL_MAK while access any queue and for PAYROLL_MAKER we have not assigned
any NETWORK because of which data fetch is not working.




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.