OTBI
Discussion List
-
Use session variable to show only Health and Safety incidents for the user logged inSummary Recording demonstrates steps to get display name of user logged in and pass as a sub report to query incidents for user logged in.Content Overview of steps: * Cr…Stephanie Golly-Oracle 104 views 4 comments 7 points Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM -
% Veterans by Assignment ManagerContent Hello, I'm trying to get % of veterans for a manager hierarchy when logged in as an HR user (access to all workers). I can calculate the % of veterans for the wh…Susan Anderson 32 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
manager phone number details in OTBI reportSummary Is there a way to get manager phone number details in OTBI reportContent Hi All, We have a requirement to capture manager phone number in the report. trying to b…User_XT9HW 87 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
What is the significance of the fields "Assigned to User" and "Assigned to Username" in the subjectSummary What is the significance of the fields "Assigned to User" and "Assigned to Username" in the subject area "Transaction Administration Real Time" ?Content The pend…Sreedharan-Oracle 21 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI formula to remove all the special characters from a column valueSummary OTBI formula to remove all the special characters from a column valueContent Hi, I am trying to remove all the special characters from a column value in OTBI ana…User_MC37Q 558 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to fetch the time card exceptions using OTBI/BIP report?Summary How to fetch the time card exceptions using OTBI/BIP report?Content Hello Team, We are trying to build a report where we need to show the details of person and t…Harish Kumar Kovi 68 views 2 comments 1 point Most recent by Sai1654 Reporting and Analytics for HCM
-
OTBI Subject Area for availability patterns of a employeeSummary OTBI Subject Area for availability patterns of a employeeContent Hi, Anyone knows subject area to get availability patterns of an employee? Regards, RashmiUser_MC37Q 37 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Securing CatalogSummary Securing CatalogContent Hi, we are going to make the reporting tool (OTBI) available to our HR end users. First we will like to create some security around the i…User_2025-02-05-08-23-23-591 51 views 3 comments 2 points Most recent by Tom Strudley Reporting and Analytics for HCM -
OTBI: how do we check if one column value is present inside another columnSummary OTBI: how do we check if one column value is present inside another columnContent Hi, Need a logic to compare if one column value is present inside another colum…User_MC37Q 66 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query related to OTBI subject area: Payroll : Personal Payments Detail Real TimeSummary Query related to OTBI subject area: Payroll : Personal Payments Detail Real TimeContent Hi, I have a query on OTBI subject area: Payroll : Personal Payments Deta…User_MC37Q 68 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Aggregate actions, and make it consistent across languagesSummary Aggregate actions, and make it consistent across languagesContent Hi, we need to aggregate action and make it consistent across languages in OTBI. I modify the f…Nicola Petri 19 views 6 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM
-
Future-dated department showing up in report instead of current dataContent Department attribute in 'Workforce Performance - Performance Task Status Real Time' subject area is fetching future-dated assignment information for employee ins…User_2025-02-05-23-59-37-171 33 views 9 comments 0 points Most recent by User_2025-02-05-23-59-37-171 Reporting and Analytics for HCM
-
Looking for Quadrant view of dashboard for BSCContent Hi, I have a requirement to build Quadrant view of dashboard for BSC. Please let me know if anyone can help me on this. Thanks. JyotiUser_2025-02-06-14-37-05-233 23 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Looking for Transfer Compensation Change ReportContent Hi, I am in need of Transfer Compensation and Location Change report. Please help. Thanks, JyotiUser_2025-02-06-14-37-05-233 15 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Reporting on when someone became a line managerContent Has anyone developed a report that allows us to see when someone first has a direct report assigned to them or knows of anyway to do this? Version 20BUser_2025-01-31-00-25-12-234 18 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Manager_type = Timecard_Approver in OTBISummary Manager_type = Timecard_Approver in OTBIContent Hi ALL, In OTBI when I see "Manager Type" ( "Workforce Management - Worker Assignment Real Time"."Worker"."Manage…User_2025-02-07-19-03-14-525 37 views 7 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Descriptive FlexfieldsSummary Deploy Descriptive Flexfields to Unified Sandboxes [HCM 20B]Content Please provide information of new features in Deploy Descriptive Flexfields to Unified Sandbo…User_080V4 47 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Salary reportSummary Salary reportContent I need a report which pulls current salary and previous salary details. Can any one have SQL to pull the data. PERSON_NUMBER OLD_SALARY_STAR…Reddykrishna 204 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
CASE Statement - Multiple rows in OTBIContent Hi, We have local legislative requirement for a report do deliver it in certain type of format. As the information is stored differently in HCM Cloud e.g. Elemen…User_KOLMZ 326 views 6 comments 0 points Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM -
Adding labels on X axis in OTBI report under graph ViewSummary I am trying to add labels on X axis in graph view of OTBI report.Content I am trying to add labels on X axis in graph view of OTBI report.I am creating on OTBI a…User_2025-02-06-15-04-02-124 50 views 1 comment 1 point Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Looking for Position ReportSummary Would like number of unfilled positions, organization chartsContent Hi everyone - we are underway with preparing to implement Position Management. We currently u…Ashley Cossey 97 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Workforce Trends - Time Column Values Are not Accurate or are BlankSummary Calendar Quarter and Calendar Month do not render correctly in the reportContent We have a requirement to show period active start and end headcount by different…Karen B 24 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Calendar PromptSummary I would like to add a calendar promptContent Hi, I have added AsOf date prompts to various reports and here I would like to include a between date prompt using t…User_2025-02-05-22-44-35-842 71 views 5 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
OTBI Matrix Manager ReportSummary OTBI Matrix Manager ReportContent Hi Team, We are working on a OTBI report where client want to add all matrix managers and should extract all manager in single …User_2025-02-01-03-43-13-079 118 views 2 comments 2 points Most recent by User_2025-02-01-03-43-13-079 Reporting and Analytics for HCM
-
Looking for solution to "https://cloudcustomerconnect.oracle.com/posts/a3fe9e182c?commentId=407101#4Content Hi, I have a requirement exactly like "https://cloudcustomerconnect.oracle.com/posts/a3fe9e182c?commentId=407101#407101". I am not able to resolve it using MAX()…User_2025-02-06-14-37-05-233 34 views 2 comments 1 point Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM
-
Parent manager blank for terminated employees.Summary Parent manager blank for terminated employees, how to retrieve manager hierarchyContent Hi all, we are facing some issues with OTBI report, we are using Parent M…Nicola Petri 95 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Recommend to RehireSummary Termination - Recommend to RehireContent Hi, Where can I find the 'Recommend to Rehire' flag value to report on? For context, when someone terminates a dropdown …User_2025-02-05-22-44-35-842 74 views 6 comments 2 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Graphs in OTBISummary Can graph with data count be created in OTBIContent Can we create a graph close to how it is shown in the image in OTBI?pooja yelsangikar-Oracle 49 views 4 comments 0 points Most recent by pooja yelsangikar-Oracle Reporting and Analytics for HCM -
Error while joining two subject areasSummary Error while joining two subject areas (No fact table exists at the requested level of detail:)Content I am trying to fetch list of roles that a worker has along …User_2025-01-25-04-02-13-126 70 views 12 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Prompt: User Selects Operator "Between"Summary If you allow users to select the operator for a date prompt, the value "between" is not available.Content We have a requirement to allow end users to select the …