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
-
Calculation cards Federal Start date and End DateContent Hi All, In which table/column holds the Federal Start Date and End date values. Thanks, Visu -
Effective Date Issue?Content Hi Experts, I've built an analysis in OTBI to extract Work Schedules doe Employees. Even though my report has the P_DATE effective date SQL prompt, it is bringin… -
Revoking User Access to the Shipped OTBI Content in Fusion HCM 19CSummary This white paper documents the steps to revoke access to the seeded OTBI content for all users in 19C.Content In 19C, OTBI introduced a new set of BI reporting r… -
Current and Previous Employment detailsSummary I need BI report to fetch Current and previous employment details.Content Hi Team, I need a BI report (Not OTBI) to fetch current and previous employment details… -
Requisition Filled Date and Time to fill on ORC reportContent I am looking for a way to pull in the requisition filled date into a filled requisition report for ORC. I cannot find that field in the subject areas. In additio…
-
Combining Multiple Question RowsContent I have an ORC report that is pulling our filled reqs and the candidates' information that have been hired into those reqs. We want to see on the report their ans…
-
Manager Detail ReportSummary My report doesn't show changes of managerContent Hi, Please see attached XML file. I have copied the output of an old report (I don't have the sql or xml for the…User_2025-02-05-22-44-35-842 56 views 4 comments 1 point Most recent by User_2025-02-05-22-44-35-842
-
HCM Cloud Dashboards for Salary and TurnoverSummary I am looking for HR dashboards for Headcount, Salary, Absence and TurnoverContent I am looking for HR dashboards for Headcount, Salary, Absence and Turnover. I d…
-
Absence Report with Between DatesSummary Report not workingContent Hi, I have attached the XML for this absence report, can anyone work out why it won't run? I've tried different combinations in the cri…User_2025-02-05-22-44-35-842 31 views 10 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
Getting month and year into one column while maintaining date date type - EVALUATE NQSCOnfig.INI errSummary Getting month and year into one column while maintaining date date type EVALUATE NQSCOnfig.INI errorContent Hi - We are trying to graph an analysis that would sh…
-
Dependent Change Audit ReportSummary Need to create a report showing dependent option changesContent Hi...I am trying to find out how to create a report/analysis that will show me any employees whos…
-
Achive 'My Folders'Summary Archive from Production to Development environmentContent Hi, Yesterday I lost all of my work that was stored in My Folders in the production 'Live' environment …User_2025-02-05-22-44-35-842 19 views 7 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
BI report or OTBI report to list out ALL Pending vacation requests for a managerSummary BI report or OTBI report to list out ALL Pending vacation requests for a managerContent Hi Experts, My manager would like to know if there’s a way to view all th…
-
Termination date for Rehire employeesSummary Termination date for Rehire employeesContent How to display termination date for rehire employees in OTBI report. We want only the latest assignment record to be…
-
Reporting SecuritySummary Non report user access to DashboardsContent I have created a number of different dashboards. We have some employees in the business who are not managers but need…
-
Security Report In OTBISummary We need to Create Security Report in OTBI with details of Roles assigned Date and also the previous role which was deleted.Content Need to Create OTBI reports fo…
-
How to schedule a BI Publisher Report on a particular Day Every hourlySummary How to schedule a BI Publisher Report on a particular Day Every hourlyContent Hi All, We have a requirement to schedule a Bi publisher report every Tuesday and e…
-
2019 Leavers with salarySummary OTBI report needed showing 2019 leavers & salariesContent Hi, I have been looking through the shared reports centre and previous posts and haven't really found a…
-
Work MissingSummary My Folders is emptyContent Hi, I've had issues logging into OTBI over the last hour, eventually after clearing my caches, browsing history etc and a reboot of th…User_2025-02-05-22-44-35-842 20 views 5 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
Graph to show current monthContent Hi I have attached a very simple graph but I would like it only to display the current months data . I am having difficulties achieving this. Regards MelissaUser_2025-02-06-11-18-47-896 23 views 2 comments 1 point Most recent by User_2025-02-06-11-18-47-896
-
Termination Reason ActionContent Hi Guys, I have to extract the information about the termination reason. I used this field in my report: "Workforce Management - Worker Assignment Event Real Tim… -
Previous Termination Date and Assignment NumberSummary Previous Termination Date and Assignment NumberContent Hi Guys, Its my first time in here. Just want to know if there's a way to get the previous assignment numb…User_2025-02-05-11-53-59-507 40 views 8 comments 0 points Most recent by User_2025-02-05-11-53-59-507
-
Need Help with Date Sorting on Advanced XML ReportSummary Date Sorting on Graph not working properlyContent Hi Experts, I tried reusing an Assignment Change in last 1 year report from the repository over here. The entir… -
How to extract Cost Center with OTBISummary How to extract Cost Center with OTBIContent Hi, We would like to export the cost center structure and corresponding values in OTBI. We are using the functionalit… -
Changing the Default value in a column selectorSummary Have Column Selector, want to duplicate and change the orderContent Hello, I'm trying to use the Column selector view and am looking for a way to either set or c… -
How can I find out winch report we created and have at HCM & is which are active?Summary I need to have a list of all our reports in HCM BIP (and/or)OTBIContent Hello How can I find out winch report we created and have at HCM & is which are active? I… -
Report on appraisal status and tasksSummary I need a report with the specs as stated below in the content. Can anybody see what I am doing wrong here?Content Fields needed: * - Performance document name * … -
Analysis showing 2 Record for manager update for employees.Summary How can we remove duplicate record for line manager change.Content HI, I have created the analysis in the subject area "Workforce Management - Worker Assignment … -
Termination Date Using Column ReferenceSummary Get a greater than term date if business unit = thisContent UPDATE: I have attached a copy of the XML of the original report. My goal is to only bring back termi… -
How do i fetch blank vales for mobile phone number in a OTBI reportSummary How do i fetch blank vales for mobile phone number in a OTBI reportContent Hi, I have a slightly different issue. I am trying to fetch the home mobile number for…