Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Standard report to track dashboard and reports accessesHi, is there a standard report that is useful to track users accesses in Dashboard HR and also the detail on which reports in this dashboard they access? We configured t… -
Table to extract BPM Approval Groups InformationHi, I cannot see any data when querying the tables below. Could it be due to the role? What could be the reason? I think it should be recorded in these tables. fa_fusion… -
Adding two person types into one OTBI analysisSummary: According to our current practice when employees are retiring we change their person type into "retiree" in the system. I need to create an analysis to capture …
-
how to enable https://www.google.com/jsapi'></script> at otbiSummary: I took from sharing center report for org char it is not working because I don't know how to enable the sceipt Content (required): window.onload = function(){…
-
ESS Job Report with link between parent and child requestsSummary: ESS Job Report with link between parent and child requests Content (please ensure you mask any confidential information): Hi Team, We use the different reports … -
Supervisor Hierarchy (Top/Down) Managed departmentsSummary: Supervisor Hierarchy (Top/Down) spanning multiple departments Content (required): We are trying to develop an OTBI report displaying reportees spanning multiple… -
OTBI - change field from text to numberSummary Changing text format fields, which include number values, to number formatContent Hi :) I have a report which shows information on Element Entries. The input val…
-
Working days lostSummary: Has anyone managed to do a comparison between, a work schedule that holds a person's work patten eg Mon to Friday 9-5 and days taken as sick eg Tuesday and Wedn…
-
Table Name for Availability CalendarTeam, Need table name which holds the availability calendar details. Person Management -> Work Schedule Assignments-> View Calendar. Please Guide.
-
How to get the Path of Sub Templates of Total Compensation Statement Seeded ReportSummary: We have a requirement to Customize the Total Compensation Statement Seeded Report Template We are not able to get the path of the sub Templates used in it. Cont… -
RTF - Display hypen instead of 0 for currency amount in excelSummary: Hello, I was wondering if it is possible to display the Excel Accounting 0 value as " - $" (as below) using RTF template. I currently use this format 999G999G99…
-
Link a report to a button near to the All-in-One evaluationSummary: Content (please ensure you mask any confidential information): Hi experts, I need to add a link that redirect me to a dashboard. Is it possible to achieve it th…
-
OTBI subject area for Job responsibilitiesSummary: Looking for the subject area to report on job responsibilities and weights associated. From the job profile Content (please ensure you mask any confidential inf…
-
Where can I find the table for phase and state submission date?Summary: Table for phase and state submission date. Content (please ensure you mask any confidential information): Version (include the version you are using, if applica…
-
Age Formulas using SQLSummary Need age as of the current date and when someone will be a certain ageContent Hello, I am needing a formula to calculate age in Years that does NOT round. For ex… -
Which action for a DEEP LINK can I use to manage a REQUSITION in DRAFT status?I need to create a custom notification with a link that leads to the detail of a requisition that is in draft status. I've tried with this deep link: //fndSetup/faces/de…
-
Will selecting Application Role within Report Agent set up secure the rows based on AORs?Summary: Hi all We want to create an agent that sends the results of an OTBI analysis to our HR Business Partner population. If I add our application role for them will …
-
We have a requirement to fetch salary component calculation columns in OTBI and a stat graph.Summary: We have a requirement to fetch all these calculation columns in OTBI as we have partially developed the solution in BIP, but client want this in OTBI so can we …
-
Grade MidpointSummary Joining Worker Assignment Real Time to Grade Rate Real TimeContent Hi, we're currently building reports for use in UAT ahead of upgrade to Cloud next year. I've … -
Grade Step DetailsContent Good Day, Within Report creation in OTBI we are trying to report on all Grade Step Levels from Grade to Step to Ceiling etc. But we are unable to find the "code"…
-
Grade Step in OTBISummary Workforce Management - Worker Assignment Real Time does not display current gradeContent Hi, Does anyone know which subject area would give me Grate step values …
-
Unable to get results when pulling Grade data in with Job Structure dataSummary Report fails when fields from Grade Rate Real Time are pulled inContent Using two subject areas: Workforce Profiles - Model Profile Real Time and Workforce Manag…
-
Comparing columns from two different Analysis areas.Summary Comparing columns from two different Analysis areas.Content I am attempting to grab Job Codes for employees and the grades for the jobs. In the analysis i am usi…
-
Joining Grade/Grate Rate with Job and PositionSummary Joining Grade/Grate Rate with Job and PositionContent I am looking to report Midpoints for Jobs and Positions. Is there a way to join "Grade Rate Real Time" Subj… -
Report - Hourly/Salaried vs Rate Value for the GradeSummary Looking to crate a report to get Hourly/Salaried vs Rate Value for the GradeContent From Person Management - Get If person is Hourly or Salaried. Then navigate t…
-
Issue with Grade Rate Real Time Subject AreaSummary Grade Rate value is not returnedContent We had a requirement to display all workers who has a current salary not equal to the current grade step rate value i.e, …
-
How to restrict based on previous Backout statusSummary: Hello All, I'm currently working on restricting the custom BIP notification based on below scenario. If an employee benefits is backed out and reprocessed again…
-
How to report on missing Costing of Positions?Summary: Content (please ensure you mask any confidential information): I'm trying to find a way to report on Position Costing that is missing. In the 'costing of positi…
-
Pending Approver when a transaction is claimedSummary: The transaction detail analysis as well as the SQLs do not provide the information of the current approver when a transaction is claimed in case of parallel app… -
Leader Dashboard for Oracle Cloud HCM 22CHello, Any guidance on where I can find the Out of the Box documentation for the Leader Dashboard for Oracle Cloud HCM, 22C? Thank you, Tanya