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