Category 81
Discussion List
-
Is there a UE that can fetch LE details including LE addressSummary: Requirement is to get all active LEs and their respective address along with Bank Details for the UE. Content (required): I tried using the below UE but it does…Vibha Pandey - Oracle 11 views 1 comment 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
Can we get offering old and new status?Summary: Hi All, I am working on a report where the requirement to get the old and the current status of the offering. I queried mentioned below tables to get the status… -
Adding data element to a data model (Adding Full_Name to EEO-1 report)Summary: Assistance requested in adding Full_Name to a data model Content (required): We have some EEO-1 reports that were built by someone else prior to my arrival. One…
-
Source System ID for Work TermsSummary: Sample Query to extract SSID for Worker.dat >>>> Work Terms object upload Content (required): We have a requirement to extract SSID of work Terms object for Wor…Dhajani Perera 514 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Best practices on how to combine HR data from other non Oracle applications with Oracle CloudSummary: I would like to know how other customers have linked data from other applications to their Oracle cloud solution. we have OAC and use ADW as a data source and a…Robert Geddes 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Converting UTC to EST time zone in Logical SQLSummary: Our report is built with logical sql, the approval dates are displaying in UTC time zone and we need these to reflect EST time zone. Need help with syntax. Cont…Denise Izzi 2.5K views 7 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
Aggregate function in OTBI AnalysisSummary: Please share some documentation on using various aggregate functions on any column of an OTBI analysis Content (required): Need to use aggregate functions acros…Hem 375 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 34 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 21 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 22 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 405 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 32 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 12 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 42 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 103 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 12 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 11 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 31 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 21 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 43 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 21 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 265 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 21 views 1 comment 2 points Most recent by Swapnil Kashid Reporting and Analytics for HCM