Reporting and Analytics for HCM
Discussion List
-
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… -
HCM OTBI Workshop Session 1Summary: This following link allows you to download the recording of session 1 of HCM OTBI Workshop for beginners organized by JAPAC CS Org along with DEV and COE. Conte…Raghavendra Raghunath-Oracle 1.3K views 22 comments 11 points Most recent by Julian Challenger-Oracle -
HCM OTBI Workshop Session 2Summary: This following link allows you to download the recording of session 2 of HCM OTBI Workshop for beginners organized by JAPAC CS Org along with DEV and COE. Conte…
-
New Bite-Size Learning Videos Published for HCM AnalyticsSummary: Need to learn how to modify OTBI analytics? Please check out the new Bite Size Learning videos just published to the Oracle Help Center Bite-Size Library page: …
-
How to identify Overdue Onboarding TasksSummary: I'm writing an analyses using the subject area Workforce Management - Checklist Real Time. I can see tasks that are incomplete, but I need to report only on tas… -
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… -
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…
-
OTBI Analysis report for auditing changesSummary: Hello - we are looking for a report/audit tool that will help us monitor when changes have been made to OTBI analysis based reports. We are utilizing the functi… -
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… -
How to customize Goal workflow notificationSummary: How to customize Goal workflow notification Content (required): Hi All, We have a requirement to customize the Goal workflow notification. we need to replace th…
-
Employee Name ChangesSummary: Employee Name Changes Content (required): I'm trying to determine via OTBI the history of someone's name and their changes, but I don't see any values where I t…
-
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… -
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…
-
Learning Calendar reportSummary: Hi Folks, Learning calendar view is blank and does not have the calendar view Please help to fix this All other reports for learning calendar title and learning…
-
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…
-
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 …
-
SQL query for Length of service in years and monthsSummary: Hi, I am trying to add formula in OTBI report on Service Date field to calculate duration in years and months. However, I don't know SQL, but was able to find b… -
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…
-
Change Date format in OTBI reportSummary: Hi, I would like to know how can I change the Date format in OTBI reports. Currently in reports that I create, date format comes up as MM/DD/YYYY. However, I wo…
-
Manager hierarchy in Recruitment using OTBISummary: Need guidance on which field or logic to be used to include manager hierarchy in an OTBI recruitment report Content (required): OTBI Manager Hierarchy Recruitme…
-
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…
-
What if i cannot find the Subject Area in the dashboard prompt. Does that mean i cannot create?Summary: Trying to create LSQL coming from Workforce Profile - Person Profile Real Time and Workforce Profile - Model Profile Real Time and will add it to a Dashboard wi…
-
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… -
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…
-
I am needing SQL for SalaryIdSummary: I am looking for an sql that includes SalaryId for trouble shooting an error I have in data flowing into FAW. I have the SalaryId in the error in FAW but can't …
-
which subject area we get father/husband names in OTBISummary: Hi Team, we need data employees of father and husband names so could please assitance on. Content (required): Version (include the version you are using, if app…
-
Not able to find column as Pending changes in Position subject areaSummary: Not able to find column as Pending changes in Position subject area Content (required): In manage position, we have "Pending Changes" column. see attached. Does…
-
Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances tableSummary: Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances table Content (required): In the Pay_run_balances table able to see "RUN" related bal…