Reports
Discussion List
-
BI Report fails with custom security roleSummary User can't run report as he is assigned to security roleContent Hi Team, BI report runs for Admin but does not run for the user. Narrowing down the roles we foun…Alvaro Couto 40 views 4 comments 1 point Most recent by Alvaro Couto Reporting and Analytics for HCM -
Changes to Payroll Run Results Real Time?Summary No longer pulling in payments on terminated employeesContent Hi all, We have used the Payroll Run Results Real Time subject area to pull element-level transactio…User_2025-01-31-00-36-50-198 60 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Is it possible to insert SQL into OTBI reports to pull correct version of Enterprise Seniority Date?Summary Is there a way to pull in a small piece of custom SQL to pull the right version of Enterprise Seniority Date into our custom OTBI reports?Content We know we want…User_KNIL2 67 views 2 comments 2 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Add Column to Reflect whether Measurement is Present in an Employee's GoalSummary There needs to be 1 column added to a Goal report namely "SUCCESS_MEASURE_EXISTS" which will reflect any of the following values: Complete, Incomplete, PartiaCon…Aahiri_Sarma 43 views 2 comments 0 points Most recent by Rebecca Emerson Reporting and Analytics for HCM -
Line Mgrs Unable to View Term DataSummary Has anyone created a report or dashabord with term data and the line mgr can see this data?Content I've created a dashboard that will allow managers to view Head…User_2025-01-25-00-37-41-739 117 views 26 comments 0 points Most recent by Orange Reporting and Analytics for HCM -
Including page with cell reference in FR Studio sum formulaSummary Including page with cell reference in FR Studio sum formulaContent I am trying to create a formula that will sum the same cell across multiple pages in an FR Stu…User_2025-02-04-16-54-25-315 31 views 5 comments 0 points Most recent by User_2025-02-04-16-54-25-315 Planning -
How to enable two bursting queries at a time in the BI report while scheduling.Summary How to enable two bursting queries at a time in the BI report while scheduling.Content Hi , I have a requirement that to send resignation alert with checklist to…User_MC37Q 216 views 5 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Table name for Element Frequency RulesSummary Table name for Element Frequency RulesContent Hi, Any inputs on how to pull Frequency Rules setup on Element definition? I'm trying with the below tables PAY_ELE…User_2025-02-04-13-35-15-879 103 views 1 comment 1 point Most recent by VijayaBaskar Ranganathan Reporting and Analytics for HCM -
Pull data from Excel file which is in content serverSummary Pull data from Excel file which is in content serverContent Hi All, I have one requirement that, one Excel file is in content server, i need to pull data from th…Sai1654 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to hide unnecessary folder for Custom Report ViewerSummary Need to hide unnecessary folder for Custom Report ViewerContent Hi, In Shared folder there exist lots of unnecessary folder related to different module. My HR us…Azfar.128 72 views 4 comments 0 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for HCM -
How to create dependent LOV Parameters for custom ESS Jobs using view criteria in cloud?Summary How to create dependent LOV Parameters for custom ESS Jobs using view criteria in cloud?Content How to create dependent LOV Parameters for custom ESS Jobs using …User_1B10X 42 views 1 comment 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
BI Publisher reportsSummary Version ControlContent Hi Team, Can someone suggest a control version for HCM SaaS for BI Publisher reports? What are our options? Thank you, Alvaro Couto Versio…Alvaro Couto 57 views 1 comment 3 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM -
Grade on Worker vs Grade on JobSummary We need a report that shows employees grade on worker level and grade on job levelContent I need a report like NAME | Grade (at worker level) | Grade (job level)… -
Length of Service BandingContent I am trying to Band together number of employees within certain Length of Service Banding. Our Length of Service is from "Enterprise Seniority Date" But the Repo…Clifford Trett 47 views 4 comments 1 point Most recent by Clifford Trett Reporting and Analytics for HCM -
Extract Employee and Manager commentsSummary How to Extract Employee and Manager comments from a performance documentContent How to Extract Employee and Manager comments from a performance document? What su…User_2025-01-25-01-15-05-644 37 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report for Performance Document having Questionaire SectionSummary Report for Performance Document having Questionaire SectionContent I have a requirement to report on the questionaire section and responses associated with Perfo…Arun Sharma 131 views 8 comments 0 points Most recent by User_2025-01-25-01-15-05-644 Reporting and Analytics for HCM -
Salary by "As of Date"Summary Active and Term employee salaries during specified dateContent Hello! I am trying to capture historical data on all employees (active and inactive/terms) who wer…User_2025-02-04-13-00-33-588 67 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
BIP Extensibility Training - How to Delete a Report LayoutSummary This short tutorial details how to delete a report layoutContent Learn how to delete a report layout in this short tutorial. Runtime: 00:01:18 View the tutorial.Neil Dickens-Oracle 60 views 1 comment 10 points Most recent by Jairo Rojas Méndez BI Publisher Learning Center -
BIP Extensibility Training - How to Create a Report LayoutSummary This short tutorial details how to create a new RTF layout for your reportContent This short tutorial details how to create a new RTF layout for your report: You…Neil Dickens-Oracle 191 views 1 comment 10 points Most recent by Jairo Rojas Méndez BI Publisher Learning Center -
BIP Extensibility Training - Enabling Additional Output Formats for Reports LayoutsSummary This short tutorial details how to enable CSV and Excel output formats for report layouts using the BIP Customize FeatureContent This short tutorial details how …Neil Dickens-Oracle 289 views 1 comment 13 points Most recent by Jairo Rojas Méndez BI Publisher Learning Center -
How to Audit HR Processes basis TATs and steps to be followed across organisationSummary Currently, our implementation partner has not provided any solution on how to audit the HR processes. we are unable to audit the health of HRMS data and SOPs, Ta…Neeraj Awate 54 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Display Person Image in a ReportSummary Can I display person image in OTBI or BI Publisher Report?Content Hi, There is an option to display the person image in an OTBI report or BI Publisher report? Th… -
Data Model Validation ResultSummary SQL query contains non-equi joinsContent Hi Guys, I am in 18C and I am getting the following warning message in Data Model: WARNING Dataset:LOV_Emp_Name SQL quer…Alvaro Couto 44 views 5 comments 2 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM -
Getting same answer to the question for all employees check-ins template in BI ReportContent I am making a report to get the answers to questions of check-ins templates.I am getting same answer for all employees who are in same check-ins meeting template…User_MC37Q 28 views 5 comments 0 points Most recent by Melanie Mahon-Oracle Reporting and Analytics for HCM -
Business User created OTBI Analyses - GovernanceSummary Business User created OTBI Analyses - GovernanceContent My reporting team is creating a strategy to allow (non-technical) biz users to develop and promote analys… -
Any one tried Calling SOAP web-services to submit and download BIP ReportSummary Any one tried Calling SOAP web-services to submit and download BIP ReportContent We are trying submit and download the BIP reports using Webservices. As per orac…User_2025-01-28-00-10-14-788 65 views 5 comments 1 point Most recent by User_2025-01-28-00-10-14-788 Reporting and Analytics for HCM -
Leaver report filtering to remove international transfersSummary Looking for a way to filter out "leavers" who have active record elsewhereContent Hi When I run a report to capture terminations in a set time period, I frequent…User_2025-02-03-23-33-26-899 42 views 3 comments 0 points Most recent by User_2025-02-03-23-33-26-899 Reporting and Analytics for HCM