Global HR
Discussion List
-
Is it possible to track how many employees clicked on a particular tile in the HCM Open Page - Eg: PSummary Is it possible to track how many employees clicked on a particular tile in the HCM Open Page - Eg: Person ManagementContent Hi Team, Is it possible to track how … -
Is anyone using an Oracle Custom Form for W4Summary: We are live with Oracle Core HR, Advanced Comp. Our Payroll and time tracking is still on our legacy system. We are looking for a way to capture W4 information …Neno Kolonich 1 view 0 comments 0 points Started by Neno Kolonich Payroll and Global Payroll Interface (GPI) -
Can we display alpha numeric values in Pivot table?Summary: Can we display alpha numeric values in Pivot table? Content (please ensure you mask any confidential information): We have a requirement to fetch the UDT (User … -
Does anyone know formula for Turnover% in Line Manager DashboardDoes anyone know formula for Turnover% in Line Manager Dashboard ? or do we need to edit the report, check the query and find it out ourselves. There is literally no doc…
-
SQL query that brings the fields to HDL for CostCenter?Summary: Content (please ensure you mask any confidential information): Does anyone have a SQL query that brings the fields to HDL for CostCenter ? Simple with the minim… -
losing headcounts while using some columns in parameter FDIHello I'm facing an issue while using a parameter in FDI for the subject area HCM - Workforce Core. below an example when I use this paramater, I get the right headcount…Ayoub AFRASS 12 views 2 comments 0 points Most recent by Ayoub AFRASS Reporting and Analytics for HCM -
Length of Service based on Rehire date calculationContent I am trying to calculate Length of Service based on employee's latest hire date. I used Workforce Event Real Time subject area to calculate the rehire date (usin…Riti Malhotra 129 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Multiple Templates - BI Publisher BurstingSummary Multiple Templates - BI Publisher BurstingContent Hi Experts I have a BI bursting report where we need to send an attachment as well as the bursting email notifi…Mansur Khalil 200 views 7 comments 0 points Most recent by Yahya Khan Reporting and Analytics for HCM -
How to embed/display the DOR attachments/images (blob data) in BIP reportWe have a requirement where employees signature needs to be captured in BIP template/report. So we are thinking of loading the employee signatures as an image via DOR ag…
-
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 attach custom bi report to document of recordsSummary: How to attach custom bi report to document of records Content (please ensure you mask any confidential information): Hi All, We got a requirement to attach bi r…
-
Restrict report access based on AORHi All Can we restrict the report access on a common report which has Master details based on the department. Lets say there are 10 departments in the report and Person …Dhilipkumaar-Oracle 1 view 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Requesting details on FDIHi Team, We are planning to implement FDI module ( Reporting ); and I am unable to get much details on FDI on CCC as well as on HelpCenter. Can you kindly assist on the … -
In what Subject will I find Vacation Service Date?Summary: I am looking for pull the Vacation Service Date for all EEs, however, this does not appear in the analysis listing and I cannot find the specific subject that t…Kelly_at_D&R 61 views 4 comments 0 points Most recent by Mohammad Afghanul Payroll and Global Payroll Interface (GPI) -
How do I get current status of previously terminated employees onto a report?Summary: I have a termination report with all prior terminations on it. However, for rehires, I want it to show that they terminated but I need to know that they are cur…
-
How to create a document of record to run BI Publisher report from it?Summary: I need to create a document of record in oracle fusion, this document of record will contain few fields to be used as a report parameter, the purpose of the doc…
-
How to fetch CURRENT and PREVIOUS Salary using BIP?I need columns to compare the CURRENT and the PREVIOUS salary of employees in 1 row only. How to construct the BIP report using SQL?Welsey 682 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
BIP or OBTI Auditing Users making changes to their own HCM/Payroll DataSummary: Does anyone have or know of any current reports that will give details on Oracle HCM users who have made data changes to their own Global HR/Global payroll info…
-
How to fetch Resignation details, which include Resignation reason,,Summary: This is the resignation page in Me tab. How to fetch all These details using SQL?Aryan Yadav 13 views 1 comment 0 points Most recent by Vishnu Vardhan Raju Reporting and Analytics for HCM -
Ability for employee to self report a conflict of interest.Summary: I have a requirement for an employee to be able to self report conflict of interests, including employment of relatives, material interest and outside interest.…
-
The manager and assignment details are not displaying on the Security Console page for the employee.Summary: The manager and assignment details are not displaying on the Security Console page for the employee. Content (please ensure you mask any confidential informatio…
-
OTBI filter - Two columns don't matchSummary: Is it possible to create a filter (maybe a new column to calculate?) to only provide results if two columns don't match? I can't imagine it's a common thing, bu…
-
WorkRelationshipPVO missing DFFsSummary: WorkRelationshipPVO is missing DFF's such as PDS_INFORMATION% and PDS_INFORMATION_DATE% columns from PER_PERIODS_OF_SERVICE. We are using DFF's to populate cust…
-
Need Oracle SQL query to get the Office number for Location details from Assignment pageSummary: Need Oracle SQL query to get the Office number for Location details from Assignment page Content (required): Need SQL Version (include the version you are using… -
LOOKING FOR OTBI REPORT FOR EMPLOYEE AND CONTACT DETAILSI am looking for a report that shows the details of Employee and the Contact details. Columns such as Employee Number, Employee name, Contact Name, Contact Phone number,…
-
Query to retrieve manager assignment numberSummary: Content (please ensure you mask any confidential information): Hello experts, we need for each employee to retrieve the line manager assignment number. Do you h…Valerio Curzi 132 views 5 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Can you use "prompted based on results of another analysis" when using presentation variables?Summary: Essentially we need to find the delta/ difference between two analyses that are date tracked to different points in time in the Prefix of the OTBI Analysis usin…
-
Query to find BIP report schedule detailsSummary: Query to find BIP report schedule details Content (required): Hi Team, We have requirement to fetch the schedule details of a BIP report like schedule start dat…Vasanthakumar Ravi 2.6K views 8 comments 1 point Most recent by Dev V Reporting and Analytics for HCM -
Columns Missing from the Subject Areas in OTBIwe have 3 OTBI reports showing error in the output, when i checked, some of the column headings are in the report like 1.Deduction Developer DF_QUALIFYING_PEN_SCHEME 2.D…Global Support Desk 30 views 3 comments 0 points Most recent by Global Support Desk Reporting and Analytics for HCM