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
-
What are the available web services for Fusion BIP?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
How to SUM 1st, 2nd, 3rd and 4th occurrence of values in trailer summary record for ETEXT template?Summary: I have a requirement to build a trailer record that includes 4 separate SUM totals based on the occurrence of these totals in the employees record. I can't chan… -
Colleague Goals Folder in Workforce Goals - Goal Alignments Real Time Subject AreaHello, Does anyone have experience using the Colleague Goals area of OTBI? I am creating Goal Alignment analyses, and I have already created analyses for Manager Goals a… -
How to get performance rating of Manager and Employee in a single row based on Review Period?Summary: How to get performance rating of Manager and Employee in a single row based on Review Period? The employee rating and manager rating should be in single row bas…
-
Rating are displaying on Different RowSummary Rating are displaying on Different RowContent We have using Performance rating real time subject area. We have selected 3 field... Person Number, Worker overall … -
CONTENT SERVER REQUEST FAILED error messageSummary: Error message when trying to generate dynamic URL embedded in custom Talent BIP report. Content (required): In the process of generating a dynamic URL to be emb…
-
Terms (Leavers) with Most Recent Box AssignmentSummary: We need a report and bar chart that shows terms (resignation and term-invol), NO legal employer changes, with their most recent box assignment from the Talent A… -
Development Goals view of Top 5 for different categories - not overallSummary: HI there, I am reporting on our Development Goals using "Workforce Goals - Goal Status Overview Real Time" As there are so many goals in our system, I want to g… -
How to give mirror text formatting in rtf templateSummary: For one of the client requirement , in rtf template i need to show the text in mirror look. Please do the needful. If anyone tried this , please help us. Conten…
-
How do we get Date performed ,Percentage of Performance Tasks by Status in performanceSummary: Hi All, I am using the Workforce Performance - Performance Task Status Real Time subject area for an OTBI Analysis. Can you please let me know from where Date p…
-
Agent for a BI report?Summary: Content (required): Hi there Is there a way to prepare an Agent for a BI report? Thanks B Version (include the version you are using, if applicable): 22D Code S… -
Period Rolling Turnover by Employment CategorySummary: I am trying to get a rolling turnover by employment category. This analysis doesn't change any value even if I provide the assignment category filter. The resul…
-
Identify the list of reports that a custom role can accessWe have 100s of custom reports within our /Shared Folders/Custom BI catalog folder structure. We have quite a few custom HCM security roles and each custom folder & repo… -
How to calculate percentage of Employees with more than 5 hours of learning?Summary: I need to get the percentage of Employees with more than 5 hours of learning for a specific time period in OTBI. So far, I have: a counter for employee names to…
-
Custom report permission with Custom RoleSummary: Hi We have requirement where we wants to give a custom report access to all of the employee of the company. Our organization in using all custom role (Custom Em…
-
Time and Labor Entries by BatchSummary Looking for a query of Time and Labor Entries by Payroll Transfer BatchContent We’d like to be able to report on the entries that were loaded from Oracle Time an… -
23A New Feature Summary and What’s NewSummary: 23A New Feature Summary and What’s New are now published to the Readiness site: https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/readiness/offeri… -
Add 2 Report Measures: Dept Active FTE and Vacancy Rate %Summary: I have an Analysis that calculates vacancy rate by department. I need expert advice on how to add two measures to the pivot table. I want to add a measure "Dept…
-
Is there a limit to the number of columns in a data modelHello, I’m attempting to create a report using a SQL based data model. It has about 90 columns but when I run the report it leaves off the last 2 columns. Is there a lim… -
Moved: How to customize Goal workflow notificationThis discussion has been moved. -
Candidate Progress Summary ReportSummary: Content (required): Can anyone share the OTBI sample report to extract the candidate progress summary? Version (include the version you are using, if applicable… -
Analyzing Skills and Competencies asked on Job DescriptionsSummary: We are looking for a Reporting or a Tool to expedite the following request from our VP Talent. Content (required): Is there some way we can pull a bunch of job … -
Payroll costing - position levelSummary: Breaking down the payroll costing report by position. Content (required): For example, if an employee had a position change on the 15th of September, is there a…
-
We develop new custom report but we getting some of employes have two recordsSummary: Hi Team, We develop new custom report but we getting some of employes have two records due to terminattion date actuallyin ui no termination date but some have … -
Hi! How can I run a query to pull data within 90 days from the effective date?Summary: I need to create a query to pull data less than 90 days of effective date to use as agent and decrease the number of lines in the reporting. Content (required):…
-
BIP - List of Employees under the Area Of Responsibility of HRSummary: Hello, Does anyone know how to get the list of employees under the Area of Responsibility of HR via BIP Report? Could you please share a query or do you have do…
-
SQL Query for Supervisor/Employee Hierarchy with Both Direct and Indirect ReportsContent I have a task to create a BI Publisher report and attach additional data from different tables based on the bottom level employees. I am wondering if anyone has …
-
How to get location for position in OTBISummary: How to get location for position in OTBI Content (required): I tried using location name column under Position folder from position real time subject area but i…
-
we have head count nearly 9000 employees and coming to this report only showing 5700 plus employeesSummary: Hi team, we have head count nearly 9000 employees and coming to this report only showing 5700 plus employees may i know how to check the issue. person real time…
-
Need to capture the details under Mobility in "Skills & Qualifications " pageSummary Need to capture the details under Mobility in "Skills & Qualifications " pageContent Hi Experts, Need a help. Need to retrieve the following data for a person. N…