Reports
Discussion List
-
Difference between data table join.Summary: Difference between data table join. Content (required): Hello All, I have some confusion on table joins. Please refer below example. I have two data tables. PER… -
Folder Level Security (Idea/Feasibility)At our organization, the staff is used to our discoverer reports where one report will pull from multiple tables/views, after asking around and looking at OTBI security …Praveen Kadiyala 41 views 5 comments 0 points Most recent by Praveen Kadiyala Reporting and Analytics for HCM
-
Bank Statement Analysis Report > Bank Statement TransactionsWe are trying to validate the transactions being reflected on this report. Here's the full path of the seeded report: Shared Folders > Financials > Cash Management >Bank…
-
Turnover Analysis - Line Manager DashboardsSummary Count fields - Termination Headcount, Voluntary Termination Headcount under Subject Area "Workforce Trends" are not reflecting correctContent Hello, We are looki…User_2025-02-05-07-43-29-505 136 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Fiscal Year HR ReportingSummary Needing to have reports such as a Turnover Report that is based on Fiscal Year vs Calendar YearContent Does anyone have any experience or examples on how i could…Rob Stahly 101 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Rehire Recommendation Details Isn't Coming in ReportSummary Rehire Recommendation Details BlankContent Hello All, This is Harmender, hope everything is fine at your side. I have created one subject area report for rehire …User_LO0GO 35 views 4 comments 0 points Most recent by Poorani Gibson Reporting and Analytics for HCM
-
BI Publisher Style Templates vs Online Layout BuilderSummary: How to deliver a consistent look and feel in BI Publisher reports Content: I'm trying to improve my skills with writing BI Publisher reports and learn about Sty… -
No Data in OTBI when Department Name is addedSummary: Content (required): We are using Subject Area "Workforce Goals - Goal Plan Assignments Real Time". When we add Worker.PersonNumber then we are getting all the 1…Vinay Gharge 21 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Where can I find prebuilt report and analysis list and pdf samples?Summary: Location of prebuilt report and analysis list and pdf samples on docs.oracle.com Content (required): The links do not work at https://docs.oracle.com/en/cloud/s…Rona Jeongco 81 views 2 comments 0 points Most recent by Rona Jeongco Reporting and Analytics for ERP
-
Logical SQL is not recommended?Summary If Logical SQL isn't the answer what is the recommended approach?Content Hello Everyone, I've been told through a recent Technical SR that Logical SQL is not a r…Rob F 66 views 12 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Custom Solve Orders on Mvmt and Consol Removed with 22.5Summary: We had an issue with the latest patch, 22.5, where our custom Consolidation and Movement solve orders were wiped out by the patch. The patch listed a specific s…John_OIiphant 41 views 1 comment 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Unable to pull specific employees for a performance reportSummary: Team - My counts vary as I try to pull additional fields from a specific report that pulls from the following areas: Compensation - Workforce Compensation Real …Vijay Rajendran 11 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
HCM &Power BISummary Possible that Oracle HCM cant feed automatically to a Dashboard using PowerBIContent Hello, I am just wondering is there any posibility that Power BI can be refr…User_2025-01-29-22-24-40-400 76 views 10 comments 1 point Most recent by Mansur Khalil Reporting and Analytics for HCM
-
Gender Pay Gap ReportSummary Has a Gender Pay Gap report been release for HCMContent I am trying to find the equivalent Gender Pay gap report that existing in EBS. Is there one? If not what …User_2025-01-23-23-03-09-078 177 views 15 comments 4 points Most recent by TarunAggarwal Reporting and Analytics for HCM
-
AZA: Consecutive Absence ReportSummary: Hi team, We have a requirement to build an absence report for a specific absence type, report should pull the data if the duration of the absence is greater tha…Ahmed AZA 31 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Login In, Login Out and Login Duration of a user in an OTBI analysis.Summary Login In, Login Out and Login Duration of a user in an OTBI analysis.Content Hi, We need to find a subject area that gives the login time of the user into fusion…User_MC37Q 302 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Trouble in arranging grids and charts in EPRCS Word report packageHi guys! There is a trouble being faced in arranging grids and charts which are referred from a report in Microsoft word report package and your ideas are much helpful. … -
Table name and column for Projects To ProcurementSummary Table name and column for Projects To ProcurementContent Hi Champs, what could be possible Table name and column for Projects To Procurement and payables or any …
-
Unallocated AORI've got sql to extract those who have an AOR allocated to them but im looking to do a cleanse on active AOR where a colleague isn't allocated. Does anybody have any tho…
-
How to get the Excel option in FCCS Reports - Report Format?Summary: Get the Excel option in FCCS Reports - Report Format? Content (required): Is there any way to get the Excel option under Report Format along with HTML and PDF? …ApOK 31 views 4 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
Total sum of three custom calculated columns is not calculating data correctlySummary I am working on learning report where I need to sum three custom calculated columns to get the total completion of 3 set of courses. I am performing sum of all t…Kamini Kaushik-Oracle 21 views 0 comments 0 points Started by Kamini Kaushik-Oracle Reporting and Analytics for HCM
-
BI Publisher - Can you FULL outer join?Summary: Full outer join in a BI Publisher is not behaving how I expect a full outer join should. Content (required): I need to do a full outer join on two sets of data …
-
BIP Query to pull unapproved/pending absences from last 10 daysHi Team, Could you please help me with the BIP Query to pull unapproved/pending absences from the last 10 days? It would be great if you can share DM or query for the sa…
-
Getting the Period Start Active Headcount to equal the previous months Period End Active HeadcountSummary: Getting the Period Start Active Headcount to equal the previous months Period End Active Headcount Content (required): We need to get the Period Start Active He…Rebekah Gilday 71 views 6 comments 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM -
Seeded HR Reports not returning any resultsSummary: Hi , We actually have to run all the seeded HR reports and present the output to the client . Now I got the list of the seeded reports but when I am trying to r…Gaurav Rath- PGC 51 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is it possible to report on HCM Recruitment transaction team system activity?Summary: We want to report on activities undertaken in Oracle Fusion by People (HR/HCM) transaction administration colleagues. This specifically relates to job offer rec…
-
In the Reports of Planning, list of members on selecting a function behaves incorrectly.When I take the complete hierarchy of a dimension in my report , the member selection option shows all members level 0 and above . But as soon as I pick up on parent hie…
-
OTBI Report Usage - Count of Dashboards run (not executions)Summary: I've found the Usage and Performance Dashboard Sample (catalog files attached) and it looks pretty great but we're struggling to make it work for us. We want to…