OTBI
Discussion List
-
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 56 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 58 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 31 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 84 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 29 views 5 comments 0 points Most recent by Vis Perera Reporting and Analytics for HCM
-
Send/Push BIP Report Extraction file to Oracle Cloud Infrastructure (OCI)Summary Send/Push BIP Report Extraction file to Oracle Cloud Infrastructure (OCI)Content Hi All, We need to send/push a Fusion BIP Report using standard scheduler option…Kasinathan Palanikumar - Oracle-Oracle 61 views 1 comment 3 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service -
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 54 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 92 views 3 comments 0 points Most recent by Lisa Ridgely-Oracle Reporting and Analytics for HCM
-
Is there any option to change field name in Data VizSummary Is there any option to change field name in Data VizContent Hi Gurus Is there any option to change the field label in Data Viz (OAC). Like in data set column nam…Saptadip 18 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI - Limit results in a bar graph only out of 10, but not on dataSummary Limit results in a bar graph only out of 10, but not on dataContent Hi all we build a report with several graphs. For the attached graph we need to list the top …Nicola Petri 59 views 5 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM
-
Row limits in OTBI ReportSummary Row limits in OTBI ReportContent Hi ALL, I have created OTBI Report based on Logical SQL. When I run it for one of the employee I see his data being populated wh…User_2025-02-07-19-03-14-525 113 views 9 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Search by OTBI analysis of workers in access groups.Summary Ability to search through OTBI analysis information about the workers who are within the access groupsContent Hi everybody, Does anyone have information on how t…
-
Ship to Org LOV not returningSummary I am able to run a report from the Procure to Pay Real Time subject area and the column returns Organization Name, but the same column in the parameter does not …Ari 32 views 2 comments 0 points Most recent by Alexandra Andrei-73074 Reporting and Analytics for SCM
-
PO line Level total is not showing in subject areaSummary PO Line Total is not available in Procure to pay - Purchasing Subject areaContent HI, PO Line Total is not available in Procure to pay - Purchasing Subject area,…Farooq Syed, CPA, PMP, CISA, TOGAF 32 views 1 comment 2 points Most recent by Gabriel Grigorie-Oracle Reporting and Analytics for SCM -
filtering by custom promptSummary We setup a custom prompt but we need to understand how to link into filtersContent Hi Ladies & Gentlemen, we configured a custom prompt based on following SQL co…Nicola Petri 54 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Master Project and Sub ProjectContent Hi All, We have a requirement to create a master project and sub project, Could any please help how do we create a Master project and its sub project in Oracle P…User_2025-02-06-13-19-17-977 344 views 10 comments 1 point Most recent by Kumar 57 Project Management
-
What is the obj Type and obj key and Action to achieve drill down to 'Manage Project Page' from theSummary What is the obj Type and obj key and Action to achieve drill down to 'Manage Project Page' from the OTBI report.Content Hello Experts, I have followed https://ww…
-
Help with creating filter on analysis for learning initiativeSummary Help with creating filter on analysis for learning initiativeContent Hi Apologies if this is a stupid question... We want to start using learning initiatives to … -
Viewing pending scheduled reportSummary How to view the schedule details for a scheduled reportContent Followed steps from other posts to search in the "hierarchy" view of scheduled processes. I do not…Justin M Roth 32 views 2 comments 0 points Most recent by Justin M Roth Reporting and Analytics for ERP
-
Creating Analysis using Simple Logical SQLSummary Issue with my query - Error getting cursor in GenerateHead (Error Codes: OAMP2OPY:KNYNDVB7)Content Hi All, I would appreciate any help on this issue I have a req…User_2025-02-04-08-51-08-912 76 views 1 comment 0 points Most recent by Gabriel Grigorie-Oracle Taleo Learn