Reports
Discussion List
-
Dashboard on Development Area: hrr_tmpl_metric_configSummary: Goodmorning, we're fancing a problema with the Talent Review Matrix in the Dashboard Standard The matrix is empty: analyzing the query from the log, we've seen …AM HRE 11 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
Which SQL Table store the Activity Information of Time Entry in OTL.Summary: If you have BIP SQL handy. Please share Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable…Ketan-Oracle 14 views 2 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM -
Female turnover rates of DashboardI'd like to ask that if I select the Female as the Gender, how is the female turnover rates calculated? Is the denominator of the ratio in relation to all employees or o…Chen, Reyna 22 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Time spent per approver in workflow approvalsSummary: We have a requirement to report out how long a specific workflow proves (Approve Job Requisition) remained with each approver within the workflow. Is there a re…Audrea Miller 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to Remove Duplicate Rows from Pivot table in OTBISummary: In excel - once you add the data to the row it makes it one to one - in OTBI how would I ensure there are no duplicated rows of data? Content (please ensure you…THawkins_LGI 99 views 10 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Issue with the Custom Data roleHi, We are using a custom role titled "Hub Data Role - Hub Driver Services". Users assigned this role should be able to view all information related to that specfic job …
-
How does your organization use Oracle to comply with the MN Wage Theft law?Summary: My organization is in the process of implementing Oracle and we’d like to understand if other MN-based organizations have a process in place related to MN Wage …Tammi Desens 12 views 4 comments 1 point Most recent by Carolyn K Payroll and Global Payroll Interface (GPI)
-
MilanMohanty 90 views 2 comments 0 points Most recent by Ankit Chauhan Reporting and Analytics for HCM -
Scheduling FTP report - How to schedule multiple reports with one job?Summary: Our purpose is to launch only one job for multiple reports Content (please ensure you mask any confidential information): Hello experts, We have a requirement t…Giuseppe Casalino 14 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Report for Missing TimecardsSummary Employees without time card associationContent Hi All, We have a requirement to identify and report those employees that are missing time card association. I am …Sowdha Murugan 241 views 3 comments 0 points Most recent by Pennie Spies Reporting and Analytics for HCM -
Impact Assessment of Redwood on the Core HR reports and dashboardsHello experts, we are now planning to implement Redwood for Core HR. Can you advise what we should watch out in the Reporting side? Like Changes in the Subject Areas, or…Maria Cristina L. San Jose 25 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Issue in Salary Certificate DORSummary: Issue in Salary Certificate DOR Content (required): Hi All, We are facing the issue in salary certificate DOR. Salary certificate is working fine in draft versi…
-
Cumulative Salary ReportSummary: Financial report of cumulative salaries per reporting period Content (please ensure you mask any confidential information): Hi experts I have a request to provi… -
Run bip reports via payroll flow or ess jobsSummary: We are planning to create BIP reports, which will run in changes only mode. As a best practise should we be running the report leveraging the last run ESS job o…
-
OTBI report available for employeesSummary: OTBI report available for employees Content (please ensure you mask any confidential information): Hello, we have configured a guided journey which is visible i…
-
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 103 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 64 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 12 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 22 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 57 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 260 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 43 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 22 views 1 comment 0 points Most recent by Shweta Ganguly-Oracle Human Capital Management