OTBI
Discussion List
-
Floater Days not updated with Absence Calendar Details Real TimeHello, I built a report with 'Workforce Management - Absence Calendar Details Real Time' subject area to include Vacations, Floater days; xml attached. I completed Float… -
Fusion analytics report - Oracle pre build columns not yielding correct dataSummary: We are trying to transition the existing OTBI report with subject area — Workforce Management to Fusion Analytics where the column under Fusion analytics - 'Ave…RachitSharma 2 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
BIP Report: How to auto scale a graph in percent to 100Hi everyone, I would like to ask if anyone has a similar report where you were able to plot column values as percentages and scale the graph to display 100%. Columns: - …CAMIL_Q 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Where to find OTBI subject area for Job responsibilityWe're creating a report in OTBI for Model Job Profiles, however we couldn't find "job responsibility" section in the subject areas of OTBI. 24AAnita Andrádi 22 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Salary pay rates are incorrect for some employeesSummary: The OTBI report is showing incorrect pay rate data for some employees for HRA EX and Notional Special Allowance components. We cannot identify why this data is …Ridma Karunanathan 24 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Report on Alerts Composer Notification ReportingSummary: I'm looking to see if there are any OTBI subject areas that can be used to report on the various event notifications that are sent out using the Alert Composer …Rohan Fernandes 237 views 8 comments 2 points Most recent by Unknown Reporting and Analytics for HCM
-
LRU Registration ReportSummary: LRU Registration Report Content (required): Hi Team, Greetings! We have the details for LRU (Legal Reporting Unit) Registration defined under "Manager Legal Rep…Parag Hiremath 75 views 11 comments 0 points Most recent by Chris Carloff Reporting and Analytics for HCM -
In what table can I find Box_Assignment Column from Talent Review?Summary: In the Oracle Fusion Cloud HCM Talent Review module, wherein the Tables and Views for HCM can I find the value for the Box Assignment? Content (please ensure yo…
-
Are there any out of the box reports that would tell me if a Second Pass email was triggeredSummary: Looking for an out of the box report that would tell me if Second pass emails are being sent to applicants. Content (please ensure you mask any confidential inf…
-
Unable to access Recruiting - Recruiting Real-Time OTBI report using the custom roleSummary Unable to access Recruiting - Recruiting Real-Time OTBI report using the custom roleContent Getting below error while accessing Recruiting - Recruiting Real-Time…Venkatraman G 172 views 10 comments 0 points Most recent by Aishwarya_15 Reporting and Analytics for HCM -
Report for a Salary basis of the type "Salary amount is determined by simple components"Summary: We have a Salary Basis defined of the type "Salary amount is determined by simple components" and we have hired an employee with this salary basis. There are 5 …Sachin_Shirke 324 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Headcount is Overstated in Pie Charts when using EthnicityHello everyone! I would like to make a pie chart to show the percentage of each of our candidates by ethnicity. The problem is this: When candidates select multiple ethn…
-
Benefit analysis with benefit plan decline detailsSummary: I have created an analysis following the steps provided by the below post to get details of a benefit plan if any one declines the benefit enrollment. The analy…Ayesha Iroshani 12 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Query to Display the Roles with their Data Security Profiles NameContent Hi Team, Has anyone created any report to display the List of Roles along with their assigned Data Security Profiles. Regards, Harish Vummidi Version 21CHarish Vummidi 165 views 15 comments 1 point Most recent by Mohit_Pal Reporting and Analytics for HCM -
Table for Additional Statuses (Timecard)We have a requirement to get Earned Date, Value, Unit of Measure, Payroll Time Type , Absence Type , Payroll Transfer Status & Payroll Processing Status. We are trying t…Manoharan 48 views 2 comments 0 points Most recent by Nagaraju Godasi Reporting and Analytics for HCM
-
Transpose rows to columns in OTBISummary I need to build a report that shows every employee as a column. Convert all rows to Columns in OTBIContent Hi I hope you can help me. I need to build a report th…
-
How to remove Blank Rows in a report?Summary: Once we export the report there are a few Blank rows at the bottom, is there a way to remove them? Content (please ensure you mask any confidential information)…THawkins_LGI 75 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Embed OTBI in Requisitions responsive PageSummary: Hi, We are trying to embed an OTBI report that will pull in the Job Code for a particular job requisition into the job requisition page. The attempt was to have…
-
Using 2 different subject areas (Salary and Performance Rating) - Getting split/merged cellsSummary: Hi Experts, I'm pretty much a beginner with reporting. My client wants an OTBI report that can pull salary details as well as latest performance ratings (overal…
-
Elements - balance feed "as of" date promptSummary: We are using SQL data model to report on various balance feed items for elements. We have hundreds of elements and need to be able to compare configuration as o…Michelle Hughes 11 views 3 comments 0 points Most recent by Michelle Hughes Reporting and Analytics for HCM
-
Is there a place we can go to get a daily usage statistics for each module showing the persons loggeSummary Management needs this information to make a decision about licence renewal.Version 21BDavid Sakeye 103 views 10 comments 1 point Most recent by Rory Fielding Reporting and Analytics for HCM
-
Reporting Prior Month Data SQLSummary: Can we add SQL to the formula to look at the Prior Month data? So tell it to look at the System date - 1(for prior month) and pull 1st to last date of that prio…THawkins_LGI 42 views 12 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM
-
Using Workforce Management - Worker Assignment Real Time Can't view own record in OTBISummary: we have one OTBI report with SA "Workforce Management - Worker Assignment Real Time". When admin user(non employee) runs this report it pulls all the records. w…User_7A1QO 55 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Report Issue with Candidate Inclusion and ExclusionI'm facing a challenge with the OTBI report. I'm trying to incorporate two sets of logic: Requisitions with candidates. Requisitions without candidates. However, when I …Ranjith Antony MPC 11 views 0 comments 0 points Started by Ranjith Antony MPC Reporting and Analytics for HCM
-
Unable to get the proper count for Assignment Count when I am using two subject AreasSummary: Hi Team, we have requirement to get the count for Nationality to get this column we are using 'Person Real time' Subject Area. and we also have to filter this c…Ashok Dhara 13 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Privileges/Duty roles required to extract Absence data via OTBI AnalysisSummary: Hi Team, Could some one kindly help us on the below requested issue. We are unbale to extract Absence related data from the Subject Area: Workforce Management -…User_2025-02-07-03-03-32-616 193 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Termination category field causes blank rows for OTBISummary: Termination category field causes blank rows for OTBI Content (please ensure you mask any confidential information): Hello experts, we are building a custom OTB…Oriana L. 12 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM -
Restrict parameter value in seeded line manager dashboardSummary: We are using Line Manager Dashboard in Fusion hcm, we have different BUs and we have requirement to restrict business unit & legal employer parameters (LOV) in …
-
How to report Open Requisitions with AS OF DATE parameterSummary: Need OTBI report that shows all open requisitions with an AS OF date parameter. For example, all open requisitions as of 1-1-2022. Content (required): I have an…
-
Cannot see Schedule name in OTBISummary: We have an OTBI report that shows the work schedule assignment using Person Real Time"."Person Schedule Assignment"."Schedule Name". Users with HR admin roles c…Crystal Pace 44 views 4 comments 0 points Most recent by Crystal Pace Reporting and Analytics for HCM