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
-
Mask Employees Payroll Run Results data after cloneSummary: We need to mask all Employees previous processed Payroll Run Result data on the cloned system Content (required): We are taking Clone from production to test fu… -
Is there a way to report on the 'Work Category' field on the Timecard?Summary: I am trying to report on the 'Work Category' field from the Timecard but I can't find it in any of the subject areas relating to Timecards Content (required): I…
-
Error while using Evaluate functionSummary: Error while using Evaluate function in OTBI. Content (please ensure you mask any confidential information): Hi, I'm getting error if I use the Evaluate function… -
Sample OTBI Report and Dashboard Workforce Compensation moduleSummary: Content (required): Hello experts, our customer want to see some delivered OTBI Analysis and Dashboards for workforce compensation module. I've tried to open th… -
Vacant Positions in SQLSummary: Hi I have had a request through to list vacancies per Position Code/per CC. But instead of having one row per vacant position, it needs to have as many rows as …
-
How to resize Rows and Columns in OTBI reports?How do I set column or cell dimensions to have a consistent format for my report? -
Showing assignments without data entries?Summary: Using subject areas to create an analysis, we have issue showing assignments without data entries. Content (required): We are creating a number of analyses usin… -
Seeded Roles allowing to open Workforce Compensation Budgets seeded reportSummary: Content (please ensure you mask any confidential information): Hello experts, I cannot successfully open the seeded dashboard in screen (screen 1). The user has…
-
can we generate a report with employee names and with file attached in Document Record.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…
-
SQL count of vacant positions in each department for the last three monthsSummary count of vacant positions for each department group by the last three monthsContent Hi, I am trying to write a sql in BIP to get the count of active vacant posit…
-
Connect Oracle cloud HCM to MS power BI reportSummary: Connect Oracle cloud HCM to MS power BI report Content (please ensure you mask any confidential information): Hi, Is it possible to connect Oracle HCM data sour…
-
Learner should be able to enroll for a course through self service if offering existSummary: Hi, We have a requirement ,learner should be able to enroll to a course if offering exist for that course, else enroll to a course should not be visible. Me->Le…
-
Where are calculated measures housed in the catalog for OTBI ?I've created measures for different reports (not sure which ones), but want to re-use them. Where can I locate them in the catalog?
-
Scheduling OTBI report with a conditionSummary: I'd like to be able to schedule an OTBI report but restrict the data that is sent to the recipient using a condition. Content (required): Our OTBI employee stru…
-
Line Managers reporting on terminated workersSummary This post provides customers a work around in OTBI to report on the terminated workers when logged in as a line manager.Content The attached document provides a … -
Aggregate all notifications from Oracle HCM Cloud into single daily email/ report.Hi all, We have a requirement in which we are looking for a way to a aggregate all notifications from Oracle HCM Cloud into a single daily email or a report, sort of lik…
-
Seeded RFT changes take a long time to get reflected in worklistSummary: Hi Team, I've updated the Seeded RFT and it takes a long time(1 day almost) to get reflected in worklist Let me know for any process name to make the response t… -
Attaching employee image in BIP notificationSummary: I need to attach employee image files in BIP notification . Is this feasible ? if not what are the other alternative solutions? Content (required): Version (inc…
-
Do we need to give Username & Password in Bursting Query for ftp delivery Channel?Summary Do we need to give Username & Password in Bursting Query for ftp delivery Channel?Content Hello Experts, I have a requirement to deliver bursting file to ftp des… -
How to hide or unhide dashboard pages & report links which are embedded in each dashboard pages?Summary: How to hide or unhide dashboard pages & report links which are embedded in each dashboard pages based on logged user. Content (required): We have a Dashboard; i…
-
Is there any link between questionnaire and talent review meeting to get individual's meetings dataNeed a direct link(Join) to fetch individual's meeting details from talent reviews and questionnaire.
-
Need to have Response Answer and Response text in same columnSummary: Dear Experts, Please advise that my questionnaire consists of both response text and response answers. Some response answers will be blank when the question is … -
Learning Ad hoc Access Group Deleted From UI are showing Active in BIP tablesSummary: I am fetching all the learning items along with access and access group assigned to them. Once I created access using Access tab under Learner tab I am able to …
-
Reporting on Uptake of Course across OrganisationSummary: Requirement to work out the uptake of a course and show in graph form Content (required): Hello We have a course that has been created that we expect managers t…
-
Can we change fetch First 250001 Rows Only to any other values?Summary: Can we change fetch First 250001 Rows Only to any other values? Content (required): Can we change fetch First 250001 Rows Only to any other values? It seems thi…
-
Number of days an employee works in the departmentHi, In our setup, an employee can work in different departments. For this, I need a SQL query that returns information on how many hours an employee works in a departmen… -
descriptive flexfield in job to be retrieved in query and joined with personSummary: descriptive flexfield in job to be retrieved in query and joined with person. Not able to join with person. Please share some references ffvs.flex_value_set_nam…
-
Performance Issue in Workforce Management - Workforce Trend Real Time subject areaSummary Performance Issue in Workforce Management - Workforce Trend Real Time subject areaContent Hi Team, We have a line manager dashboard where for one tab we are usin…
-
BIP Job History Retention PeriodSummary: BIP Job History Retention Period Content (required): I'm trying to give clear guidance to our customer, and I'm unable to find a consistent answer on this topic…
-
Pull email for Eligibility Last Updated By field for Performance Document Eligibility subject area?Summary: Field + subject area: Content (required): Hi All, We are using the following subject area to pull information: We are pulling in this field from the subject are…