Security
Discussion List
-
How to Restrict Modification of Certain Contexts in Person EIT Information Using EFF SecuritySummary: Hello, We are currently working with Extensible Flexfields (EFF) on Person EIT Information. Our requirement is to restrict modification of certain contexts whil… -
Facing issues with Users setup for AORSummary: I want to segregate users based on Departments for Time and Labor reports but the same users when associated with Departments are restricted on the Learning sid… -
Access to customize reports in Publisher greyed outHi all, Hoping someone could assist with an issue regarding access to customize reports in Publisher. The user has BI Author and BI Admin. The folder permissions for the…G. Class-Peters 22 views 0 comments 0 points Started by G. Class-Peters Reporting and Analytics for HCM -
query object permissionswe are looking for the physical tables or BI publisher SQL that will allow us to see the permissions for the objects in our catalogs (data models, report templates, prom… -
OTBI Report (Dashboard) Security Not Mirroring FusionContent My understanding of the OTBI security is that security applied in Fusion will also be applied when running reports. You'll see the same data. However, if additio…Rebecca L Smith 55 views 13 comments 0 points Most recent by GPOtimization Reporting and Analytics for HCM -
Need inputs to restrict OTBI reports only based on the AOR roleSummary: Need inputs to restrict OTBI reports only based on the AOR role for users that have both AOR and Line Manager data access roles. Content (required): We have cre…Sakthi priyanka B-Oracle 224 views 3 comments 1 point Most recent by GPOtimization Reporting and Analytics for HCM -
Transaction Console -> Error Description and Error Resolution (hrc_txn_error)Summary: I have a requirement to get the data related to the transaction console when the transaction fails I need to get the error description and error resolution as d… -
Purge older data more than 90 days in fnd_session_user_activityAfter activating FND_TRACK_USER_ACTIVITY profile option, is it possible to delete data older than 90 days in fnd_session_user_activity table -
C5ISR Audit (User Access and Behavior)We need to create BI report(s) that include as much of the FUNCTION information below as possible for audits. Already finding some useful data in the ASE_USER_LOGIN_INFO… -
Restrict the compensation information in reports and analytics.Hi Team, We have a requirement that some set of employees can able to access/view the compensation data in BI and OTBI Analysis reports. E.g: If a user queries the compe… -
Prompts are not showing while scheduling the OTBI AnalysisThere are 4 prompts in the Analysis. But when we try to schedule the report, these parameters/prompts dont show up in the General tab. Please suggest.Dona Das-Oracle 42 views 3 comments 0 points Most recent by Jagadeeswara Reddy Reporting and Analytics for HCM -
Matrix Manager into HR Hierarchy for Line Manager in PayrollIn the common lookup PER_SUPERVISOR_TYPES we have created a manager role named Indirect Manager. Is there a way we can take these newly created roles and merge them into…Sean-B-01 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Missing users from ASE_USER_LOGIN_INFO tableSummary: Missing users from ASE_USER_LOGIN_INFO table Content (please ensure you mask any confidential information): As far as I know this table stores login information…Stefano_Mazzocca 85 views 4 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
Is there a way to know who changed Password and when?Summary: We would like to know if there are any tables that store information about users' passwords Content (please ensure you mask any confidential information): Hello…Giuseppe Casalino 68 views 7 comments 0 points Most recent by Giuseppe Casalino Reporting and Analytics for HCM -
Help Desk Data only role for access to reporting for HR Service Requests and Knowledge ManagementSummary: I am trying to provide access to a Help Desk and Knowledge dashboard for users that cannot access the Help Desk and Knowledge modules. The subject areas that th… -
Can we have BI/OTBI Report to extract details to get data about privileges of the RolesCan we have BI/OTBI Report to extract details from security console to get data about privileges of the Roles as below: It should include Role, Privilege details and Inh… -
Few privileges are not available in the database tableSummary: There is issue with the privileges: Few privileges are not visible when query directly from roles/privilege screen while the same is visible when query a role. …Shailender Ahuja-Oracle 5 views 0 comments 0 points Started by Shailender Ahuja-Oracle Reporting and Analytics for HCM -
How to create one report that shows users, roles, and privileges on those roles?Summary: I need to create one report that shows all users and assignment info, the security roles on their accounts, and the privileges associated with each role. Does a…jpar 141 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Users able to access OTBI without security rolesSummary: Users without who do not have security roles to access reports and analytics are able to bypass this by using the below URL https://FUSIONURL.COM/analytics Is t…Tara Samari-237472 41 views 7 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
User Account Details (Email Address) in Security ConsoleSummary Need table names to be able to pull email address kept in Security ConsoleContent Hi All, I am struggling to find and link tables to pull User Account Email Addr…User_2025-01-28-05-11-13-165 785 views 11 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Degraded performance when using secured views in BIP reportsSummary: Using a secured view (e.g., PER_PERSON_SECURED_LIST_V) in a BIP report results in a severe increase in the execution time of the query when ran by a user with a…George Chernikov 34 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
XML-22002: (Fatal Error) Error while processing include XSL fileSummary: We are getting the error XML-22002: (Fatal Error) Error while processing include XSL file (xdoxsl:///Custom/Human Capital Management/HR/SUBTEMP.xsb?loc= en-GB) … -
PER_PERSON_SECURED_LIST_V showing own recordsSummary: Hi, We have some reports created with PER_PERSON_SECURED_LIST_V one employee is from a country A with AoR from country B, on person management the employee cant…Lucas B Maciel 11 views 3 comments 0 points Most recent by Nidhi Prasad2 Reporting and Analytics for HCM -
My Team Activity Center Org HierarchySummary: Redwood. 25A. Test Pod. When logged in as a Line Manager and accessing My Team Activity Center, the manager will click on the Org Hierarchy. When moving up the … -
Report on Auto-Provisioned RolesSummary: We are looking for a way to report on which of our security roles are auto-provisioned vs. manually provisioned. Does anyone know of a subject area that has thi…Karlie Backman 164 views 7 comments 1 point Most recent by Felix_fei Reporting and Analytics for HCM -
Request for Guidance on Managing DEI Attributes in OTBI Analysis Following Executive Order 14151In response to the Executive Order 14151, "Ending Radical and Wasteful Government DEI Programs and Preferencing," signed on January 20, 2025, our Compliance team is work…SwatiSharma 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Supplier Portal InquirySummary: Looking to create an Inquiry Only Supplier Portal role to support supplier portal vendors requiring inquiry to their Invoices, Payments, PO and Supplier profile…dgeryol 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to obtain the history of when a role is assigned and revoked to a userSummary: Hello All, As an Audit Requirement we need the complete history of when access is provisioned to a role and it is revoked. The following table ASE_USER_ROLE_MBR…Dharma_Reddy 532 views 4 comments 0 points Most recent by Matt Sinclair Reporting and Analytics for HCM -
How to list all locked users?Summary: How to list all locked users in BI Publisher? Content (please ensure you mask any confidential information): Table PER_USERS and PER_LDAP_USERS are related to u…Stefano_Mazzocca 7 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Viewing reports history submitted by the userSummary: Our target is to see the reports history submitted by all the users in the fusion HCM. Please advise accordingly how can I retrieve this information. Content (p…Azhar SIDDIQUI 1 view 1 comment 0 points Most recent by Azhar SIDDIQUI Reporting and Analytics for HCM