Global HR
Discussion List
-
Report to view workflow configuration in Fusion HCMSummary Report to view workflow configuration in Fusion HCMContent In Fusion HCM, we navigate to 'setup and maintenance' > 'Manage approvals for Human Capital Management…User_2025-01-25-04-02-13-126 379 views 12 comments 0 points Most recent by SanjayC Reporting and Analytics for HCM -
BI Publisher security on expatriatesSummary: BI Publisher using secured view shows records outside scope of user's AOR who is running the report Content (required): Hello, We have a BI Publisher report on … -
OTBI Analysis transaction report giving wrong result.Summary: Hi Everyone!. I have created an OTBI Report which fetches the Document of Records Transaction. Context: If anyone modifies something in the Document type called…ShawShankk 62 views 6 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Date of Birth less than 16 yearsSummary: Employees with Date of Birth less than 16 years. Content (required): I need to create a list of employees with a Date of Birth recorded that would make their ag…
-
Attrition Rate DashboardSummary: Hi Everyone, I am just wondering, if there is any seeded dashboard available to fetch the information about the attrition rate. Thanks in advance. Version (incl…ShawShankk 98 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to pull rehire date in OTBI REPORT?Hi Team, How to pull rehire date in OTBI REPORT? ThanksSM_EP 208 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to find deeplink for Allocate Checklist page?Summary: How to find deeplink for Allocate Checklist page? Content (required): Hi All, How to find deep link for Allocate Checklist Page? From Tools -> deep links , i go…
-
Logic on Audit bit map field in per_all_Assignments_m_ tableSummary: We are working on an audit requirement to track the insert, update and delete assignment records over a given period of time. We have enabled the audit for prod…User_2025-10-31-01-02-51-214 147 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How cHi, I want to write a query that reCansel Karasoy 41 views 1 comment 0 points Most recent by Asmit Piyush Reporting and Analytics for HCM -
Line Manager information in OTBI reportSummary: If any employee is Line Manager for other employee record then we need to display 'X' value. Content (required): Ex: Output: In the above scenario 66789 and 123…Visu 461 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Primary or Null Address TypeSummary: Hi - I am working on creating a report of all active employees and contingent workers in our system along with information from Worker Assignment Real Time and …Kyle Norris 38 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to remove certain part of a column after parenthesis in BI reportSummary: Hi All, I want to remove the part of Tax Reporting Unit column from where the parenthesis is starting. Please suggest the function to use this in sql. Example: …Dona Das-Oracle 53 views 6 comments 0 points Most recent by Dona Das-Oracle Reporting and Analytics for HCM
-
How do you bring back the last calendar date of the next two monthsSummary: Hi I've been asked to create a report where I list leavers in the next two months and I managed to find a report that shows leavers in the previous month to twe…
-
Alert Composer| Resource Alert| Time Stamp FormatSummary: Hi all, I have developed a resource alert where the requirement is to have only time in the format of HH:mm. By default the syntax is date along with timestamp.…
-
Need a report that shows assignment numbers that DO NOT have a tax card associationSummary: I'm looking for help on developing a query that will fetch Employee Name, Person Number, Assignment Number, and Assignment Effective Start Date for any assignme…
-
How to hide Mark as read and Mark as unread links based on condition in workflow notificationSummary: How to hide Mark as read and Mark as unread links based on condition in workflow notification(Checklist task) Content (required): Hi All, We got a requirement t…
-
How can I get the absence entries for the next month to my query?I am preparing a report that will be sent to employee in the form of notification for the absence in the status of Saved for the next month. So how should I restrict my …Cansel Karasoy 52 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
I need an example of a sql query that returns person names and roles.I need to prepare a report that will list certain roles. So how can I write the query about the names of the people and what roles they have?Cansel Karasoy 742 views 6 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Table Details that stores all information about a Custom Quick ActionHi All, Please help know the table name that stores Quick Actions ,Eg: If there is a custom Quick Action created like "Colleague Details" under Me TAB,want to know when …C.R.Balaji 82 views 8 comments 0 points Most recent by Sebastien Mariller Reporting and Analytics for HCM -
How can I run the report when I select the required parameter field 'ALL'?Hi, I have 1 parameter that is mandatory in the report I prepared, assignment status, you can see it in the screenshot. It is true that the report should not be opened w…Cansel Karasoy 63 views 14 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
BIP Report for batch monitoring of Scheduled HCM ExtractsSummary: Feasibility of BI Report for batch monitoring of Scheduled HCM Extracts. Content (required): Would like to know if it's possible to pull Scheduled HCM extracts …Kate Calderon 24 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Bursting body and pdf attachmentHello, I want the message body of an e-mail I prepared with bursting to appear as follows, and I also want to add a pdf to this e-mail. How can I do that?
-
Employee Roster Report using subject area-Compensation Real TimeSummary: We are in need of an employee roster report built off of the Compensation-Real Time subject area, but to pull the grade and range from the Job Details area, ins…Tammy Hemmingson 36 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
From which table can I add the Synchronization From Position field to the sql report?Hi, I want to bring the field where Synchronization From Position field returns 'Yes,No' on the assignment details page in the employee record to my report. Which column…Cansel Karasoy 36 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Custom column not prompted correctly in drill-down reportSummary: Custom column not prompted correctly in drill-down report Content: Hi, I have created a dashboard with different analysis about Hires & Terminations (analysis p…Yves Blanc 74 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Reporting on Direct & Indirect Reports of Line ManagersContent Hello, I need to build a report where, as an Admin, I can see the details of the direct & indirect reports of a manager after selecting the line manager. Could a…User_2025-02-05-06-26-19-951 98 views 4 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
how can I get correct seniority date when multiple seniority dates are there for a person in OTBISummary: I am reporting from Workforce Goals - Goal Status Overview Real Time and Workforce Management - Person Seniority Real Time. When I have Seniority Date showing, …User_2025-07-18-06-45-42-477 104 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OTBI if Grade is Null those employees are not fetching in the report.Summary: We are adding version 3 seniority dates in OTBI existing report, added new subject area "Workforce Management - Person Seniority Real Time" when using filter co…challa praveen 73 views 8 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM
-
Incremental Date Parameters on a Scheduled OTBI ReportSummary Have scheduled report run every Monday, for data from previous 7 DaysContent I built an analysis that has a between date parameter off of HR Event Action Date. W…User_2025-01-28-08-47-04-905 167 views 6 comments 0 points Most recent by Gourabh Choudhary Reporting and Analytics for HCM