Global HR
Discussion List
-
How to report on details held in Past Incumbents section of Position DetailsSummary: We need to add some of the fields held in 'Position Details' into an existing report but cannot find within any tables columns that correspond to the fields vis… -
Unable to report on Guided Journey QuestionnaireSummary: We've created a guided journey questionnaire as part of the requisition process for hiring managers, however we are unable to report on the data. We've had an S…DanSut 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to retrieve Work Day Definition (Weekly Working Hours section) using OTBIContent Hello We need to extract the information: Work Day Definition (Weekly Working Hours section) using OTBI. USA are using this information to track Shift informatio…Lucile Fleischman 81 views 3 comments 1 point Most recent by Thomas Samuel19 Reporting and Analytics for HCM -
Prompts are not showing while scheduling the OTBI AnalysisThere are 4 prompts in the Analysis. But when we try to schedule the report, these parameters/prompts dont show up in the General tab. Please suggest.Dona Das-Oracle 41 views 3 comments 0 points Most recent by Jagadeeswara Reddy Reporting and Analytics for HCM
-
When a filter is applied after ranking total months of service the analytic function no longer worksI have a report to pull the most recent seniority service data to get a list of employees eligible for a service award. My report works up until I set my final filter. H…
-
Query to fetch structural details of the admin pages and the EL Components used within themSummary: Is there any way or Query to fetch structural details of the admin pages and the EL Components used within them Content (please ensure you mask any confidential…Swati Rana2805 11 views 2 comments 0 points Most recent by Swati Rana2805 Reporting and Analytics for HCM
-
structural details of the admin pages and the EL (Expression Language) components used within themSummary: Is there any way that provide the structural details of the admin pages and the EL (Expression Language) components used within them, specifically focusing on t…Ashish Chawla-277800 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to include historic versions of org tree in OTBI workforce trend analysis?Summary Analysis containing HC summaries spanning years does not accurately reflect earlier org tree versionsContent Subject Areas: * Workforce Management - Workforce Tr…James Hoffmann 52 views 8 comments 0 points Most recent by Claudia Linares L Reporting and Analytics for HCM
-
EU Pay transparancySummary: We looking for a report to analyze the pay transparance between genders as requested by EU. Has anyone seen or created a report showing variances in payment per…Wouter.Schaap 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
convert person from text to number in BIThe person number is presented as text when we export a report with the number to excel. Is there a way to get this person number as number value in reports? WouterWouter Schaap 11 views 4 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Query to fetch all the workflow transaction in HCMSummary: Team, can someone please share me the query to fetch all the transactions recorded in HCM Cloud(Transaction Console), I tried to query from fa_fusion_soainfra.w…Satyanarayana M-Oracle 4.4K views 7 comments 0 points Most recent by AnnaMorelli Reporting and Analytics for HCM
-
Report on if employee has viewed / downloaded DOR?Summary: Hi team, We have recently been asked if we can report on if an employee has viewed / downloaded a specific DOR and/or its attachment? I am unsure on whether or …Luke.Findex 22 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Issue with getting a cloud HCM custom Cheque report to run using its custom templateI have created a custom Cheque report, data model and template to process employee pay checks. The problem I am having is finding a way to have the custom report point t…
-
Purge task is missingSummary: We are creating a report to fetch archived and purged tasks details , after purging the checklist , task name are missing . Content (please ensure you mask any …
-
Employment Contract Real Time Subject Area Not Returning any recordsSummary: Employment contract Real time subject area not returing any value when a column from "Employment Contract Details" is added. Content (please ensure you mask any…Samir Patro 21 views 9 comments 0 points Most recent by Keerthi Chinthapatla Reporting and Analytics for HCM
-
Can we download the attachments from BPM tables wfattachment?Summary Create hyperlink to download the attachments from BPM table wfattachmentContent Hello Experts, I am trying to generate a report with the approval transactions an…Sricharan Monigari 239 views 7 comments 0 points Most recent by Bisweswar Goud-Oracle Reporting and Analytics for HCM -
SQL query to retrieve employee business titleSummary: Content (please ensure you mask any confidential information): Hello experts, I need to retrieve the employee Business Title. Do you have a query to share to re…Valerio Curzi 325 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How can I modify existing seeded workflow notification template?Content I have a requirement to modify existing seeded template for Workflow notification(Transfer Report). I have found the template and copied it in custom folder and …User_2025-02-06-14-37-05-233 204 views 6 comments 0 points Most recent by Kotakonda.Balasubramanyam-Oracle Reporting and Analytics for HCM -
Need to display all workflow completed transactions as well as approver detailsSummary: Need to display all completed transactions as well as approver details Content (please ensure you mask any confidential information): We have a requirement to d…
-
Fast Formula retrieving Date formatSummary: Hello experts, we built the following formula to retrieve a date to be used in compensation plan in date custom field. However, when testing it the attached err…
-
How to pass person id from redwood page to Value setSummary: How to pass person id from redwood page to Value set Content (please ensure you mask any confidential information): Hi all, We created a value set to fetch late…
-
How to hold the EOSB payment after preforming Local and Global Transfer?Summary: The business wants to hold the EOSB payment (Years of Service) and transfer it to the new assignment after the completion of the Local and Global transfer, alon…Anisha Suri 11 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Percent of total Responses from Workforce Management - Checklist Real TimeSummary: I am trying to get an OTBI Analysis to return the Count of Responses to the Response Answers to specific Checklist Questions. In the example shown below I would… -
Converting PW to EMP future installments switched to paid on start date instead of staged future datSummary: When converting PWK to EMP, if there are multiple future Sign On Bonus installments, all element entries from the PWK record are removed. Additionally, all inst…Madhuja Bhaumik 11 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Payroll and Global Payroll Interface (GPI)
-
In which page is Military Rank Lookup present?Summary: Hi, We are aware there's a Military Rank lookup as per following documentation We are able to find the lookup, and add values to it, but we do not find this fie… -
Run Employee Active Payroll Balance report for All Balance levelsSummary Way to run Employee Active Payroll Balance report for All Balance levelsContent Is there any way to run the Employee Active Payroll Balance report for All Balanc…User_2025-01-30-17-58-41-867 139 views 5 comments 1 point Most recent by Phani S-Oracle Reporting and Analytics for HCM
-
How to fetch Audit reports under tools or how to schedule the audit report and get data on a dailySummary: Hi Team, I need to fetch audit data, I am able to export the data from the audit report under the tools, how to schedule this report on a daily basis or help me…nanda.patil 201 views 3 comments 1 point Most recent by Ashwin Sinha Reporting and Analytics for HCM
-
Could not find the lookup HRC_TRANSACTION_STATUSSummary Could not find the lookup HRC_TRANSACTION_STATUSContent Hi Experts, As a part of pulling the Approval Transaction Details, I have used the table HRC_TXN_DATA. Th…Charan Kollipara 108 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to report Job Details > Action reason in OTBISummary: We use the 'Action Reason' field in Workforce Structures - Job Details to record why we created or updated a job. We would like to be able to report on this fie…Lachlan Tanner-283818 61 views 9 comments 0 points Most recent by Kayla Malecki Reporting and Analytics for HCM -
Base table - Email Notifications Workflow approvalsContent Hi, I am looking for a table that holds emails sent out of the workflow mailer. I am specifically looking for details such as Transaction/Task id along with an e…Sriharsha Devraj 633 views 2 comments 0 points Most recent by User_AOTJG Reporting and Analytics for HCM