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
-
Creating analysis using user defined fields in Workforce CompWe are trying to create some reports using the Compensation-Workforce Compensation Real Time subject area and was under the impression this subject area would pull data … -
Fetching Data from the Legal Entity DFFSummary: Content (required): Hello experts, We've run into a bit of an odd issue, and was looking out for any advice. We've written a snippet of code to fetch the ATTRIB… -
How to calculate Turnover percentage between count attributes in OTBI ?Summary: How to calculate Turnover percentage between two count attributes in OTBI ? Content (required): We are working on an OTBI report where we have to create a summa…
-
Leave Balance Calculation date showing different than UI in BIP reportSummary: Hi Team, Leave Balance Caluclation date showing diffrent than UI in BIP report Content (required): Version (include the version you are using, if applicable): C… -
Oracle Learning - is it possible to report all assignments/roles for an individual in one report?Summary: We have a business need to report on student learning (in the same way we report on staff learning - completions and overdue by department). However, some of ou…
-
Select Max (Last Update Date) from "FUSION"."IRC_JA_EXTRA_INFO"Summary: Calling all SQL Experts: Trying to select the most current record (based upon last_updated_date field) from table "FUSION"."IRC_JA_EXTRA_INFO" in a data model. … -
How to get plan start and end dates for a persons absenceSummary: I want to build a report to show the start and end dates of a person enrolment in a plan as we need to write to each person when a plan will expire. Content (re…
-
HC trend working hoursSummary: Content (required): I am using workforce trend real time to pull period start and end HC by calendar month (2019/2020); however, when I want to drill down to wo…
-
Audit Trail for OTBI ActivitySummary We would like to see an audit trail of who has made changes to a specific folder of OTBI reports and also who has generated specific reports.Content We have a nu… -
We need to give read only access to the User to view all the reports dataSummary: Hi All, We need to give read only access to the User to view all the reports data Navigation -> Tools -> Reports and Analytics -> Browse Catalog -> Shared Folde… -
Employee Vacation Schedule and vacation rate Listing ReportSummary: Looking for sample OTBI report for Employee Vacation Schedule and vacation rate Listing Report. I looked at customer connect "HCM Report Sharing Center" but cou…User_2025-02-12-21-07-06-233 21 views 4 comments 0 points Most recent by User_2025-02-12-21-07-06-233
-
How to use the average functionality per legal employer?Summary: Trying to use th avg functionality in OTBI but not getting the right results in Content (required): I want to show some simple statistics based on legal employe… -
Learning Audit ReportSummary: Our client has a requirement to be able to audit on the following objects in Oracle Learning Cloud. currently oracle dont provide an out of the box solution to …
-
Is it possible to add Department Parameter in Seeded Gross To Net Payroll Report?Summary: I have a requirement to add a Department Parament in GTN Seeded Report Content (required): Version (include the version you are using, if applicable): 22B (11.1…
-
NewHireReport not getting triggeredSummary: Content (required): We have set the value as "true" for all the below profile options: BIP_EMAIL_NOTIFICATION_HCM BIP_EMAIL_NOTIFICATION_HCM_IRC BIP_EMAIL_NOTIF…
-
Where is 'Expedite Payroll' flag stored?Hi All, Summary: I'm trying to find what table is the 'Expedite Payroll' flag on timecards stored? Content (required): this is what it looks like in front-end Thanks!
-
When we apply filter below for particular process not working on pending transactions reportSummary: Hi Team, we have developed pending transactions report in that all process are coming like change manger,'Resignation', location, and etc but we need only Resig…
-
Data is not showing in BI after creating any TransactionSummary: Custom report is not reflecting data immediately after transaction is made in system. Content (required): We have created custom report which is based on absenc…
-
Date is not appearing after transaction madeSummary: Custom report is not reflecting date immediately after transaction is made in system. Content (required): We have created custom reprot which is based on absenc…
-
How to pull Number of employees who dont have a development goal?Summary: The requirement is to build a OTBI dashboard that should display two donut charts (should be added a link) for #of Employees who has atleast 2 development goals…Iswarya Lakshmi Priya-Oracle 21 views 4 comments 0 points Most recent by Iswarya Lakshmi Priya-Oracle
-
What tables store the representatives that are assigned to each employee?Summary: I have been tasked with creating either an OTBI analysis or BI Publisher report to pull all employees and the representatives that have been assigned/linked to … -
Cross SA Employee Census results in errorSummary: In building out an analysis that gives me one row per active employee, I've run into this error: Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8…
-
User Last Login Details Using OTBI ReportSummary: OTBI reports to pull out last login user Details Content (required): Hi, We have requirement to pull out last login user details using OTBI report. Is it possib… -
OTBI- Need 'feedback provided for the manager effectiveness success factor, by managers" detailsSummary: Hi team, I need to build an analysis with the details "feedback provided for the manager effectiveness success factor, by managers". Content (required): I need … -
OTBI Security by Line ManagerSummary OTBI Security by Line ManagerContent MY OTBI security by Manager doesn`t work. I have the Line manager person profile secured by Manager hierarchy, but the Line …User_2025-01-30-21-52-52-008 285 views 17 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
How do you join WLF_ATTACHED_DOCUMENTS with other learn tables of coure? For example WLF_LEARNING_ITSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Unable to join "Workforce Management - Absence Real Time" and Accrual real time subject area.Hi Team, I have a requirement where I need to fetch the absence details and accrual balance if the employee takes the absence under the plan which he is enrolled in. For…
-
Leave Balance showing incorrect IN Custom BIP reportSummary: Hi Team, Some of emplyoees showing incorrect leave balance that zero and some of have showing corret value . Could you please assit on ? Thanks AJAY Content (re…
-
Headcount by week or date returning blanksSummary: Is there a way to report a headcount trend by week or by date using Workforce Trend subject area? Content: I'm trying to build a report that shows headcount by …
-
how to get a report on cascading GoalsSummary: Content (required): Can anyone Give me a better way to have list of Cascaded Goals Version (include the version you are using, if applicable): Code Snippet (add…