Global HR
Discussion List
-
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 … -
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 2 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…
-
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
-
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.5K 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 22 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 12 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 21 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 12 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…User_2025-07-18-13-29-11-469 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 L 12 views 3 comments 0 points Most recent by Claudia Linares L 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 263 views 7 comments 5 points Most recent by MMS Reporting and Analytics for HCM -
In which table has the information of Manage Legal AuthoritiesSummary: SQL query or Table has the information of Manage Legal Authorities Content (please ensure you mask any confidential information): Version (include the version y…
-
Need query for Calculation card values to run result values in hcm fusionSummary: Need query for Calculation card values to run result values in hcm fusion Content (please ensure you mask any confidential information): Need query for Calculat…Kaustubh Deshmukh 16 views 1 comment 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM
-
OTBI missing journey tasksWhen creating an analysis to report on deferred journey tasks, I am not seeing ALL results. I am getting some, but there are definitely others that are seen in the UI, b…Jessica D 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Build a BI Publisher Report that tracks incremental changes in Core HRSummary Build a BI Publisher Report that tracks incremental changes in Core HRContent Hi Experts, I have a requirement for a BI Report wherein I need to pull a lot of ch…Aloka Bhattacharya 478 views 10 comments 1 point Most recent by Naresh Choudhary Reporting and Analytics for HCM
-
In which table has the information Manage Reporting EstablishmentsSummary: Hi Team, Need a table or sql query to get the information Manage Reporting Establishments as in below marked screenshot Content (please ensure you mask any conf…Opkey PA 13 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Department Set Name/CodeSummary: We have a requirement to include the Department name, Department Set name/code to a project details BIP report we are able to find what table holds the departme…Marie Joyce Wynona Marzan 17 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Employee/Person Addresses not visible in per_addresses_f tableSummary: We have loaded Employee/Person Home Addresses data using HCM HDL file and the load was successful. I can see the data in the table per_person_addr_usages_f but …Pankaj Pandey 18 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
SQL query to retrieve employee location country nameSummary: Content (please ensure you mask any confidential information): Hello experts, we need a query to retrieve the employee location country name but below it extrac…Valerio Curzi 251 views 1 comment 0 points Most recent by Vishnu Vardhan Raju Reporting and Analytics for HCM
-
organization seniority date on multiple contractsSummary: How can I report on the Org Seniority Date when person has more than 1 contract Content (please ensure you mask any confidential information): Hello Has anyone … -
In which table has the name format components storedSummary: Hi Team, We need a table where the name format components stored, Tasks: Manage Person Name Formats - HR_NAME_FORMATS I need the table for name format component…
-
How to Encrypt and Send BIP report output from oracle HCM cloudSummary: There is a need to Encrypt a BIP report output to 3rd party through SFTP. Please let us know the possibility and how to accomplish it ? Does BIP provide any def…