Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Report on Duplicate Contacts in BenefitsSummary: I'm looking to see if anyone has come up with a clean way to report on duplicate contacts in Benefits. I have read a few other posts about this issue, so I know… -
Report on Extract Definitions / Object Name / AttributesHello, I would like to create a report (Bi Publisher or OTBI). About Extract Definitions. I need following information Extract Definition Name Object Name Attributes Exc… -
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…
-
How can I pull a terminated employee's last annual salary into an OTBI report?Summary: Terminated Employees salary is not returning the expected amount. Content (required): I'm trying to create an OTBI report to use for balancing my payroll. One 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… -
What is the column for enrollment date in the WLF_LEARNING_ITEMS_F table?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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 … -
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 …
-
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… -
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…
-
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 …
-
Report on Talent Review Notes using Workforce Talent Reviews - Talent Review Meeting Real Time?Summary: Subject Area: Workforce Talent Reviews - Talent Review Meeting Real Time Report on notes associated to an employee that is part of meeting review population Con…
-
PER-1530729 POSITION UPDATESummary: ERROR (PER-1530729) POSITION UPDATE The next error that generates the position 203542 when trying to update any of the fields. Also, please indicate that the Pr…
-
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… -
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…
-
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 …
-
OTBI bursting via agent for high volume email notifications inconsistent / sporadicSummary: Classic use case: Managers are receiving emails regarding outstanding actions. Of the 1132 expected emails, 1014 succeed. 118 emails still successfully send, bu…
-
OTBI Analytic - Manager plus email and department detailsHello all, I have been asked to create an analytic that will show the following Columns; Manager Name Manager Department Number direct Reports Number indirect reports Ma…
-
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…
-
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 …
-
Oracle Fusion Table for Deleted Salary RecordGood Day Experts, What salary table to use in order to track deleted salary records within fusion application? Lets say, we have an employee whose yearly salary is like:…
-
Bursting emails are not triggered when sent from any other email apart from domain @oracle.comSummary: We are currently using bursting email notifications to notify employees . However, we have encountered an issue. When we set the "From" email address (Parameter…
-
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 … -
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… -
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…
-
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… -
Can I report on whether learners have uploaded a file into their learning assignment?Summary: I'm trying to create a report that shows me which learners have uploaded a file into their learning assignment for a particular course. In their enrolment the l…
-
User Role Membership Report SQL Query / TablesSummary: Hi Team, for audit purposes customer is requesting to know which tables/views at db level are being used to extract the seeded report "User Role Membership Repo…
-
Plan period start date in absenceSummary: Hi Team, I am trying to get absence accrual detail in OTBI report. Please let me know how to get these details with plan period start date. Thanks Content (plea…