Category 81
Discussion List
-
Not FoundSummary: Not Found error while running BIP report Content (required): Encountering "Not Found" error when user login and trying to run the report for first time and goes… -
How is Absence Days metric is calculated?Summary: Hi, We would like to understand how Absence Days measure is calculated. It gives different results (one correct and the other is not) I don't know what the issu…HulyaAkan76 52 views 5 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Can Area of Responsibility be on OTBI report?Summary: Area of Responsibility be OTBI report Content (required): We have 2 representatives in the Area of Responsibility that I need to put on an OTBI report. Is this …Donna Valentine 130 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Excel Template ErrorSummary: Hi all, I am working on a excel template and at the time of viewing the data, getting below error. Could any one please let me know the cause of the issue. PS: … -
Employee number along with Candidate numberSummary: Hi, My requirement is to extract Employee details like employee number, name etc. from Core HCM along with Candidate Number, Requisition Number etc. from ORC in… -
Sudden Issue When Exporting Reports ... Spinning Spinning SpinningSummary: Hi everyone, We are experiencing issues running reports. We are not getting an error ... the page simply spins, like for hours. Any ideas on what I can do to tr…Erin Hamrick 41 views 4 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Is there a way to see where the OTBI Agent burst to?Summary: Wondering if there is a way to see where an OTBI agent sent reports to. Content (required): We have a report that bursts based on manager username. The details …
-
DD-MON-YYYY format is not workingSummary: We have a requirement to display the date format as "DD-MON-YYYY'. Ex. 14-FEB-2025. We are using RTF Template. In the query I am not doing any kind of formattin…
-
Promotion Report - Need HelpSummary: I’m looking for a promotion report that show when an associate current and propose fields as follows: Salary from/to Management Level from/to Job Code from/to D…Prabhu Krishnamoorthy 82 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Creating analysis using user defined fields in Workforce CompWe are trying to create some reports using the Compensation-Workforce Compensation Real Time subject area and was under the impression this subject area would pull data …Jamie Bradley 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Fetching Data from the Legal Entity DFFSummary: Content (required): Hello experts, We've run into a bit of an odd issue, and was looking out for any advice. We've written a snippet of code to fetch the ATTRIB…
-
How to calculate Turnover percentage between count attributes in OTBI ?Summary: How to calculate Turnover percentage between two count attributes in OTBI ? Content (required): We are working on an OTBI report where we have to create a summa…
-
Leave Balance Calculation date showing different than UI in BIP reportSummary: Hi Team, Leave Balance Caluclation date showing diffrent than UI in BIP report Content (required): Version (include the version you are using, if applicable): C…AjayKumar Maddipati 43 views 16 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Oracle Learning - is it possible to report all assignments/roles for an individual in one report?Summary: We have a business need to report on student learning (in the same way we report on staff learning - completions and overdue by department). However, some of ou…Michelle Taylor DU 52 views 17 comments 0 points Most recent by Michelle Taylor DU Reporting and Analytics for HCM
-
Select Max (Last Update Date) from "FUSION"."IRC_JA_EXTRA_INFO"Summary: Calling all SQL Experts: Trying to select the most current record (based upon last_updated_date field) from table "FUSION"."IRC_JA_EXTRA_INFO" in a data model. …Denise Izzi 162 views 7 comments 0 points Most recent by Denise Izzi Reporting and Analytics for HCM -
How to get plan start and end dates for a persons absenceSummary: I want to build a report to show the start and end dates of a person enrolment in a plan as we need to write to each person when a plan will expire. Content (re…Sharon Harper 11 views 6 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
HC trend working hoursSummary: Content (required): I am using workforce trend real time to pull period start and end HC by calendar month (2019/2020); however, when I want to drill down to wo…Riti Malhotra 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
We need to give read only access to the User to view all the reports dataSummary: Hi All, We need to give read only access to the User to view all the reports data Navigation -> Tools -> Reports and Analytics -> Browse Catalog -> Shared Folde…Sakthi Priya S 82 views 4 comments 0 points Most recent by Raghu Seregar Reporting and Analytics for HCM -
Employee Vacation Schedule and vacation rate Listing ReportSummary: Looking for sample OTBI report for Employee Vacation Schedule and vacation rate Listing Report. I looked at customer connect "HCM Report Sharing Center" but cou…User_2025-02-12-21-07-06-233 21 views 4 comments 0 points Most recent by User_2025-02-12-21-07-06-233 Reporting and Analytics for HCM -
How to use the average functionality per legal employer?Summary: Trying to use th avg functionality in OTBI but not getting the right results in Content (required): I want to show some simple statistics based on legal employe… -
Learning Audit ReportSummary: Our client has a requirement to be able to audit on the following objects in Oracle Learning Cloud. currently oracle dont provide an out of the box solution to …Nirupa Gnanendran 132 views 2 comments 1 point Most recent by Nirupa Gnanendran Reporting and Analytics for HCM
-
Is it possible to add Department Parameter in Seeded Gross To Net Payroll Report?Summary: I have a requirement to add a Department Parament in GTN Seeded Report Content (required): Version (include the version you are using, if applicable): 22B (11.1…
-
NewHireReport not getting triggeredSummary: Content (required): We have set the value as "true" for all the below profile options: BIP_EMAIL_NOTIFICATION_HCM BIP_EMAIL_NOTIFICATION_HCM_IRC BIP_EMAIL_NOTIF…Vinay Gharge 21 views 1 comment 0 points Most recent by Vinay Gharge Reporting and Analytics for HCM
-
Where is 'Expedite Payroll' flag stored?Hi All, Summary: I'm trying to find what table is the 'Expedite Payroll' flag on timecards stored? Content (required): this is what it looks like in front-end Thanks!notautomni9 33 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
When we apply filter below for particular process not working on pending transactions reportSummary: Hi Team, we have developed pending transactions report in that all process are coming like change manger,'Resignation', location, and etc but we need only Resig…AjayKumar Maddipati 31 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Data is not showing in BI after creating any TransactionSummary: Custom report is not reflecting data immediately after transaction is made in system. Content (required): We have created custom report which is based on absenc…
-
Date is not appearing after transaction madeSummary: Custom report is not reflecting date immediately after transaction is made in system. Content (required): We have created custom reprot which is based on absenc…
-
How to pull Number of employees who dont have a development goal?Summary: The requirement is to build a OTBI dashboard that should display two donut charts (should be added a link) for #of Employees who has atleast 2 development goals…Iswarya Lakshmi Priya-Oracle 21 views 4 comments 0 points Most recent by Iswarya Lakshmi Priya-Oracle Reporting and Analytics for HCM
-
What tables store the representatives that are assigned to each employee?Summary: I have been tasked with creating either an OTBI analysis or BI Publisher report to pull all employees and the representatives that have been assigned/linked to …BeachDreamer 214 views 6 comments 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
Cross SA Employee Census results in errorSummary: In building out an analysis that gives me one row per active employee, I've run into this error: Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8…Kate V 21 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM