OTBI
Discussion List
-
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 Chidella-Oracle 202 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 329 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 51 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 95 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 72 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 116 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 33 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 94 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 72 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 47 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 69 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 …
-
Element Entry for Each WorkerContent Hi Guys, I have to create a report that allow me to extract the Element Entries associated to each worker. But I have a problem, when I Add the "Worker"."name" c…Giuseppe Iacono 104 views 10 comments 0 points Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM -
No data in Human Capital Management - Approval Notification Real Time after Sep-2019Summary No data in Human Capital Management - Approval Notification Real Time after Sep-2019Content Hello I am trying to write a report to show the approval date for sic…Helen Thomas 33 views 13 comments 2 points Most recent by Linda Dunn Reporting and Analytics for HCM
-
fields to use for employee bank account reportSummary what fields to use for employee bank account report?Content hi what are the correct fields and subject to use for getting a report of current employee bank accou…User_2025-01-29-02-09-34-137 140 views 11 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Instance name - TableSummary Instance name - TableContent Hi Team, I want to know the Instance details available table or DBI or UE. We are using email options in the extract to send the out…User_4VVG2 41 views 2 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Deriving column value based in ROLE.Summary Deriving column value based in ROLE.Content Hi All, Need HELP I'm creating report in OTBI and in report there is field call"Is Manager" and logic for this field …User_2025-02-07-19-03-14-525 16 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL for report columnsSummary SQL for report columnsContent I want to be able to query an analysis and get a list of columns that are used in that analysis.Chris Campbell 37 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Is it possible to have email recipient in Agent based on Area of Responsibility?Summary I am creating an email notification for New Hires with benefits enrollment details using Subject Areas and I would like to have the email recipients based on the…Dana Resultay 52 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Avoid Drill down on pie chartSummary How to avoid drill down on pie chartsContent Hi folks, I tried to do some configuration in order to avoid drill down on pie charts (on column properties, see att…Nicola Petri 54 views 2 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM
-
Need table Name for Job Statuses on Data exchangeContent Hi All, We all see our HDL job statuses on the Data exchange under my client groups->Data exchange. Can anyone please let me know if there are any table names av…PankajRK 27 views 3 comments 1 point Most recent by Ema Johnson-Oracle Reporting and Analytics for HCM
-
SQL Help required - pulling manager for rehiresSummary Query was built to pull in Areas of responsibility - Manager details but for rehires, it seems to be picking up their previous recordContent I have been trying t…User_2025-02-04-08-51-08-912 45 views 5 comments 1 point Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
OTBI performance recommendations paper (2679006.1) is available on MOS PortalSummary OTBI performance recommendations V2 doc is intended for OTBI system integrators, BI report developers and admins. It covers advanced performance tuning technique…Pavel Buynitsky-Oracle 87 views 1 comment 10 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Acting Up AllowanceSummary report showing old & new salaryContent Hi, I'm trying to build a report that shows employees that have or currently 'acting up' - I'd like the report to show the…User_2025-02-05-22-44-35-842 35 views 2 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
OTBI - Expression needed to filter dateSummary OTBI - Expression needed to filter last day workedContent Can someone help me with an expression for an OTBI analysis? I need to a filter on the last day worked …Shelly Feyerherm 197 views 10 comments 0 points Most recent by Sandip Khatri Reporting and Analytics for HCM -
Adding parameters for BIP Report built using OTBI AnalysisSummary How to add parameters within BIP Data Model built using for OTBI Analysis data set ?Content We have built a BI publisher report using a OTBI Analysis in the data… -
Termination category blank - how to solve?Summary How to have termination category for active employees with termination as future recordContent Hi, we need to identify active employees that have a termination p…Nicola Petri 36 views 1 comment 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Change ordering of values in horizontal axis of graphSummary Change ordering of values in horizontal axis of graphContent We have a simple graph from OTBI but want to change the display order of the values on the horizonta…Emily Robinson 28 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Master reports for Job, grade, location, department, position, active and ex-employee headcountContent Any Master reports available for Job, grade, location, department, position, active and ex-employee headcount?User_2025-02-06-14-37-05-233 71 views 4 comments 1 point Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM