OTBI
Discussion List
-
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 23 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 74 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 … -
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 66 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 337 views 5 comments 6 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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
-
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 32 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 23 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 543 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
-
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)…
-
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 -
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 346 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
Which Subject Area to use for Assignment EITSummary: Which Subject Area to use for Assignment EIT Content (required): I cannot see any subject area field showing "Assignment EIT Information EFF: Assignment Extra I…Hrms Project 49 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Hyperlinking BI Publisher reports in a DashboardContent Hello, We have a requirement to create a dashboard which will list all the reports available for certain user popluation. As per screenshot you can see that we m… -
Employee Commute DistanceSummary: We need a way to calculate and report on Employee Commute distance to support our Environmental, Social and Governance reporting. In our legacy data warehouse w…Chelsea Holden 31 views 3 comments 2 points Most recent by Chelsea Holden 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 136 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to format the date field from time dimensionSummary: How to format the date field from time dimension Content (required): I have column Calendar Month from Time dimension it is showing the output as 2022101.0 for …Raghavendra M 21 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Can't see 'Administration' Tab in Catalog?Summary: Content (required): Can't see 'Administration' Tab in Catalog after the last update? any feedback? note: the user has all related (HR Analyst, Admin Roles, and …Walid Hamdy 54 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Positions Filled in less than # daysSummary: Need to track positions filled that took less than/more than 60 days to fill. Content (required): I need to find a way to not only track the # of positions fill…Scott Conaway 11 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
NI thresholds - How to report in OTBISummary: Please can someone confirm if it is possible to report on NI thresholds using OTBI. Alternatively, which table in BIP can we derive the NI thresholds from Conte…
-
Error When open Dashboard by a certain user!Summary: Content (required): I received this error when opening a custom dashboard, noting that the user has access to the report and its Subject Areas The report can be…Walid Hamdy 21 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Analysis Female Successors for Critical RolesSummary: I am trying to work out #critical roles: used distinct (Plan Business Unit)- Correctly getting the count #atleast 1 female successor on these critical roles # c…
-
Identifying/Removing Duplicate rowsSummary: I am creating a report that is trying to highlight any blanks or erroneous data in our active workforce. It requires combining the following subject areas: Work…
-
How to display different email address types in separate columnsSummary: We have a requirement to display separate columns for work email address and home email address, one row of data per employee. Content (required): From reading …User_2025-01-29-23-50-34-285 55 views 9 comments 1 point Most recent by Tim Hopkins Reporting and Analytics for HCM -
Ask for table name - who answered the questionnaire, the questions and answersSummary: Ask for table name - who answered the questionnaire, the questions and answers Content (required): Table name for Questionnaire related have found the following…