OTBI
Discussion List
-
How to report on Historical Organization Hierarchies?Summary: We have 6 historical versions of our organization tree, but when trying to report on the previous versions in reporting, only the latest organization hierarchy … -
Need to identify the tables that hold sensitive information using Oracle Cloud RecruitingSummary: I need to identify the any tables that hold sensitive information (PII). We have started using Oracle Cloud Recruiting and want to identify tables that have thi… -
we would need a report with the previous and new cost center OTBI ?Summary: Hi Team, Hope all doing well ! we would need a report with the previous and the new cost center ? Could you please help me on ? Thanks, Ajay Content (please ens…AjayKumar Maddipati 39 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Adding multiple phone numbers to analysisSummary Add multiple phone numbers to an analysisContent Hi All, I just need some direction on adding multiple phone numbers for an employee in an analysis I am modifyin…User_2025-02-04-08-51-08-912 41 views 4 comments 0 points Most recent by Alexis PJ Reporting and Analytics for HCM -
OTBI report for learner count, count of learner according to number of courses completedSummary: I have to create a report to get the count of learners who have completed more than 1 course and learners who have completed more than two courses. Also I need … -
Can you please provide us the details of the report which provides information about all the reportsSummary: Can you please provide us the details of the report which provides information about all the reports along with permission set to that particular report Can you…Shubham Bindal 18 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Logical SQL join condition for Recruitment and Transaction ConsoleHi, I have a report where I am using below tables for fetching recruitment and postion details like JobRequisitionNumber, RecruiterFullName,DepartmentName,RecruitingType… -
Gross earnings reportSummary: Is it possible to create a report in OTBI that shows gross earnings per pay for a specific date range? If yes which subject area should we use? can anyone help …Shameer Shaik 31 views 2 comments 0 points Most recent by Shameer Shaik Reporting and Analytics for HCM -
Using dashboard prompts on multiple-subject area analysisSummary: Using dashboard prompts on multiple-subject area analysis Content (required): Hi all, I created an analysis to track a specific group of managers (narrower than… -
OTBI with a List of Courses and a link leading to the course pageSummary: Content (required): Hi there, I have created a simple OTBI report with a list of all the courses we have in Fusion Learning - xml code is at the bottom. I wante… -
Employee Names in Local LanguageSummary Employee Names in Local LanguageContent Hi All I need to display the Employee Names (Example: First, Middle and Last) in local Language (i.e. Arabic) I entered t…Shabrawi 138 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need assistance for bursting paramter4Summary: Hi Everyone, I need your assistance regarding the bursting report. I want to add a data source in my subject email but when I try to add it gives me an error. c… -
ACA Eligibility Process caused duplicate Action Codes to appear with differing datesWe found that the ACA Eligibility Process is duplicating action codes on employees' assignment histories and it's not clear how we would easily query assignment records … -
How to get one object from a string in OTBI ReportsHi Team, We have a requirement where would like to get a particular object from a string which has _ in it. Example: This the string we have in one column Evaluation_OLC…Malla Pratibha 30 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM -
Changes reportSummary All changes for specified fields in date rangeContent Hi, Is there a report that shows all changes in period: ID Name Effective Date Old Department New Departmen…Mike Borghoff 87 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How to find the OTBI report last run history?Summary: Hi All, Need to find the history of the OTBI report last run, user-wise. Content (please ensure you mask any confidential information): Version (include the ver…Haripriya 54 views 3 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM -
Subject Area for Organization AttributesSummary Subject Area to display attributes from hr_all_organization_unitsContent We deployed few attributes at PER_ORGANIZATION_UNIT_DFF under Manage Organization Struct…Amitabha 213 views 7 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Dynamically logos of the different legal employer dynamically in BIPSummary: I am trying to display the logos of the different legal employers dynamically on my BI report. I created a SubTemplate folder where I store the logos The Sub Te…Consultant Ian 29 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
Are infolets unsupported with 24A?Summary: I heard that starting with release 24A, that the support for infolets is discontinued. Is that correct and if so, is there similar functionality that can be use…A.J. 97 views 7 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Order by phase in Recuiting OTBI ReportSummary: Hi everyone, I tried to sort the phase in recruiting but it doesn't work can anyone tell me why? and what is the solution to sort the phase? -
Embedded content for dashboardSummary: Embedded content for dashboard Content (please ensure you mask any confidential information): Hello experts, we would like to have a page in oracle that allows …Oriana L. 20 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM -
OTBI - Locating 5th occurrence of character using substring and locateSummary Several fields have been migrated into one field and need to split into separate columns into OTBIContent Several fields have been migrated across as one field s…Mark Stoker 513 views 12 comments 0 points Most recent by Mark Stoker Reporting and Analytics for HCM -
pending worker record not fetching in OTBISummary: Content (please ensure you mask any confidential information): Hello, We are creating a report to fetch the checklist task values from the configurable form fil…Aishwarya_15 70 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Standard report for Oracle journeysSummary: Standard report for journeys Content (please ensure you mask any confidential information): Hello experts, does anyone know if there are standard reports delive…Oriana L. 248 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
not able to create group by function for date columnSummary: not able to create group by function for date column in OTBI Content (please ensure you mask any confidential information): Version (include the version you are…Kirish Kumar Venkatesan 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to remove ‘0’ percentages from Rising star program participant by Ethnicity graphGood Day All! We are facing one issue in a Customer created Dashboard Report. Dashboard is created to show the Rising star program participants by Ethnicity graph. we ha…Bindu Janoti-Oracle 7 views 0 comments 0 points Started by Bindu Janoti-Oracle Reporting and Analytics for HCM -
Report for ESS and MSS TrasactionSummary: Need Report for ESS and MSS Trasaction Content (please ensure you mask any confidential information): Hi All We need to fetch all ESS and MSS transactions Versi… -
OTBI Workforce Management absence entitlement case real timeSummary: How do you report out of this subject area. We have added the Job and duty roles and yet the subject area doesn't return any detail. Its as if the entire subjec…Kevin Robertson 25 views 3 comments 0 points Most recent by Kevin Robertson Reporting and Analytics for HCM -
OTBI report retrieving Base Salary amount and Annual Salary amountSummary: Content (please ensure you mask any confidential information): Hello experts, do we have a standard OTBI to retrieve Base Salary and Annual Salary amount? If so… -
Sample OTBI report to track compensation plan approvalSummary: Content (please ensure you mask any confidential information): Hello experts, is there a sample OTBI report to track compensation plan approval status? I notice…Valerio Curzi 12 views 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM