Global HR
Discussion List
-
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 14 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 12 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 143 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 197 views 3 comments 1 point Most recent by Ashwin Sinha Reporting and Analytics for HCM
-
Database Table name for Approval DelegationsSummary: We have a requirement to build a report for approval delegations, thus need the database table name for Approval Delegations. Navigation: Person Management > Se…
-
Help Needed: Retrieving Current Address for a Legal EntityHi Everyone, I'm trying to retrieve the current address for a Legal Entity, but I'm facing challenges in identifying the correct tables and joins. Context: I understand …Saurabh_Mharolkar 41 views 7 comments 0 points Most recent by Jose M Juliá 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 112 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 66 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 613 views 2 comments 0 points Most recent by User_AOTJG Reporting and Analytics for HCM -
BIP HCM Payroll - Is there any alternative to pull the Payroll process statusBIP HCM Payroll - Is there any alternative to pull the Payroll process status apart from below Query /* ( SELECT meaning FROM hcm_lookups WHERE lookup_type = 'ORA_HWM_PA…BhaskarDondapati 271 views 10 comments 0 points Most recent by Sunil Makam Reporting and Analytics for HCM
-
HCM Alert Employment DFFHi Gurus, We have a termination Alert Configured using HCM Alerts where we send notification to all HRBPs for employee who got terminated one day prior. The alert is wor…Debasish Saha 21 views 1 comment 0 points Most recent by Tamilarasan Sekar Reporting and Analytics for HCM
-
OTBI Report isn't showing all employees' dataSummary: OTBI Report isn't showing all employees' data. shows only Person number and name. Content (please ensure you mask any confidential information): When creating O…
-
Headcount and salary report with as of date using Workforce Assignment Salary History Real TimeSummary: Objective: To create an analysis with headcount (aka assignment) and salary data. Issue summary: We believe [Compensation - Workforce Assignment Salary History …
-
HCM Extract Parameter LOV values are blank and the parameter is made out of Value setsSummary: I am working on HCM to WACS OOTB. HCM Extract Parameter LOV values are blank and the parameter is made out of Value sets . Value sets are configured properly. P…Rajajeyakumar 14 views 6 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM
-
Accurate Headcount Reporting in OTBI even after department changeMy goal is to accurately reflect the headcount by department, ensuring that the count includes only active employees, even if they have changed departments. Currently, w…Nithin Reddy 7 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Redwood Workflow NotificationsWe have custom workflow notifications currently still in the Classic UI. We are in the process of migrating all modules to Redwood. Please help us transfer the custom wo…
-
Workforce Management - Person Real Time.Person Legislative Information Education Level doesn't showHi We have OTBI report which doesn't show Education data. We use Person Real Time.Person Legislative Information subject area. In application user can see the data. What…
-
Need SQL to extract Individual Compensation entries prior to approvalSummary: Need SQL to extract Individual Compensation entry values prior to Approval Content (please ensure you mask any confidential information): We need to report on I…SRIROU 80 views 5 comments 0 points Most recent by Prasad Singamaneni-Oracle Reporting and Analytics for HCM
-
Table names/SQL query for Individual Compensation details in HCMSummary: Hi All, Can you please share me the Table names/SQL query for Individual Compensation details in HCM. Thanks, Janardhana Content (required): Version (include th…Janardhana K 5.1K views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to Default Assigned Project to Web Clock and Time Card Based on Project Execution AssignmentSummary: Hello, In Oracle Time and Labor, we want the Project field in both Web Clock and Time Entry Layout (Time Card) to be automatically defaulted with the project th… -
Few privileges are not available in the database tableSummary: There is issue with the privileges: Few privileges are not visible when query directly from roles/privilege screen while the same is visible when query a role. …Shailender Ahuja-Oracle 2 views 0 comments 0 points Started by Shailender Ahuja-Oracle Reporting and Analytics for HCM
-
enhanced talent profile HDLSummary: Hi everyone, In Redwood,We cant update the existing talent profile item values. To update existing values we need to populate learning or certificate label.Plea…Krishna Manmohan 17 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How to create report on employee project manager ?Summary: Hello, For our Blue Collar Population we are using the role of Project manager in addition to the Line Manager. Our issue is that we don't find the subject area…LucieWS 22 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Query to retrieve Union fieldSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query to retrieve the employee Union name as in the attached …Valerio Curzi 13 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need to fetch the Content ID of HCM ExtractSummary: We have requirement to fetch the Content ID of HCM Extract through BI report. Any one have idea how we can fetch Content Id. Content (please ensure you mask any…
-
Service Account not able to report on FeedbackSummary: We have a service account that we use for reporting purposes in OTBI. Typically, this account is able to pull accurate data across all Business Units. We discov…Megan Obiedzinski 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM