Global HR
Discussion List
-
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 114 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 760 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 43 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 236 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… -
Auto Reject approval is showing rejected by themselves in notificationSummary: Auto-rejected approvals are displaying as "Rejected by themselves" in the notification, while in the Transaction Console, they show as "Rejected by Workflow Sys… -
Help to extract usersSummary: I need help to extract the following information: Person Number Email Username User Status (active or inactive) Does anyone know the query to do this? Thanks, A… -
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.7K 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 43 views 3 comments 0 points Most recent by Global Support Desk Reporting and Analytics for HCM -
"Report of the day" - Report about all data added/changed todayHello, I am looking for a report, which shows ALL data that have been added/changed by any user in the system per day. We have some troubles with one of our interfaces b…Michael Schweizer 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
When FTE is changed to 0, salary does not get changed automatically to 0.Summary: if we are changing FTE to 0, salary should automatically get updated to 0, but this is not happening. Content (please ensure you mask any confidential informati…Ayushi Vaswani 23 views 2 comments 0 points Most recent by Ayushi Vaswani Visual Builder Studio for HCM -
How to remove edit button Edit button from name and demographic section from personal InfoSummary: I want to remove/hide Edit button From Personal Details page for Name section and Demographic Info section in Redwood. In my responsive setup it is done via pag…Neha Thakre 2023 580 views 5 comments 0 points Most recent by Chris Borsh-Oracle Visual Builder Studio for HCM -
How to Hide URL box and Add URL button in Personal Information PageHi Experts, I need help in hiding URL box and Add URL button in Personal Details screen. I was able to hide COMMENTS option. But not able to find the option to hide thes…Jagdish Kolli 32 views 2 comments 0 points Most recent by Jagdish Kolli Visual Builder Studio for HCM -
Amending Redwood Notifications in VB StudioSummary: Can you amend HCM notifications which are now in Redwood format using VB Studio ? Content (please ensure you mask any confidential information): For custom noti…Junade Shujaat-143572 1 view 2 comments 0 points Most recent by Junade Shujaat-143572 Visual Builder Studio for HCM -
I need to update position of employees using HDL w.e.f 1st Feb 2025Summary: Hi There, Can someone help me with the HDL template to update the employees' position with effect from 1st Feb 2025. Appreciate your help! Thanks, Lakshmi. Cont…Lakshmi Devi Bathala 11 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM