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
- 
            
      
            Active employees that have a zero net paymentSummary Looking for an analysis/report that shows active employees that received a zero net payment for a pay periodContent Hello, I am looking for a report/analysis tha… - 
            
      
            SQL query to get offering start date and end date in learn module in fusion HCMContent Hi All, I am working in a requirement where I need the following details: Offering Name, Offering start date, Course Name, Person number enrolled in the offering… - 
            
      
            Reporting on the positions colleagues are working in (factoring in secondments)Content Im looking to report through OTBI on where colleagues are currently working, factoring in secondments. For example I only want 1 row to appear for each colleague… - 
            
      
            Retrieving Historical Data on all fields in Worker Assignment Real TimeContent I have built a report a report pulling fields from worker and department and have entered SET VARIABLE PARM_EFFECTIVE_DATE = '@{report_Date}{@{system.currentTime… - 
            
      
            How t get inactive employees less than 500 net payment from "Payroll-Payroll balances real time subSummary Ho t Pulling inactive employees from"Payroll-Payroll balances real time subject area" .Content Hello Gurus, I am trying to pull all employee including terminated… - 
            
      
            Date Filter with Default value FailsContent I am new to OTBI and have tried to follow the various posts etc. about creating a report with a filter on the criteria and have used a presentation variable. How… - 
            
      
            OTBI division operator in calculated column formula is not producing correct results - in RecruitingSummary The division operator in a calculated formula is not producing correct results in the Recruiting - Recruiting Events Real Time subject area.Content In OTBI, when… - 
            
      
            Dependents not enrolled in Benefits SQL HelpSummary Dependents not enrolled in Benefits SQL HelpContent Hi All, I have a query that I use in a BIP report that is supposed to be determining if a dependent is going … - 
            
      
            Custom Performance Document TemplateSummary Changing the fonts in Performance Document templateContent Hi, Has anyone successfully customized the RTF in template in: Path: /Human Capital Management/Career/… - 
            
      
            report out on offer letter templateSummary How can we report out on which offer letter template was selected for a candidate - 
            
      
            Report for Share and Retain and Share and ReleaseSummary Report for Share and Retain and Share and ReleaseContent Is there anyway we can report off of Share and Retain and Share and Release from performance document Is…Reddykrishna Chidella-Oracle 32 views 2 comments 2 points Most recent by Raghavendra Raghunath-Oracle - 
            
      
            Pull Succession Plan Name with Talent Profiles.Content I have created a report to pull latest Performance, Potential, Risk of Loss And Impact of Loss from Talent Profiles. Is there a way to add Succession Plan name t… - 
            
      
            Change Font of Delivered Performance Management ReportSummary Change Font of delivered - Performance Document Worker And Manager Ratings ReportContent Hello Experts, I am planning to change font (to Arial) for the delivered… - 
            
      
            Oracle SQL - Display rows as columns - Many to Many RelationshipSummary Oracle SQL - Display rows as columns - Many to Many RelationshipContent Good day! I need some guidance if I want to do is actually possible in Oracle SQL. I have… - 
            
      
            Line Manager DashboardSummary Line Manager prompt - Connect by in Logical SQL?Content Hi Team, I've added a Line Manager prompt in our custom version of Line Manager Dashboard. Because some o… - 
            
      
            List of Report for Onboarding ChecklistContent Hi All, Can anyone share a post of link in which we can get List of Report for Onboarding Checklist. Any kind of reports will help. Thanks & Regards, Kiran Versi… - 
            
      
            "Insufficient Privileges" in Fusion CloudContent Hi All, We have a requirement to find the approver name of a particular transaction. I did some research and found that may be we can get relevant data in hcm_fu… - 
            
      
            FTE by Actual Hours WorkedContent Hi All, I need a report that shows FTE per cost center by actual hours worked (in time card) instead of FTE based on scheduled hours. Have any ideas on how to be… - 
            
      
            Recruiting - Recruiting Real Time - Ability to Report on Position Details?Summary Currently you cannot report on all position attributes in ORC like FTE, having difficulty with joining subject areas.Content We are trying to report on FTE for O… - 
            
      
            migrate data model from test instance to productionContent Dear Members, I have accidentally deleted a data model of a report from production instance. Thankfully, our Test instance still has that data model as is and un… - 
            
      
            Agent Failure NotificationSummary Would like to have a notification sent to our HRIS group when Agents fail without sending the reportContent We are looking for a way to have agents send a notifi… - 
            
      
            Transaction Administration through multiple languagesSummary Process Name and Process Category are challenging in multiple languagesContent Hello Everyone, I've been pushing to create useful reporting on the goal setting p… - 
            
      
            Role Change Reflect to AnalyticsSummary When you change roles in Fusion, does it also get changed at the same time in Analytics?Content We encounter scenarios where we cannot see a report and then we a… - 
            
      
            Missing Payroll Element within OTBISummary Missing Payroll Element within OTBIContent I cannot see an Element with Element Classification Name = Information and at the Payroll Relationship Level within El… - 
            
      
            How to report on "lineouts" and "ergonomic injuries" within OTBI / OSHASummary How to report on "lineouts" and "ergonomic injuries" within OTBI / OSHAContent How to report on "lineouts" and "ergonomic injuries" within OTBI I think this data… - 
            
      
            OCI – HCM Analytics: What's New And What's Next On The HCM Analytics Roadmap, 18 May 2021, 9 a.m. PTContent Submit your questions for the OCI – HCM Analytics: What's New And What's Next On The HCM Analytics Roadmap session to have them answered during the live event. P… - 
            
      
            Need SQL Query/ table names to get Source System ID for person's areas of responsibilitySummary Need SQL Query/ table names to get Source System ID for person's areas of responsibilityContent Hi All, What I need is to get Source System ID for person's areas… - 
            
      
            How can we pass a table prompt selected in the main report to the table prompt in the drilldown repContent We have a dashboard with a drill down to a detailed report. The main dashboard has a report that shows the rollup counts of documents by task status. When you cl… - 
            
      
            Find subject area entriesContent Hello Experts In 21B the subject area Workforce learning - learning management real time will be replaced by Workforce learning - records real time. Does anyone … - 
            
      
            Looking for the Table for assignee Details from Service RequestSummary Table for the Assignee Details to whom the SR is assign to in the Helpdesk.Content Table for the Assignee Details to whom the SR is assign to in the Helpdesk. Ve…