Category 81
Discussion List
-
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 21 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 33 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 12 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 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 125 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 42 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 155 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 113 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 22 views 1 comment 0 points Most recent by Vinay Gharge Reporting and Analytics for HCM