OTBI
Discussion List
-
How to get the two rows of data in single row in OTBISummary How to get the two rows of data in single row in OTBIContent Hello Team, I am using organization hierarchy in one report, we have two tree codes here, i want to …Harish Kumar Kovi 369 views 3 comments 0 points Most recent by Vinay Soni Reporting and Analytics for HCM -
Reports - Page options available to the user environment?Hello, I have been asked to find a way to make available the page options of the analytics to the Reports tab. To be more specific, we need the gear icon from the analyt…Ioannis Adamou 52 views 6 comments 1 point Most recent by Ioannis Adamou Reporting and Analytics for HCM
-
OTBI Termination Dates for multiple periods of serviceSummary: Termination report in OTBI is giving the same termination date for two different periods of service. Content (required): My termination report is bringing back …Max W 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get list of roles from systemSummary: Content (required): Hi Expert, We have a requirement to get all the roles we have in the system. So we just wanted to know how to get all the roles. Please sugg…Faizan Rashid 42 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Average Time of Two PhasesSummary: I'm looking for a way to report on the average time an application is in the Screen and Interview phases (combined and separately), but am having zero luck. Any…Jessica D 61 views 4 comments 0 points Most recent by Poorani Gibson Reporting and Analytics for HCM
-
Newer of two datesSummary: I'm looking for logic that will allow me to pull in two different types of hire dates (new hire date, re-hire date) and return the most recent date. Would I do …Scott Conaway 32 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
Absence calendar in line manager dashboard shows more workers for next monthSummary: the absence calendar in line manager dashboard shows absence for current and next month. I found the next next month does not only present direct reports, but a…Wouter.Schaap 42 views 3 comments 0 points Most recent by Wouter.Schaap Reporting and Analytics for HCM
-
Termination submission/creation dateSummary: I am looking for the date a manager enters a termination. Content (required): After receiving a resignation the manager enters a termination in Oracle. This is …Scott Conaway 182 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
Headcount for last day of previous monthSummary: Headcount for the last day of the previous month. Content (required): I would like to create a report that lists the Headcount for the last day of the previous …
-
OTBI report agent is not sending emails to multiple employeesSummary: Created an OTBI report to pull Work Email of the employees and send a pre-set communication. It works when tested for one/two employees, but it does not send th…
-
Active Employees signed up for Job AlertsSummary: How can we report on internal employees enrolled in Job Alerts? Content (required): We're trying to get a gauge on how many active, internal employees have enro… -
How to add multiple filters in HCM Extract Filter CriteriaSummary: We want to add another filter under HCM Extract Data Group Filter Criteria to filter out terminated employees who has been rehired later from our result set. Co…GauravGupta39 593 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
how to add a manager email as cc in a bursting report sqlSummary: I have a report which i'm trying to schedule, but i'm stuck at the cc part. i need to add the manager in the cc field. below is my sql, how do get the manager v…
-
Payroll Run Error ReportsSummary: Payroll Run Error Reports Content (required): Hi All, Greetings! What is the best option available to get the payroll run error list - apart from the flow 'Run …Parag Hiremath 11 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
Subject Area Access for Compensation - Salary Details Real TimeSummary: I have given an employee the two roles below ORA_CMP_COMPENSATION_ANALYST_JOB ORA_CMP_COMPENSATION_MANAGER_JOB This gives the employee access to Compensation - …Mark Stoker 71 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Wage Basis Rules Configuration ReportSummary: I have been tasked with creating a report for the Wage Basis Rules so that we can confirm the setup when an element is added to the system Is there a subject ar…User_2025-02-04-08-51-08-912 54 views 3 comments 1 point Most recent by Eric Geddes Reporting and Analytics for HCM -
ODBC Error - ADFService11g on OTBI AnalysisSummary: After 22B went into our Test environment, a report built on a few subject areas no longer works. It is giving us the following error: State: HY000. Code: 77031.…
-
OTBI Agent - Italic in narrative textSummary: Content (required): Hi, I'm creating an agent to send automatic emails: is it possible to insert some italic text? In case, could you please tell me how? Thank …Alberto Americi 11 views 4 comments 0 points Most recent by Alberto Americi Reporting and Analytics for HCM
-
Language translation for OTBI ReportSummary Can we change the language of custom OTBI report Report Header, Report Title and Report Name?pooja yelsangikar-Oracle 53 views 3 comments 0 points Most recent by User_IBL58 Reporting and Analytics for HCM -
Benefits Enrollment Real Time Subject Area not pulling for future dated enrollmentsSummary: Hi All! We just completed Open Enrollment and tried running a report based on the above Subject area and we are only able to pull current year. Is this how the …Tristan Aquino 43 views 8 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Report to pull goals not createdSummary: Can any one please send me the query or analysis to pull the employees who not created goals. Content (required): Version (include the version you are using, if…Reddykrishna Chidella-Oracle 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Hourly Rate FormulaSummary: I have a report using the subject area Compensation – Salary Details Real Time and need to add a formula that calculates a base hourly rate. Here is what I'm lo…JHaden3 116 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to find and report on duplicate socialsSummary: I have a requirement for an analyses report that identifies duplicate social records. When duplicates are found, the report detail will include Person Number, P…
-
How to link Action and Action Reason to a BPM Worklist taskSummary: Hi. We can create a BIP where we have the BPM Worklist tasks but we would like to have Action and Action Reason included in that report so we can see what Actio…Jesper Majgaard Jakobsen 11 views 0 comments 0 points Started by Jesper Majgaard Jakobsen Reporting and Analytics for HCM
-
Date Match Formula ErrorSummary: Date match formula errors when I run the report. CASE WHEN "Work Relationship Details"."PER_PPS_LEG_DDF_ST_BS_SR_STRT_T_" = "Workforce Management - Worker Assig…
-
Benefits | Added or Removed Dependents ReportSummary: Hi All! Does anyone have an example report that shows added or removed dependents? Content (required): We would like to audit our benefits to see if employees h…Tristan Aquino 11 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Report to show Employees Not Paid in the Last 6 MonthsSummary: I am trying to work out Casual employees that have not been paid in the last 6 months. I can get employees that were paid over 6 months ago, but this also shows…
-
OTBI Report Performance IssueSummary: OTBI Report Performance Issue Content (required): Hi Team, We have developed the turnover dashboard using "Workforce Management - Workforce Trend Real Time" sub…Vasanthakumar Ravi 74 views 1 comment 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
OTBI Agent Email From, Reply-to, CCSummary OTBI Agent Email From, Reply-to, CCContent Hi all: Using an Agent, is it possible to alter the "From" email address and add "CC" and "BCC" email addresses? The c…User_2025-02-04-23-32-05-891 139 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM