Global HR
Discussion List
-
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 11 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 138 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 210 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…
-
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…
-
Personal Details VBS Rules Weird BehaviorSummary: Hi Community. I am facing some weird behavior when creating rules in VBS for Personal Details page. I have 3 rules(One For HR users, one for Employees and anoth…Gaurav Rath- PGC 21 views 1 comment 0 points Most recent by Gaurav Rath- PGC Visual Builder Studio for HCM -
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 -
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 62 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…
-
AI Assist button for posting descriptionSummary: Hi Experts, I have enabled the required profile options for AI Assist button for posting description and set Show AI assistant for posting description as True f…Ayushi777 141 views 1 comment 0 points Most recent by Luke Yang-Oracle Visual Builder Studio for HCM
-
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…
-
Create pop up screen when users log in as survey.Summary: Hello All, is there's way we can create pop up survey, when employees log in to fusion. and user must click on it submit and then he can enter to homepage. Belo…
-
seniority date calculation on based on assignment DFFSummary: We have a requirement to split and calculate seniority dates based on a DFF (configured at Assignment). Example Hire Date DFF Value 1.1.2020 A 1.1.2021 B 1.1.20…
-
Biographical DFF attributes are not customizable individually in personal details page of RedwoodSummary: Unable to customize biographical dff attributes individually in personal details page of redwood Content (please ensure you mask any confidential information): …
-
How to default person type in hire an employee flowSummary: Are we able to default Person Type in the Business Rule for Hire an Employee Content (please ensure you mask any confidential information): I am wondering if an…
-
How to display data in Proper format using eText templatesSummary: How to display data in Proper format using eText templates? Content (required): We have a requirement for displaying the output data in Proper format for a fiel…User_2025-07-18-01-28-01-258 111 views 4 comments 0 points Most recent by Lasya Priya Seelam HCM Extract
-
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 793 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 41 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 274 views 5 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM