Category 81
Discussion List
-
Not getting any data when opening the reportSummary: Content (required): Hi Expert, We have built a report and it is an Individual Compensation report, I have all the roles but when I am assigning payroll admin an…Faizan Rashid 33 views 11 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM -
Users cannot see their own accrual balanceSummary: Users cannot see their own holiday accrual balance in OTBI accrual report Content (required): I have an OTBI report showing Accrual Balances using the Accrual R…s_b 21 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Need inputs to get the Target Element Name under Status Processing RulesSummary: Need inputs to get the Target Element Name under Status Processing Rules in Element UI Content (required): We can have a link between Pay_Element_types_vl and P…
-
US Reporting for Legal ComplianceSummary: Content (required): Hi team, An US client asked us some Reporting for Legal Compliance. We found that Oracle HRMS and Oracle HRMS provide support for several co…Gabriele Falso-Oracle 27 views 2 comments 0 points Most recent by Gabriele Falso-Oracle Reporting and Analytics for HCM -
How do I access a .dat file that has been loaded into the systemSummary: I am trying to review file that was processed through our recruitment application but I can't figure out how to review the actual .dat file Content (required): …User_2025-02-04-08-51-08-912 28 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
User Login DetailsSummary: Hi I am looking for a BI / OTBI report that would give me the user login details. Content (required): I looking for a report that contains, User Name, Email, Pe…Manoj B. Cheruvathoor 419 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
OTBI reports to replicate delivered reports in Workforce Compensation > Pay for PerformanceSummary: Workaround solution following 21D release "improvement" Content (required): It has been decided by Oracle to disable reports in order to improve the performance…Amandine C-Oracle 39 views 1 comment 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Dashboard over a Mulitple assignment HCM config - need to eliminate wrong result from dashboardSummary: VP is seeing an Indirect reports Director that is outside of Talent/Performance Goal Drill-down compared to User Interface for Performance and Goals (Talent) Co…John White-Oracle 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Termination Report needed (workflow initiated date vs the actual termination date)Summary: We are in need of a report which will help us catch "late terminations". Report should have a date in which the workflow was initiated, and then the termination…
-
Denied the delete option from everywhere.Summary: Hi Team, I have created a custom role, and I want to denied the delete option from which function need to denied for my custom role and only the "BI Author Role…User_2025-02-12-18-16-01-181 44 views 3 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
Manage Report Jobs screen shows owner as fusion_apps_prov_patch_appidSummary: Manage Report Jobs screen shows owner as fusion_apps_prov_patch_appid Content (required): Hi, The Manage Report Job screen shows the Owner as "fusion_apps_prov_…Christopher Jothi - HCM-Oracle 104 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Error When Trying to Save Agent (Scheduling a Report)Summary: I am getting this error "The following error occurred: Oracle BI Scheduler Error: [nQSError: 12017] Unexpected socket read timeout: connection terminated by net…Erin Hamrick 23 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Session Variables for Recruiting Subject AreasSummary: We have an open requisition report that we would like to use a session variable for so that the recruiter who is viewing the report only sees their requisitions…Allison O'Brien 83 views 2 comments 0 points Most recent by Allison O'Brien Reporting and Analytics for HCM -
How to Add Documents of Record from HCM Employment Flow to Approval BIP NotificationSummary: Has anyone had success adding the DoR added during an HCM employment flow to the approval BIP workflow notification? If so, what needs to be added? Thanks! Upda… -
How can i create a current and previous report for location change for a dashboard?Summary: I need to create a location change report using the visa permit type (not null) in the Person Real Time subject area and the Assignment Event Real Time subject …Mark Stoker 13 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Ethnicity ReportingSummary: Event headcount is incorrect. Showing 2 when employee has more than one ethnicity selected. Content (required): I'd love a second set of eyes on this. On recomm…Susan Anderson 132 views 2 comments 0 points Most recent by Christine Tutani Reporting and Analytics for HCM -
How to create an advanced OTBI reportSummary: Short video describing how to create an advanced OTBI report using a calculated column and binning. Content (required): https://www.youtube.com/watch?v=YNcSgOvw…Julian Challenger-Oracle 34 views 0 comments 3 points Started by Julian Challenger-Oracle Reporting and Analytics for HCM -
Not able to hide the delete button from a reportSummary: Content (required): Hi Expert, We have a requirement to hide the delete button from a report. But we are not able to delete the button. We are using a custom ro…Faizan Rashid 25 views 1 comment 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
SQL to calculate overall tenureSummary: Content (required): I am working on a BIP report and I would really appreciate if I get some help with the SQL to calculate the overall tenure of the employee w…Prajna Hegde 44 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
BIP Report - Department HierarchySummary: Does anyone tried creating report in BIP with department levels such as Department Level 1-8. Kindly share the sample query. Thanks Content (required): Version …Hazel De Castro 23 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
In BIP, when clicking on the download button in PDF output, an HTML file is downloadedSummary: The issue is when clicking on the download button in PDF output, an HTML file is downloaded instead of a PDF. Would there be any setting to set in the BIP repor…notautomni9 281 views 3 comments 0 points Most recent by Paidiparthi Ravindra Reporting and Analytics for HCM -
Report on scheduled Extracts and BI reportsHow to get a report on all the extract and BIP reports scheduled in system with frequency of schedule? Regards, NivyaNivya Mathire 22 views 1 comment 2 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Dashboard take minutes to show resultsSummary: We have a dashboard that presents the result of review documents on one tab and goals on a second tab. When opening the dashboard, it takes quit some time befor…Wouter.Schaap 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Pull data for a specific person number when there are multiple Person numbers in the dataSummary: I am trying to pull management level for the manager's job vs the employee using OTBI report Content (required): I am using workforce assignment real time - how…Riti Malhotra 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Issue-Line Manager getting employee's all assignments performance documents details in OTBI reportSummary: I am working on one OTBI report to fetch the details of performance document for line manager. Employee who are having two Active assignments and both assignmen…Kamini Kaushik-Oracle 22 views 3 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
PERIODROLLING for Annual TurnoverPERIODROLLING for Annual Turnover I have been successful in plotting a Rolling month turnover rate using PERIODROLLING("Workforce Trend"."Period End Headcount",-11,0) . …
-
Security profile to restrict line manager to view only one assignment of employees in OTBI reportSummary: Hi All, My line manager is able to see the records for performance document for all Active assignments of employees. How to restrict my OBTI output so only the …Kamini Kaushik-Oracle 33 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Why would OTBI reporting show a row with no absence plan name against an employee?Summary: Multiple rows showing with a blank Absence plan name Content (required): I have created a simple analysis with Person number, Name, Absence plan name and termin…Elizabeth Docherty 33 views 1 comment 0 points Most recent by Elizabeth Docherty Reporting and Analytics for HCM -
How to fetch details of bypassed task for performance document in OTBI reportSummary: I have requirement to fetch the details of bypassed task in performance document in column Content (required): In our instance for performance document the work…Kamini Kaushik-Oracle 15 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM