Global HR
Discussion List
-
Grouping and sum the RUN values of balances using XSLTSummary: Grouping and sum the RUN values of balances using XSLT Content (required): I have a below requirement to group by and sum the RUN values for each balance under …Deekshith Kalluri 31 views 0 comments 0 points Started by Deekshith Kalluri Reporting and Analytics for HCM -
Sox User Report - Security Roles & Privileges SA - Errors when trying to add in Department CodeSummary Sox User Report - Errors when trying to add in Department CodeContent I was asked to create a simple user report for our IT department that could be used for sox…User_2025-02-07-16-42-37-187 52 views 2 comments 0 points Most recent by Shant Sarkissian_NES Reporting and Analytics for HCM -
Create OTBI report with manager types other than Line ManagerSummary: We created a manager type for Time Keepers that we need to be able to report on for our time keeping system. We have only been able to find Manager Type = Line …Chelsea Holden 516 views 5 comments 0 points Most recent by Evan Rathod Reporting and Analytics for HCM
-
How to habilitate 'My Reporting' tab in HCM Cloud?Summary: Greetings, I have the Hr Specialist role in HCM Cloud but it seems I lack some configuration to use 'My Reporting' tab, when I search in the simulator Navigator…Saily De Jesus 32 views 4 comments 0 points Most recent by Saily De Jesus Reporting and Analytics for HCM -
Submit a flow - When there is no privilege added to the custom roleSummary: Hi Team, We are facing an issue related to our custom payroll role. We have built a custom payroll role to perform a few payroll administrative works. This cust…Silpi 89 views 1 comment 0 points Most recent by Kathan Bhatt-Oracle Payroll and Global Payroll Interface (GPI) -
Two Employee Rows Created only one shows Gender but not dual AssignmentSummary: Content (required): We are running an "All Employees" report and there appeared to be an anomaly on a single employee where it returned two rows of identical da…CB Trett 24 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Workforce Succession Management - Talent Pools Real Time Subject AreaSummary Reporting on Talent Pools through OTBIContent Has anyone had any luck reporting on Talent Pools through this subject area? I have been unable to get any results.…User_2025-01-28-08-47-04-905 36 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
which field stores value for Primary for national_identifiersSummary: which field stores value for Primary for national_identifiers Content (required): For National Identifiers in Front end,we can enter more than 1 National Identi… -
Fetching single latest row per person in logical SQLSummary Fetching single latest row per person in logical SQLContent Hi Team, I need to fetch Top row for a person and am using assignment real time subject area.. But, i…SM-Oracle 98 views 9 comments 0 points Most recent by Manoj B. Cheruvathoor Reporting and Analytics for HCM -
Latest Assignment Row in OTBISummary: How to get the latest assignment row in OTBI Report Content (required): I am looking to develop a OTBI report to fetch the latest effective row in assignment. C…Manoj B. Cheruvathoor 321 views 4 comments 0 points Most recent by Manoj B. Cheruvathoor Reporting and Analytics for HCM -
Additional Criteria Dropping out International EmployeesSummary: I have a report built that is supposed to show everyone that is Active as of a certain date along with their job information and some personal information (phon…Kyle Norris 12 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Extracting String from a text field in OTBISummary: Hi all, I need to extract the last part of an email address so I can include the exceptions in a CASE statement. Content (required): What I need to do is extrac… -
Bursting to get xml as an attachment from xsl templateSummary: Hello Experts, I have a report where I am using xsl template as layout. Our requirement is to send the report output in xml format to the destination email, but…Jaswant Prajapati 87 views 0 comments 0 points Started by Jaswant Prajapati Reporting and Analytics for HCM -
HCM Extract for Payroll ProcessHi We have requirement to get employee details who are processed in a payroll based on the given period start and period end date , so we are planning to create extract … -
OTBI to fetch vacant and filled positionsSummary: We have a requirement to create an OTBI report which will fetch position details alongwith Employees present in those positions. Besides that, we also want to f…Sovan Mishra-Oracle 1.1K views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Turnover Report Filtering 0-2 year TenureSummary: We have a requirement for a report that would have a rolling 3 year calendar that shows the headcount/termination counts for employees that are 0-2 years during…Rob Stahly 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to print sum of Position FTEs by Business Units in OTBISummary:We have a requirement in OTBI to fetch business unit name and Position FTEs. But we have to print the sum of FTEs grouping it by each business unit. We are using…Sovan Mishra-Oracle 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Assignment Expense InformationSummary Sourcing/Auditing the assignment Expense informationContent Hello, We're trying to audit the Expenses Information stored on the on the Manage Employment screen w… -
HCM Cloud question - Consolidation of BIP Report Stage from different flow submissionsSummary: HCM Cloud question - Consolidation of BIP Report Stage from different flow submissions Content (required): Hi Team, Greetings! We have a question in terms of so…Parag Hiremath 3 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
HCM User Interface to OTBI Subject Area MappingSummary: Hi all, I am always grateful to the invaluable assistance, insight and support of the customer connect community. I have no idea if this will be of use and this…User_2025-02-11-05-19-35-410 35 views 1 comment 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How can I locate the new MCR fields for the Responsive UI?Summary: I am looking for the new fields Role_Identifier and Teacher Reference to add to the Responsive UI, but am not sure how to find them Content (required): Are the …Mark Stoker 25 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Reporting transaction history in HCMContent Hi all, We are currently looking for a way to report transaction history specifically for terminations. We've found what were using shows the most recent update …User_2025-02-05-20-24-10-848 69 views 4 comments 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
which table in fusion hcm tracks changes to user status from Active to inactive and vice-vercaSummary: which table in fusion hcm tracks changes to user status from Active to inactive and vice-verca Content (required): which table in fusion hcm tracks changes to u… -
Min and Max columns on Assignment Effective Dates are blank in OTBI analysisSummary: 'Latest Assignment Start Date', 'Earliest Assignment End Date' columns showed data while building the report. After adding more columns and filter condition the…Vinay Hardas 266 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Getting Invalid URL Error while adding the BI report URL as embeded content in the dashboardSummary: I am trying to add the existing BI report to in the dashboard.Though i ma providing the correct BI Report URL while adding embedded content i am still getting t…minati_behera-Oracle 13 views 0 comments 0 points Started by minati_behera-Oracle Reporting and Analytics for HCM -
Reporting Name at Manage Department PageSummary: We are looking for Query to fetch Reporting Name at Manage Department Page,as marked in screesnhot below Content (required): Version (include the version you ar…Priyanka More-Oracle 186 views 2 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM -
Any method to search for a keyword usage in the OTBI Reports or HCM ExtractsSummary: Any method to search for a keyword usage in the OTBI Reports or HCM Extracts Content (required): Hi All, We have the requirement to identify the reports and int…Parag Hiremath 35 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
BI Publisher - conditional region reference other fields with formulaContent (required): Hi all, I am seeking some assistance using the BI Publisher word tool and am not that experienced. Is it possible to include formula within condition… -
Need Report for Number of times hire-date changed and all hired dates changed(in one field)Content Hello , We need the report of, Number of times hire-date changed and all hired dates changed(in one field). Is it possible in BIP? If yes, pls share me the sampl…Janardhana Kondaveeti 36 views 7 comments 0 points Most recent by User_2025-11-28-00-22-13-803 Reporting and Analytics for HCM -
BI Publisher - conditional region reference other fields with formulaContent (required): Hi all, I am seeking some assistance using the BI Publisher word tool and am not that experienced. Is it possible to include formula within condition…