Reports
Discussion List
-
How to fetch the translated value from an Independent Value set in Oracle Fast FormulaSummary: How to fetch the translated value from an Independent Value set in Oracle Fast Formula Content (required): How to fetch the translated value from an Independent…Meenakshi K 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Running OTBI based upon the Results of another OTBI getting Error getting Drill InformationSummary: We are trying to base the results of one OTBI analysis off the results of a second OTBI analysis. Both analysis run successfully on their own. However, once con…Denise Izzi 11 views 19 comments 0 points Most recent by Denise Izzi Reporting and Analytics for HCM -
How does your organization use Oracle to comply with the MN Wage Theft law?Summary: My organization is in the process of implementing Oracle and we’d like to understand if other MN-based organizations have a process in place related to MN Wage …Tammi Desens 1 view 0 comments 0 points Started by Tammi Desens Payroll and Global Payroll Interface (GPI)
-
How does your organization use Oracle to comply with the MN Wage Theft law?Summary: My organization is in the process of implementing Oracle and we’d like to understand if other MN-based organizations have a process in place related to MN Wage …
-
Succession Plan BIP Report based on Job RoleSummary: Hello Experts, I have to create a Succession Plan BIP Report based on Job Role. Please help with a sample SQL/Report if you have worked on a similar requirement…Abhishek Premchandra-Oracle 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
ora_pay_transform_file_type_list is not provided. use max seq num from pay_file_detailsSummary: ora_pay_transform_file_type_list is not provided. use max seq num from pay_file_details This is fusion HCM extarct BIP report related issue, Can anyone please h… -
How to use Hyperlink in RTF templates?Summary: Hello Experts, Is it possible to use Hyperlink in RTF templates? Like, in the report output, the Person Number attribute will have a hyperlink, once the user cl…Abhishek Premchandra-Oracle 11 views 3 comments 0 points Most recent by SantoshKumarB Reporting and Analytics for HCM
-
HCM > Others tab > My Dashboard > End User Dashboard Does Not OpenSummary: HCM > Others tab > My Dashboard > End User Dashboard Does Not Open Content (required): Hello All, I will appreciate your support on the issue below: When the HR…
-
Application channelSummary: Mobile vs Desktop - Is there a way to report on how candidates are applying, whether it be on a mobile device or from a desktop/laptop? Content (required): We a…Mitch_123456 12 views 1 comment 0 points Most recent by Rosetta Jasperson Reporting and Analytics for HCM
-
Tuning Performance Task with Performance Ratings Subject Areas for Performance!Summary I've joined the subject areas together and it's VERY slowContent I've created an analysis where I'm trying to derive the current in progress performance task fro… -
HCM OTBI Index ColumnsSummary This workbook documents index columns in HCM OTBI subject areas.Content This document is published by Oracle OTBI Development. Index columns use database index f…User720640-Oracle 270 views 4 comments 10 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
in RTF how to use a parent attribute for comparison inside a child repeating group while summingSummary: In a rtf template we are trying to compare the value of child attribute to a parent attribute if the value matches then the sum of an child repeating attribute …
-
Change LOV in Comp dashboardSummary: I am looking to add a LOV in the dropdown box for Out of the box dashboards available for managers under workforce compensation Content (required): Need to add …Manoj B. Cheruvathoor 11 views 2 comments 0 points Most recent by Manoj B. Cheruvathoor Reporting and Analytics for HCM
-
How to show a report in the user interface?Summary: How can I show a specific report/analysis directly to end users in different screens? Content (required): Basically I want to know how to show data to end users…Matti Bugge 11 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to add logical sql analysis to dashboardContent Hi, I have created logical sql OTBI analysis , now I want to add this into Dashboard page which is already having dashboard prompt(all are column prompts) and ot…Razesh 177 views 28 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
What filter can I use to only list the Last Assignment details for employees and not duplicate rows.Summary: Hello Community - I need assistance listing employees "Last Assignment" or "Latest Assignment" details. If someone was Rehired, or Terminated more than 1 time, …Roland Cons 12 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Performance Tile counting assignments based on the sum of a flex field by assignment.Summary: Since upgrading to 22A we're having trouble with a performance tile used to count assignments based on the sum of a flex field we've designed and I'm looking fo…Rob F 2 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Users with FBI_CAREER_DEV_TRANSACTION_ANALYSIS_DUTY are unable to see their own development goals.Summary: Users with FBI_CAREER_DEV_TRANSACTION_ANALYSIS_DUTY inherited by either ORA_PER_LINE_MANAGER_ABSTRACT role or ORA_PER_HUMAN_RESOURCE_ANALYST_JOB role are unable…Maciej Kozakiewicz 11 views 2 comments 0 points Most recent by Maciej Kozakiewicz Reporting and Analytics for HCM
-
I need to create a group or a bin based on 2 different columns. Is that possible?Summary: Group or bin based on 2 fields Content (required): I am working on turnover report and need to create groups or bins from a hierarchy tree value and a company b…Donna Valentine 11 views 3 comments 0 points Most recent by Donna Valentine Reporting and Analytics for HCM -
SQL needed to find parent department in department tree for any given department nameSummary: SQL needed to find parent department in department tree for any given department name Content (required): Hi All, Please share SQL to find parent department in … -
Printing details on a single row using a EText Fixed Position TemplateSummary Need help in printing both parent and child XML details in the same rowContent Hi All, Need your suggestions on how to solve the below requirement: 1. Applicatio…Brendon Charles-24581 25 views 8 comments 2 points Most recent by Bhupendra Singh Rawat-Oracle Reporting and Analytics for HCM -
RCOUNT("Worker"."Person ID" by "Learning Items"."Learning Item Number")Summary: I am trying to fetch the latest status of a particular learning item number per employee. I have used RCOUNT and Max to fetch the data. When I filter with perso…Anita 14 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Dynamic effective date on AnalysisSummary: I am trying to get active employees as of a future date in Analysis "Workforce Management - Worker Assignment Real Time" Content (required): I am able to use a …
-
Fetching employee using BIP query if employee have Job changes and TerminationSummary: Fetch the details of employee who have job changes and termination details of employee Content (required): Hi, I am working on BIP query to fetch the details of…Kamini Kaushik-Oracle 12 views 2 comments 0 points Most recent by Abhishek Premchandra-Oracle Reporting and Analytics for HCM
-
UK Check/Cheuqe Payslip ReportSummary: UK Cheque payslip report query Content (required): I am adding the SQL query for custom cheque payslip report. Employee will have the payment method as cheque o… -
BIP - Talent RatingsSummary: Hello, Good day! I'm running a report in BIP but facing performance issue when I'm trying to create multiple data sets. One data set for employee details and on…Hazel De Castro 1 view 0 comments 0 points Started by Hazel De Castro Reporting and Analytics for HCM
-
Absence Summary ReportSummary: Does anyone have an absence summary report? Content (required): We are looking for a report (or better yet, and analysis) that tells us how many hours each empl…Jenna Savage 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to habilitate 'My reporting' for HR Specialist in HCM Cloud?Summary: The tab 'My Reporting', is unavailable in our environment menu. Content (required): Greetings community! I have seen that in demo.oracle I can use the tab 'My R… -
Termination Headcount MeasureSummary: Subject Area: Workforce Management - Work Assignment Event Real Time, Assignment Event, Termination Headcount calculating terms on the last day of the month in …Rebekah Gilday 1 view 4 comments 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM -
Need assistance enabling icon: "Reports and Analytics"Summary: Need assistance enabling icon: "Reports and Analytics" under Tools within Oracle Cloud Application (21D) HCM Dashboard. I could not find any specific roles to a…Roland Cons 1 view 3 comments 0 points Most recent by PatriciaS-Oracle Reporting and Analytics for HCM