Reports
Discussion List
-
BI Publisher RTF Template - Repeating GroupSummary: Team, we have a requirement to print the timecard details For each employee the header should be same and the Last Row Should Be Repeated. It would be really he… -
How to get the Time Dimensions to work with the Move HR DateSummary: We have a recruiting dashboard that has the Time.Month, Time.Quarter and Time.Year dimensions as prompts. When we run a drill down to show details of the intern…Craig Stevens 43 views 6 comments 0 points Most recent by Craig Stevens Reporting and Analytics for HCM
-
Able to see Schedulers attached to Reports?Summary: I have been asked to remove scheduled reports for a few people. These schedulers were made by someone else, and I cannot locate them. I can find the reports, bu…
-
Error in Copy of Seeded NotificationSummary: BIP Notification issue Content (required): Hi Oracle Experts, I need your help regarding BIP notifications, I have a requirement to add/hide the fields in the n…
-
I'm getting a Dashboard screen parameter error, how should I solve it?I get the 'NAME' field from the same subject area in my Analysis Report and parameter report. and in the analysis report I choose 'is promted'. But the parameter does no…Cansel Karasoy 41 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
BPM Worklist ReportSummary Help on creating BPM Worklist ReportContent Hi, We currently have several requests regarding the BPM Worklist Report in Fusion HCM. Do you have any idea on how t…User_2025-01-29-01-38-21-058 256 views 8 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
Display OTBI Analysis to Employee Without Giving Access to Reports and AnalysisSummary: Content (required): We have a requirement where the logged in employee can view his/her development goals count viz., total goals completed, total goals in prog…Jaydeep More 62 views 6 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM
-
Need help to fetch the roles with stream names and service detailsSummary: Need help to fetch the roles with stream names and service details Content (required): We have a requirement to develop a report to fetch all the roles along wi…
-
How to obtain a query between the user and the roles associated with itSummary: Roles associated with a user Content (required): Hi team, We need to obtain the list of users and the associated roles. I have reviewed some tables but I cannot…SERGIO BARRETO 122 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
No fact table exists at the requested level of detail - Ethnicity IssueSummary: Hi - We have a roster report for our whole employee population and I was trying to tweak the ethnicity section to account for the many scenarios of if they choo…
-
Create analysis using logical SQL error?Summary: Invalid SQL Identifier: fusion.per_allocated_checklists ac. error Content (required): Hi All, We are looking at building OTBI analyses for identifying allocated…William_Johnson 177 views 3 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Hello, has anyone tried creating a report in OTBI or BIP that displays an employee's most recent ratContent (required): Hello, has anyone tried creating a report in OTBI or BIP that displays an employee's most recent rating as well as their historical rating (Performan…Hazel De Castro 11 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Where can I find Product and Segment from the financials side (default expense account) in OTBI?Summary: I want to join HCM data with expense account data Content (required): I need to be able to pull in the Product and Segment from the default expense account (or …Monique Dias 22 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Calculate Percentage based on Running Sum displayI'm displaying a running sum for minority hires and overall hires from month to month. I want to calculate the % of minorities to hires for each month based on the runni…Susan Anderson 71 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Benefits Report Etext template question?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Why do some fields break a report in OTBI?Summary: trying to create a census report with fields from multiple subject areas and many fields work together but certain fields break the report Content (required): I…Monique Dias 54 views 8 comments 0 points Most recent by Monique Dias Reporting and Analytics for HCM
-
Extract Comment after Hiring Transaction or other transactionSummary: Extract comments after hiring transaction Content (required): Extract comments after hiring transaction as show in the image Version (include the version you ar…teresa.marciano 2 views 0 comments 0 points Started by teresa.marciano Reporting and Analytics for HCM
-
Formula for Data Submission Status in Talent ReviewsSummary: Subject Area: Workforce Talent Review - Talent Review Meeting Real Time Content (required): Hi All, We are looking to create an analysis that could be used to m…William_Johnson 56 views 4 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Difference between primary assignment flag and primary flag in per_all_assignments_m tableSummary: Hi , Can anybody let me know what is the difference between primary assignment flag and primary flag in per_all_assignments_m table. How these two columns behav… -
Report on PromotionsSummary: I need to be able to capture anyone who is transferred from a job with a job class of 'S' to a job in any other class (E, D, M, in our case). I'm looking for a …Jessica D 44 views 3 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
May I know which subject area suitable for below columns ?Summary: Hi Team, May I know which subject area suitable for below columns ? unable to find ? Thanks, Ajay Content (required): Version (include the version you are using…AjayKumar Maddipati 22 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Performance Management Eligibility ProfilesContent Hi All, I am unable to find the table names for "Manage Eligibility Profiles" and "Profile Criteria". Please finds the attached screen shots for your reference a…
-
Succession Permission AuditSummary Succession Permission Audit ReportContent Is it possible in Oracle HCM to create a report showing all plans, and the individuals who have Succession permission f…
-
How to report on position changes?Summary: I work for Charlotte-Mecklenburg Schools and we are in the process of modernizing to Oracle HCM Cloud. We have asked our ERP vendor to create a report to captur…Shea Hartsell 245 views 7 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
OTBI Analysis to identify employees with missing payment method - any help appreciatedSummary: We are looking to create an OTBI (not BIP) analysis which returns employees who don't have a payment method Content (required): Our current queries are bringing…Kevin M Storrie 86 views 5 comments 0 points Most recent by Kevin M Storrie Reporting and Analytics for HCM -
Formula for most recent grade name on current assignment?Summary: Subject Area: Workforce Management - Person Profiles Real Time Column: "Grade"."Grade Name" Content (required): Does anyone have a formula to pull in an employe…William_Johnson 43 views 6 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Inability to view the National ID information in the report by the employee,how should we proceed?I have an excel report that I prepared with BI publisher, and this report contains the National ID information I got from the PER_NATIONAL_IDENTIFIERS table. But the use…Cansel Karasoy 291 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Folder Permissions Error in 22BSummary: Since 22B we receive error when adding or removing users to folder permissions under Custom Content (required): The following error is thrown: "Exceeded number …Janine Brown 32 views 10 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Compensation Details (Top of Stack) when End DatedSummary: Hi - We are looking to create a report where we are able to audit active employees where their salary was incorrectly end dated. The problem is that when the sa…Kyle Norris 71 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need help on arrears balance ReportSummary: Content (required): Hello, We are trying build a custom arrears balance for both active and terminated employees. We do not have anything available for terminat…Ganesh G 206 views 3 comments 0 points Most recent by Catherine Chan Reporting and Analytics for HCM