OTBI
Discussion List
-
How to Fetch the Direct reports of Line Manager as of specific dateSummary How to Fetch the Direct reports of Line Manager as of specific dateContent Hi Team, PFA catalog of analysis. We have created an analysis which we use to pull the… -
Query help needed to determine duration in job code, title, pay gradeSummary Query generates a list of the job code, title and paygrade combinations for an employee with start and end datesContent Hi All, I have seen several queries regar…User_2025-02-04-08-51-08-912 25 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Can't unarchive catalog from Prod to DevSummary Get error message Compression - inflate Error -3 OK when trying to unarchive from Prod to DevContent Hi Apologies if this has been covered before but I couldn't … -
Too much SQL!Summary Prompt not limiting by another field - Support have advised too much SQLContent Hi I'm getting an "unexpected token" error message when trying to limit one field…
-
Regd tracking name change in OTBISummary Regd tracking name change in OTBIContent Hi , We have name change report where we track any changes to person name in past 7 days and display the person's detail… -
OTBI Analysis performance is very slow on Dashboard PageSummary OTBI Analysis performance is very slow on Dashboard PageContent Hi Team, We have created a sample analysis using Worker assignment real-time subject area and it'…Mahendra 177 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI:"Workforce Management - Worker Assignment Real Time"-->Worker"."Previous Last Name"Summary OTBI:"Workforce Management - Worker Assignment Real Time"-->Worker"."Previous Last Name"Content Hi All, When we will see data in the Worker"."Previous Last Name"…User_MC37Q 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Exported analysis output is not formatting correctly in ExcelSummary Exported analysis output is not formatting correctly in ExcelContent Hi Team, PFA catalog file of analysis. We have created an analysis which we use to pull dire…
-
Pull in results from another analysisSummary combine the results from two analysis into one analysisContent Is there a way to combine the results from two analysis into one analysis? I have two separate ana…Shelly Feyerherm 38 views 12 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Salary changes after a particular dateSummary I need a report which will identify employees that have saalry changes after a given dateContent When we apply a pay award (i.e. uplift grade rates) it does not …Esther Hess 88 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to report on Unsubmitted Timecards?Content Has anyone been able to produce a report showing which employees haven't yet submitted a time card in a given period? Any help would be much appreciatedUser_2025-01-28-05-35-00-925 122 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need query to get Termination or Resignation Requests pending for approvalContent Need query to get Termination or Resignation Requests pending for approvalMohamed Salah 885 views 5 comments 0 points Most recent by Mohamed Salah Reporting and Analytics for HCM
-
Assignment Changes on Employment HistoryContent Our organization is working to transition to utilizing the Quick Actions verse Person Management. One feature we use is the “view history” and then "export" on t…Kayla Malecki 265 views 12 comments 3 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Audit and Performance Monitoring for OTBISummary We want to track how many people are using OTBI analyses - looking for audit information similar to that available for BI PublisherContent We have recently set u…Sian S 100 views 6 comments 6 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Delivering OTBI report results to webcenter content serverSummary Is there any way we schedule OTBI reports to deliver results to webserver content server?Content Is there any way we schedule OTBI reports to deliver results to …Mahshid Madani 25 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Inaccessible column: "Organization Hierarchy"."Level 01 Organization Name"Summary Error trying to access Org Hierarchy column with Employee roleContent Hi, We need to access "Organization Hierarchy"."Level 01 Organization Name" column through …Suresh Pallapothu 35 views 2 comments 0 points Most recent by Suresh Pallapothu Reporting and Analytics for HCM -
Starters as at Start DateSummary Data must be returned as at the Start DateContent Hi all I have a starters report that provides me with all the starters between two points in time however the d…Dawn Cawston - CPS 28 views 26 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Development Goals (individual) approval StatusContent How can I get the Approval Status and time approved into Development Goals Status Report. Saw a few recommendations but some seem to be for goal plan for perform…Mike Borghoff 36 views 2 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
EEO reporting with the new check box system for Personal Details?Summary How are you getting around the removal of "Two or More Races" as an option? How are you adapting to multiple choices for ethnicity?Content Hi all, We recently up…CIT Shane 186 views 25 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
BI report based on questionnaireContent Hello, We need to create a BI report using following tables. HRQ_QSTN_ANSWERS_TL HRQ_QSTNR_PARTICIPANTS per_persons Appreciate if some one can let us know how to…User_2025-01-28-21-18-43-496 73 views 4 comments 1 point Most recent by User_X612P Reporting and Analytics for HCM
-
Comparing two datesSummary Comparing two datesContent Hello, I am trying to create a new column whereby I am comparing the effective start date from 'Worker Assignment Event Real Time' sub…Helen Tilling 46 views 2 comments 0 points Most recent by Helen Tilling Reporting and Analytics for HCM
-
OTBI - analysis runs perfectly until I try to add in Manager Name and Person Number from Manager (inSummary OTBI - analysis runs perfectly until I try to add in Manager Name and Person Number from Manager (in Workforce Management - Worker Assignment Real Time)Content B…User_A80ZS 40 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
How to use REGEXP_REPLACE function in OTBI to manage HTML tags in attribueSummary How to use REGEXP_REPLACE function in OTBI to manage HTML tags in attribueContent Hi Team, How to use REGEXP_REPLACE function in OTBI to manage HTML tags in attr… -
How to add a BI Report to a Fusion Page without navigating through Report and Analytics navigator (RSummary The Report should be embedded into fusion application page using create page entry (Link Type: Application Page)Content I want to add a report to Fusion applicat…Somefun 496 views 9 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
BIP - data model joining different data sourcesSummary BIP - data model joining different data sourcesContent Is it possible to join data from two different data sources 1) from a SQL query 2) from an Oracle BI analy…
-
How to add a BI Report to a Fusion PageSummary This document explains how to add a report to an HCM pageContent How to add a BI Report to a Fusion Page This document explains how to add a Salary Range Analyti…Gail Langendorf-Oracle 444 views 4 comments 6 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary How to Find an IP Address of a User who has Logged in Fusion Application ?Content Hey, I have a requirement to restrict the data based on login IP address in BIP… -
Unable to get the Employee payroll calculation card details from Payroll - Calculation Cards Real TiContent Hi All, We are unable to get Employee payroll calculation card details ( State name, county name and city name details) from Payroll - Calculation Cards Real Tim…User_6I33I 255 views 2 comments 0 points Most recent by Prudhvi Indukuri Reporting and Analytics for HCM
-
Pivot tables and calculations for attritionSummary Issue with calculation column in pivot table - total leavers divided by total headcountContent Hello :) I'm hoping someone can help with an issue I am having. I …NusratB 93 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Where can I find Disability Declaration?Content Hello, I am currently building a report in which I need to report on Disability Declaration for all current employees e.g. Yes/No/Not Declared. I have managed to…User_2025-02-10-23-42-02-934 34 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM