OTBI
Discussion List
-
Changing the Default value in a column selectorSummary Have Column Selector, want to duplicate and change the orderContent Hello, I'm trying to use the Column selector view and am looking for a way to either set or c… -
Report on appraisal status and tasksSummary I need a report with the specs as stated below in the content. Can anybody see what I am doing wrong here?Content Fields needed: * - Performance document name * …Inge Marinus 43 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Analysis showing 2 Record for manager update for employees.Summary How can we remove duplicate record for line manager change.Content HI, I have created the analysis in the subject area "Workforce Management - Worker Assignment …Farooq Syed, CPA, PMP, CISA 54 views 2 comments 1 point Most recent by Farooq Syed, CPA, PMP, CISA Reporting and Analytics for HCM -
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 74 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 652 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 193 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 62 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 235 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