OTBI
Discussion List
-
Medical Examination Data OTBI report display problemHello, With a specific role created role of Medical examination I have a problem displaying the report while connecting as a nurse in my organization. At first there was… -
OTBI Analyses not showing Worker DataSummary: The User cannot see all fields in a report although all columns used are attributes from one Subject Area. The columns the user cannot see are Worker related co…Sa_De_Or 23 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
90 Day New Hire TurnoverSummary: Trying to properly capture 90 day new hire turnover. Looking back 90 days from the day the report is run (today). Content (please ensure you mask any confidenti…CGardner01 81 views 19 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Original Hire Date Changed for Pending Worker vs. EmployeeSummary: Our original hire date was historically based on the work relationship start date. However, after the implementation of ORC it is now the effective date of the …Chad Morris 256 views 7 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Reporting and Analytics for HCM -
Audit ReportSummary: We did enable the audit for the PER_PHONES table. This reports on future phone number change history. We included date prompts. I updated the phone of the user …Stela Martins-Oracle 21 views 2 comments 0 points Most recent by Stela Martins-Oracle Reporting and Analytics for HCM -
Finding Records with Trailing Space in OTBISummary: Finding records that have a trailing space in OTBI Content (required): We have file transfers that fail when a trailing space is on the end of Address Line 1. I… -
Analysis done using Security Roles and Privileges real time does not show all privilegesSummary: Created a custom OTBI analysis to get custom role inherited roles and privileges, compared against exports directly from Security Console. There are plenty of m…DiegoCastanon 31 views 3 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
Candidate status in reports?Hi, Can someone help me with the table to get "Candidate Status " value in recruiting? Regards, NivyaNivya Mathire 42 views 9 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Job Entry Date and Department Entry Date Equivalents in OTBIContent Wondering if anyone has identified a way to access job entry date and department entry date in fusion hcm. These were delivered calculated fields in People Soft,…Karen Costakes 263 views 7 comments 2 points Most recent by Gloria Brewster Reporting and Analytics for HCM
-
OTBI > Transpose Rows to Columns in OTBI > Ability to Perform Sum Only on One RowSummary: OTBI > Transpose Rows to Columns in OTBI > Ability to Perform Sum Only on One Row Content (please ensure you mask any confidential information): Hello, We want … -
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 42 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 -
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 -
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 237 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 -
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 22 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… -
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… -
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 -
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 -
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 -
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 118 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