Security
Discussion List
-
Privilege for ORA_PER_LINE_MANAGER_ABSTRACT to access Workforce Management - Worker Assignment SASummary: Hello, Does anyone know what is the exact privilege required for ORA_PER_LINE_MANAGER_ABSTRACT to run the data of subject area Workforce Management - Worker Ass…Hazel De Castro 26 views 4 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM -
How to link Top Manager to a username within "Workforce Management - Worker Assignment Real Time"Summary: Hi all I'm trying to create an emergency contact report that allows managers to see their entire reporting line population and the emergency contact details on …
-
Error message when downloading BI ReportSummary: Content (required): Hello experts, when downloading a BI custom report with some users I get the following error message: ORA-01847: day of month must be betwee…Valerio Curzi 34 views 9 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Is it possible to track who changed user roles and when it happened in Security Console?Summary: Content (required): Hello experts, is there a way by OTBI or SQL to retrieve who changed user roles in security console and when it occured? Thanks in advance f…Valerio Curzi 33 views 5 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
HCM Extract Parameter LOV is visible to some users while null for othersSummary: In an Extract the LOV in a Parameter is visible to some users while it is null/blank for other users. The parameter is made out of a Value Set. There are no sec…
-
Which Role is required for column AsgRepresentativePEO.WORKER_ASSIGNMENT_ID?Summary: I have Created an OTBI report in which AsgRepresentativePEO.WORKER_ASSIGNMENT_ID is cloumn is there I am not bale to access the report , So I am assuming may be…Rajib_Samanta 24 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to view specific subject areasSummary: I can't seem to figure out how to access the vacancy numbers under Workforce Management - Vacancy Real Time Content (required): I'm attempting to view the vacan…RyanPE 32 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Display Performance OTBI Analysis to a user Without Giving AccessHello All, Appreciate the help in advance! We have a new office assistant who will be reviewing information like evaluation tracking, performance status, sick leave, etc…Gail Wilmoth 27 views 9 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
Data security on BIP reportHi friends, We have developed a BIP data model/report using the below tables which touches across payables, supplier and hcm. Some of payroll users having the Payroll Ma…Vijay Ramani VJ 19 views 4 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM -
Need help to fetch the roles with stream names and service detailsSummary: Need help to fetch the roles with stream names and service details Content (required): We have a requirement to develop a report to fetch all the roles along wi…
-
Oracle FAW usage tracking not showing custom dashboard under custom folderSummary: Oracle FAW usage tracking not showing custom dashboard under custom folder Content (required): Hi All, Oracle FAW usage tracking not showing custom dashboard da…
-
Folder Permissions Error in 22BSummary: Since 22B we receive error when adding or removing users to folder permissions under Custom Content (required): The following error is thrown: "Exceeded number …Janine Brown 12 views 10 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Could not able to search BI Consumer in PermissionSummary: Hi Experts, I have removed the BI Consumer role from a folder and when I try to add back the BI Consumer role, I could not able to search in "Add Application Ro…HarishVummidi 13 views 1 comment 0 points Most recent by HarishVummidi Reporting and Analytics for HCM -
Failed to log into BI Publisher: invalid username or passwordSummary: Failed to log into BI Publisher: invalid username or password Content (required): Hello experts, we have done the P2T in oracle HCM, but after it, the connectio…
-
Security is not working in otbi dashboardSummary: Content (required): A custom role is able to see all the data regardless of their security. Is any privilege or security policy missing? Version (include the ve…Swati Rana 43 views 5 comments 0 points Most recent by Mayur Kaushik-Oracle Reporting and Analytics for HCM
-
Query to extract Mail address Effective start dateSummary: Content (required): Hello experts, please, could you share the SQL query to extract employees effective start date? Thanks in advance for your time! Kind Regard…Valerio Curzi 43 views 9 comments 0 points Most recent by DavidBlake Reporting and Analytics for HCM
-
Need query to get the list of all privileges for a given roleSummary: Need query to get the list of all privileges for a given role Content (required): Navigation: Tools > SecurityConsole > Roles If I query a role name, I am getti…Jaeyshree Kumaran Kalpana 34 views 7 comments 1 point Most recent by Jaeyshree Kumaran Kalpana Reporting and Analytics for HCM
-
An OTBI report in Workforce Management-Work Relationship subject area doesn't work for some rolesSummary: We have an OTBI Report with 4 columns, all under Workforce Management - Work Relationship Real Time category (Display Name, Person Number, Worker Payroll Name, …Justin Hurley 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Table which stores User password expiration dateSummary: Table which stores User password expiration date Content (required): Hi All, Which table stores the user password expiration date? The user wants to create a re…
-
SQL Query to retrieve User Status both Active and InactiveSummary: Query to retrieve User Status both Active and Inactive Content (required): Trying to put together a query that will tell which users and how many of those are e…Edwin Martinez 162 views 2 comments 0 points Most recent by Edwin Martinez Reporting and Analytics for HCM
-
Need to customize a workflow notification but cannot see 'Customize' in the More dropdownSummary: Need to customize a workflow notification but cannot see 'Customize' in the More dropdown. I have a custom BI Admin role. Am I missing a permission to be able t…prjohns-Oracle 22 views 1 comment 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
Report to Audit Approval Rules ChangesSummary: Just trimmed back access to Transaction Console, but would like to see who made the most recent Approval Rules changes to workflows, and when the changes were m…
-
What is the best way to mass assign a Dashboard to a large groupSummary: Only a small handful of employees use the reporting system. I am building several Dashboards for various teams, and was wondering the best way to get those folk…Wesley Morgan 12 views 1 comment 0 points Most recent by HarishVummidi Reporting and Analytics for HCM
-
Secured List View - How it works in a BIP ReportSummary: Hello, Is there any documentation or white paper on how secured list view works in a BIP report? Content (required) We used secured list view in our BIP query t…Hazel De Castro 43 views 3 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
Is there a way to extract the Manage Privileges details?Every oracle maintenance we are manually checking the Manage Privileges (OBIEE > Administration > Security) if still intact. Are there any way to extract all the details…
-
Does anyone know how to prevent BI Folder being accidently moved?Summary: Any strategy to prevent the BI folder structure from being accidently manipulated. When a folder is accidently moved, the reports that use a BI Publisher data m…
-
Where can I find "Job Definitions" for ESS jobs?Summary: I'm looking for a list of ess job definition names such as: 'JobDefinition://oracle/apps/ess/hcm/users/SyncRolesJob' Content (required): The end goal is to crea… -
How to restrict performance data access in BIP report when having Frontend accessSummary: How can we exclude employees from a BIP report for performance, where the HR User has access to the employee information over the frontend but not to the perfor…Franziska Reichel 2 views 0 comments 0 points Started by Franziska Reichel Reporting and Analytics for HCM
-
Create a BI Publisher report to spool users whose password is expiring in next 14 daysHi Experts, I want to create a BI Publisher report to spool users whose password is expiring in next 14 days. Has anyone created something in these lines. Any inputs wou…Aloka Bhattacharya 2 views 0 comments 0 points Started by Aloka Bhattacharya Reporting and Analytics for HCM