OTBI
Discussion List
-
Report to say if employee has any direct reportsContent Hi, have a simple report that says something like PERSON NUMBER | Name | Department. I need to add an additional column that returns yes/no for if that employee …Mike Borghoff 128 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Is it possible to add a time zone prefix to an OTBI report?Summary: If I want my OTBI report's data to only display one specific time zone no matter the user's preferences, how would I do that for just one report? Could the pref…CCannadayCTR 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Unable to report on Guided Journey QuestionnaireSummary: We've created a guided journey questionnaire as part of the requisition process for hiring managers, however we are unable to report on the data. We've had an S…DanSut 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Difference between Oracle Delivered OTBI Report-Budgets Wrksheet & Budgets Wrksheet Worksheet MgnrWhat is the difference between these two out of the box OTBI reports? Budgets Worksheet and Budgets Worksheet for Worksheet Manager Path: /Human Capital Management/Compe…MeghnaDe 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Overtime status is not showing data in workrelation subject areaSummary: Hi Team, We had defined overtime status at job level. like below. but the information is not showing workrelationship subject area. Request you to help on to fi… -
Looking for a Applicant Report < Oracle delivered report>Summary Looking for a Oracle out of box report output - To display all candidate responses to the application questions/fields including the signature with date and time…Prabhu Krishnamoorthy 19 views 3 comments 0 points Most recent by Karen Costakes Reporting and Analytics for HCM -
Current approval status table name for development goalsUnable to get approval status for development goal: Need a table name and SQL query for development goa approval status to check whether the goal is approved? rejected o…
-
Trying to find a Link between Career Site and RequisitionSummary: We are trying to derive the career sites where a specific job requisition is published. Can you point us to a REST API which can provide this information ( alre…
-
Select performance goal seeded report customization in not working in Production.Summary: Select performance goal seeded report customization in not working in Production . where as working in TEST pod. Below are the steps followed to customize the r…
-
Subject Area to determine the Legal Entity details in Workforce Succession Management Subject AreaSummary Subject Area to determine the Legal Entity details in Workforce Succession Management Subject AreaContent Hi , While building some reports for the talent Module,…Manisha Chakraborty 105 views 3 comments 1 point Most recent by Atif Nisar Reporting and Analytics for HCM
-
Help with setting up Map View in OTBI - Map showing marker on incorrect StatesSummary: I'm looking to create a headcount by State/City/County report and use the map feature to display the results. State appears to be working correctly and the head…
-
How to retrieve Work Day Definition (Weekly Working Hours section) using OTBIContent Hello We need to extract the information: Work Day Definition (Weekly Working Hours section) using OTBI. USA are using this information to track Shift informatio…Lucile Fleischman 81 views 3 comments 1 point Most recent by Thomas Samuel19 Reporting and Analytics for HCM -
Difference between two dates with decimal outputSummary: In an OTBI report, the requirement is to calculate years of service for terminated employees (difference between hire and term dates). The output needs to be 2 …JHaden3 21 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Issue and Resolutions from the Transaction ConsoleSummary: Hello, I was able to find the issue description and resolution information from the table "HRC_CONSOLE_FAULT_DETAILS_VL". However, I'm unable to connect the act…
-
How do I extract a portion of a text field before a special character in OTBI?Summary: One of our Display Name fields shows Preferred Name Last Name (pronouns). What is the expression to extract the portion of the text before the "("? Content (ple…
-
Restrict the compensation information in reports and analytics.Hi Team, We have a requirement that some set of employees can able to access/view the compensation data in BI and OTBI Analysis reports. E.g: If a user queries the compe… -
Subject area for report to fetch content section of person profile typeSummary: Content (please ensure you mask any confidential information): Hello, We want to fetch all the details inside 'Content Sections' under Profile > Profile type > …
-
Prompts are not showing while scheduling the OTBI AnalysisThere are 4 prompts in the Analysis. But when we try to schedule the report, these parameters/prompts dont show up in the General tab. Please suggest.Dona Das-Oracle 41 views 3 comments 0 points Most recent by Jagadeeswara Reddy Reporting and Analytics for HCM
-
how to get the retention rate calculationSummary: HI team! Do you know how to calculate the retention rate in an Analysis Report? This is the formula: (Number of employees at the end of the period / Number of e…Claudia Linares L 11 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Analysis report to find all the talent notifications enabled in systemSummary: Content (please ensure you mask any confidential information): Hello, We want to create an analysis report where we get the list of all the enabled and in use n…
-
Seniority Date in Workforce Management - Worker Assignment RT is not returning any data in OTBISeniority Date.Seniority Date in Workforce Management - Worker Assignment RT is blank whereas Person Seniority Details.Seniority in Workforce Management - Person Seniori…MeghnaDe 11 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Issue - per_availability_details.Get_availability_detailsWe've developed a BI Publisher Report, but it's experiencing performance issues. When run ad-hoc, the report times out (Timeout Error), and when scheduled, it takes over…
-
When a filter is applied after ranking total months of service the analytic function no longer worksI have a report to pull the most recent seniority service data to get a list of employees eligible for a service award. My report works up until I set my final filter. H…
-
How to add Active FTE column to OTBI PivotIs there a way to add a column to the Pivot in this OTBI report that shows CURRENT total FTE by Dept By Job? Here is a print screen of output example. New column hi-ligh…
-
How to fetch report in hiring tab in redwoodSummary: Content (please ensure you mask any confidential information): Hello, When using the Responsive UI, we were able to add a report (Candidate tracking ) in such a…Aishwarya_Saju 11 views 2 comments 0 points Most recent by Shikha Agarwal Reporting and Analytics for HCM
-
Report to fetch all the questionnaire present in systemSummary: Content (please ensure you mask any confidential information): Hello, We want to fetch all the active questionnaires and the items resent in question library, a…Aishwarya_Saju 1 view 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Disabling caching for specific OTBI analysis not workingSummary: We tried to disable caching for an OTBI analysis in HCM with both 'Bypass Oracle Analytics Presentation Services Cache' and SET VARIABLE DISABLE_CACHE_HIT=1, DI…
-
Latest Talent Ratings OTBISummary: We are required to create a prompted OTBI analysis that includes each of the worker's latest talent profile ratings. How can this be achieved? Version (include … -
How to set dashboard prompt where user selects name, but variable is set for person_Id?Summary: Hi team, I am seeking some assistance building an OTBI dashboard prompt. I am wanting to present the display name to the user, but when they select it I want to…Luke.Findex 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to include historic versions of org tree in OTBI workforce trend analysis?Summary Analysis containing HC summaries spanning years does not accurately reflect earlier org tree versionsContent Subject Areas: * Workforce Management - Workforce Tr…James Hoffmann 52 views 8 comments 0 points Most recent by Claudia Linares L Reporting and Analytics for HCM