Reports
Discussion List
-
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 27 views 11 comments 0 points Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
Reporting on KPI's of HR teams including metadataContent Hi Guys, I'm sourcing ideas on how tor report on KPI's that we need to report on around our HR team. Does anyone have any templates or ideas on how to create the…Ivy__Valverde 78 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Effective As-of-Date / Hire Date ProblemContent I am trying to create a report for HR to list all upcoming employees for our external payroll provider. Unfortunately I'm struggling with hire dates that are in …Stefan Orac 140 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Mapping of OBI Subject area to HCM ExtractsSummary Document for mapping OBI Subject area to HCM ExtractsContent Hi We have been using OBI Subject areas to extract data dump from HCM fusion. Now that our databse h…Mohit Gupta-45440 93 views 4 comments 0 points Most recent by Mohit Gupta-45440 Reporting and Analytics for HCM -
Goal Counts Report by Goal PlanSummary Employee Goal CountContent I've been trying to create this very basic and most commonly asked for report for well over a year to no scalable avail. I've tried nu… -
Pulling All Rows of Data (All Effective Dates)Summary Has anyone found a way to easily pull all rows of data for an employee in an OTBI report?Content Has anyone found a way to easily pull all rows of data in an OTB…
-
New Hire NotificationsSummary Daily notifications of new hires created the previous dayContent Hi everyone - We are trying to create notifications of new hires created daily using analysis an…Roy Paolo Paunlagui 335 views 9 comments 2 points Most recent by Mandi Egeland Reporting and Analytics for HCM
-
Need to develop a BI Publisher report that will have filter mechanism in the output.Summary Need to develop a BI Publisher report that will have filter mechanism in the output.Content Need to develop a BI Publisher report that will have filter mechanism…Aloka Bhattacharya 60 views 4 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Join Grade Rate Real Time and Salary Details Real TimeSummary I want to create a report with information from Workforce Management - Grade Rate Real Time and Compensation - Salary Details Real Time but I can not join them p…Rogelio H 89 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Drill down to a specific part of the chart ?Content Hi Community, We noticed that in our reports, when we have a drill to details function enabled (eg headcount by country in this case), it sometimes drills to the…[Deleted User] 46 views 2 comments 0 points Most recent by [Deleted User] Reporting and Analytics for HCM
-
Lenth of Service or Tenure FunctionSummary I'm looking to create a column that will show length of service in years.Content I'm looking to create a column that will show length of service in years. Is it …Margaret Harvey 155 views 7 comments 2 points Most recent by Nathan_Martin Reporting and Analytics for HCM -
OTBI Analytic: 2 values in one column - share it to two columns or show meassures only once in one cSummary Behind one field there are two different values . Under the results the two values are summarized in one column. Would need each value in a separate column. How … -
Not Able to Update Permission on Shared FolderSummary Not able to update Shared FolderContent Good day, We recently updated to R13 in our test environment. I was going through to add permissions on the Shared folder… -
Inability to Secure Seeded Reporting Folders in R13Summary We were informed that as part of R13 we are unable to individually secure the seeded report folderContent Has anyone found a work around for securing the seeded …Andrea Arment 60 views 5 comments 0 points Most recent by Andrea Arment Reporting and Analytics for HCM
-
End of Year Active AssociatesSummary List of employees that were active the last day of last yearContent I have tried this every which way to Sunday and I can not get the right amount of employees. … -
Question about Worker -> Parent Manager fieldsSummary Question about Worker -> Parent Manager fieldsContent I have a question on how the data in the parent manager fields (Parent Manager 1, 2, etc.) gets populated. …David Villegas 87 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reference Number in BI Publisher ReportSummary How to capture unique reference number for BIP report when you run each timeContent Hello Experts, We have BI publisher report (HR Letter) report like No Objecti…VinodKumar 51 views 7 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Assignment Status Reporting IssueSummary Assignment Status Reporting IssueContent Hi All, I am building a Global Payroll Transfers Report in OTBI with the SA "Workforce Management - Worker Assignment Ev…Nikhil Nelluri-71478 58 views 4 comments 0 points Most recent by Nikhil Nelluri-71478 Reporting and Analytics for HCM -
make infolets available based on the user's roleContent Hello, We are using infolet in production but we don't have find a way to display those depending of the user's role. Most of the infolet (in example) are used t…Amaury Blanc 217 views 17 comments 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
New Hire and Termination ReportSummary Combining Active and Inactive Information in one ReportContent Hi, We currently have a BI Publisher report that were pulling all the New Starter base on the date…Nephtisrael Manas 202 views 2 comments 0 points Most recent by Nephtisrael Manas Reporting and Analytics for HCM -
Last calendar day of the previous month as default promptContent Hi Oracle Community, We are trying to have a prompt with the date automatically set on the last calendar day of the previous month (which is our closing day), bu…[Deleted User] 46 views 3 comments 0 points Most recent by [Deleted User] Reporting and Analytics for HCM
-
BI Publisher: Is there a alternative view for per_all_people_f table?Summary BI Publisher: Is there a alternative view for per_all_people_f table?Content Hi, I am currently using per_all_people_f and per_all_assignments_m tables (which ar…User_MC37Q 81 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Unable to get the from email address in BurstingContent Hi All, In the bursting query for the parameter3 value we are passing "bipublisher-report@oracle.com" and able to get the email after report submitted. If we use…
-
Has anyone built a report that lists all possible drop down menu option for HCM fields?Content Afternoon all, I was wondering if anyone has built a report that shows all configured data items for OOTB fields and DFF. We want to do an audit of all configure…Evan Jenkins 68 views 2 comments 0 points Most recent by Evan Jenkins Reporting and Analytics for HCM -
Count of Workers With No Performance GoalsSummary Need for building a report with workers without any performance goalContent Hi community, We currently have the report attached in BI to count workers per # of g…[Deleted User] 66 views 2 comments 0 points Most recent by [Deleted User] Reporting and Analytics for HCM
-
Future Dated RecordsSummary Future dated records/Inserted rowsContent I need to build a daily report for when managers/HR has entered a change when there are future dated records that need …JB 96 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Performance Management Comments in OTBISummary Performance Management: Competency comments and Overall comments in OTBIContent Hello, I have realized a custom report to extract Performance Management competen…Giuseppe 1234 127 views 3 comments 1 point Most recent by Peter Kirwan Reporting and Analytics for HCM
-
Need inputs to fetch the Element Additional DetailsContent Hi All, While creating Element we need to provide required information in the Element additional details. Please suggest in which table (SQL) or Subject areas ho…
-
Turnover Formula AssistanceSummary Building a turnover % by termination typeContent Using a CASE formula I have identified and split out terminations by our company's preferred type, desired and u…Ryan Davis-43690 69 views 3 comments 0 points Most recent by Ryan Davis-43690 Reporting and Analytics for HCM
-
Can I use Dashboard Prompt in the individual Column Formula in my analysis?Summary Can I use Dashboard Prompt in the individual Column Formula in my analysis?Content Hi, I have a requirement where I need to use the dashboard prompt(Presentation…User_MC37Q 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM