Global HR
Discussion List
-
Query to retrieve Union fieldSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query to retrieve the employee Union name as in the attached …Valerio Curzi 10 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need SQL to extract Individual Compensation entries prior to approvalSummary: Need SQL to extract Individual Compensation entry values prior to Approval Content (please ensure you mask any confidential information): We need to report on I…SRIROU 35 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need to fetch the Content ID of HCM ExtractSummary: We have requirement to fetch the Content ID of HCM Extract through BI report. Any one have idea how we can fetch Content Id. Content (please ensure you mask any…Alpesh Sanghvi 2 views 0 comments 0 points Started by Alpesh Sanghvi Reporting and Analytics for HCM
-
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…megan.obiedzinski 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Workforce Management - Person Real Time.Person Legislative Information Education Level doesn't showHi We have OTBI report which doesn't show Education data. We use Person Real Time.Person Legislative Information subject area. In application user can see the data. What…Ilmars K. 29 views 6 comments 0 points Most recent by Pranav Kakaraparthy Reporting and Analytics for HCM
-
How to embed Dashboard to My Team Page tab?Summary: Content (required): Could you please advise where I can find the instruction on how to embed an OTBI dashboard into My Team as a new tab? Thank you! Version (in…Evgeniya Repnina 185 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Oracle FDI: Predictive Analytics for attritionsSummary: In FAW/FDI , any examples for predictive analytics for exit risk using HR Core subject areas? We see diversity analysis in demos but there is no catalog exists …
-
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…
-
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…Shwetha_01 7 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to disable the download option of Increment Letter posted in DORSummary: We have requirement to post the Increment letter from custom BIP via extract to post in the DOR of employee. However we would like to have the option of downloa…
-
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…
-
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…LucieWS 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What is the specific report template to which 'Edit Work Relationship' transaction points ?Could someone please confirm which seeded report template and data model (DM) are being automatically utilized for the 'Edit Work Relationship' transaction? There are tw…Aseem Bhawalkar 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
HCM Extract Parameter LOV values are blank and the parameter is made out of Value setsSummary: I am working on HCM to WACS OOTB. HCM Extract Parameter LOV values are blank and the parameter is made out of Value sets . Value sets are configured properly. P…Rajajeyakumar 18 views 4 comments 0 points Most recent by User_CJJ9F Reporting and Analytics for HCM
-
Redwood Workflow NotificationsWe have custom workflow notifications currently still in the Classic UI. We are in the process of migrating all modules to Redwood. Please help us transfer the custom wo…Swetha J Nair 10 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
SQL Query to get HRBP assigned to an employee (when AOR uses organization hierarchy)Summary: We need a query to find HRBP assigned to an employee when Organization hierarchy has been used to assign the AOR(area of responsibility). It doesn't include any…Aloka Bhattacharya 1.3K views 6 comments 1 point Most recent by User_6I7ZA Reporting and Analytics for HCM -
Query to find the representative of an employeeSummary Query to find the representative of an employee through AORContent Hi Experts, Is there any generic query available to get the representative of an employee thro…Charan Kollipara 1.6K views 4 comments 0 points Most recent by User_6I7ZA Reporting and Analytics for HCM
-
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…Lucas B Maciel 19 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
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…Gali Sujana 18 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
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…Opkey PA 24 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
N/ASummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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…
-
Oracle HCM BI Table to retrieve employees Eligible for eligibility profileHi team, the client ask for creating a report to track Eligibility Profiles and Employees eligible for them. Is it possible to create a report like this "dynamically", s… -
which table having the United States Job Information under the Manage Job setupSummary: Hi Team, We could not find the right table for "United States Job Information under" the "Manage Job setup" We have gone through multiple table but we are unabl…Opkey PA 17 views 1 comment 0 points Most recent by Martina Iovino-Oracle Reporting and Analytics for HCM
-
How to fetch the document names of the attachments on a Journey Checklist taskSummary: I need to fetch the names of the attached documents on a checklist task, onto my OTBI analysis. Content (required): I need to fetch the names of the attached do…Shruti Krishnan 55 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
In which table having the Workday informationSummary: Hi, We need a table to get workday information. For the setup: Manage Department have the workday information and we could not find the right table. Attached sc…
-
How to get the last assignment if the worker have several records in a Analysis and Report (Goals)How to get the last assignment if the worker has several records in an Analysis and Report (Goals). We need to get the last assignment considering their last assignment …Claudia Linares 11 views 3 comments 0 points Most recent by Claudia Linares Reporting and Analytics for HCM -
Trying to get BIP report to burst and consolidate on emailSummary: I am having trouble getting my BIP report to burst and consolidate delivery by email, even though the Enable Consolidate Output box is checked. I have been doin…
-
BI Tables storing legal employer addressSummary: Content (please ensure you mask any confidential information): Hello experts, do you know in which Oracle HCM table the legal employer address is stored? Thanks…Valerio Curzi 21 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
OTBI Workforce Trend: For better performance, use equi-filter on Calendar Month End Date columnSummary: This is an announcement to provide guidance to improve response time of Workforce Trend reports and dashboards. Content (required): 1- Response time of reports …Abhishek Dixit-Oracle 269 views 7 comments 5 points Most recent by MMS Reporting and Analytics for HCM