Global HR
Discussion List
-
Can we report on Workflow TransactionsContent Hi All, I am trying to see if we can report on Workflow Transactions. I am able to query fa_fusion_soainfra.WFTASK table which seems to have workflow data in HCM…Vibha Pandey - Oracle 228 views 9 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
BI Report to achieve SANDWICH ABSENT LEAVE CASES.Summary BI Report to achieve SANDWICH ABSENT LEAVE CASES.Content Please Kindly Help us to achieve these scenarios in BI Reports. Here below are the two scenarios, We are…Ravikanth Rao Thota 38 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Table to get the currency listContent I need to find a table to get the currency list maintain in manage currency task.' And I could not able to find in Tables and Views page. Appreciate your ideas.Ayesha Thilakarathna 50 views 3 comments 0 points Most recent by Ayesha Thilakarathna Reporting and Analytics for HCM -
BIP SQL Query for Previous Assignment Information, Updated Assignment Information, Previous Person ISummary BIP SQL Query for Previous Assignment Information Updated Assignment Information Previous Person Information Updated Person Information Previous Bank Information…User_2025-02-01-06-07-07-886 533 views 4 comments 0 points Most recent by User_2025-02-01-06-07-07-886 Reporting and Analytics for HCM -
Determining # of direct reports at time of terminationSummary How can we determine how many direct reports someone had as of their term date?Content We have received a request to pull together a report of terminations over …Cheryl Burwell 33 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Error Password Protecting Excel Templates in BIPSummary Trying to password protect BIP reports that were built using the excel add in, but incorrect file type is showing up.Content Hi all, I'm having some issues with …User_2025-01-31-00-25-12-234 41 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Is it possible to create OTBI analysis that should reports person numbers for alternate Managers andSummary We are trying to create an OTBI analysis that should reports person number for alternate Managers and Line managers both.Content Requirement- Need to create an O…User_F89L9 78 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Direct Report - OTBI Report CatalogContent Hello from Columbus, Ohio! Does anyone have a nice Direct Report with Managers and Direct Reports listed? I'm looking for an .xml catalog file that I can share i…User_2025-02-04-11-13-27-138 93 views 3 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM
-
Area of Expertise - Subject AreaContent Hi, I am trying to create Skills and Qualifications report from below subject area. --Workforce Profiles - Person Profile Real Time I wanted to add "Area of Expe…User_2025-01-30-00-14-06-021 114 views 5 comments 0 points Most recent by User_2025-01-30-00-14-06-021 Reporting and Analytics for HCM
-
Department Tree - Father and two Child Levels of a Department in inputContent Hello everyone, I'm trying to create a OTBI Report to extract Father and two Child Levels of a Department given in input. Extracting the Father of a Department i…User_2025-01-31-00-30-34-540 87 views 2 comments 0 points Most recent by User_2025-01-31-00-30-34-540 Reporting and Analytics for HCM
-
Reporting on Worker Comp Change Statement ActionSummary Comp Change Statements can be enabled in ESSContent We need to know when a worker accepted/declined/signed statements that are shared with them in ECC. Is there …Gala Meyerovich 58 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need subject area for cost center and companySummary Need subject area for cost center and companyContent Hi, I assign cost center and company values at department level . Now I want subject area for extract detail…
-
Headcount by Business Unit and locationsSummary Headcount by Business Unit and locationsContent Hi Friends There are a couple of reports in which we get Headcount by Business Unit and locations. We have around…Mansur Khalil 61 views 2 comments 0 points Most recent by User_2025-02-04-06-31-44-785 Reporting and Analytics for HCM -
Reports Filtered by Action Approval/Completion Date?Content Hi All, Has anyone found a way to filter a term report or employee changes report by date the corresponding action was approved? For example; we send a term repo…
-
Workforce Management - Absence Real TimeSummary Issue with Absence DashboardContent Hi, I am trying to create a OTBI report based on Subject Area - Workforce Management - Absence Real Time. Currently we have a…Shail Parekh 245 views 14 comments 1 point Most recent by Rambo Jacob Reporting and Analytics for HCM -
OTBI Employee report - how to stop delegated employees appearing on it ?Summary OTBI Employee report - how to stop delegated employees appearing on it ?Content I have a OTBI manager report that managers can use to see their direct reports ho…Ruzwan Akram 48 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SUCCESSION PLAN CANDIDATE READINESSSummary SUCCESSION PLAN CANDIDATE READINESS column detailsContent Hello Everyone, How to find current active record for the succession plan candidate readiness, as per o…VarunG 72 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Time to First PromotionContent Hi All, We're trying to measure time to first promotion (or the tenure an employee has on average before they're first promoted). Wondered if anyone has had luck…Lauren Owen 52 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Turnover Calculation in OTBISummary What is the formula for the out of the box turnover calculation in OTBI?Content What is the formula for the out of the box turnover calculation in OTBI? Thanks, …User_2025-02-05-04-33-50-822 117 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there any subject area is available which shows the inprocess/complete/initiated resignation infoSummary Is there any subject area is available which shows the inprocess/complete/initiated resignation informationContent Is there any subject area is available which s…User_2025-02-05-01-04-36-989 27 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HR can't see all HR Action valuesSummary We have analysis and HR can't see all HR Action values.Content Hi All, In our analysis we see who left the company, why and dates, actions etc. In HR Action we h…User_2025-02-04-18-26-11-309 43 views 2 comments 0 points Most recent by User_2025-02-04-18-26-11-309 Reporting and Analytics for HCM
-
Need Subject area to get the Person Identifier number for external applicationsSummary Need Subject area to get the Person Identifier number for external applicationsContent Hi Team, Does any one have an idea on which subject area to use for gettin…User_2025-02-04-07-00-18-658 147 views 2 comments 0 points Most recent by User_2025-02-04-07-00-18-658 Reporting and Analytics for HCM
-
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
-
EIT - India Nomination InformationContent Hi All, We have a requirement from our business in India regarding their benefits program. We require to report on Extra Information - India Nomination Informati…User_KOLMZ 45 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
-
Time card transferred to Payroll with success and failureContent Hi All, I am working on a report to get details of 1. Timecards transferred to Payoll. 2. Time cards not transferred to Payroll due to error and 3. Time card exc…Vibha Pandey - Oracle 73 views 5 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Customizing Seeded Analyses from CatalogSummary Seeded analyses are using custom values that don't match our setupContent Hi Everyone, I understand that with R13 we can no longer modify or remove the seeded re… -
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
-
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 345 views 3 comments 0 points Most recent by User_2025-01-28-05-11-13-165 Reporting and Analytics for HCM
-
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 49 views 3 comments 0 points Most recent by Ashish Shrivastava-Oracle Reporting and Analytics for HCM