Global HR
Discussion List
-
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 51 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 753 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 81 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 61 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 21 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 31 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 31 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 71 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 94 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 101 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 71 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 163 views 6 comments 0 points Most recent by Gourabh Choudhary Reporting and Analytics for HCM
-
How to Prevent merging columns in excel using RTF template in Fusion BIP ReportsSummary How to Prevent merging columns in excel using RTF template in Fusion BIP ReportsContent Hi Experts, How to Prevent merging columns in excel output using RTF temp…Bala Kasineedi 1.3K views 6 comments 0 points Most recent by User_67JNL Reporting and Analytics for HCM
-
Performance Task Status subject area is not pulling data belongs to old org structure.Summary: Performance Task Status subject area is not pulling data belongs to old org structure. Content (required): We have created new organization structure version in…Swati U 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need a Query to Exclude the Terminated Record after 7 daysSummary: First 7 days , The Record should show with Status= Inactive Status and after 7 days The Record should not be shown in the Report. Content (required): Version (i…MilanMohanty 101 views 10 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How can I combine multiple templates in a publisher?I have a report that returns the absence records of the people I prepared from SQL and it will work according to the absence type parameter. The report will be prepared …Cansel Karasoy 71 views 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for HCM
-
Slicing data in Workforce Trend subject area by Sales RegionSummary: I am trying to measure period start and end headcount that lives in Workforce Mgmt - Workforce Trend subject areas. I need to be able to slice it by Sales Regio…Tracy Colon 31 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Cross subject area analysis - ErrorSummary: Content (required): Hello everyone, We are trying to create a cross analysis in OTBI using the following subject areas: Workforce Management - Person Real Time …Agapi 91 views 6 comments 0 points Most recent by Nilanjan Biswas-Oracle Reporting and Analytics for HCM -
Need to report on Document Record attachmentsContent can we report on Document Records attachments count? Has anyone done it? Can anyone share a report or any with me? Thank you in advance! Version 21BGala Meyerovich 93 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
What is the Subject Area for Things to Finish (which are displayed on the user home page)?Summary: We have a requirement to show the count and Details of Assigned to Me under Things to Finish (which are displayed on the user home page) in an OTBI dashboard, s…Bhukya Vamsi Naik 25 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Missing Work Phone TypeSummary: I'm looking at the subject area mapping, and playing with a few subject areas, but I cannot figure out how to build an analysis to see which employees are missi…
-
Can I put a link inside my Bursting query?I want to add an oracle link to send it in the mail notification in the message I print inside my bursting query, is this possible?Cansel Karasoy 51 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
How to take Length of service(in years), Service category and transfer detailsSummary: How to take Length of service(in years), Service category and transfer details? Content (required): Hi All, We got a BI report requirement to show employee's Le…
-
What does it mean to have 'INITIAL' in the 'STATE' field in the hrc_txn_data table?When I query the records with 'DRAFT' from the transaction table, the STATE field is reflected as 'INITIAL' AND 'SAVED'. What exactly does INITIAL mean?Cansel Karasoy 11 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM
-
How can I create dependent working parameters in SQL report?Hi, I have 'person number' and 'absence start date' parameters that I will use in my sql report and I have defined lov value set for them. But I want start date to come …Cansel Karasoy 51 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM