OTBI
Discussion List
-
ORC Candidate Diversity - SummarySummary Getting to one row per job requisition?Content I've created an analysis that uses the delivered counts of applications, veterans, gender, and disability status t…User_2025-02-10-15-34-12-310 149 views 2 comments 0 points Most recent by User_2025-02-10-15-34-12-310 Reporting and Analytics for HCM -
Adding Action link on Performance Document Created vs Not createdSummary Adding Action link on Performance Document Created vs Not created Content Hi, We have requirement to add an action link and display the employee populations in t…Prabhu Krishnamoorthy 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to calculate time from different eventsSummary Calculate time difference between different phases (events) in a recruitment processContent Hi, I´m trying to create a report where I can report on the different…Even Kjorsvik-Oracle 41 views 1 comment 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Scheduled Reports Are Stuck on either "Running" or "Waiting" StatusSummary Scheduled Reports Are Stuck on either "Running" or "Waiting" StatusContent Hi, Our scheduled BIP reports are stuck on "Waiting" or "Running" status, even the one… -
Report on Transactions that failed in BPMSummary Report on Transactions that failed in BPMContent Hi Has anyone worked on creating reports based on BPM tables. I have requirement to fetch the failed termination…User_2025-01-30-21-52-52-008 130 views 6 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for HCM
-
CASE statement THEN valueContent I would like to add a case statement logic where if a condition holds true, a column value is displayed. But in addition to the value being displayed from the sy…User_2025-02-10-08-27-16-805 25 views 2 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Subject Area in OTBI to extract default Expense Account information of userSummary Subject Area in OTBI to extract default Expense Account information of userContent Hi, I am trying to build a OTBI report which has cost center and company infor…Nidhi Chhajed 112 views 9 comments 1 point Most recent by Nitin.Goswami Reporting and Analytics for HCM
-
Ethnicity bar graphSummary Bar graph does not match tabular view.Content I am trying to pull employee ethnicities from the system. I have come across multiple posts on how to bucket employ…User_2025-02-10-08-27-16-805 68 views 6 comments 1 point Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Direct Report Headcount in OTBI?Summary Are there any fields in OTBI which can pull a manager's direct reports / headcount, or otherwise indicate that they are a manager?Content Are there any fields in…Monica Fundak 53 views 3 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM
-
BIP Report Jobs IssueContent Hi all, I asked a couple of weeks ago about changing the privacy of Report Jobs from Private to Public which was answered here: https://cloudcustomerconnect.orac…
-
As of Date Worker ReportSummary OBTI Report with Worker Information as of specific dateContent I am looking for way to build a report in OBTI that contains worker data that can be pulled from a…Mike Householder 29 views 2 comments 1 point Most recent by Mike Householder Reporting and Analytics for HCM -
Reporting on saved goalsSummary Reporting on a goal before it's been approved by the managerContent Hello, We used to be able to report on goals using Goal Status Overview Real Time. The Versio… -
Hire Date using OTBI Reporting (Not to include Global Transfer Dates)Content Greetings, We recently went live with Oracle HCM Cloud in January and we are trying to figure out how to correctly report a hire date using OTBI Analysis reporti…
-
As Of Date reporting and dimensional attributes in OTBIContent Hi, We want to use As Of Date reporting with OTBI. But we are not sure which dimensional attributes will also move to the value at this 'As Of Date'. Will all di…User10137270-Oracle 28 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to load sample report in Oracle HCMContent Hello experts, I need to load a custom template as example in Oracle HCM. I want to load an image showing a sample performance document. In addition, I have crea…Valerio Curzi 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Simple logical sql query fails to load in data modelSummary Simple logical sql query fails to load in data modelContent We were trying to create a data model with Simple query(Name = Any , Data Source = Oracle BI EE, Type…Sreedharan-Oracle 73 views 7 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Customize Rating Distribution graphContent Hello, Would like to know using which analysis the graph is generated on this Performance Calibration page. We have a requirement to cutomize this graph and want…Praneeth K-261878 46 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Absence Calendar Details Real Time - Incorrect Data in ReportContent Hi Experts, We have created a OTBI report in which we are getting the results as per leave type and for one specific leave type, we are getting very small (Incor…Kiran Kancherla 25 views 1 comment 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
how to schedule an OTBI Agent using SoftDates such as: {$SYSDATE()$}Summary Scheduling an OTBI Analysis to run for previous month using {$SYSDATE()$} and {$SYSDATE()-30$}Content Hi, We'd like to schedule an Agent to run monthly, on the f…BDO Sue Cronin 33 views 5 comments 3 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
How to export OTBI report including Personal Photo?Summary Need to crreate an OTBI with Personal Photo and Export successfullyContent Dear Experts: I have builld an Employee List report with Personal photo as a columon. …Mayi218-Oracle 73 views 1 comment 2 points Most recent by Seiichiro Yasui Reporting and Analytics for HCM
-
Latest Assignment ChangeContent Hello, I'm trying to pull the latest assignment change row using the Assignment Event Subject area, but it doesn't seem to be working anymore. In the past I've u…User_2025-01-31-00-25-12-234 137 views 8 comments 0 points Most recent by Ahmed AZA Reporting and Analytics for HCM
-
Organization Levels, Organization Manager Names, and their Effective DatesSummary Organization Levels, Organization Manager Names, and their Effective DatesContent Hi Experts, Good day! Can you please help and guide or redirect me to resources…Raymund Jerome 12 views 4 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM
-
Join two different Subject areas - Workforce Learning - Learning Management real time and WorkforceSummary I am facing error when I tried joining two different subject areas (Learning and Person)Content In OTBI, I cannot able to Join two different Subject areas - Work…Prabhu Krishnamoorthy 55 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
21A Enhancement- HR_DOR_REPORTING_LIST_VSummary 21A Enhancement- HR_DOR_REPORTING_LIST_VContent Do you need to update/fix any security roles after this enhancement in 21A? How do you "control this access" with…Andrew_Schmitz 42 views 3 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
General Preferences OTBI Subject AreaContent Hello All. I am trying to include Language from General Preferences in an OTBI report, but I am not able to figure out which subject area general preferences are…Antoine Richard 49 views 2 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report to show all future approversContent Hi, Does anyone know of a report or way to query, all future approvers in an approval chain for notifications. For example, next approver is person x, then once …
-
Analysis about own Person ProfileContent Hi, it seems that Worker cannot see information about own Person Profile on analysis (Workforce Profiles - Person Profile Real Time). Can we achieve this by cust…
-
Need Employee Leave Balance Report ?Summary Need any pointers/hints for building Employee Leave Balance ReportContent Expected Layout Parameters Effective Date : 06-Jul-2015 Employee Leave Balance Report P…AshishERPCloud 718 views 10 comments 5 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Grouping EthnicitiesSummary Grouping ethnicities after a single row of data has been calculatedContent Hi everyone, Using this post, I was able to successfully get an ethnicity report to re…User_2025-02-11-03-07-51-707 171 views 4 comments 0 points Most recent by User_2025-02-11-03-07-51-707 Reporting and Analytics for HCM
-
Nationality Head Count AnalysisSummary Nationality Head Count AnalysisContent Hi All, May I know if anybody has done head count analysis based on Nationality . Could you please guide me. If I take fro…User_2025-02-06-09-41-56-955 35 views 4 comments 0 points Most recent by User_2025-02-06-09-41-56-955 Reporting and Analytics for HCM