Global HR
Discussion List
-
Audit Document Records AccessContent Hi experts - hoping you can help with an OTBI or BIP audit report. I have the tables needed to run a report on what documents exist in the Document Records secti…Prudence K 126 views 11 comments 0 points Most recent by Malla Pratibha Reporting and Analytics for HCM -
Alert (Bell) Notifications to Line Manager from OTBISummary Alert (Bell) Notifications to Line Manager from OTBIContent I have a requirement where i need to send a notification as well as an email to a line manager when t…Mansur Khalil 140 views 7 comments 0 points Most recent by User_ZICBC Reporting and Analytics for HCM -
How to remove these many duplicates of Child Role columnDear Experts, The Below query producing duplicates. Could you please help out me. Query: ============================================================================== S… -
From which table can I obtain the Manager Overall Rating field?Hi, I want to add the Manager Overall Rating field to a report. Can I do this with SQL? In which table do I find this field? In OTBI, I can achieve this by using the Wor…Cansel Karasoy 286 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Can I add a response button to BIP bursting emails?Summary: We need to send emails to external candidates and get their responses. Is it possible to add a response button to emails? TYIAEm-Jay 24 views 1 comment 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Randomization of employee list(from different BU/Department) for every runSummary: Report to fetch Random list employees for every run Content (please ensure you mask any confidential information): I need the report to fetch randomized list of…Raksha Govindaraj 25 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Transaction ID is missing Human Capital Management - Approval Notification Archive Real TimeSummary: We are trying to develop a report with below two subject area Workforce Management - Worker Assignment Event Real Time and Human Capital Management - Approval N…ISHWTW 52 views 2 comments 0 points Most recent by User_2025-11-28-01-12-01-794 Reporting and Analytics for HCM
-
Sql to fetch reason from payment details pageHi Team i want to fetch the reason column from payment result screen. Please find the attachment for referance.Chetana Pawar 15 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Journey Audit_action_type_Summary: From table PER_ALLOCATED_CHECKLISTS_TL_ in AUDIT_ACTION_TYPE_ how to get 'DELETE' value I am unable to get it, from the backend. I have deleted the assigned Jou…Afrid_3R3AE 19 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Is there a way to bring UNION_ID for an employee in FAW? Please suggest a suitable PVO for UNION_ID.How to get UNION_ID for an employee in FAW? It is not present in assignment table: dw_wrkfrc_asg_f.Rituparna Maity 25 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to Restrict BIP report data based on the AORsSummary: Hi All, @Mandeep Gupta --> If you have faced any such type issues kindly help me with this. I have a requirement to build a BIP report in such a way that If emp…Dasari Dileep 458 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Get Time Card Period (Employee Time Card Details)Summary: We have a requirement to get employee's timecard (timeentry details) ... daywise. We have got the measure (days) from the table hwm_tm_rec using the resource_id…
-
Parag Hiremath 9 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Aaron Reynolds 18 views 1 comment 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM -
Compensation Salary History Details Real Time not showing data for leaversSummary: Hi all I have built a report in OTBI using the Compensation - Salary History Details Real Time. I noticed I am missing data for employees who have left the orga…NusratB 83 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Can we Autopopulate TRU as per the Legal Employer, when when hiring an employee.Summary: When hiring an Employee/converting a Pending Worker, in the Payroll detail section, we need to auto-populate the TRU as per Legal Employer. Is this achievable t…Megha N. 18 views 1 comment 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
How to Create a Report for "Correct Employment" Transactions?Summary: I need to create a report for all the Correct Transactions performed by the HR team in a day/week/month but not sure which table to use? Is there a way to repor…Amit Mundlye-27103 17 views 1 comment 0 points Most recent by Iulian Brinzoi-Nuta - HCM-Oracle Reporting and Analytics for HCM
-
Workforce Structures > Job Detail Screen - Can You Report a History of Changes?Summary: Is there a way to write an OTBI report that shows old and new values, field name and date of change entered on the Job Detail screen (Workforce Structures/Job D…
-
Schedule report to run based on Last Run DateSummary: Is there a way to schedule a report to run starting from last run date? Content (please ensure you mask any confidential information): Version (include the vers…THawkins_LGI 36 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
In which table is the information about who rejected the notifications with rejected status?Hi, I would like to access the information on who and on what date the rejected leave notifications were rejected in the system. I would appreciate it if you could share…
-
Grade values not appearing in the notification templatePlease refer to the document below for more information about the encountered issue. Thank you.VDoolhur 6 views 1 comment 0 points Most recent by ravali koaduru-Oracle Reporting and Analytics for HCM
-
How to sort characters numerically in OTBI?I'd like to order these custom values in OTBI numerically. However, this is how my current values sorted: The requirement is to sort them like this: 0-0.5 0.5-1 1-3 3-5 … -
Adding Grade Details to Standard Approval Workflow Notifications using Custom templateBusiness has a requirement to add Grade under Employment Details section that is displayed in the delivered/standard Workflow Approval notifications. We have tried achie…Neeraj Awate 15 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management
-
how to disable expired identity service provider(SSO)?Summary: In our single sign on configuration page(Security console), we see two expired identity service provider(certificates) with Enable Flag= Yes, we would like to k…Sushant95-Oracle 28 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
Salary Amount Fast Formula Compilation ErrorSummary: Fast Formula for getting Salary Amount is giving compilation error saying: the assignment uses inconsistent data types Content (please ensure you mask any confi…
-
Solutioning Data Archival for US(United States) and CA(Canada) Legislations.Summary: My Client has a requirement to archive complete fusion data and I want to understand how could we preserve anything and everything from Fusion HCM Cloud's Criti…SAHILVASYANI 45 views 5 comments 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
Need report of SVC_SERVICE_REQUESTS table details with SR employee, his dept, reporting dept, team,Summary: Need report of SVC_SERVICE_REQUESTS table details with SR employee, his dept, reporting dept, team, unit,section, trying with following query, but i am getting …
-
how to get the length of service based on gradeSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…a.w.anand 18 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
CSV output in body and attachmentSummary: Is it possible to show data in CSV format in the body of the email bursting as well as in an attachment? Content (please ensure you mask any confidential inform…Consultant Ian 15 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Employee Advance details in oracle Fusion HCMSummary: Employee Advance details in oracle Fusion HCM Content (please ensure you mask any confidential information): Hi, Please help to identify table/query for Employe…Hitha Harikumar 136 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM