Hello,
We are currently revising the permission sets. We now have over 850 functional roles and numerous user roles (a total of over 1,097 permission sets). The two QuickReports titled “Permission Set Grants Reports” are no longer functioning as intended. They are no longer returning any data. We need these reports for the audit.
These two QuickReports are running on the IFS-MIG as intended. However, we now have 256 permission sets there.
We use IFS Cloud 25R1 SU 5
Best regards,
André
+9Which user are you logged in as when trying to run the report? I suspect you might need to use IFSAPP or another user with admin type access.
Hi,
You first need to generate the reports on page 'Permission Set Grants Reports'
(Solution Manager > Access Control > Permission Sets > Permission Set Grants Reports)
Best regards
Johan
We have received a response from R&D:
"Oracle DB limits columns to 1000. We model permission sets (roles) as columns in the report table, and the number of roles exceeds 1000, so creating the report table fails, and the code enters the WHEN OTHERS block, which creates an empty table. We could change the error handling to return a clear message."
very intresting
We are facing the same issue and if i understand correctly we must have more than 1000 permission set based on IFS response ?
When quering the database , we get 296 row
select count(*)
from FND_ROLE;
Also, threw IFS Cloud :
We currently have over 1,100 end-user roles and functional roles.
For the report, a matrix (in Oracle tables) is created that lists all end-user roles along with all associated functional roles.
This worked fine for up to 800 roles. We are still in the process of revising the permission sets and now have over 1,100. Once we’re done, I’m sure I’ll be able to delete a few permission sets. However, we will definitely exceed 1,000.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.