OTBI
Discussion List
-
How to pass Run Time Parameter in Logical SQLSummary How to pass Run Time Parameter in Logical SQLContent Hi Team, I am working on one Logical SQL in OTBI. Report is working fine but i could not bale to pass run ti… -
In OTBI Report How can we defaulft 'Value Suppression' as Repeat in ColumnSummary In OTBI Report How can we defaulft 'Value Suppression' as RepeatContent Hi, While defining the OTBI analysis the default value for Suppression is Suppress, and t…Farooq Syed, CPA, PMP, CISA 50 views 13 comments 2 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Drill downs in OTBI Direct Database Query reportsSummary Drill downs in OTBI Direct Database Query reportsContent Hi I have created a Direct Database Query report in OTBI which displays the employee counts joined in ea…SuryaMuralidharan 72 views 6 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
BI Author - Who should have the power?Summary Who is the targeted audience to receive teh BI Author role?Content Hello Experts, I have a bit of an abstract question and I'm looking for your opinions and to g… -
Download/Export from OTBI AlertContent Hi! I think this has been asked before, but is there any functionality or planned functionality to have a download/export from the OTBI Alert as attached? We are…User_2025-01-31-00-25-12-234 67 views 4 comments 4 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Report Returning Duplicate RowsSummary Learn Report on Evaluation Responses is returning duplicate rowsContent Created a report on responses to Learning Evaluations, but it is returning duplicate rows…User_2025-01-28-20-43-56-568 99 views 5 comments 0 points Most recent by Tom Strudley Reporting and Analytics for HCM
-
Annualized TurnoverSummary Does anyone have a report that calculates annualized turnover by month?Content I have a table that calculates Turnover Rate by month but our management team is l…User_2025-01-28-20-43-56-568 143 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Employee Hire Date field in "Workforce Management -Person Real Time. Worker" Subject AreaSummary I used "Workforce Management - Person Real Time"."Worker"."Employee Hire Date" field in many OTBI reports. Now we are in 19 B and I can't find that field anywher…Elina Ovetsky 46 views 2 comments 0 points Most recent by Elina Ovetsky Reporting and Analytics for HCM
-
How to pass dynamic URL in Action Links in OTBIContent We are trying to navigate to WebPage via action link in an OTBI analysis. The problem is when we will migrate this analysis from one instance to another we have …
-
OTBI Cross Subject Area Analysis - Performance Goals and Feedback NotesContent Good afternoon, We are looking to build out an OTBI report where we tie performance goals to feedback notes related to the goals. We have attempted to build a cr…User_2025-01-23-23-27-03-729 88 views 4 comments 0 points Most recent by User_2025-01-23-23-27-03-729 Reporting and Analytics for HCM
-
Subject Area for Custom Objects - UDTs and Lookups etcContent Do we have Subject Areas separately to handle/report on UDT and Lookups? I know we have some thing for UDTs -' Payroll - User Defined Tables Real Time'. But this…Vibha Pandey - Oracle 286 views 2 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Department Hierarchy ProblemSummary Having problems with Org/Department Roll-up FilterContent All, I am having a problem creating a reliable Org or Department roll-up filter in my dashboards. I use…Charles Egegbara 134 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Show Every Other Label on a Graph AxisContent I'm sure there's an easy way of doing this that I'm missing. I have a line graph showing our FTE trend over the last 12 months. I don't like the look of the x-ax…Lauren Owen 34 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Termination counts on graphs don't match Term detailSummary Created multiple reports for Terminations year over year but noticed the counts don't match that are reflected on the graphs versus what is in the detailed repor…User_2025-01-28-20-43-56-568 32 views 4 comments 0 points Most recent by User_2025-01-28-20-43-56-568 Reporting and Analytics for HCM
-
Pull date from prior rowSummary performance task number of days spentContent The start date in this is an excel field I manually created. Essentially, as people move thru the performance review…Mike Borghoff 36 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Benefits Status Report to monitor new hires who do not make benefit elections at all.Summary How will we be able to discern between a true waive and someone who has not touched enrollments?Content Is there away to query out employees who never went into …Vishal Gala 52 views 2 comments 0 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM
-
Removing Rich Text Formatting from OTBI AnalysisContent Morning all, Can anyone suggest any ways of removing any formatting from text fields in OTBI? I'm trying to export our Goal Descriptions / Success Criteria / Com…User_2025-01-28-05-39-23-766 70 views 3 comments 1 point Most recent by Karen Waddell Reporting and Analytics for HCM
-
County or District in OTBI AnalysisContent Can we get the County or District, which are additional attributes in Address, on an OTBI analysis.Vibha Pandey - Oracle 37 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Prompt: Realize a prompt filter beetween effective star and end dateContent Hi Guys, It is possible realize a date column in the prompt that allow me to show the rows in the report where the inserted date is between the effective star da…Giuseppe Iacono 66 views 5 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM -
Goal Measurement ID in OTBIContent We are looking to confirm if 'Goal Measurement ID' exists as a reportable object in the Goals subject areas in OTBI. We are working on creating an HDL spreadshee…User_2025-01-23-23-27-03-729 23 views 7 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Termination Report based off Entry DateSummary Business need to create a termination report based off of entry dateContent Hello, Has anyone created a Termination Report that looks off of the termination/acti…User_2025-01-31-00-25-12-234 99 views 9 comments 1 point Most recent by User_2025-01-28-20-36-10-715 Reporting and Analytics for HCM
-
How to pull Rate Name in Reporting?Summary How to pull Rate Name in Reporting?Content How do we pull rate names tied to employees benefits in analysis reporting? I have added the Benefits - Enrollments Re…
-
Employee Self Service: how do you show employees their salary history?Summary Employee Self Service: how do you show employees their salary history?Content Hi, Our team would like to display an employee's own salary history on the Personal…Matthew Grillo-95429 122 views 5 comments 1 point Most recent by Kalyan Amaravathi Reporting and Analytics for HCM
-
Employee not appearing on report; issue appears to be related to Top Manager Name fieldSummary Recreated current report with filter on the impacted employee to identify why she is not showing up on report. When I pull in Top Manager Name field, I get no re…User_2025-01-28-20-43-56-568 47 views 5 comments 0 points Most recent by User_2025-01-28-20-43-56-568 Reporting and Analytics for HCM
-
50,000 Cell Excel Export limit from OTBIContent My current client's Pods seem to have a 50,000 cell limit on exports from OTBI into Excel. I've never come across this restriction with previous clients, and for…User_2025-01-25-01-23-28-110 182 views 8 comments 1 point Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM
-
BI Report to achieve SANDWICH ABSENT DAYS CASES.Summary BI Report to achieve SANDWICH ABSENT DAYS CASES.Content BI Report to achieve SANDWICH ABSENT DAYS CASES. Please Kindly Help us to achieve these scenarios in BI R…Radhika Yalamanchili 29 views 2 comments 0 points Most recent by Radhika Yalamanchili Reporting and Analytics for HCM
-
GenerateHead Error when writing Employee Changes ReportContent I have an employee changes report that runs fine until I try to add two additional fields to it (Cost Center and Manager Name). Now I'm getting a GenerateHead er…Lauren Owen 26 views 3 comments 0 points Most recent by Parthiban Vaithiyanathan Reporting and Analytics for HCM
-
Worker Assignment Event - Created ByContent Hi, I am interested in finding out which user created the assignment event. I get the user "FUSION_APPS_HCM_ESS_LOADER_APPID" created this. How would I find out …User_2025-02-01-04-05-22-904 55 views 9 comments 0 points Most recent by User_2025-01-28-16-10-52-033 Reporting and Analytics for HCM
-
OTBI Reporting of the new Onboarding FeaturesContent We are looking at alternative designs for OTBI support for the new Onboarding feature and we'd appreciate your input. The existing Workforce Management - Checkli…Julian Challenger-Oracle 139 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Subject Area for Onboarding TaskContent Hi All, Is there a subject area to pull the data from the Me-->Quick Actions-->Onboarding Tasks for the pending workers. I tried using the subject area: Workforc…