Global HR
Discussion List
-
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 397 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… -
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.2K 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 14 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 13 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Can we download the attachments from BPM tables wfattachment?Summary Create hyperlink to download the attachments from BPM table wfattachmentContent Hello Experts, I am trying to generate a report with the approval transactions an…Sricharan Monigari 199 views 4 comments 0 points Most recent by User_BOLFT 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 242 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
-
Task Performer name in Workforce Management - Checklist Real Time is blank in OTBISummary: Task Performer name in Workforce Management - Checklist Real Time is blank in OTBI Content (please ensure you mask any confidential information): If the Task pe…AvinashP 21 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Requirement for Custom QuerySummary: Hi Experts! We had a requirement from the customer to have a role which would grant access only to CONTRACTOR records and should satisfy the following condition…
-
Dies anyone know the table and field for "Enrollment Type Description" in OBTI Learning?Summary: Does anyone know is what the table and field that correspond to "Enrollment Type Description" and/or "Enrollment Type" in OBTI. Specifically under "Workforce Le…
-
Matrix Manager HDL Load shows new manager in UI but not in OTBISummary: We completed an HDSL load of new Matrix Manager assignments for employees. The UI shows the new manager but the OTBI report does not. Reflect the update. Is the…
-
Can we send alerts to AOR via alert composersSummary: Hi Team, I have a quick query can we share alerts to AOR / role via alert composers Content (required): Version (include the version you are using, if applicabl…priyankatriv 32 views 8 comments 0 points Most recent by ShivaBildikarMGS Reporting and Analytics for HCM
-
Position History ReportingSummary Is it possible to report on changes to positions themselves over a period of timeContent I have a requirement to report on historical changes to positions in OTB…Jo Kelly 167 views 4 comments 2 points Most recent by Julian Challenger-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 …
-
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…Visu 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
we looking lapsed(Forfeiture) data in all plan types as on dec 2024Summary: Hi Team, we looking lapsed(Forfeiture) data in all plan types as on dec 2024. please find xml of report. Thanks, Ajay Content (please ensure you mask any confid…AjayKumar Maddipati 1 view 0 comments 0 points Started by AjayKumar Maddipati Reporting and Analytics for HCM -
if a journey- checklist is deleted in ORC, what are the ways we can check who has deletedSummary: if a journey- checklist is deleted in ORC, what are the ways we can check who has deleted the checklist. We wish to capture the data of deleted ones Content (pl…