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
-
I need a query to fetch top performing employees in talent managementSummary: I need a query to fetch top performing employees in talent management Content (please ensure you mask any confidential information): Version (include the versio… -
I need a query which will fetch Percentage of employees with high risk of lossSummary: I need a query which will fetch Percentage of employees with high risk of loss in oracle fusion talent management Content (please ensure you mask any confidenti…
-
I need a query which will fetch Percentage of employees with succession plansSummary: I need a query which will fetch Percentage of employees with succession plans in fusion hcm talent management Content (please ensure you mask any confidential i…
-
I need a query which will fetch Percentage of turnover of top performing employeesSummary: I need a query which will fetch Percentage of turnover of top performing employees Content (please ensure you mask any confidential information): Version (inclu…
-
I need a query which will fetch Cycle time in days for the formal performance review processSummary: I need a query which will fetch Cycle time in days for the formal performance review process from start to finish Content (please ensure you mask any confidenti…
-
how can I create an alert within OTBIHello, how can I create an alert within OTBI? I need to send email notifications to both the manager and the employee. Is there any documentation or guidance available f…
-
convert person from text to number in BIThe person number is presented as text when we export a report with the number to excel. Is there a way to get this person number as number value in reports? Wouter
-
Report for Qualification EntitlementsSummary: Hi, we have a requirement to create a report for the Qualification Entitlement details of employees. We have checked OTBI and BIP (both ANC_PER_ABS_QUAL_ENTL an…
-
FMLA Qualified Entitlement Balance ReportSummary Does anyone have a report that pulls balances on qualified entitlements?Content I am able to pull reports of absences but not entitlements. Since some absences a… -
Extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tablesSummary: We have a requirement to extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tables since go live. We tried to build a BIP Report and running them …
-
Customizing Email notifications for timecard transactionsWe have a requirement where we need to send customized email notifications for the below timecard transactions: If a timecard is submitted by employee, a custom email no… -
OTBI showing home department instead of worked/cost department for reported hoursWe’ve noticed a reporting discrepancy between HCM and OTBI when it comes to department allocation for hours worked. In HCM, an employee’s hours are correctly charged to …
-
How can I pull an open requisition report that lists each Req's AOR representative?Summary: We would like to pull a report of open requisitions that includes a column listing the req's AOR Representative of a particular type. Content (please ensure you… -
Ability to embed an OTBI report into a Redwood pageSummary: We have requirements to call an OTBI report from redwood page , its applicable ? if yes , what are the required steps to do that? Content (please ensure you mas…
-
In which table do I find the name of school in Skills and Qualification > EducationSummary: In this query hpi.item_number_9 returns the ID of the school field. But I do not know with which table the ID must be linked to display the description of the s… -
Total current hours worked per employee in reportI am trying to run a report that will show every employee with the total number of hours they currently are contracted to work subtotalled (we have quite a number of emp… -
SQL query to fetch the Candidate university name from Academic qualification section in ORCHi Team, Need assistance, we are trying to fetch the university name from the candidate education qualification section. But not getting the data from this table IRC_PRO…
-
BIP Web Layout Editor (.xpt) Pivot table Header's Vertical alignmentSummary: Is there really no Vertical Alignment in Measure labels header in a pivot table in .xpt report template? it looks in the center in edit but in the output: I tri…
-
How to embed an OTBI report or dashbaord on a redwood page?Summary: Content (please ensure you mask any confidential information): Is it possible to include or embed an OTBI report/dashboard on a redwood page (e.g., Journeys pag… -
Hiding columns based on conditions in BI report excel outputRequirement: Based on the employee who is viewing his/her compensation, we need to do hide few columns depending upon the employee's LDG and his eligibility. Can anyone …
-
Getting Person ID of the direct reportee from a comp page for which the Manager is viewing the dataSummary: On the Compensation Info page, we have a requirement to embed a report with additional compensation information details and when a manager tries to click and vi…
-
How to see who deletes datamodel/report in catalog?Summary: How to see who deletes datamodel/report in catalog? Content (please ensure you mask any confidential information): A datamodel is missing under analytics/catalo… -
Query to fetch all the workflow transaction in HCMSummary: Team, can someone please share me the query to fetch all the transactions recorded in HCM Cloud(Transaction Console), I tried to query from fa_fusion_soainfra.w…
-
Hiding columns based on conditions in BI report excel outputRequirement: Based on the employee who is viewing his/her compensation, we need to do hide few columns depending upon the employee's LDG and his eligibility. Can anyone …
-
Formula for Days Open in OTBI for Job RequisitionsSummary: I'm creating an OTBI report for Posted Requisitions. Currently I'm using Job Requisition Open Date from the Recruiting - Recruiting Events Real Time and to get …
-
OTBI report to pull BPFM hierarchySummary: Could you please help in pulling the BPFM Hierarchy using OTBI Content (please ensure you mask any confidential information): Version (include the version you a…
-
Can we create a dashboard using cards?Summary: Is it possible to create a visual dashboard within Oracle HCM to display key HR metrics such as headcount, billable vs. non-billable employees, attrition trends…
-
Report on if employee has viewed / downloaded DOR?Summary: Hi team, We have recently been asked if we can report on if an employee has viewed / downloaded a specific DOR and/or its attachment? I am unsure on whether or … -
Workflow Notification addition to DM and BI template not showing up on UI page (ManageCompensation)Summary: Hi Forum: on a Redwood-enabled workflow notification, our additional JobCode field we added in Employee Details section of ManageCompensation report/DM does not…
-
How does the data get restored into a useable format so that reports can be generated?Hi Team, Could you please help with the following query. Client is running SaaS Fusion ERP, HCM, SCM, and a few others. Client is dissolving and going out of business Cl…