OTBI
Discussion List
-
Act as Proxy Manager for Line Manager DashboardSummary: As an HR user with view all, I am unable to proxy the line manager view what they can see in their own dashboard. In Workforce Compensation, there is Act as Pro…Sonia Canumay 43 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to include legal employer to a document of record OTBI reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Aina Emmanuel 23 views 4 comments 0 points Most recent by Aina Emmanuel Reporting and Analytics for HCM -
Logical SQL with NULL resultsSummary: I'd like a Performance Tile based on a Logical SQL query to show Zero when no results are found i.e. there is a null result Content (please ensure you mask any …Richard Kemp-Eyre 33 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Possibility to Create Dynamically Different Tabs of The Same Report by Passing Diff. Param’s ValueSummary: OTBI Dashboard > Possibility to Create Dynamically Different Tabs of The Same Report by Passing Different Parameter’s Value Content (please ensure you mask any …Bernard T 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Line Manager Dashboard Workforce Trends with no resultsSummary: Hi, We are working on customizing the seeded Line Manager Dashboard. In "Workforce Trends" tab there are no results for the analysis (see attached screenshots) …Vasco 54 views 1 comment 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Calculated Field in OTBI PromptSummary: Wish to have Calculated field in OTBI prompt. I want to have 3 prompts based on the given table data below: Assignment Last Update Date Grade Change Flag Grade …Pradnya_Pampatwar 32 views 8 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Third party organization payment method reportSummary: Third party organization payment method report Content (please ensure you mask any confidential information): We have a requirement to run a report of the bank …Michelle Hughes 101 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
in OTBI Performance Report Completion Weight value not showing the total weight percentageSummary: OTBI Performance Report needs to show the Completion Weight percentage value display as the total. it is displaying as the separate Completion Weight percentage…Ritu Surve 13 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Can you secure objects in Subject Areas?Summary: Can you restrict certain objects contained within a Subject Area? Content (please ensure you mask any confidential information): Hi Community, I have a requirem…Matthew Hancock 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is it possible to fetch Projected Start Date changes of Pending Workers through HCM Extract or OTBISummary Is it possible to fetch Projected Start Date changes of Pending Workers through HCM Extract or OTBI or BIP?Content Hi Experts, We are working on a requirement to…Harish Kumar Kovi 177 views 4 comments 0 points Most recent by 'Reekey Reporting and Analytics for HCM
-
Help reporting on Veteran, Disability, and DiversitySummary Looking for a way to report on Veteran, Disability, and Diversity dataContent Hello All, I would like to create a report in Fusion to include veteran, disability…User_2025-01-22-19-24-11-575 365 views 4 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM -
How to get the PTD & YTD Balance values from the "Payroll Balances Real Time" Subject AreaWe need to create an OTBI report with the balance PTD and YTD values. In the "Payroll Balances Real Time" Subject Area, Assignment-Period to Date, and Assignment- Tax Ye…Jatin_Maru_1 86 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Payroll - Payroll Costing Setup Details Real Time subject area has timed tracked changesSummary: This subject area is called RealTime but it contains history, as a result it will only return costing details for a position if the costing details have a start…Diane G123 25 views 3 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Can HCM OTBI output file be password protected like BI Publisher ReportSummary Can HCM OTBI output file be password protected like BI Publisher ReportContent Hi, We know how to BI Publisher report output file can be password protected with …User_2025-02-05-22-36-27-300 82 views 11 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
OTBI Report for Grade Change ReportSummary Grade Change ReportContent Hi Team I want to create the grade report to retrieve the previous and current based on the date parameter. I referred to all the repo…User_2025-03-07-20-55-01-859 183 views 24 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Different infolets for employee and managerHi, Can we enable different infolets for Employee and Line manager ? Regards, NivyaNivya Mathire 23 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Can you secure reports using area of responsibility?Summary HR Managers have an area of responsibility based on business unit however can see every employee when in Oracle Transactional Business Intelligence.Content We ha…
-
Workforce Management - Documents of Record Real Time: how to pull the DOR attachment link?Summary: Workforce Management - Documents of Record Real Time: how to pull the DOR attachment link? Content (required): Hi experts, I am curious if there is any way to p…Volodymyr Faranosov 41 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
case statement was producing only 3 records instead of 6 records in FINAL_PATH ColumnHi All, need help on below case. i am concatenating the different structure of Reports Url's (BIP,OTBI,DASHBOARD) with POD url along with report path. Here FLV.DESCRIPTI…Ravindr-Oracle 12 views 4 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
How to increase the length of the Description column more than 1000 pixels in lookup tablesHello All, Currently, I am facing issue with Description column in lookup tables. i wanted to store the Bip report path in Description column but it is truncating some p…Ravindr-Oracle 24 views 2 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
Alternative ways to Schedule Reports, Agents and Report Bursting as opposed to using a Generic userSummary: We currently use a generic user which is against our IT internal controls (so have an open Risk we track). We are looking to establish if other customers have t… -
LSQL - Connect Job Applicant and Employee AssignmentHello All, I am writing an LSQL analysis in OTBI which requires us to add the Hire Date for applicants who are hired. We're familiar with the Projected Start Date and ev…Nick Dorfner 31 views 2 comments 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM -
Automate the Archive process in OTBISummary Automating the Archive process in OTBI for Fusion HCMContent Hi, We take backups of the OTBI catalog across our Fusion instances by archiving the custom folder. …User_2025-01-30-01-56-27-828 136 views 9 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to join worker assignemnt real time and Higher education person Real timeSummary: Hi Team, We unable to add the two subject areas ? Any one assisatnce me on ? We need RACE colum from Higher education person Real time. Content (please ensure y…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How do we control Grant/Restrict access to OTBI > Jobs > Report Job HistorySummary: Hello All, We Would like to understand how can can we grant or restrict access to "OTBI > Jobs > Report Job History". Do we have a role or Privilege with contro…tawfeeq.k 62 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
No Results- The specified criteria didn't result in any data in WorkForce Manag.- Person Real TimeSummary: Hello Oracle Experts. We are trying to create an OTBI for generating the employees loaded in the Fusion ERP. We don't have HCM in scope, it is only SCM and Fina…Lokesh_619 73 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to Automate BACS file to be placed in UCM server?Summary: We have a requirement where BACS File generated using "Make EFT payments process" should be automatically sent to UCM(Oracle WebCenter Content). If anyone has f…
-
Report a journey task status "not applicable"Summary: How can I report, via OTBI, the status "not applicable" if an employee clicked on it during the completion of a journey? It won't appear as a completed task on …Jacqueline GRANDIN 23 views 4 comments 0 points Most recent by Jacqueline GRANDIN Reporting and Analytics for HCM
-
Infolets sampleHi Experts, Can someone share infolet samples/catalog files for employee and manager ? Thanks in advance. Regards, NivyaNivya Mathire 32 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
How can I optimize/simplify my KPI formula in order to reduce the time of the report to load?Summary: It takes 13mins to load my report using the formula since I have to add 2 values on my KPI formula before getting the percentage. Is there a way to optimize my …John Patrick Diaz 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM