Category 81
Discussion List
-
New user account password reset statusSummary: Is there a way to fetch the new user account details if the password was reset successfully or not? Content (required): As part of Onboarding process, user acco… -
Calculate time between interactions ORCSummary: Hello - we are trying to report on the time between interactions in ORC. We can pull in the creation dates for each interaction, but we are unsure how to calcul…Shanna Oppenheim 31 views 5 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Job Requisition approval audit reportSummary: Please help with Requisition approval audit report sample. hanks in Advance. Content (required): Version (include the version you are using, if applicable): Cod…User_2025-02-12-21-07-06-233 52 views 3 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Getting error in Headcount OTBI ReportSummary: Hi all I am using the below Subject area Workforce Management – Worker Assignment Real Time Compensation – Salary Details Real Time Workforce Management – Perso…Deepak Bhatt 31 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Data is not populated in HWR_WLNS_POINTS_REPORT tableSummary: Data is not populated in HWR_WLNS_POINTS_REPORT table Content (required): We have configured the Wellness activities and tasks and, employees have completed the…Jhansi K 32 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Where we can find predefined template for cloud hcm notifications ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):priyankatriv 23 views 16 comments 0 points Most recent by Karla Dixon-Proactive Support SPA-Oracle Reporting and Analytics for HCM -
Pivot table not showing as intendedI am trying to create a Pivot table using a User Defined field in Compensation-Workforce as the main Row, except that it keeps totaling the user defined data instead of …Jamie Bradley 32 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Below code only getting only for India data and remaining country Not comingSummary: Hi Team, we have code but only coming data for one country. Could you please help on where i need enhance to get all other countries data also. Thanks Content (…AjayKumar Maddipati 33 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How many years will the BI Job History be retained for along with the results and logsSummary: How many years will the BI Job History be retained for along with the results and logs Content (required): Version (include the version you are using, if applic…SAKTHI SUNDAR 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Does BI Publisher XSL template support xsl:Include href='filename.xsl'Summary: xsl:include href="//sharedfolder/templates/mysubtemplate.xsb" gives fatal error Content (required): I have simple xsl to print the HCM extract xml file and at t…makarandamondikar 13 views 5 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM -
Where is 'Elective Disbursement' details of Absence Plans stored?In the details of absence plans, which tables/lookups can I find values of this field? This is what it looks like in front-end: Thanks! -
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 56 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 123 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 42 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 83 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 12 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 53 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 179 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 83 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