OTBI
Discussion List
-
DoR DDF correlation table HDOR.DEI_INFORMATION_NUMBER2Summary: Hello experts I'm trying to query some Document of records for brazil taht have fixed DDFs SELECT HDOR.DEI_INFORMATION_NUMBER2 as "STATE" HDOR.DEI_INFORMATION_N…Pedro Teixeira 2 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI with Personal Payment Method DeeplinkSummary: Team, I am working on a Personal payment method OTBI analysis with Deeplink enabled. I am finding one issue like while I am selecting then it I select the assig…Mohan Murali 32 views 3 comments 0 points Most recent by Julian Challenger-Oracle Human Capital Management -
What is the best way to show all employees for a specific element even if they do not have it?Summary: I need to build a report showing all employees, but needs to show a specific element if the employee has it, and leave a blank if they don't Content (required):…Mark Stoker 32 views 3 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
How to use MAX Date in OTBIContent Hi I'm getting multiple work relationship records, I would like to return only the latest work relationship record. How can use MAX function to select the latest…User_2025-02-07-19-03-14-525 2.5K views 8 comments 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
Pie Chart Percent Display OverlapContent Hi - I need to display the percentage for each pie chart slice in an OTBI report for export to powerpoint, but some percentages overlap when displayed. Is there …Julia SRI International 66 views 2 comments 0 points Most recent by Ms_Oracle Reporting and Analytics for HCM
-
Workforce Learning - Learning Management Real TimeSummary: Can anyone please help me with the table names that is being used in this subject.we have requirement to convert the OTBi to BIP Reportminati_behera-Oracle 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
workforce management - worker assignment real time returning in correct dataSummary: We are maintain an OTBI analysis which fetches Core HR details adding Grade Step column is fetching incorrect details. PFA snippet for more details Please let m…Manoj Kumar S 32 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Placing a Report Job on HoldSummary: Content (required): I have a report in OTBI that is scheduled to run every Monday morning. I would like to place the job on hold for the next month (December) a…Annette M 21 views 1 comment 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Sample CSV file for Purging Learning recordsSummary: Content (required): Hi there, I am looking for a sample csv file for purging Learning records Is there any available? Thanks in advance. Bobby Here is the featu…Bobby Jourdan 21 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
How to associate an historical event State within a particular Phase in "Recruiting - Recruiting EveContent The requirement is to calculate totals based on Phase/State of historical events for auditing purposes. For example, in a "Job Application Status History" analys… -
Changing Ownership of Scheduled AgentsSummary: We recently had an employee leave the company who was the owner of the majority of our reports and scheduled agents. In an effort to safe time, is there a way t…User_2025-02-11-00-58-38-371 23 views 1 comment 0 points Most recent by Paidiparthi Ravindra Reporting and Analytics for HCM
-
Fiscal Year, quarter and Month in OTBI reporting as a parameter and also as a fields.Summary: We have a requirement to report Employee Details based on Fiscal Year, Fiscal Quarter and Fiscal Period. In the subject Area Workforce Management Assignment Eve…Venkateswaran Murali-Oracle 500 views 2 comments 1 point Most recent by Venkateswaran Murali-Oracle Reporting and Analytics for HCM
-
Dashboard with two Prompts: Selecting a value in the first Prompt changes the value in the second PrContent Hello All, In the dashboard “Performance Evaluation Comparison FCU Second Half”, there are two different Prompts, each Prompt uses the same field in OTBI "Perfor…
-
How to map an Subject Area Field to an Oracle tableSummary: I am trying to find the table that holds the company name for our contingent worker the field that I am trying to map to SQL is I thought the data would be in t…User_2025-02-04-08-51-08-912 31 views 9 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Is it possible to display contents of CLOB column in OTBI analysis?Content Is it possible to display contents of CLOB column in OTBI analysis? I am adding a CLOB column to an OTBI analysis but it comes up with blank. When I query the sa…User_2025-02-11-06-57-37-559 156 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Termination - reporting offboarding commentsSummary: Content (required): We are trying to create a report that selects all terminated employees within a date range, along with the term action reason. Many times ou…Annette M 61 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI report logic to fetch Employees who were in current position as of 1st June,2019Summary: We have a requirement to create an OTBI report which will fetch all Employees who were in current position as of 6/1/2019. I was looking at the subject area - '…Sovan Mishra-Oracle 123 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report on all the comments that the enrolled users have done in Enrollee Self-service conversationSummary: Content (required): Hi there I want to run a report on all the comments that the enrolled users have done in Enrollee Self-service conversation in a course. Is …Bobby Jourdan 11 views 2 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM
-
How to find 'User Defined Column' within Compensation PlanSummary: Can anyone help locate this field within a Compensation Plan. I need to find "Numeric Column 18", preferably within a Subject Area or if it's only within a tabl…Andrew_Schmitz 33 views 5 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Join "Approval Notification Archive Real Time" & "Transaction Administration Real Time" subject areaSummary: How to join Human Capital Management - Approval Notification Archive Real Time & Human Capital Management -Transaction Administration Real Time subject area Con…Nikhil Bhandari 332 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unable to find Filing Status, Allowances and Exempt fields in OTBI in 19CContent Hi All, We are unable to find the "Filing Status" , "Exempt" and "Allowances" fields in "Payroll - Calculation Cards Real Time" OTBI subject area. When we click …
-
Subject Area filtering - empty valuesSummary: Subject Area filtering - empty values Content (required): Subject Area filtering of Assignment Type filters out empty values as well. For example, if we have pe…User_2025-02-11-21-40-21-159 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Data StrategySummary: I am in need of running a report that pulls how many minorities in a certain grade were promoted to an officer status. Please help guide me to the correct subje…User_2025-02-11-00-58-38-371 23 views 2 comments 0 points Most recent by User_2025-02-11-00-58-38-371 Reporting and Analytics for HCM
-
Need sample analysis/SQL to get various balance values for each assignment for EE with multiple GTSummary: When global transfer happens for any employee, we need to validate various balances to confirm if they are transferred to the new LE. During a year if an EE is …
-
Average Salary for Job over TimeSummary: Need average salary for a job code over time Content (required): Is it possible to look at average salary for a job code month over month? Version (include the …Riti Malhotra 21 views 12 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Report on 'Ad Hoc' feedbackContent The business has decided they want the option to give feedback without the one receiving the feedback being able to see it (don't ask me why). We've advised the … -
How to use the Min aggregate function along with group by clause in OTBI analysisSummary: I have a requirement to build analysis to fetch all the benefit enrollment data for a participant as well as dependent. I need to fetch the actual enrollment da…
-
Turnover for a Certain PeriodSummary: Is it possible to report on period start headcount and period end headcount for anytime period instead of month start and month end from the Workforce Trend Rea…Anita 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Year to Date Turnover FilterSummary How to return Year to Date (YTD) this year vs. YTD previous years for turnover metrics.Content I'm trying to return year to date turnover and compare it against …Ryan_Sullivan 27 views 3 comments 0 points Most recent by Ryan_Sullivan Reporting and Analytics for HCM -
Reporting on Area of ExpertiseSummary Reporting on Area of ExpertiseContent The Talent Profile - Me > Career Performance > Skills and Qualifications Includes an Area of Expertise section and we would…User_2025-01-23-21-24-21-434 89 views 2 comments 0 points Most recent by dwi Lestari-Oracle Reporting and Analytics for HCM