Global HR
Discussion List
-
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 128 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…
-
Custom BIP reports - Security access to view scheduled job outputsSummary: Hi All, We have 5 custom BIP reports, which are shared via scheduling to 5 different groups of people in our organization. We are not sending the output via ema… -
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 622 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 11 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 115 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.5K 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 21 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 -
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…Dasari Dileep 283 views 5 comments 0 points Most recent by kanchana venkatasubramanian Reporting and Analytics 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
-
25A New Feature : View Journeys Analytics - How to hide response Summary buttonSummary: We need to hide the Response Summary button, where Oracle soak testing confirmed this can not be handled by privileges, they told to raise SR and SR redirected … -
Primary keysSummary: Is there any document listing the Primary keys to be joined in the fscm oracle pvo ? Content (please ensure you mask any confidential information): Version (inc…Lauriane Massin Whitaker 21 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for SCM