Reports
Discussion List
-
Payroll Check Details ReportSummary We have a requirement to pull out Payroll Check Details for an employeeContent Hi, Can anyone help me with a Sample query which will give Payroll Check Details (… -
Report for users with current rolesSummary Not able to pull all users for above reportContent Hello Folks - We have been using below report to satisfy one of our downstream system for periodic audits. Req…User_2025-01-25-04-02-13-126 50 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Audit report for user roles in HCMSummary Audit report for user roles in HCMContent Hi When I tried to pull the User roles report form the delivered LDAP report it is displaying roles which are currently…User_2025-02-01-08-16-14-343 211 views 3 comments 0 points Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM
-
Entitiy Model/relationship diagram for HCM CloudContent Please could someone point us to the entity model / entity relationship diagram for the Bi reporting tables for HCM Cloud ThanksRebecca Smith-27468 82 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is it possible to create a Data Model In Oracle HCM Cloud Using Multiple Datasources (One as SQL QueSummary Is it possible to create a Data Model In Oracle HCM Cloud Using Multiple Datasources (One as SQL Query Data Set and other as Static Excel Spreadsheet)Content Hi …AshishERPCloud 177 views 15 comments 0 points Most recent by Kalyan Amaravathi Reporting and Analytics for HCM -
'Column format - Suppress' do not work in OTBI Direct Database request reportSummary Suppress property in OTBIContent Hi All, I have created a direct database request report where I want to suppress a field 'Year' if the values are repeated. I us…SuryaMuralidharan 61 views 2 comments 0 points Most recent by SuryaMuralidharan Reporting and Analytics for HCM
-
Choosing All options from filter at the TableSummary We have department filter at one Table. We can't choose All.Content Hi All, How can we choose All options from one filter at the table. It allows only declared d…User_2025-02-04-18-26-11-309 35 views 6 comments 1 point Most recent by Timothy Orrange Reporting and Analytics for HCM
-
Employees by Tenure and Age BandSummary Employees by Tenure and Age BandContent Hi I am looking for a report which has the Employees by Tenure and their Age band for the last 4 years. Could you please …Mansur Khalil 73 views 5 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
Unable to generate EEO-1 (Type 3 and Type 4 ) ReportSummary Unable to generate EEO-1 (Type 3 and Type 4 ) ReportContent I We have configured the EEO as per the note "Fusion US Payroll: How to Setup EEO-1 Report. Also appl…Venkat P - Automus 125 views 1 comment 0 points Most recent by Tony Johnson-Oracle Reporting and Analytics for HCM
-
Analysis of seeded HR dash boardContent Hi Team, Can any one know where to find the analysis of seeded HR dashboard ? We have checked all the folders in reports and analytics.User_4VVG2 74 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Element Entry ReportSummary Element Entry ReportContent Hello Experts, Wondered if anyone could help with xml/sql that will help me pull out all the element entries against all employees (i…Ramson Maseko 346 views 3 comments 0 points Most recent by User_2025-01-28-05-11-13-165 Reporting and Analytics for HCM
-
Totals for Amount fieldSummary How to subtotal a field that does work when using "Totals After"Content Hello Experts, I am trying to create a subtotal of a field called "Amount" from "Benefits…User_2025-01-29-23-59-58-976 53 views 6 comments 0 points Most recent by User_2025-01-29-23-59-58-976 Reporting and Analytics for HCM
-
Query to get active and active uses in the systemSummary Query to get active and active uses in the systemContent Query to get active and active uses in the system.We have Crosse verified the per_users table but didt g…Koteswararao Yenikepalli 78 views 3 comments 0 points Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
Using Distinct for OTBI reportsSummary We want to see only one result for specific areasContent Hi All, I have one report about absences and balances which belongs departments. We used Sum for some sp…User_2025-02-04-18-26-11-309 1.2K views 6 comments 1 point Most recent by User_2025-02-04-18-26-11-309 Reporting and Analytics for HCM
-
Recreating HR dash boardContent Hi Team, Since the HR dash board willnot availabe after the latest patch, We are recreating it. We are facing following issue, 1. In one of the choice list "maxi…User_4VVG2 29 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Query/Table to view BPM commentsSummary Query/Table to view BPM commentsContent Hello All, We have requirement to capture the Approver comments in a report. Let us know if you are aware of table/query … -
How to link Data Sets belonging to different Data Sources in Oracle BI Publisher in HCM CloudSummary Approach to link data sets created from WebServive and SQL Query Data SourcesContent Hi All, We have a requirement to build reports on data from external data so…Kalyan Amaravathi 50 views 3 comments 0 points Most recent by Ashish Shrivastava-Oracle Reporting and Analytics for HCM
-
Delivered Analytics on Pay Equity InformationContent Hello again customer connect community! I'm looking for information regarding delivered analytics in cloud HCM OTBI or your experiences reporting on pay equity. …User_2025-01-22-19-43-38-766 46 views 8 comments 0 points Most recent by Lauren Owen Reporting and Analytics for HCM
-
OTBI Agent not sending some of the recipients emailsSummary OTBI Agent not sending some of the recipients emailsContent Hello, One of the recipients mails in agent - is not being sent , ALL other mails are sent . what cou…Revital Mefano 127 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Manager Assignment vs Worker Assignment in OTBISummary Manager Assignment StatusContent Hi Team, I know there are a few Manager's information fields available in OTBI but I could not find Manager Assignment Status, f…Alvaro Couto 68 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Error when Migrating Custom Subject Area ContentContent Hello! I migrated over my reports from one test environment to another test environment by using Archive/Unarchive. My reports have some custom columns that are …User_2025-01-31-00-25-12-234 39 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Need new table names to pull calculation card detailsSummary Need new table names to pull calculation card detailsContent Hi Team, i am looking for the table names/query to pull the calculation card details like Federal , …User_2025-02-04-07-00-18-658 162 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Prompt Search Edit functionality for BIP reportsSummary How to achieve the prompt search edit functionality for BIP reports similar to one available in Analysis ReportsContent How to achieve the prompt search edit fun…
-
Element result report - explanationSummary How the Element result report is designedContent Hi All, Can anyone elaborate me how the Element result report is designed. I am able to understand the Extract's…SuryaMuralidharan 50 views 1 comment 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Which Subject Area holds the EmailAddressIdContent Could anyone tell me which subject area I can find the EmailAddressId? I need this to update email addresses through Data Exchange for the full version of HCM Da…Rebecca Smith-27468 57 views 6 comments 1 point Most recent by Ema Johnson-Oracle Reporting and Analytics for HCM
-
Bypass report securitySummary bypass report securityContent Is there a way we can bypass user security when setting up a report? We have created some workforce KPI dashboard reports for a sma…Shelly Feyerherm 65 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Issue in Intro Period Status Burst Report - Performance ManagementContent Hi All, we are facing an issue with an OTBI Analysis Report 'Intro Period Status Burst Report' in Production. Issue Description: When the report is run for recen…User_1B10X 17 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need Query/Catalog to pull the Payroll Balance details.Summary we have to create a report to pull the custom balance details for payrollContent Hi Team, We have a requirement to get the custom balance details in payroll for …User_2025-02-04-07-00-18-658 134 views 6 comments 0 points Most recent by Visu Reporting and Analytics for HCM
-
Users Preferred Timezone reportSummary Listing timezones set up in User's preferences by UserContent Hello Everyone, I found this script in one Oracle Support documents but I can't run it as it is sho…Alvaro Couto 67 views 4 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM
-
Changing Date Format at ReportSummary We can not change date format as we want to see.Content Hi All, You can see in below screenshot that we have date format at report column. We can only choose 3 o…User_2025-02-04-18-26-11-309 62 views 5 comments 3 points Most recent by User_2025-02-04-18-26-11-309 Reporting and Analytics for HCM