OTBI
Discussion List
-
HR self-service reporting in Oracle HCMSummary: Content (required): Hello everyone, I wanted to ask about the possibility to have HR self-service reporting in Oracle HCM, i.e. the possibility for HR users to …Maria Xydopoulou 65 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Deeplinks in OTBI and BI ReportsContent Is there a way we can use the Deeplinks in the OTBI and BI reports dynamically. Suppose I have a column for 'Person Number' and I click on a particular person nu…Amrit 126 views 8 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Properties Attribute "Read Only" - what does it do?Summary: Properties dialog box -> Attributes section -> Read Only Content (required): Hi All, If I adjust the attributes section to "read only" in the properties dialog …William_Johnson 24 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Parameter not working when embedding OTBI AnalysisSummary: Embedded an analysis on HCM page but it seems that the binding variable is not being received by the analysis because the report is not being filtered Content (…Jezreel Furagganan 65 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM -
Why OTBI Analysis not giving correct manager details in output ?Summary: OTBI analysis not giving correct output in one environment but working on other environment Subject Area : Workforce Management - Worker Assignment Real Time Co… -
Seeded line manager dashboards for executive leadershipSummary Dashboards for executive leadershipContent We have made a copy the of seeded line manager dashboard and modified it to work with our system configuration and req…User_2025-02-10-08-27-16-805 99 views 12 comments 0 points Most recent by Deborah A Reporting and Analytics for HCM -
How to get Home email and business email addresses in OTBI reportingSummary: How to get Home email and business email addresses in OTBI reporting? Content (required): We are trying to get employees home email and business email addresses…Abhishek Jois 569 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
COUNT IF in a columnSummary: Replicate the COUNT IF condition in a column Content (required): Hi All, I need to replicate this KPI in a column of analysis: In details, I don't find the corr…Andrea Rubino 88 views 2 comments 0 points Most recent by Andrea Rubino Reporting and Analytics for HCM -
Transaction Detail - TerminationSummary: Terminations used to pick up in our transaction detail report but it seem to had stopped working from 22D. Content (required): Is there another way to create a …Ratha Sun 37 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How should I calculate the employee's seniority?Hi, I have a query where I calculate the seniority of the employee and I want to sort by the highest seniority. The query works like this if the 'Seniority Reference Dat…Cansel Karasoy 47 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
how do I define datesSummary: I am trying to fun an agent weekly and want to have it select a date range Content (required): the job will run every Friday morning and needs to include employ… -
Open/filled position management reportingSummary Delivered Position Incumbents report returns terminated employeesContent Hello - There's a requirement to create a report of all current filled/open positions wi… -
OTBI:Market Data: No data in report when columns from Global HR dimensions are usedSummary: Guidance to ensure that Market Data reports return data when Global HR dimensions are used. Content (required): 1- Subject Area: "Compensation - Market Data Rea…Abhishek Dixit-Oracle 66 views 3 comments 1 point Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Combining fields into one field or cell in OTBIIs it possible to combine all the columns and rows (per person) under Question Text, Response Answer and Response Text in one field? From this To thisEm-Jay 16 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Need to know Progress Summary Reason Table/Subject area nameSummary: Need to know Progress Summary Reason Table/Subject area name Content (required): We are unable to find Progress Summary Reason field either in the Recruiting - …Visu 48 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Infolet Report Failing / Erroring with Direct and Indirect Reporting LineHi all, I'm hoping someone can tell me if what I'm trying to achieve here is possible. The report itself should look at anyone who has learning that's due and then apply… -
I want to restrict the values for prompt in OTBI reports.Summary: I had applied a prompt for customer contract name in OTBI report, it is fetching all the values present in that column but I need to fetch only those values tha…Yashdeep 39 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
how to change columns as rows in below requireimentSummary: Hi Team, In OTBI how change annual accrual and carry over coulmn into row we need . Any one help me on ? Content (required): Version (include the version you ar…AjayKumar Maddipati 85 views 20 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How to change the date format in OTBI analysisSummary: I need to change the date format of OTBI analysis into mm/dd/yyyy format. I tried to do it using the column properties following below post. But it's showing 00…Ayesha Iroshani 1.2K views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
We need Work Schedule Name, Work schedule start date, Work schedule End date on OTBISummary: Hi Team, we looking below columns in OTBI subject areas May i know which subject area available? Thanks, Ajay Content (required): UI: Version (include the versi…AjayKumar Maddipati 39 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Phase Sequence Number doesn't match CSPSummary: Phase Sequence Number doesn't align with the CSP we've defined. Content (required): We have defined candidate selection phases for our job application progressi…Rob F 26 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI Dashboard ErrorSummary: Error Codes: OAMP2OPY:U9KP7Q94 Path not found - Check the input path entered. Content (required): When running the dashboard, error appears. This only happens t… -
Agent not sending report to application roleSummary: We have selected Application roles as the recipients for the scheduled agent, but the emails are not sending to anyone in these roles. However, If I list an ind…THawkins_LGI 25 views 2 comments 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
How to compare Salary Minimum to Grade Rate MinimumSummary: I have an Analyses that uses Compensation - Salary Details Real Time and Workforce Management - Grade Rate Real Time subject areas. The requirement is to compar…JHaden3 15 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI folder and column name Contract InfoSummary: Content (required): Hello, do you know in which folder or the column name in OTBI for the highlighted columns (Contract Info)? Kind Regards, Valerio Version (in…Valerio Curzi 58 views 8 comments 0 points Most recent by teresa.marciano Reporting and Analytics for HCM -
How can we track the changes made in Performance Goals using OTBI?Summary: Hello, Does anyone know how to fetch all changes made in Performance Goals using OTBI? Your help is highly appreciated! Regards, Hazel Content (required): Versi…Hazel De Castro 35 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Setting Access Role to DashboardSummary: I am needing to add access to a Dashboard to a certain role, but the role I want isn't an option in the dropdown. Content (required): I have created a dashboard…Aaron Reynolds 101 views 2 comments 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM -
OTBI Report to fetch all changes done for goalsSummary: Hello, Does anyone know how to fetch all changes done for goals? ex: change of description/goal name Regards, Hazel Content (required): Version (include the ver…Hazel De Castro 26 views 2 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM -
OTBI Report: Interaction note - Start Date ChangeSummary: We tried to create a report which includes the field Interaction note = Start Date Change, has anyone created one that works? Content (required): We tried to cr…Jessie Gee 59 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Report - Width column for development goalsSummary: Hello, Does anyone know how to fetch width column for development goals? Content (required): Version (include the version you are using, if applicable): Code Sn…Hazel De Castro 16 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM