OTBI
Discussion List
-
Difference between data table join.Summary: Difference between data table join. Content (required): Hello All, I have some confusion on table joins. Please refer below example. I have two data tables. PER… -
Folder Level Security (Idea/Feasibility)At our organization, the staff is used to our discoverer reports where one report will pull from multiple tables/views, after asking around and looking at OTBI security …Praveen Kadiyala 42 views 5 comments 0 points Most recent by Praveen Kadiyala Reporting and Analytics for HCM
-
OTBI Report ColumnsSummary: I am using three Subject Areas: Workforce Performance - Performance Document Status Real Time Workforce Performance - Performance Rating Real Time Workforce man…Anshul Varshney 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Bank Statement Analysis Report > Bank Statement TransactionsWe are trying to validate the transactions being reflected on this report. Here's the full path of the seeded report: Shared Folders > Financials > Cash Management >Bank…
-
Turnover Analysis - Line Manager DashboardsSummary Count fields - Termination Headcount, Voluntary Termination Headcount under Subject Area "Workforce Trends" are not reflecting correctContent Hello, We are looki…User_2025-02-05-07-43-29-505 142 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Error in OTBI reportSummary: Content (required): Workforce Management- Worker Assignment Real Time Workforce Goals - Goal Plan Assignments Real Time Workforce Goals - Goal Status Overview R…Deepak Bhatt 31 views 2 comments 0 points Most recent by Deepak Bhatt Reporting and Analytics for HCM -
Fiscal Year HR ReportingSummary Needing to have reports such as a Turnover Report that is based on Fiscal Year vs Calendar YearContent Does anyone have any experience or examples on how i could…Rob Stahly 91 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
FTE and Salary - Compensation Salary Details Real Time Subject areaSummary: The FTE and Annualized Full Time Salary appear to be sourcing the FTE from the Assignment instead of the Salary row Content (required): I'm digging into an erro…Rob F 41 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
No Data in OTBI when Department Name is addedSummary: Content (required): We are using Subject Area "Workforce Goals - Goal Plan Assignments Real Time". When we add Worker.PersonNumber then we are getting all the 1…Vinay Gharge 18 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Cost Center ReportingSummary How to report on Cost Centre in Cost Accounts section of Manage Costing of DepartmentContent All, I am new to Fusion OBTI reporting and am hoping you can help me…Prudence K 179 views 6 comments 0 points Most recent by User_2025-02-12-21-43-20-416 Reporting and Analytics for HCM -
Logical SQL is not recommended?Summary If Logical SQL isn't the answer what is the recommended approach?Content Hello Everyone, I've been told through a recent Technical SR that Logical SQL is not a r…Rob F 68 views 12 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Where can I find tax registration Number for Reporting UnitSummary: Please can anyone tell me where the tax registration number is in OTBI, I am wanting to add it to a report but cannot find it. Content (required): I am looking …Sharon Harper 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unable to pull specific employees for a performance reportSummary: Team - My counts vary as I try to pull additional fields from a specific report that pulls from the following areas: Compensation - Workforce Compensation Real …Vijay Rajendran 11 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How create a Recruiting Report with ReasonSummary: Content (required): Hello Guys, We would create a Report that extract the reason linked to the last event for each worker, how we can create it, in our database…Giuseppe Iacono 11 views 3 comments 0 points Most recent by Madhavi-Oracle Reporting and Analytics for HCM -
HCM &Power BISummary Possible that Oracle HCM cant feed automatically to a Dashboard using PowerBIContent Hello, I am just wondering is there any posibility that Power BI can be refr…User_2025-01-29-22-24-40-400 77 views 10 comments 1 point Most recent by Mansur Khalil Reporting and Analytics for HCM
-
"Close Date" in Payroll RelationshipsSummary: Morning, We are trying to report on the "Close Date" in Payroll Relationships but I am struggling to find it in OTBI. Would it be possible to have it in the OTB…Tim Hopkins 11 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Login In, Login Out and Login Duration of a user in an OTBI analysis.Summary Login In, Login Out and Login Duration of a user in an OTBI analysis.Content Hi, We need to find a subject area that gives the login time of the user into fusion…User_MC37Q 302 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
To pull direct and indirect managers list from Compensation Worksheet pageSummary: Hello Team, We have a requirement to pull all the indirect and direct managers in a single column along with their direct line manager from Compensation Workshe…Geej 91 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Total sum of three custom calculated columns is not calculating data correctlySummary I am working on learning report where I need to sum three custom calculated columns to get the total completion of 3 set of courses. I am performing sum of all t…Kamini Kaushik-Oracle 24 views 0 comments 0 points Started by Kamini Kaushik-Oracle Reporting and Analytics for HCM
-
BI Publisher - Can you FULL outer join?Summary: Full outer join in a BI Publisher is not behaving how I expect a full outer join should. Content (required): I need to do a full outer join on two sets of data …
-
OTBI report Timing outSummary: Content (required): I am pulling some payroll data using an OTBI but it keeps timing out- How do I increase the time? I can't schedule since I created a DM usin…Riti Malhotra 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
"Benefits - Enrollment Real Time" Subject Area Not Populating Plan Name without Payroll Element NameHello all, I have a requirement in which I need to display benefits plan and corresponding payroll element name in OTBI Report. I am using "Benefits - Enrollment Real Ti…Khush Tiwari 62 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Dashboard PromptSummary: Content (required): Version (include the version you are using, if applicable): Oracle HCM 21D Code Snippet (add any code snippets that support your topic, if a…
-
Getting the Period Start Active Headcount to equal the previous months Period End Active HeadcountSummary: Getting the Period Start Active Headcount to equal the previous months Period End Active Headcount Content (required): We need to get the Period Start Active He…Rebekah Gilday 65 views 6 comments 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM -
Seeded HR Reports not returning any resultsSummary: Hi , We actually have to run all the seeded HR reports and present the output to the client . Now I got the list of the seeded reports but when I am trying to r…Gaurav Rath- PGC 41 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Subject area for user defined columns under worksheet display (Compensation)Summary: Hi everyone - We have some criteria defined under one of our compensation plans in a user-defined column for the worksheet. The user defined column contains the…Vijay Rajendran 13 views 2 comments 0 points Most recent by Vijay Rajendran Reporting and Analytics for HCM
-
"Benefits - Enrollment Real Time" Subject Area Not Populating Plan Name without Payroll Element NameHello all, I have a requirement in which I need to display benefits plan and corresponding payroll element name in OTBI Report. I am using "Benefits - Enrollment Real Ti…Khush Tiwari 31 views 16 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
OTBI Report Usage - Count of Dashboards run (not executions)Summary: I've found the Usage and Performance Dashboard Sample (catalog files attached) and it looks pretty great but we're struggling to make it work for us. We want to…
-
Recruiting Dashboard PDF downloadSummary: Content (required): Hello, The functionality used to download a Recruiting Dashboard page doesn't work anymore. We usually used this html code:Giuseppe Iacono 23 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
How to display indirect terminations for a specific manager?Summary: We have a requirement to build OTBI (Graphs) to display number of terminations under a specific manager. There are 2 OTBI analysis I use in the dashboard - 1 wh…Vijay Rajendran 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM