Global HR
Discussion List
-
Business Unit Name ER_EXT_SEC_HISTORY_ASSIGNMENTS_UETeam, We have created an extract and using PER_EXT_SEC_HISTORY_ASSIGNMENTS_UE. Attributes: Business_Unit_ID - Extract Historical Assignment Business Unit ID (DBI) Busine… -
OTBI Analysis for Remote Workers and Onsite Associate Work Location State and Postal CodeSummary: We currently have a large population of workers who work remote or their "Work Location" is classified as their home office. Our population of around 18,000 wor…Kayla Malecki 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Integrate OTBI with ODASummary: I need more clarity on the feasibility of the integration of OTBI/BI publisher with ODA. Is it possible to access OTBI report from ODA ? Content (please ensure …
-
Optimizing Infolet Loading Time on the SpringboardHello Community, We’ve designed and implemented multiple infolets for employees, line managers, and HR, placing them on the springboard to provide quick access to releva…Harish Vummidi 11 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Request for Infolet Samples to Enhance User Experience in Core HR, Absence, ORC, OTL, and PayrollHello Community, I’m currently exploring ways to enhance the user experience for employees, line managers, and HR teams in Oracle Cloud by leveraging infolets effectivel…Harish Vummidi 22 views 0 comments 3 points Started by Harish Vummidi Reporting and Analytics for HCM
-
HCM ExtractsSummary: There is one requirement in HCM extract currently we are fletching primary address in Extract but now we need who are all employees having Mailing address need …
-
what is the difference in oracle cloud hcm core from legalentityID to legalentityorganizacionid?Summary: Content (please ensure you mask any confidential information): what is the difference in oracle cloud hcm core from legalentityID to legalentityorganizacionid? … -
Calculating Days in Calendar Year on a Suspended StatusSummary: Part of our annual incentive program, we prorate any worker who has been in a Suspended Assignment Status for greater than 90 days in the Calendar Year. Looking…Kayla Malecki 21 views 4 comments 0 points Most recent by Kayla Malecki Reporting and Analytics for HCM
-
Can anyone help with a report to find potential duplicate employeesSummary: We have Contingent Workers who instead of being re hired as Permanent employees against the CWK record, these are being rehired as new employees creating duplic…Laura_Stewart_Sita 11 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
23D:AUDIT MASS DOWNLOAD OF DOCUMENT RECORDS-hr_dor_mass_requestsHello All I am trying to query the hr_dor_mass_requests and its populating the values. It populates the numeric values for status and object version number as 3,4,7. wha…
-
Which table contains the information from Manage Legal Reporting Unit HCM Information ?Summary: Content (please ensure you mask any confidential information): Which table contains the information from Manage Legal Reporting Unit HCM Information? Version (i…OliveiraRR 21 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How do I do a simple SQL to bring the Name, Legal Entity and registration number of the Legal ReportSummary: Content (please ensure you mask any confidential information): How do I do a simple SQL to bring the Name, Legal Entity and registration number of the Legal Rep…OliveiraRR 125 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Custom report is changed using page integration. But the link is showing the previous reportThe report is added to the home page as a page entry using page integration. Later the report path is changed and report is modified using page integration. However, the…Reshma Eldho 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to return values within a subquery by referencing tables from outer query?Summary: Content (please ensure you mask any confidential information): How can I return the name of the task owner from Oracle HCM Journeys using the Task Owner Person …Giuseppe Cannova 22 views 2 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM -
How to add background image in fusion home pageSummary: How to add background image in fusion home page Content (please ensure you mask any confidential information): Hi All, How to add background image in fusion hom…
-
how to customize employee promotion letter notificationSummary: how to customize employee promotion letter notification Content (please ensure you mask any confidential information): Hi Team, We got a requirement to add new …
-
loader for licenses and certificationsSummary: I'm trying to figure out how to do a bulk load of employee licenses/certifications with the field below. I looked in HSDL and I'm not sure what I need to pick t…
-
Change assignment transaction cannot be approved with a comment.Summary: In change assignment, transaction cannot be approved with a comment but without comment it can be approved Content (please ensure you mask any confidential info…Abhishek Kr. 11 views 1 comment 0 points Most recent by Rambabu Laveti-Oracle Human Capital Management
-
Projected start date field in OTBI showing incorrect valueThe Projected Start Date in the OTBI Recruiting Real Time subject area doesn't appear to be pulling accurate data. We tried changing time zones but at the end of the day…Vaishnavi Katiyar 41 views 5 comments 0 points Most recent by Chantel Berger Reporting and Analytics for HCM
-
Using the Termination Date value for counts between Calendar Month Start Date & Calendar Month EndSummary: I have read a lot of posts where individuals have been looking to get counts of employees who have a termination date between X & Y. However, if an employee has…
-
OTBI - Calculate age in years and monthsSummary How to calculate the age in years and months?Content Hi, In OTBI I want to create a column which present the full age of the employee, for example 43.12 (means 4…Yaniv 830 views 18 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL query to retrieve employee country (work relationship level)Summary: Content (please ensure you mask any confidential information): Hello experts, is there a way to retrieve Country field at the employee level by SQL query? If so…Valerio Curzi 405 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to get one time data in audit tables after enabling auditing for HCM processes.Summary: How to get one time data in audit tables after enabling auditing for HCM processes. Content (please ensure you mask any confidential information): We have enabl… -
Query to get REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, REQUISITION STATUSSummary: Can anyone please help me in writing a Oracle SQL Query for BI Report to fetch columns like REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, RE…a.w.anand 2.3K views 9 comments 0 points Most recent by Gongati Nandish Kumar-Oracle Reporting and Analytics for HCM
-
Fast Formula with FF type "Extract Criteria" is not working when we are trying to add it in extract.Summary: Hi Team, We have designed extract to pull the employee assignment details but it was picking the multiple records for an employee. We used fast formula in "Filt…
-
Trying to Retrieve the Specific Ethnicity Record Associated with each Period of ServiceSummary:It appears that there is a separate row in table per_ethnicities for each of an employee's period of service. Looking for a query Content (please ensure you mask…ChicagoConsultant 1 view 1 comment 0 points Most recent by ChicagoConsultant Reporting and Analytics for HCM
-
Recently updated data in an Org Tree is not displayed in OTBI reportsSummary: In mid December, I created about 20 new departments and tied them to existing Divisions in an Organization Tree. The departments were created with a 1/1/25 effe…
-
adding different manager types to analysis reportsHello there, I have prepared a report from the analysis and in this report I would like to see the types of managers that people are affiliated with, such as head and ex…Sinem Kara 21 views 4 comments 0 points Most recent by Girish Kushibi Reporting and Analytics for HCM
-
Approvals are in progress. Info is lockedHello, I am trying to transfer an employee from one legal entity to another and I am getting a message that approvals are in progress. I tried to run the Conflicting Tra…Catherine Abi Samra 262 views 6 comments 0 points Most recent by Rahul M Reporting and Analytics for HCM -
Submitted Timecard and Web Clock Details ReportSummary: Need to SQL query for view the detail of submitted timecard and web clock's reported hours and schedule deviation with custom attribute. Content (please ensure …Melek Cinar 466 views 6 comments 0 points Most recent by Melek Cinar Reporting and Analytics for HCM