Reports
Discussion List
-
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 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Access OTBI Data without Job RolesSummary For OTBI Administrators - Is there a way to access Data as a Super User without getting a specific Job Role assigned?Content Hey Guys, We were checking to see if…User_2025-01-30-04-49-10-284 127 views 4 comments 0 points Most recent by IIGC Reporting and Analytics for ERP -
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…User_7836 207 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, …User_2025-03-07-05-24-33-733 31 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 21 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
List of values source definitions for essSummary: Need the list of values source definitions for contract type and LOC processing options parameters to define custom ess job for Generate Invoices process Conten…
-
How can I SUMIF greater than zero? In Excel the formula is =SUMIF(C6:C22,">0")Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):User_2025-02-11-09-50-09-390 21 views 3 comments 0 points Most recent by User_2025-02-11-09-50-09-390 Narrative Reporting
-
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 41 views 3 comments 0 points Most recent by Donna Valentine Reporting and Analytics for HCM -
The "Cur" member in Text Function doesn't appear to exist in Mgmt ReportingIn the Financial Reporting Tool, I was able to reference a Current Row on a Report to get a dynamic member to pull. It would look something like this: AncestorName("Posi…
-
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 155 views 8 comments 2 points Most recent by Bhupendra Singh Rawat-Oracle Reporting and Analytics for HCM -
BI Publisher Report producing values for next row when values cannot be foundHi all, Hoping you can assist me with some off behaviour that I am experiencing when producing a report in BI publisher. We have written a data model that when run appea…Luke.Findex 11 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center -
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 41 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 …
-
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 31 views 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 31 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… -
create a report connected to different PBCS applicationsSummary: Content (required): During a migration from on-premise Planning to PBCS, I encoutered a report that has two grids with connections to different on-premise appli… -
User POV selection screen in Web Reporting (FR) does not filter as per user securitySummary:When selecting member for user POV, user security is not applied and can see all members of the dimension Content (required): When the FR report is run through R…
-
BI Publisher Output File NameSummary BI Publisher output file name Suffixes Template/Layout NameContent BI Publisher report output file from Oracle Fusion cloud suffixes the Template/Layout name at …Senthilrajan V 160 views 12 comments 2 points Most recent by Ravi Tilekar Reporting and Analytics for ERP -
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…User_2025-03-07-05-24-33-733 63 views 3 comments 0 points Most recent by Patricia-S-Oracle Reporting and Analytics for HCM
-
Assignment Event Headcount at Start of MonthSummary: Getting the Headcount at the Start of the Month Content (required): How can we configure the Formula for the Assignment Event Headcount at the Calendar Month St…Rebekah Gilday 31 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
User and Role Access Audit Report - be awareSummary: This is not a query but a heads up for users. Content (required): This delivered report does not return the values it's supposed to. Running the report with 'Al…K DeFabrizio 82 views 6 comments 0 points Most recent by K DeFabrizio Reporting and Analytics for HCM
-
HFR ReportingSummary: Hi All, In my report client need Level4,3,2,1 of the center dimension in 4 separate columns. But the problem is in the report the center level did not come as p…Mrinmoy Paul 12 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Profitability and Cost Management
-
HFR ReportingSummary: Hi All, It is possible to show member name with UDA tag in one of the dimensions i.e service in two separate columns i.e in one column I need service dimension …Mrinmoy Paul 11 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Profitability and Cost Management
-
Organization Chart with Persons ImagesSummary Organization Chart with Persons Images with Google Chart ServicesUser_Z8Y6M 126 views 8 comments 2 points Most recent by Vasiliki Tripolitsioti-Oracle Reporting and Analytics for HCM