OTBI
Discussion List
-
Deriving IS Manager column in OTBISummary Deriving IS Manager column in OTBIContent Hi ALL, I'm building OTBI Report. And I want to derive column "IS MANAGER" ( Note we are not maintaining in WorkerAssig…User_2025-02-07-19-03-14-525 53 views 4 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
How to get SalaryId information from ReportingContent Hello experts, I have noticed that in Compensation subject areas I cannot retrieve the SalaryId information. I need this information to massively correct Salary …Valerio Curzi 37 views 1 comment 2 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Get the list of persons included in an Access Group for a Learning OfferingContent Hi everybody, for an Offering in the Learning Catalog I have created an Access Group. I would like to extract from HCM tables the list of persons that are includ… -
Talent Pool DashboardSummary Example of a Talent Pool DashboardContent Hi, Does anyone have an example Talent Pool Dashboard which they are able to share? Regards, Karen Waddell Version Rele…Karen Waddell 89 views 3 comments 1 point Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
How to Incorporate a Person Number Dynamically in the "Email Subject" using OTBI AgentContent We are trying to trigger an email alert using OTBI Agent, with a subject line which should pick up the person number from the analysis we have created. However, …Tejaswini-Oracle 54 views 3 comments 1 point Most recent by Tejaswini-Oracle Reporting and Analytics for HCM -
Filter Formula to automatically fill in the Hiring Manager based on user logged inSummary Is there a formula that will auto-populate a filter based on the user logged in (running the report)Content I am developing an additional tab within Hiring to po…User_2025-02-06-12-05-09-447 43 views 9 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM
-
Rel 20B (11.13.20.04.0)-> No data for Pending Workers in 'Workforce Management - Checklist Real TimeContent HCM OTBI Prod Dev Team, Can anyone please confirm if the issue documented in Doc ID 2600452.1 (https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-…SantoshKumarBhairi 40 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to ensure a Manager is not seeing their own data when viewing a dashboard reportSummary Is there a way to ensure a Manager can't see their own data when viewing a dashboard report?Content Is there a way to ensure a Manager can't see their own data w…User_2025-01-28-20-43-56-568 19 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Restricting Access to OTBI Dashboards / Reports not Working as ExpectedSummary Restricting Access to OTBI Dashboards / Reports not Working as ExpectedContent Hi, We use Custom Roles and have configured the following: - Employee Role: No Acc…Karen Waddell 123 views 26 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
No fact table exists at the requested level of detail (Assignment and DoR SAs)Summary [nQSError: 14025] No fact table exists at the requested level of detail (Assignment and DoR SAs)Content Hello, Just wondering if anyone faced this type of issue …SantoshKumarBhairi 57 views 19 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Changed username and now user cannot login to OTBISummary Changed username and now user cannot login to OTBIContent Hello, We had to change the username for an existing user and now the user is unable to login to OTBI. …User_2025-02-04-15-06-22-759 150 views 8 comments 2 points Most recent by Robert Fighiroae-Oracle Reporting and Analytics for HCM
-
Prompt - put conditions on promptSummary I use Display Name and want to filter only employeesContent Hi, I need to limit the prompt on "Display name" to active employees only. I added a SQL statement bu…Nicola Petri 47 views 2 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM
-
Formatting Code appearing in some columnsSummary Success Criteria & Comments ColumnContent Hi, I've just ran a Goals reports from the Workforce Management - Goals Tasks Real Time and found lots of formatting co…User_2025-02-05-22-44-35-842 31 views 6 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Nice look and feel outcome when NO result in OTBISummary How to display a nice page in case of NO result in OTBIContent Hi, do you know if there is some way to display a courtesy page if no result in a OTBI analysis? T…Nicola Petri 45 views 4 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Infolet for Personal InformationContent Good Day All, i have created numerous infolets in the new UI and all work fine. One of the infolets is for Length of Service. Now if you are a Line Manager you w…CB Trett 88 views 4 comments 2 points Most recent by Swati SinghVerma Reporting and Analytics for HCM -
OTBI CapabilitiesSummary OTBI CapabilitiesContent Hi Experts, I hope some of you will agree that although OTBI has advanced features and capabilities still some consultants prefer to use…AshishERPCloud 307 views 5 comments 4 points Most recent by Kalyani Koylada Reporting and Analytics for HCM -
New Hires in last 90 daysSummary New Hres reportContent Hi, I've found some examples of new hires report where the TIMESTAMP formula is -1 to show hire in the last year. How do I modify it to sh…User_2025-02-05-22-44-35-842 58 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Salaries in WordsSummary I Need to put in Word Template the Salaries in wordContent I need to put in template WORD (bi publisher) , the salary in full (Words) can someone help me?Jorge Donaire-229567 54 views 8 comments 1 point Most recent by Sahil Makhiza Reporting and Analytics for HCM
-
Employee, Manager, Department Head ( Director & up ) and Division Head ( VP & up) in a report.Summary Employee, Manager, Department Head ( Director & up ) and Division Head ( VP & up) in a report.Content HI, I'm planning to build a BI Report having Employee, Mana…User_2025-02-07-19-03-14-525 51 views 9 comments 0 points Most recent by Mishra Ankit Reporting and Analytics for HCM
-
COUNT of new hires and veteransSummary Calculate the count of 2 custom fieldsContent Hi Team, I am calculating the count of employees who are new hires and veterans. Below is the query used which is n…Kalyani Koylada 59 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Action Link on Performance TileSummary Opening detailed report (attached via action link) in separate tabContent Hi All, We are compiling a dashboard which has multiple performance tiles in one sectio…Ankush Rode 60 views 9 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Absence BalancesContent Hi all - I am working on a report to show absences taken during a period of time, and I have it just fine for calculating how many absences someone has taken in … -
Conditional Formatting of Blank Cells not workingSummary I want Null / Blank Cells in RedContent Hi, I have a report (see XML attached) that has 17 columns, some of which have missing data (NULLS). All I am trying to d…User_2025-02-05-22-44-35-842 33 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Department name not available in Position Subject area - causing duplicate rowSummary Looking to report on position listing and incumbent information and getting duplicate rowContent Hi there, I have created a report based on position and have add…Mario B 41 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Future Starters / Pending WorkersSummary Need a list of pending workersContent Hi I'm trying to build a simple report that shows all pending employees (yet to commence employment). Which subject area sh…User_2025-02-05-22-44-35-842 85 views 7 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Manager name for the CEOSummary After promoting an associate to CEO, the former CEO is still seen as his managerContent When our previous CEO retired, he was replaced by an associate within the…User_2025-02-05-12-06-38-063 49 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
sql to use to find out if someone is a line a manager ?Summary sql to use to find out if someone is a line a manager ?Content What sql to use to find out if someone is a line a manager ? We dont use the manager flag at assig…Ruzwan Akram 52 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Involuntary Turnover ReportSummary Involuntary ReportContent Hi, I'm trying to build a report from scratch that will show the number of involuntary leavers and their reasons (e.g. redundancy) etc …User_2025-02-05-22-44-35-842 30 views 5 comments 0 points Most recent by Vis Perera Reporting and Analytics for HCM
-
Date Prompt QuestionSummary As Of Date Prompt QueryContent Hi, I have a number of reports that use the SET VARIABLE PARAM_EFFECTIVE_DATE ='@{AsOfDate}'; that work correctly up to a certain …User_2025-02-05-22-44-35-842 55 views 28 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
YTD MTD QTD Balance reports for 401KSummary YTD MTD QTD Balance reports for 401KContent Hi Team, I heard that we do not have Time to date (YTD,MTD, YTD dimensions in OTBI. I have to fetch 5 YTD values for …SM-Oracle 83 views 3 comments 0 points Most recent by Lisa Ridgely-Oracle Reporting and Analytics for HCM