OTBI
Discussion List
-
How do i fetch blank vales for mobile phone number in a OTBI reportSummary How do i fetch blank vales for mobile phone number in a OTBI reportContent Hi, I have a slightly different issue. I am trying to fetch the home mobile number for…User_2025-01-30-21-52-52-008 73 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Analytics Section on HomepageContent Hello Everyone, Has anyone used "Analytics" section on homepage to display reports/dashboards? Currently, it displays Order to cash infolets and Service infolets…Hetal Vaghela 71 views 4 comments 1 point Most recent by Pooja_Chowdhary-Oracle Reporting and Analytics for HCM -
How to get the previous performance task name in OTBIContent Hi All, I am trying to get the results for current Performance Task name and previous Performance Task name using the Subject Area: "Workforce Performance - Perf…Janardhana Kondaveeti 81 views 5 comments 0 points Most recent by Elizabeth Docherty Reporting and Analytics for HCM -
Changing Column HeadingsSummary Any implications for existing reports?Content Hi, I recently learnt that column headings can be permanently re-named by saving the new column heading as a system…User_2025-02-05-22-44-35-842 36 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Org Chart in OTBISummary Ability to create Org Chart in OTBIContent Hi All, I am looking at ways to create an Org Chart in OTBI, which will display the Hierarchy in a Tree View similar t…User_2025-03-07-00-53-57-686 619 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Analysis- restrict access at field level?Summary Want to hide a field within a subject area in analysisContent We have a requirement to create an analysis & then restrict access at field level within the subjec…Delia Coelho 29 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
report to pull manager rating and participant reviewSummary report to pull manager rating and participant reviewContent Hi All, I have prepared two simple reports to pull manager performance rating and participants review…Ritwick Chatterjee 56 views 3 comments 1 point Most recent by Ritwick Chatterjee Reporting and Analytics for HCM -
Missing Manager Names on Hire NotificationsContent Hello, We currently have alerts set up for new hires that goes to our IT department using the attached XML. To get the latest hire date and information we use th…User_2025-01-31-00-25-12-234 33 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
unposted Payroll Transaction review.Summary how to check the unposted payroll transactions for review.Content how to check the unposted transaction for review before payroll runs. for example, we have upda… -
BI Publisher vs OTBI? Any guidance/recommendations on when to use each solution?Content Hello, I have tried searching but cannot see anything as focused - query is, are there any recommendations or guidance from Oracle around when to use BI Publishe… -
Missing Prompt ValuesContent I'm looking at a Manager Username Prompt, but not all the values are returning for the prompt/filter. Has anyone seen this before or know why all the options in …User_2025-01-31-00-25-12-234 32 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Total Compensation FigureSummary I would like to add Total Comp to my reportContent Hi, The Compensation - Workforce Compensation Real Time subject area is redundant in my organisation, is there…User_2025-02-05-22-44-35-842 42 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
report to get list of direct reports for a managerContent Hi Experts, I am looking for a query where the manager can get the output as the name of all direct report specific to them, I am able to achieve it in analysis …GauravSushant 971 views 3 comments 1 point Most recent by User_2025-03-07-00-53-57-686 Reporting and Analytics for HCM -
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 56 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 70 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 26 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 28 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 84 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 80 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 20 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 56 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 49 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM