Reports
Discussion List
-
Slow Performance when Department tree columns are includedContent We have built a simple report using ‘Goal Alignments Real Time’ subject area. The report runs in few seconds if we do not include Department tree columns. Howeve…User_2025-02-05-23-59-37-171 30 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Aligned Goal information missing in report outputContent We are setting up Goal Alignment report using the "Workforce Goals - Goal Alignments Real Time". Subject Area. The report works fine when running with a HR View …User_2025-02-05-23-59-37-171 68 views 4 comments 0 points Most recent by User_2025-02-05-23-59-37-171 Reporting and Analytics for HCM -
Auditing reportsSummary Is there a way to view changes to reports?Content As part of an audit, we've been asked to start providing a list of changes to reports in PBCS. We have the audi…User_2025-02-04-16-54-25-315 54 views 2 comments 1 point Most recent by User_2025-02-04-16-54-25-315 Planning -
FTP File delivery - PGP Encrypted with required extensionSummary PGP encrypted output with desired extensions.Content Hi All, We have a requirement to generate the extract output which is text format but > Delivery method : FT…Prerna Tuteja-61210 59 views 5 comments 0 points Most recent by Prerna Tuteja-61210 Reporting and Analytics for HCM -
Workforce Trend Headcount by User Person TypeSummary We have a requirement to trend headcount by person type. It appears the workforce trend real time subject area only returns the latest person type and not the pe…Ryan_Sullivan 59 views 5 comments 0 points Most recent by Ryan_Sullivan Reporting and Analytics for HCM -
Can I tell if an Expenditure Item has been burdended via SQL?Content Hi, I'm trying to work out how to tell, via SQL, if an Expenditure Item has been burdened via Projects > Costs > Tasks > Generate Burden Costs. For example - I h… -
Calculation cards Federal Start date and End DateContent Hi All, In which table/column holds the Federal Start Date and End date values. Thanks, Visu -
Making more than one Approval group for Contracts ApprovalContent HI , is it possible to make more than one approval group for each Contract Organization / Contract Type ? if possible would you please discuss the action plan ne… -
Requisition Filled Date and Time to fill on ORC reportContent I am looking for a way to pull in the requisition filled date into a filled requisition report for ORC. I cannot find that field in the subject areas. In additio…Jennifer Eichholz 97 views 4 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Combining Multiple Question RowsContent I have an ORC report that is pulling our filled reqs and the candidates' information that have been hired into those reqs. We want to see on the report their ans…Jennifer Eichholz 44 views 2 comments 0 points Most recent by Jennifer Eichholz Reporting and Analytics for HCM -
Manager Detail ReportSummary My report doesn't show changes of managerContent Hi, Please see attached XML file. I have copied the output of an old report (I don't have the sql or xml for the…User_2025-02-05-22-44-35-842 57 views 4 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Absence Report with Between DatesSummary Report not workingContent Hi, I have attached the XML for this absence report, can anyone work out why it won't run? I've tried different combinations in the cri…User_2025-02-05-22-44-35-842 30 views 10 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Getting month and year into one column while maintaining date date type - EVALUATE NQSCOnfig.INI errSummary Getting month and year into one column while maintaining date date type EVALUATE NQSCOnfig.INI errorContent Hi - We are trying to graph an analysis that would sh…Roy Paolo Paunlagui 39 views 7 comments 1 point Most recent by Roy Paolo Paunlagui Reporting and Analytics for HCM -
Dependent Change Audit ReportSummary Need to create a report showing dependent option changesContent Hi...I am trying to find out how to create a report/analysis that will show me any employees whos…Denise Haas 50 views 4 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Termination date for Rehire employeesSummary Termination date for Rehire employeesContent How to display termination date for rehire employees in OTBI report. We want only the latest assignment record to be…User_2025-02-01-05-31-10-698 135 views 18 comments 2 points Most recent by Lindsay Lamont Reporting and Analytics for HCM -
2019 Leavers with salarySummary OTBI report needed showing 2019 leavers & salariesContent Hi, I have been looking through the shared reports centre and previous posts and haven't really found a…User_2025-02-05-22-44-35-842 52 views 14 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM -
Need Help with Date Sorting on Advanced XML ReportSummary Date Sorting on Graph not working properlyContent Hi Experts, I tried reusing an Assignment Change in last 1 year report from the repository over here. The entir…Meet Bhavsar. 39 views 3 comments 0 points Most recent by Meet Bhavsar. Reporting and Analytics for HCM -
How to extract Cost Center with OTBISummary How to extract Cost Center with OTBIContent Hi, We would like to export the cost center structure and corresponding values in OTBI. We are using the functionalit…Hakim Slimani - AXA 364 views 13 comments 3 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Changing the Default value in a column selectorSummary Have Column Selector, want to duplicate and change the orderContent Hello, I'm trying to use the Column selector view and am looking for a way to either set or c… -
Request to provide information on "Installed base Assets" 19DSummary Request to provide information on "Installed base Assets" 19DContent Hi All, Request to provide information on "Installed base Assets" 19D. Would like to underst… -
Report on appraisal status and tasksSummary I need a report with the specs as stated below in the content. Can anybody see what I am doing wrong here?Content Fields needed: * - Performance document name * …Inge Marinus 43 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Termination Date Using Column ReferenceSummary Get a greater than term date if business unit = thisContent UPDATE: I have attached a copy of the XML of the original report. My goal is to only bring back termi… -
How do i fetch blank vales for mobile phone number in a OTBI reportSummary How do i fetch blank vales for mobile phone number in a OTBI reportContent Hi, I have a slightly different issue. I am trying to fetch the home mobile number for…User_2025-01-30-21-52-52-008 74 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Analytics Section on HomepageContent Hello Everyone, Has anyone used "Analytics" section on homepage to display reports/dashboards? Currently, it displays Order to cash infolets and Service infolets…Hetal Vaghela 71 views 4 comments 1 point Most recent by Pooja_Chowdhary-Oracle Reporting and Analytics for HCM -
How to get the previous performance task name in OTBIContent Hi All, I am trying to get the results for current Performance Task name and previous Performance Task name using the Subject Area: "Workforce Performance - Perf…Janardhana Kondaveeti 81 views 5 comments 0 points Most recent by Elizabeth Docherty Reporting and Analytics for HCM -
How to split element input values into separate columns in BI ReportSummary How to split element input values into separate columns in BI ReportContent Hi Experts, Currently, in my BI report, all element input values are showing under on…Mahendra 124 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
report to pull manager rating and participant reviewSummary report to pull manager rating and participant reviewContent Hi All, I have prepared two simple reports to pull manager performance rating and participants review…Ritwick Chatterjee 56 views 3 comments 1 point Most recent by Ritwick Chatterjee Reporting and Analytics for HCM -
Etext Template in csvSummary Etext template in csv drops leading 0's from reportContent when we export the file as text, the ID's keep leading 0's, but when it goes to csv leading 0's are dr…Mike Borghoff 28 views 2 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM