OTBI
Discussion List
-
Time Cards - Calculated Time breakdownContent Hello We have a reporting requirement to show the calculated time breakdown by Type. Is it possible to bring this data in a OTBI report? In which folder do we ha…Ridma Karunanathan 46 views 4 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM -
Missing Salary Report on OTBIContent Hi all. I'm trying to build a simple report on OTBI that reports the employees who are missing salary at the current date. I tried to use both Compensation - sal…BenZionP 80 views 7 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI query: extract Withdrawal Reason, Data and CommentContent Hello, In the Learning subject area I cannot find the following info to extract: Withdrawn Date, Withdrawal Reason and Withdrawal Comment. Are they available? Wh…Daniela Spaseska-Oracle 49 views 3 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
Limit Datepicker in OTBI parametersSummary Datepicker to limit the user to select only dates from past till today and not any future datesContent Can we limit OTBI Parameter Datepicker to show dates only …pooja yelsangikar-Oracle 34 views 4 comments 1 point Most recent by pooja yelsangikar-Oracle Reporting and Analytics for HCM -
Accrual Balance Report is showing double the actual valueSummary Accrual Report is showing the balance as double what it should beContent Hi, I have created a accrual balance report in OTBI using the Accrual Real Time subject …
-
Need help on OTBISummary Sum of Balances in OTBI reportContent Hi Team, We are creating one report. Our requirement is to print the balance value in such a way that balance value of A an…
-
Date fields using excel templatesContent Is there a way to print date fields on excel based BI publisher reports where excel can recognize it as an actual date field? Is this the only solution https://d…User_2025-02-10-08-27-16-805 27 views 1 comment 0 points Most recent by Sricharan Monigari 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
-
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…Sharon Harper 38 views 4 comments 0 points Most recent by Sharon Harper 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 -
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…Sharon Harper 41 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
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… -
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
-
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…Raymund Jerome 38 views 2 comments 0 points Most recent by Raymund Jerome 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 -
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…Kiran Kancherla 104 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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… -
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 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…Andrew_Schmitz 31 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
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 …Pedro Teixeira 46 views 2 comments 1 point Most recent by Pedro Teixeira Reporting and Analytics for HCM -
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…Preethi nair 16 views 3 comments 0 points Most recent by Andrew_Schmitz 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…
-
"Edit Column Formula" Easy Reference and Simple Examples for BeginnerContent Hi there, Would you please guide me towards a good resourse for a beginner who wants to Edit Column Formulas? I need a few rather basic things but need to undert…Bobby Jourdan 37 views 4 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
OTBI - Defaulting Date ValuesSummary OTBI - Default Date ValuesContent Requirement Let say, your financial year start date is 01-Jul. If the month is between 01-Jul(previous year Eg., 2020) to 30-Ju…User_2025-03-07-20-55-01-859 117 views 1 comment 7 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM