OTBI
Discussion List
-
How to remove Grouping of data in OTBISummary How to remove Grouping of data in OTBIContent I have Created a report to fetch the absence Entries for a Person.And in the Prompt i am using Start date column. i…User_2025-02-05-02-11-29-794 118 views 5 comments 0 points Most recent by Mark Johnson Reporting and Analytics for HCM -
Analysis of seeded HR dash boardContent Hi Team, Can any one know where to find the analysis of seeded HR dashboard ? We have checked all the folders in reports and analytics.User_4VVG2 74 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Element Entry ReportSummary Element Entry ReportContent Hello Experts, Wondered if anyone could help with xml/sql that will help me pull out all the element entries against all employees (i…Ramson Maseko 339 views 3 comments 0 points Most recent by User_2025-01-28-05-11-13-165 Reporting and Analytics for HCM
-
Totals for Amount fieldSummary How to subtotal a field that does work when using "Totals After"Content Hello Experts, I am trying to create a subtotal of a field called "Amount" from "Benefits…User_2025-01-29-23-59-58-976 51 views 6 comments 0 points Most recent by User_2025-01-29-23-59-58-976 Reporting and Analytics for HCM
-
Using Distinct for OTBI reportsSummary We want to see only one result for specific areasContent Hi All, I have one report about absences and balances which belongs departments. We used Sum for some sp…User_2025-02-04-18-26-11-309 1.2K views 6 comments 1 point Most recent by User_2025-02-04-18-26-11-309 Reporting and Analytics for HCM
-
Recreating HR dash boardContent Hi Team, Since the HR dash board willnot availabe after the latest patch, We are recreating it. We are facing following issue, 1. In one of the choice list "maxi…User_4VVG2 29 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
HCM - Business Intelligence: Using OTBI Hierarchies -- September 14, 2017, 9 a.m. PT - Submit QuestiContent Submit your questions for the HCM - Business Intelligence: Using OTBI Hierarchies session to have them answered during the live event. Post your questions by pos…Gail Langendorf-Oracle 101 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Delivered Analytics on Pay Equity InformationContent Hello again customer connect community! I'm looking for information regarding delivered analytics in cloud HCM OTBI or your experiences reporting on pay equity. …User_2025-01-22-19-43-38-766 45 views 8 comments 0 points Most recent by Lauren Owen Reporting and Analytics for HCM
-
OTBI Agent not sending some of the recipients emailsSummary OTBI Agent not sending some of the recipients emailsContent Hello, One of the recipients mails in agent - is not being sent , ALL other mails are sent . what cou…Revital Mefano 125 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Manager Assignment vs Worker Assignment in OTBISummary Manager Assignment StatusContent Hi Team, I know there are a few Manager's information fields available in OTBI but I could not find Manager Assignment Status, f…Alvaro Couto 66 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Top Manager field not populatedSummary Some employees are missing a Top Manager so they don't appear on reportContent Does anyone know how the Top Manager field gets assigned? I pulled it into a repor…User_2025-01-28-20-43-56-568 39 views 6 comments 0 points Most recent by Linda Dunn Reporting and Analytics for HCM
-
Loan 401K Accrued BalanceSummary Trying to find where the Loan 401K accrued amount is stored in OracleContent Hi, We have a number of 401K Loans and due to the way we process thru our vendor we …Raz Baboorian 57 views 1 comment 0 points Most recent by VijayaBaskar Ranganathan Reporting and Analytics for HCM
-
Error when Migrating Custom Subject Area ContentContent Hello! I migrated over my reports from one test environment to another test environment by using Archive/Unarchive. My reports have some custom columns that are …User_2025-01-31-00-25-12-234 39 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Prompt Search Edit functionality for BIP reportsSummary How to achieve the prompt search edit functionality for BIP reports similar to one available in Analysis ReportsContent How to achieve the prompt search edit fun…
-
HR Reporting ProxyContent Hi - I have a report that we pull location information from our work structures area. Fusion > Workforce Structures > Manage Locations | scroll down to Legislati… -
Which Subject Area holds the EmailAddressIdContent Could anyone tell me which subject area I can find the EmailAddressId? I need this to update email addresses through Data Exchange for the full version of HCM Da…Rebecca Smith-27468 57 views 6 comments 1 point Most recent by Ema Johnson-Oracle Reporting and Analytics for HCM
-
Legal Employer Hire Date in OTBI ReportContent User is creating OTBI report using subject area "WorkForce Management - Work relationship Real Time" subject area. But user is not able to find any column for "L…Nidhi Chhajed 133 views 4 comments 0 points Most recent by Nidhi Chhajed Reporting and Analytics for HCM
-
Issue in Intro Period Status Burst Report - Performance ManagementContent Hi All, we are facing an issue with an OTBI Analysis Report 'Intro Period Status Burst Report' in Production. Issue Description: When the report is run for recen…User_1B10X 18 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Users Preferred Timezone reportSummary Listing timezones set up in User's preferences by UserContent Hello Everyone, I found this script in one Oracle Support documents but I can't run it as it is sho…Alvaro Couto 67 views 4 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM
-
Bulk fetch failed. (HY000)Summary While casting date in the filter criteria getting error for BulK Fetch Failed - OTBIContent Requirement - Service Anniversary report (Need to get the Employees d…
-
How we can export data from Infolets ?Summary If a table is displayed at expand view and we need to export it. Is there any way ?Content Hi All, We are displaying the data of manager reportees on the expand …
-
Percentage of columnSummary Need to calculate a percentage off Median salary by various attributesContent Attached sample. I can get the first 4 columns. However, I can't come up with the r…Mike Borghoff 59 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there any easiest way to find the Fact/Measure columns in OTBISummary Is there any easiest way to find the Fact/Measure columns in OTBIContent Hi Team, I am looking for the easiest way to find the Fact/Measure columns in OTBI inste…User_2025-02-04-07-00-18-658 227 views 6 comments 0 points Most recent by User_2025-02-04-07-00-18-658 Reporting and Analytics for HCM
-
Calculations - level downContent I need to build three charts that hinge off one another: 1. Average or Median salary by Gender/BU/Management level. 2. From the chart above, I need to just get a…Mike Borghoff 41 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
BI Publisher, Bursting Template ConditionsSummary Only show second page of template if condition is metContent Hello I am bursting a letter to colleagues telling them the outcome of a pay review. The template ha…User_2025-01-31-17-49-32-187 53 views 5 comments 1 point Most recent by User_2025-01-30-21-52-52-008 Reporting and Analytics for HCM
-
Is SFTP possible in OTBI AgentsSummary Is SFTP possible in OTBI AgentsContent Hi Team, Is there a possibility of sending output file to third party by using SFTP in OTBI agents. Regards, Chaitanya.User_2025-02-04-07-00-18-658 61 views 4 comments 0 points Most recent by User_2025-02-04-07-00-18-658 Reporting and Analytics for HCM
-
Monthly Headcount by Assignment Status for each MonthSummary Monthly Headcount by Assignment Status for each MonthContent The business is looking for Headcount by Month by Assignment Status. I tried using the Workforce Tre…Preston Schultz 53 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Auditing Hierarchy Loops in Department TreesContent Hi Guys, Does anyone happen to have a report that is able to show hierarchy loops within a department tree? We do currently have a report that shows which manage…Ivy__Valverde 35 views 3 comments 3 points Most recent by Ivy__Valverde Reporting and Analytics for HCM -
Autopopulated Prompt with Current_Date (SYSDATE)Content Hello everyone, We have a OTBI dashboard that contains analysis that is running As-Of date parameter. As-Of reporting was set up by adding SET VARIABLE PARAM_EFF…User_KOLMZ 242 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Backend Table column value for Ethnicity "Not_disclosed"Summary Ethinicity "Not_disclosed" backed table column valueContent Hello, Im trying to find Backend Table column value for Ethnicity "Not_disclosed". Attached is the sc…