OTBI
Discussion List
-
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 663 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 -
How to remove page number from PDF PO layouSummary How to remove page number from PDF PO layouContent Hello, We want to remove page number from PDF PO layout. (review attache file). How can we do this? Regards, E…User_2025-02-04-11-05-39-148 214 views 7 comments 1 point Most recent by Manavalan Ethirajan Purchasing -
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 31 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 39 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Misaligned columns and lines in reportSummary When published in Excel, reports lines and columns are misalignedContent Hello everyone, Sorry if this topic was already created before (I didn't find it), but I…User_2025-03-28-01-07-13-341 42 views 8 comments 2 points Most recent by Rich Merkel Reporting and Analytics for ERP -
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 1K 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 59 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 40 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 201 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Supplier should not see Negotiation controlsSummary Supplier should not see Negotiation controlsContent Hi All, When Negotiation is published, supplier can see Negotiation control like in PDF & as well on supplier… -
Values for the Expanded Authority Field in Analysis Report in OTBISummary Values for the Expanded Authority Field in Anaysis Report in OTBIContent I created an analysis using the "Projects - Grants Management - Award Funding Real Time"… -
Access to Procurement/Purchasing Subject Area & Purchasing Related ReportsSummary User without Buyer role are unable to Access Procurement Subject Area and Procurement Related Reports, Also they are unable to Create New AnalysisContent Client …PiyushBihany-Oracle 229 views 7 comments 2 points Most recent by User_2025-02-01-08-03-13-309 Purchasing -
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 41 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 45 views 3 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Active Learners in LMSSummary How can I deactivate/delete learners ?Content I am encountering an issue that I can't seem to find an answer. I want to clean what I have pending in LMS and deac… -
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 25 views 4 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
How to automate Supply Plan Back-Up process in Planning CentralSummary Business Requirement - Supply Plan should be copied first to a back up before being launched as part of daily run schedule.Content Hi, Business Requirement - Sup…Omkar Panda-Oracle 52 views 2 comments 0 points Most recent by Omkar Panda-Oracle Supply Chain Planning and Collaboration -
SQL for duration of inspection requiredSummary Measure key metricContent SQL Guru's need some help figuring out what tables to get: For receiving, we want to measure the duration of a receiving task to captur…