Reports
Discussion List
-
Report Delivery - Agent Completed with WarningsSummary: We currently have a report that is scheduled to run daily at around 7am. There are times when the report doesn't send, and it shows the following message below …Alejandro Macias 73 views 1 comment 6 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
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 55 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…
-
HOW TO PASS AsOfDate TO OTBI AGENT OUTPUTSummary: We have created a OTBI report with AsOfDate prompt which is getting passed . This report will be scheduled monthly through agent. Our requirement is send the ag…Aathimoolam R 31 views 2 comments 0 points Most recent by Aathimoolam R Reporting and Analytics for HCM
-
Report on specific Manager and his/her actions with employeesSummary: Content (required): Good afternoon. We have a request to identify any employees that one specific manager either Supervised (their direct supervisor), Hired (th… -
How to display indirect terminations for a specific manager?Summary: We have a requirement to build OTBI (Graphs) to display number of terminations under a specific manager. There are 2 OTBI analysis I use in the dashboard - 1 wh…Vijay Rajendran 31 views 9 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM
-
Looking for Learning Reports specified in 20A release notesSummary: NOW RESOLVED. 22/05/23 Hi, I'm looking for a set of reports that were listed on the 20A Oracle release notes (https://www.oracle.com/webfolder/technetwork/tutor…
-
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 91 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 205 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How can restrict the data in reports?Summary: How can restrict the data in reports? Content (required): Hi Team, Can some one help me to understand, how to restrict the data in reports. For example we have …
-
Need to know approval date file & table name of absence records attached my sql, if anyone please moSummary: we use oracle fusion cloud. OBI report and analytic Need to know approval date file & table name of absence records attached my sql, if anyone please modify and…RIfdhy Zain 520 views 3 comments 0 points Most recent by RIfdhy Zain Reporting and Analytics for HCM -
Seeded EEO and VETS ReportingSummary Is anyone using the seeded EEO and VETS Reporting?Content Hello Customer Connect Community, Has anyone used the seeded EEO and VETS reporting from Fusion HCM yet…User_2025-01-22-19-43-38-766 285 views 17 comments 0 points Most recent by Suppu 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…
-
Report on Learning Alerts Notification ReportingSummary: I'm looking to see if there are any OTBI subject areas or BI tables that can be used to report on the learn notifications that are sent out using the Alert Comp…Mahesh_M123 171 views 4 comments 0 points Most recent by Swaraj_Sudhagonela 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 -
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 31 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 51 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…
-
In Xsl template we are getting error like:sun.util.calendar.ZoneInfo cannot be cast to java.util.SimSummary: Hi Team, Hope everyone is doing good! We have an requirement, where we have to use Current date condition in xsl template as mentioned below, but we are getting…MaheshRayudu7 61 views 2 comments 0 points Most recent by MaheshRayudu7 Reporting and Analytics for HCM
-
Calculation using a UnionSummary: Is a calculation from two results using a Union possible? Content (required): I have a report which I'm looking to show the % of active employees who have a wor…Gary Miller-39965 41 views 2 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM
-
How to restrict Effective Date parameter in schedule process, not to generate on specific DatesSummary: We have an ADP Payroll Extract. During the scheduling process, where in Effective Date Parameter should not pass Saturdays,Sundays and should consider every alt…MaheshRayudu7 51 views 1 comment 0 points Most recent by HarishVummidi Reporting and Analytics for HCM
-
Creating Reports and Extracts: How to map/link application front end fields to back end database tabSummary Looking for a simple way to map application pages/fields to cloud database tablesContent Good morning, I have been digging through the schema documentation while…User_2025-02-10-17-54-21-557 242 views 5 comments 1 point Most recent by Vamsi BOmmagani Reporting and Analytics for HCM
-
Just like for each that populate several rows in Excel Template, can we do the same for columns?Summary: Hello, For the Recruiting module, our client wants to have a report that dynamically populates the Questions found in Questionnaires of Job Requisitions based o…
-
Pass Dashboard prompt and analysis filters to drill down analysisI have a summary analysis of employee count by home state in a dashboard using a dashboard date prompt to pull as of a certain effective date. I have other filter criter…Susan Anderson 102 views 9 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
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 call fast formula from SQLSummary: how to call fast formula from SQL Content (required): Hi All, Is it possible to call Fast formula from SQL to verify the FF results? Thanks, Venkatesan R Versio…Venkatesan 739 views 4 comments 1 point Most recent by Ketan Prajapati Reporting and Analytics for HCM
-
I am unable to fetch payroll details with worker and bank details in OTBI .Summary: When i take only payroll columns like payroll_id, payroll_name then i got output but when i select payroll columns with bank details or worker columns getting n…mohityagyik 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 712 views 6 comments 0 points Most recent by Cansel Karasoy 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