OTBI
Discussion List
-
Pivot table not showing as intendedI am trying to create a Pivot table using a User Defined field in Compensation-Workforce as the main Row, except that it keeps totaling the user defined data instead of … -
How is Absence Days metric is calculated?Summary: Hi, We would like to understand how Absence Days measure is calculated. It gives different results (one correct and the other is not) I don't know what the issu…HulyaAkan76 12 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Can Area of Responsibility be on OTBI report?Summary: Area of Responsibility be OTBI report Content (required): We have 2 representatives in the Area of Responsibility that I need to put on an OTBI report. Is this …Donna Valentine 21 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Logical SQL With Dashboard PromptSummary: Hi - I am trying to build a logical SQL report that displays paycheck information along with current salary as an outer join from Compensation subject area. The…Kyle Norris 11 views 15 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Checklist Real Time not returning Pending Worker ChecklistsContent We are using Checklists for our Onboarding process, and these checklists and associated tasks are being assigned to Pending Workers automatically prior to their …Jason McWatts-172517 76 views 31 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Gross to Net YTD valuesSummary Require a report that shows the Gross to Net YTD valuesContent I found the base report in /Shared Folders/Human Capital Management/Payroll/Payroll Calculation Th…
-
Employee number along with Candidate numberSummary: Hi, My requirement is to extract Employee details like employee number, name etc. from Core HCM along with Candidate Number, Requisition Number etc. from ORC in… -
Is there a way to see where the OTBI Agent burst to?Summary: Wondering if there is a way to see where an OTBI agent sent reports to. Content (required): We have a report that bursts based on manager username. The details …
-
Creating analysis using user defined fields in Workforce CompWe are trying to create some reports using the Compensation-Workforce Compensation Real Time subject area and was under the impression this subject area would pull data …Jamie_B 1 view 3 comments 0 points Most recent by Gail Langendorf-Oracle 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.…
-
How to calculate Turnover percentage between count attributes in OTBI ?Summary: How to calculate Turnover percentage between two count attributes in OTBI ? Content (required): We are working on an OTBI report where we have to create a summa…
-
Inaccessible Column Error When Running OTBI Report DashboardSummary: Inaccessible Colum error while running OTBI reports Content (required): Reports run fine for few users role but for few user/groups tried to run shows Inaccessi…VarunG 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Oracle Learning - is it possible to report all assignments/roles for an individual in one report?Summary: We have a business need to report on student learning (in the same way we report on staff learning - completions and overdue by department). However, some of ou…Michelle Taylor DU 23 views 17 comments 0 points Most recent by Michelle Taylor DU Reporting and Analytics for HCM
-
OTBI does not show accrual/absence balance dataSummary: I'm trying to create a report which shows an employee's accrual. However it does not show any data in OTBI. Content (required): I want to create a report in OTB…Nicolas Vahman 19 views 6 comments 0 points Most recent by Vibha Pandey Reporting and Analytics for HCM
-
How to get plan start and end dates for a persons absenceSummary: I want to build a report to show the start and end dates of a person enrolment in a plan as we need to write to each person when a plan will expire. Content (re…Sharon Harper 11 views 6 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
HC trend working hoursSummary: Content (required): I am using workforce trend real time to pull period start and end HC by calendar month (2019/2020); however, when I want to drill down to wo…Riti Malhotra 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Audit Trail for OTBI ActivitySummary We would like to see an audit trail of who has made changes to a specific folder of OTBI reports and also who has generated specific reports.Content We have a nu…
-
Original Referral SourceSummary: How can we show the original referral source from the candidate's general profile? Content (required): If an employee refers a candidate for the first time the …Greg Rank 11 views 3 comments 0 points Most recent by Allison O'Brien Reporting and Analytics for HCM
-
How to use the average functionality per legal employer?Summary: Trying to use th avg functionality in OTBI but not getting the right results in Content (required): I want to show some simple statistics based on legal employe… -
How to pull Number of employees who dont have a development goal?Summary: The requirement is to build a OTBI dashboard that should display two donut charts (should be added a link) for #of Employees who has atleast 2 development goals…Iswarya Lakshmi Priya-Oracle 11 views 4 comments 0 points Most recent by Iswarya Lakshmi Priya-Oracle Reporting and Analytics for HCM
-
What tables store the representatives that are assigned to each employee?Summary: I have been tasked with creating either an OTBI analysis or BI Publisher report to pull all employees and the representatives that have been assigned/linked to …BeachDreamer 21 views 6 comments 0 points Most recent by Rosetta Jasperson Reporting and Analytics for HCM -
Cross SA Employee Census results in errorSummary: In building out an analysis that gives me one row per active employee, I've run into this error: Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8…Kate V 11 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Learning Management replaced by the Learning Record subject areaSummary: Can't find mappings for the new Subject Area Content (required): Goodmorning, in reference to "APRIL MAINTENANCE PACK FOR 21A" document which states: "Be aware …A.Ferraro 21 views 2 comments 1 point Most recent by Nitika Arora-Oracle Reporting and Analytics for HCM -
Absence Accrual BalancesContent Hi - I have a report that shows the absence accruals for each of our plans and it works great for those that are calendar year Plan Period Type. It shows me the …Prudence K 227 views 26 comments 4 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
User Last Login Details Using OTBI ReportSummary: OTBI reports to pull out last login user Details Content (required): Hi, We have requirement to pull out last login user details using OTBI report. Is it possib…Vasanthakumar Ravi 11 views 5 comments 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
OTBI- Need 'feedback provided for the manager effectiveness success factor, by managers" detailsSummary: Hi team, I need to build an analysis with the details "feedback provided for the manager effectiveness success factor, by managers". Content (required): I need …Satyabrata Nanda 2 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI Security by Line ManagerSummary OTBI Security by Line ManagerContent MY OTBI security by Manager doesn`t work. I have the Line manager person profile secured by Manager hierarchy, but the Line …User_HF4N3 175 views 17 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Unable to join "Workforce Management - Absence Real Time" and Accrual real time subject area.Hi Team, I have a requirement where I need to fetch the absence details and accrual balance if the employee takes the absence under the plan which he is enrolled in. For…Khush Tiwari 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Headcount by week or date returning blanksSummary: Is there a way to report a headcount trend by week or by date using Workforce Trend subject area? Content: I'm trying to build a report that shows headcount by …Callum Jones 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Deep Link for Employee detailsSummary: Content (required): We have a use-case to send workflow notification BIP Report to the HR Team/Head in case of Termination or Re-hire. Oracle provides the stand…Vinay Gharge 12 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM