Global HR
Discussion List
-
Generate Employment Letter from Employee Self ServiceSummary: Hello Experts, We have a requirement to develop the Employment Letter from the system from the employee self service. We have checked in the delivered Document …Jaydeep.More 14 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
HR Action / Termination Action in Manage Work RelationshipSummary HR Action / Termination Action in Manage Work RelationshipContent Hi - We are trying to move all of our BI Publisher reports to Analysis and encountered an issue…Roy Paolo Paunlagui 195 views 13 comments 1 point Most recent by Anjaneyulu Reporting and Analytics for HCM -
Exit Interview - ReportingSummary: Can we report exit interview responses on a terminated employee Content (please ensure you mask any confidential information): Hi, We plan to use exit interview…Vijay Mamilla 194 views 3 comments 0 points Most recent by Nazila Dabestani Reporting and Analytics for HCM -
Need inputs to restrict OTBI reports only based on the AOR roleSummary: Need inputs to restrict OTBI reports only based on the AOR role for users that have both AOR and Line Manager data access roles. Content (required): We have cre…Sakthi priyanka B-Oracle 232 views 3 comments 1 point Most recent by GPOtimization Reporting and Analytics for HCM -
OTBI Worker Attributes Changed After Redwood EnablementSummary: Our reports stopped working in Production after migrating to Core HR Redwood. We’ve observed changes in OTBI column attributes when comparing Redwood and non-Re…Josel Pleyto 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
The datatype of this column is NULL and such columns are not supported in the BICC schedule extractWe are facing error "The datatype of this column is NULL and such columns are not supported in the BICC schedule extract" for few columns in HcmTopModelAnalyticsGlobalAM… -
How to get Journey Survey Responses?Summary: How do I report the responses from Journey Surveys to the LMs or HR? Can anyone suggest table names for BI reports or Subject areas for OTBI? Content (required)… -
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 14 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 84 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 42 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 37 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.5K 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 21 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 23 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 244 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 425 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 227 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 12 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…