BI Publisher
Discussion List
-
Multiple legal employers records showing in each employeeSummary: Hi Team, we have BI query but it Multiple legal employers records showing in each employee. example one employee have x legal employer but it also showing secon…AjayKumar Maddipati 24 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Employee previous and current locations reportSummary: Looking for a way to report employees and their locations (Current and all previous locations). Content (required): Looking for a way to report employees and th…Scott Conaway 94 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
List of all Custom ReportsSummary: Can we get a list of all reports (Custom + Standard) using a query? Also, users who are all having access to these reports? Content (required): Version (include…
-
How to get legal employer legislation code with SQLSummary: How to get the legal employer legislation code with SQL Content (please ensure you mask any confidential information): Hi experts, I need to get the legal emplo…Volodymyr Faranosov 66 views 2 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
How to identify the employees who didn't receive Outlook invites after a course is assigned?Summary: Hi, Is there a query to identify the recipients of Outlook invites after a course is assigned? we have a situation where some individuals received the invites w… -
SQL query or Table for Actions under Transaction Design studio in oracle fusion HCM my client groupSummary: Hi @everyone We need your help to get below requirement: in case we do personalization through transaction design studio, we can unhide a section in the page wh…
-
Can we change the View Profile link to navigate to Skills Center in the ProfileChangeNotification?Hi All, We have a requirement to open the link of the 'View Profile' option button from Connections to the Employee Skills Center page in the ProfileChangeNotification W…
-
Generate run balances seeded processSummary: If we run Generate Run Balances need to know what all are the transactions/records are added/updated in the Pay_run_balances tables Content (please ensure you m…
-
How can some Audit details be reported in Oracle Cloud HCM?Hi, I need some application security details that the client requires. For Example; User Login and logout Roles assigned to the user and their changes Password change in… -
Payroll query that fetches results only if for the Employee Generate Payslip flow is not run.Summary: I need to create a BI report which retrieves Employee Information of the users along with other Common columns also needed to see if whether is employee get pai…Ketan-Oracle 9 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
hide an RTF hyperlink field on notification report conditionallySummary: Hi forum and BI Publisher Experts: i wish to hide a URL hyperlink only when ( 2 ) previous data model person number values (will not be shown on report) are equ…
-
How can I export list of delivered reports for fusion HCM?Summary: Where can I find list of core delivered reports for fusion HCM modules. Content (please ensure you mask any confidential information): Version (include the vers…
-
What Oracle IP address(es) should be provided to recipients of reports via SFTP delivery option?Summary: We need to provide IP addresses to an external third party so that they can whitelist them in order to successfully receive BI Publisher reports directly from O…BeachDreamer 389 views 5 comments 0 points Most recent by Christopher Haupt Reporting and Analytics for HCM -
Fast Formula doesn't return expected valueSummary: Content (please ensure you mask any confidential information): Hello, we built the following FF where we should retrieve value from two different value sets. If…Valerio Curzi 25 views 3 comments 0 points Most recent by A_R-Oracle Reporting and Analytics for HCM -
SYSTEM_PERSON_TYPE not updated to CANCELED_HIRE after Cancellation of work relationshipSummary: We used to get the employees whose work relationship is cancelled after Hire (from Pending Worker to Employee conversion) by querying the 'per_person_type_usage…Sujay Bhowmick 66 views 6 comments 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
System Account OwnerSummary System Account OwnerContent Hello Everyone, We've updated a few reports back in October/2020, however we can see now the owner as System Account, (as per screens… -
Reporting for Workers CompGood morning. I am in need to find a report that will show rates and also a worker's comp audit report. Has anyone had success with these types of reports.?Tisha Negrete 52 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
User Last Login Date ReportSummary Need to report on User Last Login DateContent Hi All, I am looking for a way on how can I report for User Last Login Date using BI Publisher. I tried using the F…User_2025-02-04-07-19-57-588 10K views 32 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Print Talent ProfileContent I am creating a custom print of talent profile RTF Template and there are some sections that are only available to line managers but when an employee prints it s…Misbahul Khair 54 views 2 comments 2 points Most recent by Harshal M Reporting and Analytics for HCM -
Enterable Calculation Values on Calculation Cards - Query/ReportSummary: Enterable Calculation Values on Calculation Cards - Query/Report Content (required): Hi Team, Greetings! Does anyone have the report or query to extract the dat…Parag Hiremath 142 views 6 comments 1 point Most recent by Ankammarao Reporting and Analytics for HCM -
Based on the parameter year i should get the data based on that year i should get the data.lets say the paramter is audit_year = '31-12-2021' the requirement is something that we should get the data based on the parameter i.e i should get the person record bas…
-
How to have a report send email that report is ready to be viewed in checklist?Summary: We would like to have a report send notification that the report is ready to be viewed in checklist. But, we do not wish to attach the report output to that ema… -
Payroll Flow - BI Report - Bursting - Not generating output file.Hi folks, I'm generating a payroll report and pushing it on SFTP using bursting. Template, filename and path is derived via bursting .This report is attached to a Payrol…
-
Request Documentation on Critical PVOs for Oracle Fusion HCM Integration with Data LakeDear Team, We have recently implemented Oracle Fusion HCM and are now working on integrating it with our Data Lake. To better understand the critical PVOs required for t…MDge 2 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Chetana Pawar 769 views 2 comments 0 points Most recent by Maheswar Reddy Reporting and Analytics for HCM
-
How to customize the seeded deduction report?Summary: We would like to add additional columns like assignment status to the standard deduction report that runs part of the payroll flow. What is the recommended appr…
-
Report to identify Users when Clicked on Learning Tile under My Client GroupsSummary: Report to identify Users when Clicked on Learning Tile under My Client Groups Content (please ensure you mask any confidential information): I am looking to see…Thulasi Ram 11 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Can't access report and analyticsSummary: Content (required): All the users can't access to Reports and analytics even in admin User. The error massage is Insufficient permissions You do not have suffic…LiorZiv 577 views 10 comments 0 points Most recent by Parth Trivedi-Oracle Reporting and Analytics for HCM
-
Query to get Latest offer extended by details in ORCHi Folks, We are trying to fetch the latest offer extended details in our report, we tried latest updated by column from irc_offers, but It didn't work. Scenario: Hiring…Sushant95-Oracle 27 views 1 comment 0 points Most recent by Anu Puchha Reporting and Analytics for HCM