Global HR
Discussion List
-
document recordSummary: If I upload documents to document records, I want a report to show me the details of the document as entered into Oracle, the ability to filter by document type…Asha Barnes 22 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to fetch the Initials of the employee using OTBI?How to fetch the Initials of the employee using OTBI?Hazel De Castro 31 views 2 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
Report/Tables to extract User Role change History for every role assigned/revoked on a userSummary: Hi Experts, We have a requirement from the customer to track the history of changes on a user roles. Ex, If a user has been assigned a role on 01-Jan then that …Abhinay Singh-Oracle 143 views 1 comment 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
BIP Report: Position title change data irrespective of their current employment status.Summary: Hi experts, I am looking for a report which can return previous and current employment fields if position gets changed. Mainly looking out for these fields: Pre…
-
Document record request, details are not reflecting on Supervisor's notification page.I'm raising a Document Record request from an employee user but in supervisor's notification page the document details are not reflecting in the document details column …
-
Generate query related ODA reportsSummary: I want to generate analytics report for responses for specific queries like feedback query to understand bot responses and communication with user to improve pe…
-
Is it possible to include Null values in BIP Report Parameter?I'd like to pull null values within my report. Is it possible to run the report with 'null value' parameter? -
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 15 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 12 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 22 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 13 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 22 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 120 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 21 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 Kuamr 12 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 45 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 819 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 365 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…