Reports
Discussion List
-
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…Urvashi Jain-160544 76 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 71 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 16 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 11 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 36 views 12 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Error on running an OTBI report after 22B being appliedSummary: We are facing issues in running a OTBI report post 22B upgrade. Please see the attached error and let me know how to resolve this issue. Content (required): Ver…Veena P 24 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Ability to report on permissions/access granted for reporting.Summary: Has anyone managed to /know how to report on the permissions assigned to a report/folder in BIP? Content (required): Hello Has anyone managed to /know how to re…Helen Thomas 12 views 7 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
Need table name to fetch 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen.Summary: Dear Experts, Which table stores the 'Plan Period Start Date' in the 'Accrual Plan Balance' Screen. Please find the attached Screenshot for your reference. Than…
-
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 …VRaj1182 2 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Payroll Costing Setup: Join Position Level Segments with Work Structure DataSummary: Having trouble finding a good way to join Position Level costing segments from "Payroll Costing Setup Details Real Time" with relevant columns from "Worker Assi…Patrick_Midd 12 views 4 comments 0 points Most recent by Patrick_Midd Reporting and Analytics for HCM
-
Grade Step in OTBISummary Workforce Management - Worker Assignment Real Time does not display current gradeContent Hi, Does anyone know which subject area would give me Grate step values …Neena S-82284 55 views 19 comments 0 points 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…Maria Winters 66 views 10 comments 1 point Most recent by Mansur Aulam Reporting and Analytics for HCM
-
Executing seeded data model to display report - TalentProfileDMSummary: How can I run the seeded data model, TalentProfileDM, to review the data that I have input into the talent profile? Content (required): This is a massive data m…
-
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 …Alison Moss 157 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 21 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 232 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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…
-
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 11 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 …
-
Where can I find the database table that holds Segment Value Security Conditions and Policies?Summary: I'm looking for the table in the database where Segment Value Security Conditions and Policies live. Content (required): I am making some changes to the rules a…David Rabalais 11 views 0 comments 0 points Started by David Rabalais Reporting and Analytics for HCM -
How to Get XLE_LE_ADD_INFO in HCM OTBI Subject Area?Summary We have a DFF with module Legal Entities and the Legal entity GL code has been created on Attribite1 of XLE_LE_ADD_INFO FlexfieldContent Hello Friends, We have a…Mansur Aulam 54 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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 13 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- THG 23 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…
-
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…
-
How to display indirect terminations for a specific manager?Summary: We have a requirement to build OTBI (Graphs) to display number of terminations under a specific manager. There are 2 OTBI analysis I use in the dashboard - 1 wh…VRaj1182 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Customize- Payroll Register Report for the Latest ProcessSummary: Can we add additional attributes by customizing the seeded extract "Payroll Register Report for the Latest Process". Content (required): Can we add additional a…Mohan Murali 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Issue in OTL BI reportSummary: Performance Issue in OTL report Content (required): We have existing report on OTL which is taking 3-4 minutes for generating data. Is there anyway that we can …Priyanka More-Oracle 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM