Reports
Discussion List
-
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…Mani Venkataraman 1K views 1 comment 0 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM -
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…MattW 35 views 9 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
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…Manju01 74 views 20 comments 0 points Most recent by Prudhvi Indukuri Reporting and Analytics for HCM -
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 …User_2025-02-04-08-51-08-912 110 views 1 comment 0 points Most recent by Nagaraj Hunur-Oracle Reporting and Analytics for HCM -
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/…Janine Dorongon 23 views 2 comments 0 points Most recent by Janine Dorongon Reporting and Analytics for HCM
-
report out on offer letter templateSummary How can we report out on which offer letter template was selected for a candidateRiti Malhotra 31 views 3 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
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 32 views 2 comments 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
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…User_2025-02-10-08-27-16-805 27 views 1 comment 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…Anil Pillaresetty 34 views 9 comments 0 points Most recent by Janine Dorongon Reporting and Analytics for HCM -
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…Alvaro Couto 74 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
"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…
-
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…Megha Patel 35 views 3 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
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…Kyle Norris 60 views 4 comments 3 points Most recent by James Hoffmann Reporting and Analytics for HCM
-
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…Rob F 20 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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…Pernel Dela Pena 27 views 6 comments 0 points Most recent by Matt Nease Reporting and Analytics for HCM
-
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…Andrew_Schmitz 42 views 4 comments 0 points Most recent by ravikiran goda-Oracle Reporting and Analytics for HCM -
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…Tom_Giarratano12 30 views 3 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
Cannot Find Category Name in Service RequestsSummary Looking for Category Name in the CRM Service ModuleContent Hey everyone, We recently installed HCM and we use the service model to act as our HR Help desk. I hav…
-
Organization Chart Custom ReportContent Hi All, I customized the DirectoryPrintReport report in /xmlpserver. I have kept only Custom as Default and Active. But the system is still printing the delivere…Mohit-Sinha 41 views 2 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
Custom report for goals displays HTML tags and splits the Success Criteria Text CLOB data into multiContent Sample text in Success Criteria Field. - -This is a sample for success criteria textoralife 50 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dashboard prompt returned error (Failed to load (Odbc driver returned an error SQLExecDirectW).)Content Hello All, Currently I am using SQL Results option to populate value of a dashboard prompt called "Module Name".I am using below SQL code for this : actual colum…Janardhana K 27 views 6 comments 0 points Most recent by Janardhana K Reporting and Analytics for HCM -
Custom Labels of OTBI are getting changed automaticallyContent Hi I have customized labels names of the parameters used in OTBI reports But somehow those customized labels are changing to it's initial name automatically This…Dhajani Perera 38 views 2 comments 1 point Most recent by Sushan Peiris Reporting and Analytics for HCM
-
deep link to reportSummary deep link to reportContent Hi, We are trying to deep link to report in OBI report. below is the link we copied from the browser address bar:…Nizar Kassam 201 views 5 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
How to navigate from OTBI report to Absence Record Entry page in Edit modeSummary There is no Deep Link available to navigate to Absence Record page in Edit Mode using Absence Entry ID. Want to know if there is any way to open the Absence Reco…User_UM4C6 53 views 2 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
how to extract sql query in data modelSummary how to extract sql query in data modelContent Hi, I wonder if there is any way to extract SQL Query in Data Model using table/web service/etc. Regards, Suyoung V…Suyoung 39 views 3 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
HDL Error ReportingSummary HDL Error ReportingContent Hi Experts, Does anyone have user friendly error reports for HDL Loads. Because PBL is deprecated, we are looking for a good reporting…Rahul Bedia 102 views 8 comments 1 point Most recent by Suma Raghavendra Reporting and Analytics for HCM
-
What roles needed to let custom HR Specialist Role able to open any report or analysis?Content What roles needed to let custom HR Specialist Role able to open any report or analysis? and what controls reports and analysis data security? BI consumer Role? B…Walid Hamdy 51 views 5 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM
-
OTBI Report showing multiple Parent Position Codes for a recordSummary Display the current parent position code in the OTBI analysisContent I have an OTBI analysis that is using Workforce Management - Worker Assignment Real Time and…User_2025-02-04-08-51-08-912 37 views 8 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Number of days a requisition is suspendedSummary Asking if it is possible to calculate the number of days a requisition is suspended (regardless of the number of times it is suspended) in OTBIContent Hello ever…Tom John Bontoyan 49 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM