OTBI
Discussion List
-
Users with FBI_CAREER_DEV_TRANSACTION_ANALYSIS_DUTY are unable to see their own development goals.Summary: Users with FBI_CAREER_DEV_TRANSACTION_ANALYSIS_DUTY inherited by either ORA_PER_LINE_MANAGER_ABSTRACT role or ORA_PER_HUMAN_RESOURCE_ANALYST_JOB role are unable…Maciej Kozakiewicz 11 views 2 comments 0 points Most recent by Maciej Kozakiewicz Reporting and Analytics for HCM -
Additional comments and Reason for joining can't fetch the OTBI reportSummary: Question test to response answer in Pivot Table format Content (required): Formula for Question test CASE WHEN "Checklist Questionnaire"."Question Text" = 'What…AjayKumar Maddipati 31 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Where to find in OTBI Calculation Card Start and End Date?Summary: Where can I find in OTBI Calculation Card Start and End Date? Content (required): Please see image below. I am using the "Payroll - Calculation Cards Real Time"…tiffnyc 41 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
How can i create course due learning reminder notification.Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
I need to create a group or a bin based on 2 different columns. Is that possible?Summary: Group or bin based on 2 fields Content (required): I am working on turnover report and need to create groups or bins from a hierarchy tree value and a company b…Donna Valentine 43 views 3 comments 0 points Most recent by Donna Valentine Reporting and Analytics for HCM -
I have 2 parameters for analysis both are list of values on the same table - how I can write the sqlSummary: I have 2 parameters for analysis both are list of values on the same table - how I can write the SQL the will limit the lov of the second parameter Content (req…
-
what are the standard VAT reports available for UK?Summary what are the standard VAT reports available for UK?Content Hi Experts, Can you please provide me the list of standard vat reports available for UK? Thanks, Pradv…
-
How Shows/Downloads OTBI Analysis results in Excel fileSummary: Content (required): Hello Guys, We would create an analysis which extract all the candidate members inside all pools. We have a lot of candidates and for this r…Giuseppe Iacono 11 views 2 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Workforce Trend Real time subject are not giving the dataSummary: I am using workforce trend real time subject are and it is not giving the correct data when we migrate it to another instance. Content (required): We have migra…Raghavendra M 21 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
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 32 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