Reports
Discussion List
-
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 71 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 140 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 179 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 23 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 25 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 82 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 59 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 6 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 49 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 25 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 269 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 89 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 47 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 359 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 36 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 75 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 216 views 3 comments 0 points Most recent by Catherine Chan Reporting and Analytics for HCM -
table to pull the error details from transaction console.Summary: Hi All, I'm trying to build a report and looking to pull the error details from transaction console. I tried searching tables but I'm not getting the info, can …vamshi krishna-283622 459 views 8 comments 0 points Most recent by Arun Menon Reporting and Analytics for HCM
-
How can I get an interaction to filter on 2 columns at once?Summary: I have created a graph to show male/female by Grade level. I created an interaction to drill down to a report, however the interaction is only filtering on eith…Dannielle Dellucci 45 views 4 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM
-
Report to get the list of employees with multiple active relationshipsSummary: Report to get the list of employees with multiple active relationships Content (required): Hi Team, Greetings! With Global Transfer- there are some cases observ…Parag Hiremath 335 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Bursting Query table from the reportsSummary: Bursting Query table from the reports Content (required): Hi Team, Greetings! Is there any table(s) which holds the queries included in the bursting query in th…Parag Hiremath 394 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Best practice for reporting on incomplete allocated checklists?Summary: Hi All, Does anyone have any "best practices" for reporting on incomplete allocated checklists? We have a business case to report on number of incomplete checkl…William_Johnson 65 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Extract information about the Job Board eQuest in ORCSummary: Content (required): Hello everyone, We are having problems extracting information regarding the publication of a job requisition. In particular, in addition to …Gerardo Peluso 15 views 0 comments 0 points Started by Gerardo Peluso Reporting and Analytics for HCM