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 Job Offer Employment Category in AnalysisSummary: I want to Report the Employment Category of a Job Offer in an Analysis Content (required): I use the Subject Area "Recruiting - Recruiting Real Time" and can't … -
Learning Count Using Disability StatusSummary: Using the Workforce Learning - Learning Records Real Time Subject Area to pick up disability (which is using Workforce Management - Person Real Time to count th… -
Query About Column Names for Source Tracking.Summary: I am creating one BI report in which I need to pull application source and application source details. In which table i can find it? I have checked in IRC_SOURC… -
Hi, I hope everyone is doing well. I need help to pull every column from Oracle HCM (BI Query) .Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Length of Time in Job OTBISummary We have a reporting requirement where we need to capture the Length of Time in Job. Is it possible through OTBI? -
HR Security Access - ReportsSummary: HR admins have access to salary data for the organization, except for within the HR department. They are not authorize to see each other's salary data. We had c…
-
Export to excel for an OTBI analysis in Guided JourneysSummary: We have deployed an OTBI analysis in Guided Journeys that would be most useful if the user could export it to excel. Is there a way to incorporate this feature … -
How can I fix some columns in the Analysis report?Hi I created a report from analysis and set it to Fixed headers with scrolling content. But I have too many columns in my report, so I need to freeze 3-4 columns. How is… -
SQL for compa ratioSummary: Need correct SQL to find Compa Ratio Content (required): Hello, I am writing a report for the business that includes the compa ratio as one of the columns. And …
-
Fetch users who have NOT logged in since past 30/60/90 days and send reminder emailSummary: Fetch users who have NOT logged in since past 30/60/90 days and send reminder email Content (required): I need to fetch list of users who have NOT logged in sin…
-
Ability to track the number of times learner retook/reviewed an already completed learning itemSummary: Looking to create a report that gives the number of times a learner has reviewed or retaken an already completed learning item. Is this information recorded, an…
-
Pending worker Not converted report in OTBISummary Pending worker Not converted report in OTBIContent Hi, I am trying to create a Pending Worker Not Converted to Employee/Contingent worker report in OTBI. I am cu…
-
Looking for table for salary change action and reasonSummary: Looking for table for salary change action and reason Content (required): Which table holds the salary change reason and action? This is not the same table whic… -
Filter based on custom values in promptSummary: How to filter analysis based on custom values in prompt? Content (required): I have a variable prompt which has custom values like ALL, Female, Ethnicity etc. i… -
Salary Increases reportSummary Report to show increases to salary with date and reasonContent Hi, has anyone created a report, (guessing it would need to have been done in BIPublisher?), to re…
-
Error While opening OTBI ReportSummary: Error While opening OTBI Report Content (required): Hi Everyone, While opening the OTBI report, it throws me following error. As per the document Doc ID 2083725…
-
Report on total number of direct and indirect reports by managerSummary How can I sum distinct direct and indirect reports by manager?Content Hi - I'm having a hard time figuring out how to sum direct and indirect report total counts…
-
How do I create a learning category headcount report?Summary: I am having to create new reports for the new Learning Subject Area (Workforce Learning - Learning Records Real Time) due to the Learning Management Subject Are…
-
Report on Salary Change Action and ReasonSummary I'm looking to report on Action and Reason within Manage SalaryContent Using the Compensation - Salary Details Real Time subject area I'm able to pull Action and…
-
Unable to hide prior incumbent details in position FTE reportSummary: Unable to hide prior incumbent details in position FTE report Content (required): Unable to hide prior incumbent details in position FTE report. Following scree… -
Payroll - Element Entries Real Time - zero results when adding person numberSummary Zero results when from including different fields from same subject areaContent I hope this is one of those obvious "doh" moments. Subject Area: Payroll - Elemen… -
Different Learning Metrics - Existing dashboard resource?Summary: Content (required): Hi there at the end of the year we need a number of learning reports. I have a few organised but I was wondering if there is any resource re… -
MonthName function not WorkingSummary MonthName function not WorkingContent Hi All , I am trying to get the Month Name (Jan / Feb / Mar) from a Date entry - Eg -I'm using the following function - Mon… -
How to display MTD, QTD in payroll register report for latest processSummary: How to display MTD, QTD in payroll register report for latest process Content (required): As of now payroll register report displaying only Run and YTD values. …
-
What is the best way to mass assign a Dashboard to a large groupSummary: Only a small handful of employees use the reporting system. I am building several Dashboards for various teams, and was wondering the best way to get those folk…
-
How to Capture a Work at Home Flag Change in a report?Summary: Content (required): Hello Experts, We need to report on instances when employee's Work at Home flag changes from 'no' to 'yes' and from 'yes' to 'no'. Does anyo… -
Calculation Cards TRUSummary: I would need to get the value of TRU in Calculation Card. I am unable to find the table name. If anyone could help on this, would be really great. Screenshot At…
-
Exception: The job attached to employee must have an EEO job category.Summary: Hi All, I am getting this in the EEO1 exception report . Any idea why its throwing this error? I have made sure that all the jobs that are used have the EEO cat… -
How to embed Analytics, as an icon, in My Team page in UISummary: Our client wants to embed Analytics, as an icon, in My Team page in UI, which will redirect to a custom Analysis, as similar to the attached screenshot. The ico…
-
Can a column name be modified but also translated?Some standard colom names are not suitable for our organization but if I change them the name will be fixed. For example if I change the language settings the name of th…