OTBI
Discussion List
-
Analysis or Report not returning any resultsContent I'm hoping there is something obvious I'm not doing right, but every time I try and run an Analysis or Report in BI Publisher, it returns No Results as per the s…User_2025-02-05-23-39-39-057 50 views 6 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Absence plan usageContent Hi, We have an absence plan in OTBI called 'Sickness 3 Day Waiting Depot'. We are trying to get information on this plan using an OTBI analysis from the "Workfor…James Seller 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
HR_ORG_UNIT_CLASSIFICATIONS_F not aligned with HR_ALL_ORGANIZATION_UNITS_FSummary Some fields are empty in HR_ORG_UNIT_CLASSIFICATIONS_F although populated in HR_ALL_ORGANIZATION_UNITS_F for some departments onlyContent We are using OTBI for s… -
Benefits Pending Action Item Report - Incorrect DataSummary I've created an OTBI to report on Pending Benefit Action Items, but it pulls in employees that have already completed them.Content I have created the attached an…User_2025-01-31-00-25-12-234 193 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
HR Help Desk - Organizational hierarchySummary Need to add "Level 3" to an exciting help desk reportContent Hello, I wonder if anyone can help me out. I need to add "Level 3" of the organizational hierarchy t…Mitch_123456 42 views 4 comments 0 points Most recent by Mitch_123456 Reporting and Analytics for HCM
-
Reporting in Working days when absence UOM is hoursSummary I need to know how to convert a duration from hours into days using WPContent We are on 19D and our UOM is set to hours so when i report on absence, the duration…Dawn Cawston - CPS 68 views 2 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Probation End DateSummary Is Probation End Date available in OTBI?Content Hi, Is the Probation End Date available in OTBI? If yes, which Subject Area is it located in? Many thanks, Andrew…User_2025-02-05-22-44-35-842 46 views 3 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Manager Name not updating in Absence ReportSummary Manager change not reflected in reportContent Hi, I have an absence report that has a legal entity prompt that end users use that has worked perfectly fine until…User_2025-02-05-22-44-35-842 27 views 4 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
OTBI Report Shared to Supervisor does not show parameterContent Hello Everyone, I have added a tab to 'My Team' to show reports to Line Managers. I have added an OTBI report to this tab using personalization. However, when ru…Hetal Vaghela 29 views 2 comments 2 points Most recent by Hetal Vaghela Reporting and Analytics for HCM -
how to send the Salary Slip email PDFSummary we need to send the Salary Slip email PDFContent is there any option to send the Salary slip PDF with password protected. -
Employees who had their job changed?Summary OTBI report for all employees who had their job changeContent Hi Experts, Is it possible to create a report in OTBI which gives me a list of all employees who ha… -
OTBI reports not working in 20ASummary All OTBI reports are erroring out in 20AContent We recently got our test instances upgraded to 20A over the weekend and all our OTBI reports are not working. We …Roy Paolo Paunlagui 85 views 10 comments 0 points Most recent by Roy Paolo Paunlagui Reporting and Analytics for HCM
-
Track hours for ACA requirementsSummary Looking to find details to track hourly employees to see if they meet hours for ACA eligibilityContent Hi all, Client is outsourcing ACA administration, however,…User_2025-01-30-00-53-42-934 82 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Returning data based on two columnsSummary Data must be returned if either of the criteria satisfiedContent HI all Any ideas how to do the above. I am working in Absence Calendar and have the start and en…Dawn Cawston - CPS 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HR Help DeskSummary Subject area details/mappingContent Good afternoon, i was wondering if we have any supporting documents for the "New" help desk subject areas like "Service - CRM…Mitch_123456 45 views 1 comment 0 points Most recent by Balaji Durai-Oracle Reporting and Analytics for HCM
-
Workforce Map - ReportSummary Looking to see if the Workforce Map we use can be replicated in OTBI or BIPContent Hello We are soon to move from a partial cloud installation to a full cloud of…Andrew Braid 58 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Pull Question Library with SQLSummary Questionnaires:- My Workforce > performance > Setup and maintenance > Manage Questionnaires > Select “HR Checklists” in Subscriber > Select “Questionnaire Librar…User_2025-02-06-07-21-22-662 56 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 58 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 200 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 38 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 50 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 39 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 66 views 3 comments 1 point Most recent by Rambabu Laveti-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 70 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 45 views 1 comment 0 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM