OTBI
Discussion List
- 
             Suppress data in Gender, Personal Address columns in OTBI based on logged in user Job rolesSummary: Hi, Our client considers fields such as Gender, DOB, Personal address as PII data whereas Oracle does not. We are looking for ways to suppress the data in these…Debkanya 41 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM Suppress data in Gender, Personal Address columns in OTBI based on logged in user Job rolesSummary: Hi, Our client considers fields such as Gender, DOB, Personal address as PII data whereas Oracle does not. We are looking for ways to suppress the data in these…Debkanya 41 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
- 
             Learning Evaluations CommentsSummary: We have an OTBI Report developed using Learning Management Real Time subject area to show questions and employee responses. We are unable to show the comments e…Ridma Karunanathan 21 views 2 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM Learning Evaluations CommentsSummary: We have an OTBI Report developed using Learning Management Real Time subject area to show questions and employee responses. We are unable to show the comments e…Ridma Karunanathan 21 views 2 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM
- 
             Agent / Recipient List OTBI reportSummary: Is there an OTBI report I can run to see which recipients are listed against an Agent? Content (please ensure you mask any confidential information): I need to … Agent / Recipient List OTBI reportSummary: Is there an OTBI report I can run to see which recipients are listed against an Agent? Content (please ensure you mask any confidential information): I need to …
- 
             Dashboard: Workforce Compensation Budgets issueSummary: Content (please ensure you mask any confidential information): Hello experts, what is the meaning behind the attached budget seeded reports? The count of total …Valerio Curzi 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM Dashboard: Workforce Compensation Budgets issueSummary: Content (please ensure you mask any confidential information): Hello experts, what is the meaning behind the attached budget seeded reports? The count of total …Valerio Curzi 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
- 
             How can I add a deep link to go straight to an employee's details?Summary: I am trying to create a deep link in OTBI using the employee number to open the Additional Person Info page, but can only get to the initial page rather than th…Mark Stoker 234 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM How can I add a deep link to go straight to an employee's details?Summary: I am trying to create a deep link in OTBI using the employee number to open the Additional Person Info page, but can only get to the initial page rather than th…Mark Stoker 234 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
- 
             Sending emails using agents to recipients from an analysisContent Hi I want to send reports to users using agents. The problem is, I want to send different data to each recipient based on their requirements. e.g. I would like t…Mohit Gupta-45440 89 views 10 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM Sending emails using agents to recipients from an analysisContent Hi I want to send reports to users using agents. The problem is, I want to send different data to each recipient based on their requirements. e.g. I would like t…Mohit Gupta-45440 89 views 10 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM
- 
             we unable to find the worker type in worker assignement real time subject area OTBISummary: HI Team, An one can help me on . we get only person type but we need worker type. Thanks Ajay Content (please ensure you mask any confidential information): Ver…AjayKumar Maddipati 21 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM we unable to find the worker type in worker assignement real time subject area OTBISummary: HI Team, An one can help me on . we get only person type but we need worker type. Thanks Ajay Content (please ensure you mask any confidential information): Ver…AjayKumar Maddipati 21 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
- 
             What role or privilege do we need to access "Inherit Segment Value Attributes" ESS JobSummary: We would like to understand what role or privilege do we need to access "Inherit Segment Value Attributes" ESS Job. We tried searching for this in OTBI and "Man… What role or privilege do we need to access "Inherit Segment Value Attributes" ESS JobSummary: We would like to understand what role or privilege do we need to access "Inherit Segment Value Attributes" ESS Job. We tried searching for this in OTBI and "Man…
- 
             Hiding Schedule and Job from BIP report part of dashboardSummary: Hiding Schedule and Job from BIP report part of dashboard Content (please ensure you mask any confidential information): Hi, We've a BIP report part of a dashbo…Bhavna-Civeo 51 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM Hiding Schedule and Job from BIP report part of dashboardSummary: Hiding Schedule and Job from BIP report part of dashboard Content (please ensure you mask any confidential information): Hi, We've a BIP report part of a dashbo…Bhavna-Civeo 51 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
- 
             Report to confirm those that do not have a probation keyedHello, Has anyone built a report to show those that do not have a probation keyed? I have tried building one based on anyone that has the action reason 'end probation' a… Report to confirm those that do not have a probation keyedHello, Has anyone built a report to show those that do not have a probation keyed? I have tried building one based on anyone that has the action reason 'end probation' a…
- 
             Sending of analysis to managers via agentsSummary Sending of analysis to managers via agentsContent Hi - We have set up a number of Analysis which are currently being sent to different business units / locations…Roy Paolo Paunlagui 74 views 9 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM Sending of analysis to managers via agentsSummary Sending of analysis to managers via agentsContent Hi - We have set up a number of Analysis which are currently being sent to different business units / locations…Roy Paolo Paunlagui 74 views 9 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM
- 
             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 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 30 views 4 comments 0 points Most recent by Aina Emmanuel 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 30 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 31 views 1 comment 0 points Most recent by Nivya Mathire 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 31 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 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 55 views 1 comment 4 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 55 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 31 views 8 comments 0 points Most recent by Pradnya_Pampatwar 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 31 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 111 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle 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 111 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 11 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 11 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 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 179 views 4 comments 0 points Most recent by 'Reekey 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 179 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 369 views 4 comments 0 points Most recent by Shant_Sarkissian_WJG 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 369 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 81 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani 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 81 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 21 views 3 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 21 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 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 182 views 24 comments 0 points Most recent by Pradnya_Pampatwar 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 182 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 21 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM Different infolets for employee and managerHi, Can we enable different infolets for Employee and Line manager ? Regards, NivyaNivya Mathire 21 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… 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 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 11 views 4 comments 0 points Most recent by Ravindr-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 11 views 4 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM