Reports
Discussion List
-
Time to Fill Measure using Requisition Open Date in Recruiting - Recruiting Real Time Subject AreaContent I'm trying to create a Time to Fill measure using data in the Recruiting - Recruiting Real Time Subject Area. My calculation works but the Requisition Open Date …User_2025-02-10-14-03-41-548 112 views 5 comments 0 points Most recent by AshleyM Reporting and Analytics for HCM -
Recreating Workforce Goals Reports using BI PublisherHello, For a number of reasons we've had to use BI Publisher to build a report on performance Goals and Goal Plan Eligibility. We've tried to use HRG_PERF_GOALS_SECURED_… -
Payroll Element Entries History excluding terminated employeesSummary Payroll - Element Entries History Real Time subject area is excluding terminated employeesContent I have created a report to pull Annual Salary and Annual Bonus … -
Completed Talent Review-Not populating in ReportSummary Completed Talent Reviews are not populating in reportContent Hi All, Our Talent Review process has started and we are now submitting the meetings and completing …User_2025-01-25-01-10-42-578 63 views 6 comments 1 point Most recent by Pandey Roma Reporting and Analytics for HCM
-
How to restrict to get one level of indirect employee data of manager?We want to get the data only for Indirect employee of the Senior Manager? but we are getting Indirect employees reportees data also. In query we have used PER_ASSIGNMENT…YAMINI DANTOORI 11 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Can we track Candidates who agree to Terms and Conditions on the Career site?We are trying to find out if it's possible to track candidates who agree to the terms and conditions when applying through our career site. Candidates are given the opti…Niveditha 21 views 1 comment 0 points Most recent by Ramya Pabba-Oracle Reporting and Analytics for HCM
-
Is it possible to get metadata of OTBI reportsSummary I am looking for any workaround to get the report/analysis names with subject areas used in a folder.Tried to find any xdo tables but no luck. TIAContent Assume …User_2025-02-05-19-28-09-134 56 views 3 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Oracle fusion hcm OTBI Subject area for person extra infoSummary: I am looking for subject area in oracle fusion HCM that store person extra information. (i.e. Region (PEI_INFORMATION1), Capability (PEI_INFORMATION2), Service …Anup Karmankar 354 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Data Security Policy is not working for the custom role which has Purchase Analysis role addedSummary: We have created a custom role by copying it BI Consumer Role, We have also added the Purchase Analysis role under this custom role so that users can access the …Shabbir M Tahasildar 72 views 5 comments 0 points Most recent by Shabbir M Tahasildar Reporting and Analytics for HCM -
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…
-
Finding Business Owner of Dynamic GroupsI am reaching out to inquire whether anyone has knowledge on how to find the report owners for Dynamic Groups within oracle system. Specifically, I am interested in unde…Demetrius Davis Jr 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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…
-
HR_DOCUMENTS_OF_RECORD_AUDIT Missing DFF Value for Assignment Number (Purged I-9 Report Issue)We are encountering a critical issue with generating a purged I-9 report due to a missing Descriptive Flex Field (DFF) value in the HR_DOCUMENTS_OF_RECORD_AUDIT table. T…Sunil Kumar A 23 views 1 comment 0 points Most recent by Shweta Ganguly-Oracle Human Capital Management
-
Issues experienced when using agentsHi everyone, We have a reporting team member has raised a few issues when using agents for reporting. Below are the symptoms of the problem. The agent failing The agent …
-
Remove Manager role from Worker self-evaluation Performance TaskSummary: Hello, I need help to check if my case statement below is correct. I encountered errors several times so I'm not sure what is the problem with this. I want to i…
-
What is the role of the Manager in Self-Evaluation?Summary: Hello, I'm currently working on Performance Task Status Report for my organization. I've changed the Role to Task Assignee. In the Worker Self-Evaluation, there…
-
OTBI Report for EthnicitySummary OTBI Report for EthnicityContent Hello, CASE WHEN COUNT("Worker"."Employee Ethnicity Code" BY "Worker"."Person Number")>1 THEN 'Two or More Races' WHEN "Worker".…Shanna Oppenheim 646 views 79 comments 2 points Most recent by Juliet Eaton 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…
-
Talent Review Meeting Report-Security BIPSummary: How can we limit the visibility of the Talent Review Meeting Report so that facilitators can only view the meetings where they are assigned as a facilitator, wi…
-
Need to report the number of Goal plan assignees who have Goals Created/Not createdSummary: Hi peers, My client wants a report that gives a count of the number of employees that have created goals as well as those who haven't yet created (even a single…
-
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…
-
HCM report for monitoring access visibilityHi All, As a part of Executive and above (10,000+ employees) salary migration to the Fusion system, we are planning to introduce controls on salary visibility and access…Sachini 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 491 views 5 comments 0 points Most recent by Christopher Haupt Reporting and Analytics for HCM -
OTBI - ORC Report - How to pull the Offer accepted application status and Background Check applicatiSummary OTBI - ORC Report - How to pull the Offer accepted application status and Background Check application statusContent Hi. We have the candidates who accepted thei…Shabber Shaik 73 views 3 comments 0 points Most recent by Abhiram Vissamsetty 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… -
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 10.7K views 32 comments 2 points Most recent by Parag Hiremath 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 181 views 6 comments 1 point Most recent by Ankammarao Reporting and Analytics for HCM -
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…