Reports
Discussion List
-
Subject Areas - Seniority Dates and Per Periods of ServiceSummary Subject Areas - Seniority Dates and Per Periods of ServiceContent We are wondering if there is a subject area, or an enhancement to allow for analysis to retriev…Dustin Puchalla 430 views 12 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How should I write multiple data returned from a column separated by commas next to each other?Hi, I actually have a pretty simple little query. More than one data is returning from this column and I want to write it on the same line separated by commas. SELECT YY…Cansel Karasoy 42 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Tables not available for BICCC extraction - what is the alternative?Summary: While configuring data extract from BICCC, we notice that within a data store many tables do not have equivalent PVO. Below are few examples where I could not f…Sharas Vitalapuram 92 views 2 comments 0 points Most recent by ravikiran goda-Oracle Reporting and Analytics for ERP
-
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 387 views 12 comments 0 points Most recent by SanjayC Reporting and Analytics for HCM -
How to add prompts defined in the report in the bursting definition?Summary: In the report that I have built, the period and year are set as prompts, which were not there when I created the bursting definition. The below-attached screens…
-
Workforce Talent Review - Talent Review Tasks Real Time reporting bug?Summary: How can we pull a report using this subject area to provide an administrative overview of all existing tasks in a Talent Reviews within the system? Content (req…William_Johnson 25 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
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 84 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 61 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…
-
OTBI login based data will display but user id not matchedSummary: OTBI dash board /analysis based on login user name data will display if user name/display name not matched still they want data using custom session variable to…SivaRamaKrishna-Oracle 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to fix envelope section in the first page when there are more than one page output in RTF?Summary: How to fix envelope section in the first page when there are more than one page output in RTF? Content (required): We have a requirement to fix the bottom secti…Abhilash K - Deloitte USI 31 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
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 102 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 214 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 533 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 297 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 172 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 52 views 1 comment 0 points Most recent by Harish Vummidi Reporting and Analytics for HCM