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
-
Showing Attachments on Notification Worklist for "Request New Position" & "Request Position Change"Hello Community, I'm working with Oracle Cloud HCM and have a question regarding the visibility of attachments on approval notifications in the worklist. My Goal: I want… -
Need to update the absence Entry before holiday and after holidaySummary: Hi Everyone , We have requirement where we have to update absence entry for employees who is in long term absence. Below is requirement:- First Step: Check for … -
SQL query for Planned Schedules on Time ManagementHello! I need help in developing an SQL query for generating the Planned Schedules for employees on the Time Management navigation: My Client Groups>Time Management> Pla…
-
What is impact of Enabling Extensive Flexfields in Oracle Fusion Analytics(fusion data intelligence)Hi , What is impact of Enabling Extensive Flexfields in Oracle Fusion Analytics fusion data intelligence, from following point of view. Data Replication time Performance…
-
do we have any process for Area of Responsibility ?Summary: when we change the employee status from Active to Inactive under Area of Responsibility (RUI/Redwood )section , the employee access is still Active. But as we c…
-
HCM Alert Employment DFFHi Gurus, We have a termination Alert Configured using HCM Alerts where we send notification to all HRBPs for employee who got terminated one day prior. The alert is wor…
-
Few Absence records missing for an Employee in OTBISummary: Some of the scheduled absences are not showing up in the report. We cannot find June absence record but can see August absence record for the same person. Ran t… -
Repeat section in RTF and add total on each pageI have the following two tables in an RTF document: The first table displays data from the DM Header. The second table displays data from the DM Lines. The client has re…
-
How to create report on employee project manager ?Summary: Hello, For our Blue Collar Population we are using the role of Project manager in addition to the Line Manager. Our issue is that we don't find the subject area…
-
Service Account not able to report on FeedbackSummary: We have a service account that we use for reporting purposes in OTBI. Typically, this account is able to pull accurate data across all Business Units. We discov… -
How to generate the BIP report with the user time zone rather than the server time zone?Summary: Our reports are generated in UTC time zone, especially when it comes to Exit reports the LWD & the submitted dates are not matching because of time zone differe… -
How to fetch current incumbent name for a Position_code/position idSummary: Please Help! Please share your insights ASAP! I need help in fetching current incumbent name tagged to a position code. I wrote the query like this : SELECT DIS…
-
Report on Benefits Self-Service Enrollment actionsSummary: Looking for a way to report whether employees went through the Benefits Self-Service enrollment process thoroughly. For example, did an employee click on Enroll…
-
Dependents not displaying on reportSummary: I had a detailed Benefits Enrollment report that had the employee's information and dependent information displaying on the same report. I started with Benefits…
-
how can i fetch in bip report parent position name and parent position code for a position codePlease Help Me! Need to write a sql query for all the position details, in which i need to fetch parent position name and parent position code, how can i fetch that in b…
-
OTBI dashboards using 2 fields prompts based on oneSummary: Dashboard with two prompts fields based on one field, and currency prompt Content (please ensure you mask any confidential information): I'm creating a dashboar…
-
While loading worker dat file, getting error the error for PersonLegislativeDataSummary: While loading the worker dat file getting the below error for PersonLegislativeData component You can't update this record because the SourceSystemId {SRC_SYSTE…
-
Need SQL query to get Set General PreferencesSummary: We need a query for the setup Set General Preferences as shown in the UI. We are unable to get Date format, Time format and Time zone as shown in UI page. For e…
-
Reporting employee access to dataHello Experts, It was rise as a demand the possibility to have a report on what employee has access of country data, i was trying to use per_person_secured_list_v and pe… -
Is there a report that will show all data roles and their security policies?Summary: Hello - Our organization has 3 Document Type Security Profiles created that are spread across many roles. Instead of manually trying to find which data role has…
-
Need sql for all Content including Catalog Item the Content is tied to from Learning moduleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to fetch a BIP based extract to source Approver1, Approver2 details based on Transaction SummaryThe management has requested for Approver1 and Approver2 details for all the transactions for Process name "Approve Job Requisition" within Oracle fusion. We could not f…
-
Trace the processing details of scheduled BIP ReportSummary: Trace the processing details of scheduled BIP Report Content (please ensure you mask any confidential information): Hi Team, Greetings! What are the best option… -
HCM Quick Link Usage StatisticsSummary: Looking for statistics for individual pages access by role, user, etc… for a specific timeframe Content (please ensure you mask any confidential information): A…
-
How do I convert the field Time.Month from CCYY / MM to just show the month?Summary: The Time.Year fields just displays the year The Time.DayofMonth fields just displays the day The Time.Month field displays the year and month. I need the Time.M…
-
Segregating the success and error report to different email id through SOAP UI Request PayloadSummary: I did a POC , using the SOAP UI Payload request i'm able to get the email notification to multiple emails. but the expectation was like for success report we wi…
-
Change to absence start or end date - event level reportingSummary: We have a requirement to report on changes to absence start and end dates i.e. when someone edits an existing absence. The OTBI Subject Areas are all Real Time …
-
Is there any way to calculate day difference excluding weekends for Term date - Action date?Hi, We have a requirement to pull late/retro termination counts. The logic is if Action date - Actual Term date > 1 then it is marked as Late term. Is there any way to e…
-
Unable to Find "Placement Match Date" Field in OTBI - Workforce Management: Absence Real TimeWe're encountering an issue in Oracle Fusion HCM when reporting on Adoption Leave (Event Type: Placement) using the Workforce Management - Absence Real Time subject area…
-
OTBI - Job Application direct URL in OTBIHi Team How to get the candidate's job application URL in OTBI?