OTBI
Discussion List
-
Payroll-Calculation Cards Real Time OTBI SA issueSummary Payroll-Calculation Cards Real Time OTBI SA issueContent HI, We have a issue with "Payroll-Calculation Cards Real Time" SA. I am picking the Calculation Card :'S… -
SQL Expression on column filter in OTBI reportContent Created a headcount report and looking for a SQL Expression for a column filter so I can generate the report based on current or system date employee start dates…User_2025-02-11-16-17-40-645 2.5K views 4 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
How to Add Sorting to Bar Graph ResultsContent When I create a bar graph using "Facts - Requisition Counts"."Number of Job Requisitions Currently Open" by "Job Requisition - Hiring Team"."Recruiter Full Name"… -
HCM Quarterly Changes Impact on Reporting and AnalyticsSummary HCM Quarterly Changes Impact on Reporting and AnalyticsContent Hi all, Is there any other references for Quarterly changes on HCM that affects reporting? I have …Raymund Jerome 22 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Manager name from Assignment Manager (Unsecured) does not work with event countsContent When I add Manager name from Assignment Manager (Unsecured), the hire/ termination count reduces significantly. How does the Assignment Manager (Unsecured) work?…User_2025-02-10-08-27-16-805 46 views 9 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Drill down and action link opening an email to the user - OLCContent Hi there, I have a table with users' names or email addresses. Can I add an action link with a drill down that will open an email to the user? Thanks BobbyBobby Jourdan 24 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to sort Age BinsSummary Sorting Age Bins in a ChartContent Hello, I am trying to get my Age Bands to sort in numeric order but the Bin Labels with text keep defaulting to the end of the…Rebekah Gilday 49 views 5 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Current status is "Interim"Summary Trying to report on all employees who are an interim assignmentContent I'm trying to report on all employees who are currently on an "Interim". Using the HR Acti…
-
Tracking new line managersSummary Identify line managers who have managed employees less than a yearContent Is there a way to identify line managers who have managed employees less than a year? W… -
Query to exctract Person Email addressesContent Hello experts, do you know the query to simultaneously exctract the following information? EmailAddressId|PersonNumber|EmailType|EmailAddress|DateFrom|DateTo|Pri…Valerio Curzi 25 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
New Absence within 3 days of old AbsenceSummary We require a report that would show any colleague who had an absence closed, and a new absence opened within 3 days.Content Hi, I am currently working on an abse…Mitch_123456 22 views 1 comment 0 points Most recent by Venkata Sumanam Reporting and Analytics for HCM
-
How to mask data values?Summary In OTBI, how to display an * instead of a number or percentage where the results might identify peopleContent In OTBI I would like to mask identifiable data such…Mnrussel-Oracle 73 views 3 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report Job History Page in OTBI IssueSummary Report Job History Page in OTBI Issue is BlankContent Is anyone else experiencing an issue accessing the Report Job History Page? I assume a browser issue, but h… -
OTBI Dashboard Layout for SectionsContent I have created a dashboard with two sections, one of the sections I need the two analysis to render side by side (horizontal) rather than vertical. However when …N. Adams-Oracle 114 views 3 comments 0 points Most recent by SimonTomey Reporting and Analytics for HCM
-
Need SQL query to fetch Balance Initialization/Balance AdjustmentContent Hi All, We are looking SQL query to fetch the Balance Initialization/Balance adjustment data. Please share SQL query if anyone is having in handy. Thanks, Visu
-
OTBI > Ability to Capture Name of Employee Performing Adjust Balance on Employee BalanceContent Hello All, I will appreciate your support on the following issue: Our customer wants to capture the name of the employee who performs Adjust Balance on Employee …Bernard T 16 views 6 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report on employee careers of interestContent Hi, Has anyone built a report that indicates people and their careers of interest under career development in Oracle HCM Cloud? I am specifically looking to buil…Dishti Malhotra-Oracle 28 views 2 comments 0 points Most recent by Krista Kay Reporting and Analytics for HCM
-
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 43 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 83 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 51 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 35 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 39 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 29 views 3 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM