Global HR
Discussion List
-
Timing issue for an SQL querySummary: Content (please ensure you mask any confidential information): Hello experts, we built a query to retrieve the organization manager assignment id for a specific… -
Calculate FTE and headcount automatically filed nameSummary: Calculate FTE and headcount automatically filed name Content (please ensure you mask any confidential information): In the "Change Assignment" UI, we have "Calc… -
How to create BI report for checklist task type "Report" which accepts the parameter as AllocatedCheSummary We have requirement that one of the Task performer (which is last task in checklist) wants to review the report with all other task performers input to DFFs and …
-
Person Costing Page Not Updating with Hire Date ChangesSummary: We recently updated an employee's hire date using 'Employment Start Dates' quick action from October 21, 2024, to November 25, 2024. The assignment page reflect…Madhuja Bhaumik 20 views 0 comments 0 points Started by Madhuja Bhaumik Payroll and Global Payroll Interface (GPI)
-
Task Type in Subject Area Workforce Management - Checklist Real Time - Checklist Task TemplateSummary: 1- Looking for the Task Type in the Subject Area Workforce Management - Checklist Real Time. This is to pull the configured task type for various tasks in the j… -
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 643 views 16 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How do I write a number in full in the report?Summary: I need to write the salary amount in full, for example, R$ 1,000.00 (one thousand dollars). I know it's possible using a PL/SQL function, but I couldn't do it i…Simiao Oliveira 11 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
We are trying to send a static (fix)pdf attachment to all newly created candidatesSummary: We are trying to send a static (fix)pdf attachment to all newly created candidates, for that we tried below query . Have uploaded a pdf doc to content server as…Awadhendra Tripathi 33 views 3 comments 0 points Most recent by Manikanta Reddy S Reporting and Analytics for HCM
-
In-app FYI notifications Error -The transaction details are no longer availableGetting Below Error in In-app FYI notifications The transaction details are no longer available here because the approval process is complete. Please find my below obser…Rama Krishna Annam 39 views 2 comments 0 points Most recent by Sowmiya Velusamy Human Capital Management
-
Embedded OTBI Analysis Refresh IssueHi, I'm using an embedded OTBI Analysis within Fusion HCM on Candidate Submission Profile. I'm running into a cache issue where if the report is viewed before the result… -
DocumentsOfRecordEO psValue Meaning/ MappingSummary: Mapping/ Meaning for DocumentsOfRecordEO psValue Content: Support doc https://support.oracle.com/epmos/faces/DocumentDisplay?id=2692905.1 refers to different fu…Jan Barz ACN 21 views 1 comment 1 point Most recent by Ravinder Namsani-Oracle Human Capital Management
-
Privilege required to see Home Phone and Home Email Address in BIP ReportSummary: Content (required): We have few BIP reports created to cater to the client requirement. We see that the report doesn't fetch the Home Email Addresses and Home N…Prajna Hegde 195 views 11 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Active department not found in reportHi, We are using the department level to differentiate between departments (divisions, sections, units). We have created a new tree version based on the new requirements…Catherine Abi Samra 14 views 2 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
Need to report on Employees work schedules and patternsContent Hello, We need to be able to report on employees work schedules and patterns so we can create a report that looks like a calendar and show the days that employee…
-
Extract Rollback using SOAP serviceSummary: Unable to rollback extract using Flow Action Service Content (please ensure you mask any confidential information): Hi, I am using Flow Action Service With Perf…Shanmugaraja_Karunamoorthy 3 views 0 comments 0 points Started by Shanmugaraja_Karunamoorthy HCM Extract
-
OTBI Vacancy ReportSummary: Is there a way to report using Subject Area(s) all current employees and any requisitions and vacancies so we have one entire list? For example a report that sh…JHaden3 142 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HCM Transformation Fast Formula : Getting all Metadata for AssignmentWe are trying to develop Worker.dat which will include Workterm and Assignment Metadata why We are able to get all the required fields metadata for worker but somehow as…Ajitabh Kumar-Oracle 21 views 1 comment 0 points Most recent by Ajitabh Kumar-Oracle Reporting and Analytics for HCM
-
Calculating average headcount and turnoverSummary Calculating average headcount and turnoverContent We'd like to be able to calculate the average turnover rate for rolling 12 months by using Period End Headcount…Emily Robinson 345 views 5 comments 0 points Most recent by Lauriane Massin Whitaker 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 18 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Limiting restricted, Confidential and PII fields BI Authors in HCMSummary: Our goal is simple: Make OTBI authorship available to as many HR and potentially non-HR employees as possible while being conscious of security. Example: Make a…bwdata 32 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Assignment Manager (Unsecured) Dimenssion in Goals Real Time SASummary Data Role Data security not working in OTBI, when using the Assignment Manager (Unsecured) Dimmension in goals Subject areaContent Hi Team, We are using the Dime…Chethan Voma-20174 51 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
retrieving timestamp is not giving correct date and timestamp from Table PER_EXT_APP_IDENTIFIERSSummary: retrieving timestamp is not giving correct date and timestamp from Table per_ext_app_identifiers Content (please ensure you mask any confidential information): …
-
SQL query to retrieve Division Name and Manager division display nameSummary: Content (please ensure you mask any confidential information): Hello experts, I need to extract the Manager Division full name field and the Division name as we…Valerio Curzi 25 views 4 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM
-
Query to get Report run History in Fusion HCMSummary: Query to get Report run History in Fusion HCM Content (required): Hi All, Can we get the detail who all have run the BI report, is there any query available. He…Swati U 1.1K views 11 comments 0 points Most recent by Punam Roy Karmokar-272206 Reporting and Analytics for HCM
-
Termination Headcount from Trend real Time not giving correct headcountSummary: I'm working on an OTBI analysis to calculate and display the turnover percentage for leavers over the last two years as a line graph. The objective is to show t…
-
How to get Month name as abbrevation concat with year in OTBIHi Experts, Can someone please help me how can we get Month name Concat with year in the same column in OTBI. We have a requirement to show the date's in the below scree…
-
How to get the Top-Down Manager Hierarchy in OTBI expect CEO,remining Top down 3 Manager hierarchy.Summary: Currently we are looking to fetch top down manager hierarchy in one of our OTBI reports like from CEO to employee Top level manager hierarchy to fetch in to the…challa praveen 641 views 29 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Query to get Position History along with Changed Attributes.Summary : I have a requirement to find out Position History details along with the changed attributes as shown in screenshot below. If anyone have query for this kindly …
-
Get firstname lastname of user without person recordSummary: Requirement to get firstname, lastname of a user record which doesnt have a person record. since its ERP project, HCM part would not have been configured. PER_L…Jaeyshree K K 4 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Notifications are disappearing from bell icon under "Assigned To Me / All" Tabs but showing in BPMSummary: Notifications are disappearing from bell icon under "Assigned To Me / All" Tabs but showing in BPM worklist Content (required): Version (include the version you…