OTBI
Discussion List
-
RCOUNT("Worker"."Person ID" by "Learning Items"."Learning Item Number")Summary: I am trying to fetch the latest status of a particular learning item number per employee. I have used RCOUNT and Max to fetch the data. When I filter with perso…Anita 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How can I locate which subject area the IR35 (Off-Payroll Worker Flag) is in?Summary: Trying to produce an otbi report including the IR35 flag which I think is in the Legislative Info Section of Person Management in the Person area. Can someone p…Mark Stoker 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Extract Otbi Analysis with more then 25000 LinesSummary: Content (required): Hello Guys, We would create an analysis that it extract all the candidate members inside a candidate pool. The candidate pool is very large,…Giuseppe Iacono 21 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Passing Prompts through an AgentSummary: Does an OTBI Agent use the hardcoded prompts? Content (required): Hi, I have an OTBI headcount report that has a hardcoded effective date prompt for the last da…Joe Dorrian 91 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Dynamic effective date on AnalysisSummary: I am trying to get active employees as of a future date in Analysis "Workforce Management - Worker Assignment Real Time" Content (required): I am able to use a …
-
View pending approval assignees for pending registration requestsSummary: We are using the supplier registration workflow approval functionality. We need to create a report that identifies who the approval is pending with when the reg…
-
OTBI>Shared Folders>Human Capital Management>Dashboards>Line Manager DashboardSummary: our managers are running the headcount report from the above location and the numbers in the top boxes esp Headcount does not equal the employee numbers in Orac…Lorrie Weiss 71 views 11 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Consolidated List of OTBI and BI Publisher Reports Posted (10 August 2015)Content The following is the list of published OTBI and BI Publisher reports for Fusion HCM between 15 June and 10 August 2015: * Address Changes After Date * Marital St…Julian Challenger-Oracle 344 views 5 comments 6 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Sales Analytics DashboardHi, Kindly help me out where does the configuration need to be done to setup the hierarchy to be displayed in Sales Analysis Dashboard report For eg I need John in Globa…Mohammed Rafi 31 views 2 comments 1 point Most recent by Mohammed Rafi Reporting & Analytics for Fusion Service -
Termination Headcount measure question.Summary: In Subject Area: Workforce Management - Workforce Trend Real Time - the Termination Headcount measure is set to 1 on the Inactive assignment line that starts th…Robert Craske 51 views 7 comments 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM
-
OTBI Subject Area to fetch Employee Rates in Manage Rate SchedulesSummary: Hi all, Could someone help me get a OTBI Subject Area to fetch Employee Rates defined in Manage Rate Schedules ? Content (required): Version (include the versio…Anandhan Erulappn 71 views 2 comments 0 points Most recent by Andy May-Coates-Oracle Project Management
-
Different Data between Subject AreasSummary: Content (required): Hello Guys, We would create an analysis that it shows for each candidate the reason why they are rejected. We use the Recruiting Event Real …Giuseppe Iacono 31 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Export more than 30 rows from dashboardpage to ExcelSummary: Content (required): I have a few dashboard which includes an OTBI analysis. The end user wants to export all the data output from the analysis to Excel to have …Nicolas Vahman 31 views 3 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
OTBI Training, Documentation, FAQs and moreContent Just a reminder that there is a knowledge article on My Oracle Support that provides a wealth of information on HCM Cloud OTBI (and also some on BI Publisher). Y…Julian Challenger-Oracle 538 views 6 comments 0 points Most recent by User_2025-03-07-20-15-16-297 Reporting and Analytics for HCM
-
Assignment Event Headcount at Start of MonthSummary: Getting the Headcount at the Start of the Month Content (required): How can we configure the Formula for the Assignment Event Headcount at the Calendar Month St…Rebekah Gilday 31 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report Interaction: Web Page Action link problemSummary: Content (required): Hello Guys, We would create a dynamic action link that give us the possibility to reach the specific page of the requisition number inside t…Giuseppe Iacono 11 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
"Total Amount" column in OTBI from Paysheet - ICMSummary: Anyone who knows the exact column name of "Total Amount" in OTBI? This is a field from Paysheets in Incentive Compensation. Tried other existing columns in the …User0901 21 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Organization Chart with Persons ImagesSummary Organization Chart with Persons Images with Google Chart ServicesUser_Z8Y6M 126 views 8 comments 2 points Most recent by Vasiliki Tripolitsioti-Oracle Reporting and Analytics for HCM
-
P45 filing dateSummary: P45 filing date in OTBI (or SQL code if not in OTBI) Content (required): Does anyone know where in OTBI I can find the P45 filed date (see bottom of screenshot)…
-
How to include attendees on the business meals seeded Expense Report template ?Summary: How to include attendees on the business meals seeded Expense Report template ? Content (required): Hello Although the user captured the attendees on the busine…
-
Limit invoices to own departmentSummary: Is it possible to create a report which shows only invoices which are related to your own department - and not seeing every invoice of all other departments as …
-
OTBI Subject Area Contents Listing (metadata)How do we provide our users with a user-friendly listing of the contents in each Subject Area? Or, at least, how or where do we get the data necessary to build one? This…Eric Geddes 31 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to Add note to Conference expense screen through a SanboxSummary: How to Add note to Conference expense screen through a Sanbox Content (required): Hello I need to add a note to the screen when conference/seminars is selected.…
-
Termination Reasons & Salary in Workforce Trend to measure TurnoverSummary: When adding Termination Reasons (Action Reason), the terminations sum up correctly, but the Headcounts are inaccurate. Salary data doesn't populate. Content (re…
-
Looking for a YTD payroll reportSummary: I need to create a report showing YTD payroll. Content (required): Report needs to contain employee demographic detail along with current pay rate, YTD earnings…Scott Conaway 361 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM