OTBI
Discussion List
-
Incorrect drill-down results (action link to BI content) when using UNION in OTBI AnalysisI've written an analysis against the Workforce Goals - Goal Status Overview Real Time subject area. I had to use a UNION to accommodate some complex criteria and breakou…Shawn Gertler 11 views 6 comments 0 points Most recent by Shawn Gertler Reporting and Analytics for HCM -
How do I report on the field 'Order Reference'In Court Order Calculation Card page, I need to report on the Order Reference field - how and where can this be found?Helen Tilling 1 view 2 comments 0 points Most recent by Helen Tilling Reporting and Analytics for HCM
-
BIP Scheduled Trigger Failing - Help NeededSummary: Hi all, I'm trying to add a schedule trigger to my BIP report that's currently scheduled, but when it runs with the code, it fails with the following message: D…
-
Reporting on assessment attempt scores when there's more than one assessment in the offeringSummary: I need to report on the score achieved for each attempt within an assessment however I find that if an offering contains more than one assessment activity, the …
-
Sql query listing transactions with 'Pending' status with transaction tablesI want display_name and person_number information of records in 'Pending' status from transaction tables.Is there a sample query you can share?Cansel Karasoy 708 views 6 comments 0 points Most recent by Nitin Kashiv-Oracle Reporting and Analytics for HCM -
OTBI Need subject areas with Representative Name to be pulled into reportContent Hi Team, We have captured HRBP in the representative section of Manage Employment. Now I want to capture that information in my OTBI report. But I am not able to…
-
Employees with Manager Change can be viewed in OTBI by the old manager?Summary: OTBI report with the following info: Employees info + performance ratings + worksheet manager name info. This report has been delivered to managers. If an emplo…Oriana L. 3 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report on candidate log-ins for experience siteSummary: We have a requirement to identify the last time a candidate logged into their candidate profile through the external career site. Is there a reportable field in…Audrea Miller 1 view 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
FTE in Compensation Subject Area is not correctSummary FTE value is showing 5 instead of 1Content Hi All, I need your help. I am getting two different values for FTE in OTBI. One comes from Compensation Subject Area …Alvaro Couto 42 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to display Name given Person Number.Summary: We have a DFF tied to Department that has the Person Number of the Executive overseeing the department. The name of the executive (not just Person Number) is of…
-
How to identify Overdue Onboarding TasksSummary: I'm writing an analyses using the subject area Workforce Management - Checklist Real Time. I can see tasks that are incomplete, but I need to report only on tas…JHaden3 72 views 5 comments 0 points Most recent by Ashraya_SN-Oracle Reporting and Analytics for HCM
-
Annualized Full-Time Salary the same value as Annualized Salary for those with <1.0 FTESummary: Within the Compensation - Salary Details Real Time there is an option to pull in both the Annualized Salary and Annualized Full-Time Salary. When checking this …
-
How do we get the Pay Period Month , Year , Max Gross Pay MTD in OTBISummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Is there a way to limit access to the worker assignment real time subject area?Summary: Hello, We have a "Learning Course Owner View All" data role that is essentially a learning admin. They have access to view all learning data including courses, …Tommy Sullivan 5 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need inputs to fetch balance "Reference" field value against balance dimensionSummary: Need inputs to fetch balance "Reference" field value against balance dimension Content (required): In the Employee Payroll balance results we are able to see Ba…
-
Does anyone have a Leadership Hierarchy prompt or guidance on how to create one?Hello Does anyone have a leadership hierarchy prompt? If so can you share some guidance on how it was created? I want to be able to add a leadership hierarchy onto our d… -
Point in Time Headcount with Salary report - isolated doubling of salarySummary Our "point in time" report is mostly working. For a very small percentage, the salary amount is being doubledContent We have a report that is working fairly well…Cheryl Burwell 112 views 7 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
pass parameter in formula in otbiSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…lbodeddula 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Issue occurring that seems to double values in certain fields e.g. FTE and SalaryContent We're experiencing an issue whereby assignment information in certain fields is multiplying; giving us inaccurate data. It's not occurring in the majority of cas… -
About OTBI, BI and EXTRACTSummary: Use cases for OTBI, BI and EXTRACT. When we use Extract, when we use BI and when we use OTBI Content (please ensure you mask any confidential information): Hi T…
-
Display date in a pivot table (both for OTBI and BI Publisher)Summary: Display a date in a pivot table (OTBI and BI Publisher) Content (please ensure you mask any confidential information): Hi, I wish to create a pivot table like s…
-
Viewing reports history submitted by the userSummary: Our target is to see the reports history submitted by all the users in the fusion HCM. Please advise accordingly how can I retrieve this information. Content (p…Azhar SIDDIQUI 1 view 1 comment 0 points Most recent by Azhar SIDDIQUI Reporting and Analytics for HCM
-
Certain talent dashboard is unable to fetch data for talent admin role in Redwood 25B InstanceSummary: In one of the 25B Redwood non-prod instances(eg. instance A) ,the below issue is encountered. There are multiple Talent reports and all are working as expected …
-
SQL query to create value set for Manage Organization Tree Node namesSummary: We need to establish a value set to define the node names under Manage Organisation Tree. Do we have any SQL query to get to get the Node Name? If not please te…
-
Career StatementsSummary: Creating a Career Development's analysis report and I am unable to locate Career Statement in the subject area. Content (required): Looking to add Career Statem…
-
Reporting on Career StatementsSummary Enhanced Talent Profile & Reporting on Career StatementsContent Hi, Prior to upgrading to the Enhanced Talent Profile we used the following subject area and colu…Karen Waddell 87 views 7 comments 0 points Most recent by kamal_sethia_ Reporting and Analytics for HCM -
How to display OTBI report in Journey task "report"Summary: Hi Team, I have a OTBI report and I want to display in journeys where employee can see the data and esign. I am using advanced task and but report is not coming…AvinashP 188 views 15 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI Report does not show Person Legislative information DetailsSummary: Our business has created few reports where they are capturing personal details of users and it includes person legislative info but in OTBI the data is coming b…AbhishekLahoti 96 views 11 comments 0 points Most recent by Ilmars K. Reporting and Analytics for HCM
-
Highest Education level not showing in OTBI person profile subject areaSummary: Hi Team, we have need to extract the report of each employee of highest education level but not coming in workforce profile - person profile real time . ANy one…AjayKumar Maddipati 161 views 5 comments 0 points Most recent by Ilmars K. Reporting and Analytics for HCM -
Which table stores Payroll Association dates?Summary: We are able to report on Payroll Relationship Final Close date and specific Payroll Assignment dates, but cannot find the data for Payroll Association Final Clo…TraciH-NorthBayHealth 985 views 6 comments 0 points Most recent by awheel09 Reporting and Analytics for HCM