OTBI
Discussion List
-
Concatenate a case statement with fieldsSummary I want to concatenate a case statement with a field in OTBI. How would i do so?Content "Worker"."Person Type", CASE WHEN ( "Assignment Manager List Unsecured"."M…User_2025-02-06-07-21-22-662 55 views 3 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Connect OTBI to SQL DeveloperSummary ReportingContent Is there a way to connect OTBI to SQL developer? I want to run queries and create reports through SQL developer.User_2025-02-06-07-21-22-662 199 views 3 comments 1 point Most recent by Tom Strudley Reporting and Analytics for HCM
-
RetirementSummary Eligible to RetireContent To be eligible for the pension plan an employee has be to be aged 65 or meet the “magic 80” rule which is the employees’ start date + a…User_F1ZIP 40 views 8 comments 0 points Most recent by User_2025-02-05-05-51-12-049 Reporting and Analytics for HCM -
Issue with Annualized Salary in OTBISummary Anunaluzed Salary not showing up in OTBI analysisContent Hi - We are in the process of building/moving our BIP reports to analysis but have been encountering iss…Roy Paolo Paunlagui 49 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
I can't see any secured reportsContent Hello Guys,The technical department has secured the reports in BI. My users cannot view the reports anymore, it seems as if they no longer exist. Is there any ro…Giuseppe Iacono 38 views 2 comments 0 points Most recent by Tom Strudley Reporting and Analytics for HCM -
Can I report on System Entry Date?Summary How can I report on the system entry date of an action? Not the creation date or last update date.Content Hi all, Has anyone found a way to report on the actual …User_2025-01-31-22-36-07-589 92 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Improvement Ideas for BI Catalog UI / NavigationSummary BI Catalog UI ImprovementsContent Hi All, We at DHL are using HCM for few years already and we are looking to further exploit our data to provide intelligence an… -
Create a report for Areas of ResponsabilitiesContent Hi Guys, I need to realize a Report in order to extract: Person ID, Employee Name, Area Of Responsibility Name , Responsibility Type and Scope Of Responsibility.…Giuseppe Iacono 65 views 3 comments 1 point Most recent by Rambabu Laveti-Support-Oracle Reporting and Analytics for HCM
-
Error on Technical Summary Report under /Shared Folder/HCM/Setup and Maintenance/ConfigurationSummary Getting data model error while running Technical Summary Report under /Shared Folder/HCM/Setup and Maintenance/ConfigurationContent Hi All, Does anyone know what…
-
How to get readiness level in reportContent Hi Everyone. I am trying to get the data of the succession plan in a report however I got all data except Readiness level. In HRM_PLAN_CANDIDATES table, the Read…Misbahul Khair 45 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM -
Potential assessment report on a specific talent reviewSummary Potential assessment report on a specific talent reviewContent Hello, we have a OTBI report for potential assessment, this report is accessible through > select …Helene V 51 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM -
How to embed a an OTBI report in the Skill and Qualifications pageSummary How to embed a an OTBI report in the Skill and Qualifications page?Content Hi, I want to embed an OTBI report in the Skill and Qualifications page, in order for …Silvia Guido 68 views 2 comments 0 points Most recent by Silvia Guido Reporting and Analytics for HCM
-
OTBI Learning data incompleteSummary Data present on learning module not present in OTBI extractContent Hello all, Records present on the learning module not present on OTBI. Check the 3 screenshots…User_2025-02-05-11-42-08-011 46 views 1 comment 0 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM
-
HR Help Desk - SR`s out of SLASummary Can we report on how many SR`s go out of SLAContent Hello All, i was wondering if anyone knows how i would go about creating a report on how many SR`s per period…Mitch_123456 46 views 3 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Oracle BI to HCM NavigationSummary Oracle BI to HCM NavigationContent Hello, Is there a smart navigation that will allow users to navigate from BI back into HCM without a new web browser being gen…User_2025-01-29-01-38-03-243 32 views 3 comments 1 point Most recent by Tom Strudley Reporting and Analytics for HCM
-
Steps to audit BI folder changes?Summary In what way can we identify what user moved heh folder in BI Catalog?Content In our PROD pod, we have several folders under the custom folder location that inclu…User_VR8E0 68 views 5 comments 3 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Leave adjustment detials for employeesSummary Leave adjustements for employees is available in any subject areas in OTBIContent HI, In the Absences sometime HC team are doing adjustment in the annual leave, …Farooq Syed, CPA, PMP, CISA 29 views 4 comments 1 point Most recent by User_2025-02-06-09-29-18-902 Reporting and Analytics for HCM -
Manager type problemContent Hi guys, Someone know in which subject area i find the field manager type that contain all the the manager type and not only the line manager? Best Regard Giusep…Giuseppe Iacono 49 views 12 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report showing changes to key fields onlySummary I have been asked to develop a report that will extract data changes onlyContent Hi, I have been asked to develop a scheduled report on based on the following fi…User_2025-02-05-22-44-35-842 38 views 8 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
How to count NULLS - OTBI Analysis reportSummary I have a basic employee extract and would like to count the number of nullsContent Hi, I have a basic employee extract report that has 12 columns from Workforce …User_2025-02-05-22-44-35-842 49 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Implementing Styles in OTBISummary Where do you go to create/edit Styles for OTBIContent Hello Experts, We're using OTBI and I'm trying to leverage Style to get a consistent look and feel to our r… -
Created a Time Card dashboard and want to the Manager prompt to default to the manager pulling the rSummary Is there a way to default a prompt so that it is automatically set to the person that is pulling the reportContent We have a Time Card dashboard with a prompt fo…User_2025-01-28-20-43-56-568 73 views 8 comments 2 points Most recent by User_2025-01-28-16-10-52-033 Reporting and Analytics for HCM
-
Mobile App in BI analyticsContent Hi, Can someone tell me what is the use of "Mobile App" in BI Analytics and how to use the functionality? Please share any documentation if you have any. Regards…Nivya Mathire 27 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Workforce StructuresContent All - I am trying to put together a Workforce Structures report that I can share with all of our HR partners, regardless of their security. Some of our partners … -
Location informationSummary I need to run a report showing our locations, addresses etcContent Hi, Is there a subject area that holds the following information: Location Name, Office, City,…User_2025-02-05-22-44-35-842 45 views 5 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM
-
20A Documents of Record Real Time - 4 fields decommissioningContent Hello, Just reading the release notes and see a line around 4 columns to be removed from this area, any particular reason why? Are these fields remaining on the …Kevin M Storrie 44 views 2 comments 0 points Most recent by Kevin M Storrie Reporting and Analytics for HCM -
Table information required which stored the employee deleted/Removed role informationSummary Table information required which stored the employee deleted/Removed role informationContent Hi Expert, Table information required which stored the employee dele…User_2025-02-05-01-04-36-989 35 views 5 comments 0 points Most recent by nitin Sharma Reporting and Analytics for HCM
-
Administrative Rights ListSummary List of employees with admin rights to OracleContent Hi, I need a report created for auditing purpose showing a list of all people with Administrative Rights to …User_2025-02-05-22-44-35-842 28 views 3 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Retrieving more than 500 rowsContent I have an analysis that may return more than 500 rows, however it appears 500 is the max. Is there a setting in my report, or someplace else that will increase t…Annette M 65 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Previous and current values flip in the OTBI ReportSummary Previous and current values for different action codes for an employeeContent Hi All, I have a requirement to fetch a report consisting of changes to Jobs, EEO1 …User_2025-01-30-21-52-52-008 465 views 21 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM