Reports
Discussion List
-
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 531 views 3 comments 0 points Most recent by RIfdhy Zain Reporting and Analytics for HCM -
Connect a Report to Workforce in Reporting Web StudioSummary: Content (required): I would like to set up a connection to our Workforce cube to the Reporting Web Studio. Is there a way to change the connection on an existin… -
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 295 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 41 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 53 views 1 comment 0 points Most recent by HarishVummidi Reporting and Analytics for HCM
-
Need to identify tables that contain BPM configurations - Application PreferencesContent Looking to identify the table(s) that contain Application Preferences for BPM Worklist. See screen shot below.Jeff Hare CPA CISA CIA 221 views 6 comments 2 points Most recent by Pallavi S Reporting and Analytics for ERP -
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 275 views 5 comments 1 point Most recent by Vamsi BOmmagani Reporting and Analytics for HCM
-
Stacked Charts Unavailable?Watching a tutorial where the author created a stacked chart. I do not see this currently in narrative. Did the feature disappear? Thank you. -
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 111 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 801 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
-
Clubbing of SOA Instances while Invoking a web service using BIP reportSummary Clubbing at SOA instance instead of creating new instance while calling a external web service from SaaS BIP report as a Webservice type of BIP report.Content We…
-
Can you create a group or parent across several dimensions?Summary: Is it possible to create parents or groups involving multiple dimensions such as a "Gift Card" parent containing ("Account 1, Region 1, Dpt 1" and "Account 2, R…
-
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 752 views 6 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Report Bursting - Can you publish a report in excel version to library folder?Summary: Client is needing a way to automate exporting reports to an external directory - Want to use an API to grab report from folder structure in Library but it needs…Valerie Fisher-279201 51 views 4 comments 0 points Most recent by Valerie Fisher-279201 Financial Consolidation and Close
-
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 62 views 14 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
report formatting questionSummary: looking for help on report formatting with $ on first and last line but left justified Content (required): looking for help on the best way to format reports so…Nancy Ackerman 41 views 1 comment 0 points Most recent by Ganesh Golla Financial Consolidation and Close