Reports
Discussion List
-
LRU Registration ReportSummary: LRU Registration Report Content (required): Hi Team, Greetings! We have the details for LRU (Legal Reporting Unit) Registration defined under "Manager Legal Rep…Parag Hiremath 78 views 11 comments 0 points Most recent by Chris Carloff Reporting and Analytics for HCM -
How Can We Identify Whether The User Is Logged In Via SSO OR Native LoginHi Team, We have enabled both SSO and Native login for our pod and wanted to know how the users are logging into the system. Is it by SSO or Native login. Please suggest…Sudarshan Uppara 37 views 2 comments 0 points Most recent by Sudarshan Uppara Reporting and Analytics for HCM -
XML-2200 Error while parsing XSL fileHello everyone, I would like to ask if anyone has experience this error in BIP Reporting? The issue was encountered after migrating the report to another environment. Th…
-
Are there any out of the box reports that would tell me if a Second Pass email was triggeredSummary: Looking for an out of the box report that would tell me if Second pass emails are being sent to applicants. Content (please ensure you mask any confidential inf…
-
HR Dashboard - Length of Service Diversity - What date is used?For the Headcount tab in the HR Dashboard, what date is being used and where is this information pulling from?
-
Unable to access Recruiting - Recruiting Real-Time OTBI report using the custom roleSummary Unable to access Recruiting - Recruiting Real-Time OTBI report using the custom roleContent Getting below error while accessing Recruiting - Recruiting Real-Time…Venkatraman G 168 views 10 comments 0 points Most recent by Aishwarya_15 Reporting and Analytics for HCM -
How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportSummary How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportContent Hi Team, We are creating new HCM BIP Report to Fetch the…User_2025-02-01-06-07-07-886 837 views 7 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM -
How to remove Blank Rows in a report?Summary: Once we export the report there are a few Blank rows at the bottom, is there a way to remove them? Content (please ensure you mask any confidential information)…THawkins_LGI 83 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Embed OTBI in Requisitions responsive PageSummary: Hi, We are trying to embed an OTBI report that will pull in the Job Code for a particular job requisition into the job requisition page. The attempt was to have…
-
PDF output is not giving the correct fontContent Hi, we are trying to generate a PDF output with custom font. While downloading RTF output, it is giving correct font, but PDF is not giving the same font. How do…Nivya Mathire 88 views 8 comments 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
Using 2 different subject areas (Salary and Performance Rating) - Getting split/merged cellsSummary: Hi Experts, I'm pretty much a beginner with reporting. My client wants an OTBI report that can pull salary details as well as latest performance ratings (overal…S Shree 82 views 9 comments 0 points Most recent by Reddykrishna Chidella-Oracle Reporting and Analytics for HCM
-
How to report on proxies setupSummary: We have a requirement to report on the proxies information setup (Set Preferences > Proxies). Is there any seeded report or information on building custom repor…
-
Is there a place we can go to get a daily usage statistics for each module showing the persons loggeSummary Management needs this information to make a decision about licence renewal.Version 21BDavid Sakeye 104 views 10 comments 1 point Most recent by Rory Fielding Reporting and Analytics for HCM
-
How to use an OTBI analysis to create a data model with a parameter (prompted?)Summary: I am trying to use an OTBI analysis to create a data model. My data model will be refrenced by Oracle Journeys so there is a requirement that I attach a specifi…Amy Wilson 796 views 7 comments 0 points Most recent by Stefan v. Glabbeek Reporting and Analytics for HCM -
Reporting Prior Month Data SQLSummary: Can we add SQL to the formula to look at the Prior Month data? So tell it to look at the System date - 1(for prior month) and pull 1st to last date of that prio…THawkins_LGI 41 views 12 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM
-
Need to create a BI report to See What Jobs Are Scheduled Along With Frequency, Start and End dateSummary: Hi All, We've a requirement from the customer where they need to create a report to See What Jobs Are Scheduled Along With Frequency, Start and End date. Can so…Sandeepan Rana-Oracle 22 views 3 comments 0 points Most recent by Sandeepan Rana-Oracle Reporting and Analytics for HCM
-
Seeded reports not returning any dataSummary: I am trying to run the seeded reports in the below location but none of them are returning any data. I am running this report with the seeded Employee and Line …Consultant Ian 21 views 8 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
OTBI Report Issue with Candidate Inclusion and ExclusionI'm facing a challenge with the OTBI report. I'm trying to incorporate two sets of logic: Requisitions with candidates. Requisitions without candidates. However, when I …Ranjith Antony MPC 11 views 0 comments 0 points Started by Ranjith Antony MPC Reporting and Analytics for HCM
-
What table is storing Change working hoursHi Team, Which table is storing change working hours information? Any sample will be helpful.
-
how to bulk download the attachments in report job historyHi Team, I have a requirement to download the output name (attachments) in the Job History. But when I download the files it's coming in the XML Format. can anyone tell …Haritha 22 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Unable to get the proper count for Assignment Count when I am using two subject AreasSummary: Hi Team, we have requirement to get the count for Nationality to get this column we are using 'Person Real time' Subject Area. and we also have to filter this c…Ashok Dhara 12 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to report Open Requisitions with AS OF DATE parameterSummary: Need OTBI report that shows all open requisitions with an AS OF date parameter. For example, all open requisitions as of 1-1-2022. Content (required): I have an…
-
'Signer Address' column in Checklist Real Time Subject AreaSummary 'Signer Address' column in Checklist Real Time Subject AreaContent We are trying to leverage Checklist Real Time subject area to develop reports on the onboardin…User_2025-03-07-21-34-36-848 43 views 5 comments 1 point Most recent by Marcy Hart Reporting and Analytics for HCM
-
Is there a way to pull a report that shows if an assignment is missing a payroll relationship?Summary: Is there a way to pull a report that shows if an assignment is missing a payroll relationship? We are new to adding assignments for employees, and didn't realiz…Jenna Savage 46 views 5 comments 0 points Most recent by BrentBlackwell Reporting and Analytics for HCM -
I need query to get expense approver nameDoes any one have query to get expense approver nameSwati U 225 views 2 comments 0 points Most recent by Stephen Westerfield-Oracle Reporting and Analytics for HCM
-
Subject area/database table for historical manager hierarchySubject area/database table for historical manager hierarchy Client is interested in building dashboards to show different HR metrics for which historical manager hierar…
-
how I can measure application usage in HCMSummary: Now a days i need to verify if my users are using the app, for example if they are creating new depts, they hire new persons or they are be in some feature in s…User_1VTMP 24 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Getting Java.lang.Nullpointer exception while running the data modelSummary Getting Java.lang.Nullpointer exception while running the data modelContent Hi Team , i am getting Java.lang.Nullpointer exception while running the data model, …User_2025-02-04-07-00-18-658 190 views 5 comments 0 points Most recent by John Peter Noble-Oracle Reporting and Analytics for HCM
-
Data Model throws a nullpointer exception while trying to retrieve dataSummary: I have created a data model with 2 data sets (one for employees and one for Contingent workers) - I have created an Excel Template that has 2 tabs for the data …User_2025-02-04-08-51-08-912 293 views 3 comments 0 points Most recent by John Peter Noble-Oracle Reporting and Analytics for HCM
-
Report showing enrollments As Of Prompted DateSummary: Requirement is for an OTBI report showing enrollment detail as of a prompted date and plan(s). For example, what employees were enrolled in Voluntary Life as of…