Reports
Discussion List
-
Workers Compensation wage reports neededSummary Looking for recommendations and examples of reports related to Workers CompensationContent Our team that administers our Workers Compensation programs has not fo… -
Need help with BI publisher reportSummary Need help with SQL for BI publisher ReportContent Hello, I have a BI publisher report that is run at the end of every pay period to provide payroll information o…GauravGupta39 52 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
How to schedule BI report only when it has dataContent Hi All, Can some please help me if its possible to schedule BI Report when there is data. I know we do it in OTBI in condition tab. Thanks, VijayUser_2025-02-07-19-03-14-525 40 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Simple Math on a Pivot TableSummary I need some help with some math that I might be overcomplicating.Content I have created a pivot table that groups employees into temporary, seasonal and regular …
-
Reporting Error with Worker.AssignmentNumber fieldSummary OTBI error being generated when user attempts to access report - specifically states user does not have access to Worker.AssignmentNumber fieldContent Hi all, We…
-
How to stop dashboard auto runSummary How to stop dashboard auto runContent Hi Team, Greetings of the day!!. Dashboard is getting auto run even the parameter was not passed in oracle fusion. Is there…Vasanthakumar Ravi 240 views 4 comments 0 points Most recent by Seiichiro Yasui Reporting and Analytics for HCM -
How to identify position of Nth occurance of a character or string similar to INSTR functionalitySummary Objective is to display one of the segment values from People Group Flexfied Structure in OTBI ReportContent I have requirement to show a segment value from Peop…
-
Unwanted grouping of data in OTBI AnalysisSummary OTBI analysis giving multiple data against employee instead of one rowContent I have created an analysis with a custom column to interpret employee's adoption of…User_2025-02-11-13-38-56-242 40 views 5 comments 0 points Most recent by User_2025-02-11-13-38-56-242 Reporting and Analytics for HCM
-
Detail vs Summary flagContent I have a report that prompts the user for a beginning and ending check date. Is there a way to add a flag to an OTBI parameter that when selected, the report wil…Annette M 30 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is it possible to have conditional Display of report parameters on the basis of value in other paramSummary Is it possible to have conditional Display of report parameters on the basis of value in other parameter ?Content Hi Experts, Is it possible to have conditional …Abhishek Sood HCM 185 views 6 comments 1 point Most recent by Abhishek Sood HCM Reporting and Analytics for HCM -
BI Pub folder/object security reportContent Hello, Are the catalog folder/object level permissions stored in a DB table? Can we report on what users/roles have been applied to folders/items to secure them?…JBlain 25 views 1 comment 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
What is Talent Rating Subject areaContent Hi Team, We have the talent rating where we have, Performance rating, Risk of loss etc. Is there any possibility to get the from OTBI? I know, We can get through…User_2025-02-11-13-25-48-351 28 views 2 comments 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM
-
Query to return employees related to a particular Representative type for a given AoR and scope of rSummary Query to return employees related to a particular Representative type for a given AoR and scope of responsibilityContent Hi All, Please share Query to return emp… -
HCM Cloud - OSHA ReportsSummary Looking for documentation (HCM Cloud) on 300, 300a and 301Content I cannot find any configuration documentation related to these reports. Can someone please dire…David Zajac 41 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
BI publisher SQL for finding users who are active in the security console but terminated in the applContent Hi experts, We have found an issue where sometimes when an employee is terminated in HCM they are still showing as an active user in the security console. To res… -
RTF TemplateContent Scenario: I have created two data sets in my data model: G1 and G2 G2(Parent) G1(Child) Parent will always have one row and its corresponding child can have a ro…
-
OTBI Agent to send one email for each recordSummary OTBI Agent is sending the entire report to the recipientsContent Hello Everyone, I need some help. We are trying to implement a mail merge that will be triggered…Alvaro Couto 157 views 12 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Issue with Views in HCM cloud Learning Management (WLF_LRNR_COMPLETION_DETAILS_V) in SpecializationSummary Joins are missing in the Specialization item type part in the Views WLF_LRNR_COMPLETION_DETAILS_V and WLF_LRNR_COMPLETION_SUMMARY_VContent In the code of the vie…Rajesh Ravikumar 46 views 2 comments 1 point Most recent by Rajesh Ravikumar Reporting and Analytics for HCM
-
How many columns can report based on Excel Template have?Summary How many columns can report based on Excel Template have?Content Hello. I am busy creating a data migration extract (BI Report) that contains a lot of fields. I …IanDeKoker 29 views 4 comments 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM -
Unable to Create Cross Subject Area Report for Succession - Incumbent Plans x Candidate DetailsSummary Unable to Create Cross Subject Area Report for Succession - Incumbent Plans x Candidate DetailsContent As we are preparing for Talent Reviews, I have been trying…User_2025-02-08-03-57-26-191 32 views 8 comments 0 points Most recent by User_2025-02-08-03-57-26-191 Reporting and Analytics for HCM
-
Report jobs how can we view BI Publisher reports scheduled by OTHER users ?Summary Report jobs how can we view BI Publisher reports scheduled by OTHER users ?Content Hello , We enter with an admin user the “reports and analysis “-> report jobs.…Revital Mefano 163 views 10 comments 0 points Most recent by Revital Mefano Reporting and Analytics for HCM -
Base Salary and Payroll elements tablesContent Hello experts, I need to extract by SQL compensation data for a specific employee. Do you know in which table I can find the following information: -Base Salary …Valerio Curzi 44 views 5 comments 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
Need query to pull finalised or processed pay period namesSummary Need query to pull finalised or processed pay period namesContent Need query to pull only finalised or processed pay period details?ViswanathaReddyKetireddy 32 views 2 comments 0 points Most recent by ViswanathaReddyKetireddy Reporting and Analytics for HCM
-
call Dashboard from HCM page -how to keep BIP paramsContent MY BIP report has two params (one dependent on another). I need to create a dashboard and display the dashboard under 'My Client Groups'. I did it all. However, …
-
Last Update Date in OTBIContent Hi, Can someone help me to find where to get Last Update Date for "About This Record" in Person tab for "Extra Information". Flow will be go to Person=> Extra In…User_2025-02-07-19-03-14-525 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Current Performance Task by Org TreeContent Hello, I feel like this is a tough one to figure out. I have an analysis where I isolate the current performance task on a performance document. I'm trying to en…Rob F 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
New hire report - Need to remove Global Transfers with changes afterwardsContent Hello, We are creating a new hire report that would show employees with a work relationship start date within the past year but we do not want to include global …Shanna Oppenheim 40 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
-
BI Publisher - tracking of an email notificationSummary Schedule Report JobContent Hi All, One of users has complained about some of their scheduled processes not sending email notification even though she filled up t…Alvaro Couto 80 views 6 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Log for emails sent through scheduled Reports jobContent Hi, We have scheduled a report job. So some are going under failed. Can i know how to fetch log daily how many reports are successfully sent and how many were fa…User_2025-02-10-17-13-07-021 40 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM