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
-
Adding parameters to a deep linkContent Hi, Does anyone have steps or documentation of adding parameters to a deep link to go into a specific person's page/details from an OTBI report? Deep Link - http… -
Average Time to HireSummary Documentation or Logic of Average Time to HireContent Is there any documentation or means to know how the measure "Average Time to Hire (Days)" is calculated in …
-
Please share SQL to return only employee person type whose termination approvals has been acceptedSummary Please share SQL to return only employee person type whose termination approvals has been acceptedContent Hi All, Please share SQL to return only employee person… -
Absence Management | Hours Worked Year to DateContent Hi all, I have a request to create a report that shows hours worked year to date. Is there a specific subject area that I should be referencing? We do have the A… -
How to bring different type of manager in analysisSummary To display matrix manager and functional manager in analysisContent In fusion system, as per business requirement, there are two types of manager type, one is Li…User_2025-01-29-18-45-19-617 75 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle -
Duplicate lines in OSHA 300 when an employee transfers to a new job/positionSummary Duplicate lines in OSHA 300 when an employee transfers to a new job/positionContent We are working through some issues where an employee has two rows within the … -
Role permissions to BI reportsContent We want to give access to our HR manager to modify BI report or create an adhoc OTBI analysis for the recruitment and onboarding module. What permission can we g…
-
HCM Cloud Delivered Approval RulesContent Does anyone have a list of delivered approval rules and the workflow details on each rule? I am trying to understand what is delivered to help client determine w…
-
commonly used HCM tables in fusionContent Hi, Any body has commonly used HCM tables in fusion, Please let me know. Regards, Reddykrishna -
Add 45 day to Benefit Program Date in OTBI AnalysisSummary Add 45 days to Benefit Program Date in in OTBI Analysis filterContent Hello, I need to add a filter to the OTBI analysis. The filter should add 45 days to the Be…
-
NEW HIRE(FAST,PRESENT,FUTURE DATED EMPLOYEES) ANNOUNCEMENTSummary Developed BIP Report on ORACLE FUSION HCM we are getting data for current hire employees only, Unable to get future dated employeesContent Hi ALL, I have develop…
-
Is there a way to track which all analytics/Reports are run by users and via which device (Laptop VsContent Hi Everyone, Is there a way to track which all analytics/Reports are run by users and via which device (Laptop Vs Mobile phones) Please let me know if you have a…
-
Create a report that shows the actual date when the assignment status changed with the Action ReasonSummary Actual date and reason when an assignment status changesContent Hi All, I hope someone is able to help me with a SQL that I am trying to build. I have several re…User_2025-02-04-08-51-08-912 234 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
Dashboard prompts using sql querySummary Need to create dashboard prompts using sql query as the relevant subject areas for prompt data is not availableContent Hi Experts, I have a requirement to have p…
-
Why are some column headers clickable links in my OTBI report? What is the functionality of these liContent Hi, I would like to know why some of the column headers in my OTBI report are clickable links and others are not. I would also like to know the purpose of these …
-
Merged: We invite you to attend a ⭐️ LIVE ⭐️ webinar to get started with your Oracle Cloud Applicat…This discussion has been merged. -
Payroll Pay Affecting changes reportSummary Payroll Pay Affecting changes reportContent Hello, I am in process of creating the Payroll Pay affecting changes report and wanted to know if any one has come ac…
-
Denormalized view for workersContent Hello everyone! Do we have any inbuilt view in HCM which will provide a denormalized record per employee with basic fields like name, emplid, department, jobocde… -
Need help on Logical SQL with UnionContent Hi Experts, I am trying to identify the New Hire's/ Exits and TEC changes using Logical SQL. Both parts of the sql works , but when UNION is applied it breaks. A…
-
Can anyone give me Logical SQL with UNION ALL sample codeSummary Can anyone give me Logical SQL with UNION ALL sample codeContent Hi All, Can anyone give me Logical SQL with UNION ALL sample code Regards, Rashmi -
How to replace DATA_CACHE columns in 21B with XML_DATa_CACHESummary How to replace DATA_CACHE columns in 21B with XML_DATa_CACHEContent Hello, Can anyone help me replace DATA_CACHE columns in 21B with XML_DATa_CACHE, in BI report…
-
Viewing secured views for Oracle delivered reportsContent I am reviewing some of our delivered reports and am noticing what I believe to be an issue with our secured views. Specifically, I noticed that users can see the…
-
Report that pulls out the extract runSummary Do you have a report ready?Content Hello, I need to develop a report that pulls out the extract run in a specific date. Do you have something ready? Thanks Nicol…
-
Is there any possibility to create dynamic password protect for excel in Oracle HCM BI reports ?Summary Is there any possibility to create dynamic password protect for excel in Oracle HCM BI reports ?Content Hello Team, Is there any possibility to create dynamic pa… -
How to add bin as prompt?Summary How to add bin as dashboard prompt?Content We have created a column, Position Status, on a position management analysis based of a calculated measure we created,…
-
Need SQL Query or OTBI report to display OTL Calculated HoursContent Hi All, Pls share Subject area or SQL query to get the OTL calculated hours. For Ex: In a week employee entered 42 hours under Regular. When we click on NEXT but…
-
Unable to fetch OTL Data from "Workforce Management - Worker Compliance Results Real Time" SubjectSummary Unable to fetch OTL Data from "Workforce Management - Worker Compliance Results Real Time" Subject area.Content Hi , I am trying to fetch the data from "Workforc…
-
Create a ORC Report with Records having hyperlink to ORCSummary Hyperlink to candidate ProfileContent Hi All, I have a requirement where I need to create an ORC report with candidate data. This report should have a hyperlink …
-
Report of Assignments in a flowContent I was hoping to have a report of assignments within a flow so that we can use that as the basis to check whether people will be paid during the calculate payroll…
-
Convert OTBI Analysis into BIP ReportSummary Convert OTBI to BIPContent Hi All, As our population in HCM is fast-growing, we are noticing some of the disadvantages of OTBI, performance, # of input records ,…