Reports
Discussion List
-
Requirement to have a report that provides details of changes made to UDTSummary: We have a requirement to have a report that provides details of changes made to User defined tables. can anyone please help us on this requirement? Content (ple…Jagadesh S 21 views 2 comments 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
"Periodicity Prime" data not found in subjects areaHello, I'm creating a report about contractual compensation, in this report i have many columns about Primes (bonus) (type of prime, amount, etc). I need a column that w…Hiba Ghoualmia 21 views 2 comments 0 points Most recent by Hiba Ghoualmia Reporting and Analytics for HCM -
Worksheet Proration ReportSummary: Worksheet Proration Report Content (please ensure you mask any confidential information): Hi All, Greetings! This is about the reporting requirement including c…Parag Hiremath 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
I Need a report showing pension contribution by employees and employersSummary: Does anyone know which subject areas I should use to get the pension contribution from employees and employers? Content (please ensure you mask any confidential…Isabela Radivoi 132 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
PL/SQL - Absences in UoM: Weeks to be Displayed in Days?Hi all, Hope you are well. We have certain absence types such as Maternity, which have the UoM: Weeks. We have a requirement for reporting purposes to display this as Da…David Oldfield 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is it possible to authorize manager-based reports?We added the SQL reports we prepared to the spring board screen and we want to make an authorization here. But is it possible to make it manager-based rather than person…Cansel Karasoy 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there a report I can run with earnings history?Summary: Is there a report I can run with earnings history? Content (please ensure you mask any confidential information): Version (include the version you are using, if…Tisha Negrete 1 view 2 comments 0 points Most recent by Tisha Negrete Reporting and Analytics for HCM -
Document of Records OTBI Subject Area not displaying dataSummary: Document of Records OTBI Subject Area not displaying data. Do we need to run any processes? Content (please ensure you mask any confidential information): Tryin… -
How do we track bypass Approval Rules - Bypass TrackingSummary: Need Audit record of Approval Rules - Bypass Tracking Content (required): Hi Team, We got a requirement from customer that we need to get the Audit details when…ankit.j.kumar-Oracle 123 views 2 comments 1 point Most recent by Sowdha Murugan Reporting and Analytics for HCM -
How to limit Department prompt values to active onlySummary: I have an OTBI report using Workforce Management - Worker Assignment Real time subject area with an optional Department prompt. How can this prompt be limited t… -
Production to Stage for BIP ReportsSummary Easiest way to copy BIP reports from Production to Stage environmentsContent Hi all - we have two ways that we use BIP reports on our dashboards: 1) Embedded Con…Prudence K 48 views 6 comments 4 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Manager only saves ratings (no submit) and then the OTBI report is run, are saved ratings fetched?Summary: Hi Peers, Our client has a requirement relating to an already live Performance Evaluation. They want to calibrate the rating (as an afterthought) Instead of add…S Shree 1 view 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
ORC - Answers to open questions not visible in analysis with Subject Area 'Recruiting Real Time'Hi, We can't seem to pull the answers from open text questions (prescreening) into a report using an analysis based on the Subject Area 'Recruiting Real Time'. We use th…Natalia_Leemans 1 view 2 comments 0 points Most recent by Natalia_Leemans Reporting and Analytics for HCM -
Unable to list just one manager for each Matrix Manager TypeSummary: We have a report that provides employee details AND includes each manager type i.e. Line Manager, Comp Planning Manager, and Timeclock Supervisor. When we run t…Darrin N 12 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is there a way to include historical source information?Summary: Candidate Pool Reporting - historical 'Source' data Content (please ensure you mask any confidential information): We are building a report on candidate pools a… -
How to get "Person Type" and Assignment Details from Fusion TablesSummary: Hi All, We are seeing a difference between the "Users license Usage" numbers in the Usage reports for HCM Base cloud Licenses and number of "actual user report … -
how to send a custom email when employee submits resignationwe have a requirement to send an email to employee when he submits resignation and also we need to send another email as resigantion approved to employee with the custom…Dara Nagasai 12 views 2 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM -
Query for Person Security Profile ReportHi team, we need a person security profile report. can someone help me to provide the query of this if anyone has already gone through this type of requirenment. Thanks!Pushpendra Patle 11 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
OTBI: Prompt Link not workingHello All, When prompt link is generated either from edge or chrome browser it error out as Bad Gateway. Any help would be appreciated! Thank you.Gail Wilmoth 21 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to output a list of all reports and their folders in Production environmentSummary: We are trying to map all reports in our production environment, with their folder locations. Does anyone know of an administrative tool that might be able to ou…Rich R 1.3K views 28 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Talent Profile report not printing few valuesHi, I am looking to extract license and certifications, career preferences values in print profile Navigation: My career->My profile->skills and qualifications -> action… -
How to get distinct record for Dimension field in OTBI just like SQL?Summary: Any DISTINCT function that can be used in OTBI to get distinct Dimension record just like SQL ? Content (please ensure you mask any confidential information): A…Pradnya_Pampatwar 438 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
previos salary after correctionSummary: Content (please ensure you mask any confidential information): Hi all, I need to fetch current salary and the previous one, when i do it on the regular way - it…Hadassah Friedman 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report to show Deleted Payroll ElementsSummary I need to generate an Audit report showing when an element was deleted and by whoContent I tried running the Deleted Data Report but I didn't get any information…User_2025-02-04-08-51-08-912 46 views 9 comments 0 points Most recent by Julie Searles Reporting and Analytics for HCM -
When adding field to my report, the Matrix Manager values are being eliminatedSummary: I have a report that includes both Worker Assignment Real time and Compensation Salary Detail subject areas. I have been able to add all desired fields successf…Darrin N 31 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Watermark not coming in HTML ( Email body) outputContent We got a requirement to send an email (not an attachment in email) to user on his/her anniversary. We are trying to use BIP bursting concept to send an email. In…Naveen Jayaraman-48236 80 views 5 comments 0 points Most recent by Ruma Bhatnagar-Oracle Reporting and Analytics for HCM -
Sickness - Avg day lost and % time lostContent Hi I have created a report to work out average days lost and % time lost , but in order to do this I need the total number of working hours available (which I al…User_2025-02-06-11-18-47-896 49 views 4 comments 0 points Most recent by BillM Reporting and Analytics for HCM -
Quick question: Is there a way to confirm when a report was last opened ?Summary: Hi friends. I am doing a reports and analytics audit, of sorts, and am looking to delete reports that are no longer utilized. How can I confirm when a report/an…Erin Hamrick 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Problem with the sender for a bursting reportHi folks! I'm developing a simple notification with BI Publisher report using the bursting, but if I use for sender any address with domain @customer.com the system indi…Gian Luca Triglia 11 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Check list real time SA for onboarding questionnaire but output vertical view issue in reportSummary: Hi Team, How can I convert Vertical into horizontal of question text and response answer . we need candidate onboarding questionnaire feedback suervy but in que…AjayKumar Maddipati 51 views 10 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM