OTBI
Discussion List
-
SQL Query to get HRBP assigned to an employee (when AOR uses organization hierarchy)Summary: We need a query to find HRBP assigned to an employee when Organization hierarchy has been used to assign the AOR(area of responsibility). It doesn't include any…Aloka Bhattacharya 1.6K views 7 comments 1 point Most recent by User_R6F1A Reporting and Analytics for HCM -
OTBI ResourcesContent Resources to help you get the most from OTBI. Training Oracle Applications Analytics Cloud Service Videos (Oracle Learning Library) - many are no longer availabl…Julian Challenger-Oracle 41.5K views 95 comments 118 points Most recent by Dave Chudzik Reporting and Analytics for HCM -
Person real time and Assignment real time securityWe have an OTBI analysis for passport and visa details. It combines the Person Real Time and Assignment Real Time subject areas. One employee has a current assignment in…Stephen Jones 13 views 4 comments 0 points Most recent by Stephen Jones Reporting and Analytics for HCM -
How to report on previous person name in OTBI?Summary: I want to create a report in OTBI, that will show changes of person name - current name and previous name. Content (required): I tried Person Names/Person Names…Maciej Kozakiewicz 184 views 4 comments 0 points Most recent by MJ Surel Reporting and Analytics for HCM
-
Accurate Headcount Reporting in OTBI even after department changeMy goal is to accurately reflect the headcount by department, ensuring that the count includes only active employees, even if they have changed departments. Currently, w…Nithin Nannuri 14 views 2 comments 0 points Most recent by Nithin Nannuri Reporting and Analytics for HCM
-
What is the SA to use for Goals' Published Flag ?Summary: Hello, We need to display in an OTBI report the Performance Goals along with their Shared and Published flags. We are using Workforce Goals - Goal Status Overvi…MariaStanciu 9 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Dashboard passing prompts with url link.Hi, I am creating a OTBI dashboard and i want to generate a link with an url which would be passed through tthe prompt directly. i tried this link but it did not work…MYassikaya 12 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI: HR HelpDesk Request Real Time - Line ManagerSummary: We are creating an analysis report using HR HelpDesk Request Real Time Subject Area with the ff goals: 1. If the Line Manager runs the report, the report should…Garry Parta 3 views 2 comments 0 points Most recent by Vishal Purohit Reporting & Analytics for Fusion Service
-
Future dated benefit groupsSummary: I am trying to create an OTBI report that shows the effective start date and end date of Benefit Groups. The only subject area that I can find that has the bene…
-
OTBI Custom Subject Areas using Application ComposerSummary: Can Customer create custom Subject Areas for OTBI in Fusion HCM using Application Composer? Content (please ensure you mask any confidential information): Highe…AVorster-Oracle 18 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How to identify hires as Internal or ExternalSummary: Using OTBI, I would appreciate recommendations on how to identify hires as either an Internal or an External hire. Thanks! Content (please ensure you mask any c…
-
How to change the date format in OTBI promptSummary: How to change the date format in OTBI prompt. currently we are trying to change the accounting date column to mm-dd-yyyy format but we are getting syntax issue.…User_U4A6A 55 views 4 comments 1 point Most recent by Kuldipsinh Rajput Reporting and Analytics for HCM
-
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…Dasari Dileep 295 views 6 comments 0 points Most recent by Aditya Jadhav Reporting and Analytics for HCM
-
Join multiple subject areas in AnalyticsSummary: Join multiple subject areas to have an outer joint result. Content (required): My users want a dashboard to show the percentage of the employees who set up annu… -
Question on where to fetch seniority dates in OTBI (v1 vs v3)Summary: with the v3 seniority dates in play, we are a bit confused as to where to fetch the seniority date data in otbi. Before we migrated to v3, we leveraged 2 fields…
-
How to identify if a goal has been added from the goal library?Summary: I have created two basic reports showing employee performance and development goals. I want to know how many of those goals have been added from the goal librar…Sarah Cottrell 28 views 3 comments 0 points Most recent by Paul Campanello Reporting and Analytics for HCM -
SQL Query - Pending Benefit Transactions that would prevent Employee TerminationHello, Hope you are well. Does anyone have a SQL query available, that displays any Active/In-Flight/Pending Benefit Transactions which would cause the Termination of an…David Oldfield 10 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Performance Task Status data is emptySummary: Workforce Performance - Performance Task Status Real Time returns the 'No Results' error. I checked and confirm that my role has the FBI_PERFORMANCE_MANAGEMENT_…George Chernikov 6 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
OTBI Report Is Not Showing Any Employee's Absence DataHello Everyone Summary: We developed an OTBI report to extract employee absence details (leave balance, unapproved leaves, total leaves taken, etc.) using the Workforce …Andriampeno Odilon 36 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Employees With or Without Goals Report - Missing dataSummary: Hello again, I need some help on my report. I need a report of Employees With or Without Goals. I created case statements for Total Employees, Goal Status (With…
-
Guidance to optimize OTBI HCM Cross-SA Reports having static report filters1- Some Cross subject area reports may be costly in terms of response time, if they are not designed correctly. It is always recommended to use (i) at least one common d…Abhishek Dixit-Oracle 139 views 2 comments 4 points Most recent by UdayrajSingh Reporting and Analytics for HCM -
Report Date Parameters needed START: (First_Day of Last month) END: (Last_Day of Last_month)Summary: Hi Forum: I'm looking to use below to accomplish General tab for Scheduling a report START: Last_Day(ADD_MONTHS(SYSDATE,-2))+1 First_day END: Last_Day(ADD_MONTH… -
SQL to list all customized OTBI and BI Publisher reportsSummary How to list all OTBI and BI Publisher reports in Shared Folders?Content Hi Team, Does anyone have the SQL that we can run to list all OTBI and BI Publisher repor… -
No results if no filter is appliedSummary: Hi, We have an HR role with access to a compensation OTBI report. In order for the results to be displayed, HR must filter by at least one BU. However, if I ass…
-
How to pass login user name dynamically in the OTBI Report nameSummary How to pass login user name dynamically in the OTBI Report nameContent Hi Team, We have an OTBI report called Direct Reportees of Manager and it's working as exp…Mahendra 462 views 11 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Time card details based on payroll flow - Load Time Card BatchesHi Expects, Requirement : Need to fetch time card details based on payroll flow - Load Time Card Batches. basically OTL report , based on payroll flow parameter. when we…Rajdeep Chavda 73 views 6 comments 0 points Most recent by Om Shukla-Oracle Reporting and Analytics for HCM
-
Hide Schedule and Job option from reportSummary: Hide Schedule and Job option from report Content (please ensure you mask any confidential information): Hello experts, does anyone know how to hide the followin… -
Looking for the Checklist Task Sequence in the Workforce management Checklist Real TimeSummary: Looking for the Checklist Task Sequence field in the Subject Area Workforce Management - Checklist Real Time Content (required): We are looking to add the Check… -
Building an OTBI report using OTL data. Can't find Project RoleSummary: We are building an OTBI report to show all timecard entered for the week. We are project based company so our timecards include Project and task information, in…Anjula Mittal 25 views 3 comments 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM
-
APISummary: Hi Expert, How to get the ( additionalInformationDetailsUniqID)? I have only URL and Offer ID how shall i get the additionalInformationDetailsUniqID? /hcmRestAp…