Data Models
Discussion List
-
Error when loading HDL for WorkerHello experts, An employee is still appearing as the incumbent of the Position even this employee have already a different position. We discovered that the reason of thi…Maria Cristina L. San Jose 105 views 3 comments 0 points Most recent by Marius Voicu-Oracle HCM Data Loader (HDL) -
The values 20 aren't valid for the attribute PersonId.Hi I am getting the following error when trying to assigned the JOB roles for existing employees using the HCM Spreadsheet template: The values 20 aren't valid for the a…
-
Please help share SQL to extract all oracle fusion hcm setup configuration with data.Hello All, We want to have a download of Config Workbook from the POD,but Configuration Package and Implementation Project setup isnt working as expected. Please help sh… -
V3 Seniority Date HDL file for manually adjusted datesHi Experts, We ran "Seniority Dates V3 - Remove Seniority Dates Transaction Data" Diagnostic process to removes seniority date for the certain configured rules. While ru…Yuvraj S-Oracle 698 views 6 comments 0 points Most recent by Shant_Sarkissian_WJG Human Capital Management
-
Sql query to extract list of all HSDL spreadsheets along with parametersSummary: Hi Team, We are looking for a sql query / table name / any other way, to extract a list of all the HSDLs that we have in our pods (irrespective of whether they …
-
how to fetch primary key of each table in fusion hcm??Summary: Hello all, how to fetch primary key of each table in fusion hcm??Chandra Kiran Ushakoela 32 views 1 comment 0 points Most recent by Parag Hiremath Human Capital Management
-
Need table name which stores HCM Extract Report CategoriesSummary: Need table name which stores HCM Extract Report Categories Content (please ensure you mask any confidential information): Version (include the version you are u…
-
Position Cost Center Mismatch validation errorSummary: When we try to update the position we get Cost center mismatch error but historically it allowed the mismatch to bypass. Hence wanted to check when was the vali…
-
an inactive employee is visible from front end but no present in Secured views?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Create an employee using rest apiDear All, I am attempting to create an employee using the following REST API: /hcmRestApi/resources/11.13.18.05/workers. Here is the request body: { "DateOfBirth": "2023…
-
Create a job using rest apiDear All, is there a rest api to create a job? Waiting for your response, it's urgent, Thank you,
-
Notification for legal entity creationSummary: Content (please ensure you mask any confidential information): Hi everyone, we are configuring the notifications that must be sent to users who have carried out…Gerardo Peluso 21 views 6 comments 1 point Most recent by Sailaja Duggirala Human Capital Management
-
Absence Qualified Entitlement SQL QuerySummary: Hi All , I need SQL Query to fetch Qualified Entitlement Plan Details for the employees .The following is the navigation given: Absence > Absence Records > Plan…Padamatinti Varsha 455 views 2 comments 0 points Most recent by Padamatinti Varsha Human Capital Management
-
Recruiting candidate Process issueSummary: last year one candidate applied for job and did not get selected. Now he's trying to reapply, but system is not allowing. how to fix this issue Content (please …
-
I need to change the Legal entity name and Business Unit name as effective-start date as 01/11/2023.I need to change the Legal entity name and Business Unit name as effective-start date as 01/11/2023, but I need to know the impact of changing these at all modules in HC…
-
How to change specific Section in a Redwood Theme?Summary: Hi everyone, we are trying to change the theme of a specific section (Directory-My Organization Chart- in ME Tab) to a Redwood theme without changing the system…Marlon Castillo Maliglig 83 views 3 comments 1 point Most recent by Derek Dreyfus Human Capital Management
-
How to update Disciplinary incident status in UI?Summary: How to update Disciplinary incident status in UI? I have checked this data is storing on PER_PEOPLE_EXTRA_INFO_F table Content (please ensure you mask any confi…
-
Is it possible to trigger an alert as soon as employee submits resignation?Summary: Is it possible to trigger an alert as soon as employee submits resignation and before resignation is approved? Content (please ensure you mask any confidential … -
Unable to get data for Secured views pay_payroll_secured_list_vSummary: When the user is trying to run the report not getting the data as secured view used in the report. Content (please ensure you mask any confidential information)…
-
If we load pending workers through HDL, will the onboarding will trigger automatically?Summary: If we load pending workers through HDL, will the onboarding trigger automatically? Content (please ensure you mask any confidential information): Version (inclu…
-
SQL to get current Oracle ReleaseSummary: We're looking for the database table (or even a complete query if anyone has it) to retrieve the current version of the environment. Basically we need it to che… -
How can I optimize/simplify my KPI formula in order to reduce the time of the report to load?Summary: It takes 13mins to load my report using the formula since I have to add 2 values on my KPI formula before getting the percentage. Is there a way to optimize my …John Patrick Diaz 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dynamically parameterized OTBI for journeysSummary: Content (please ensure you mask any confidential information): Hello everyone, We have created an OTBI report on the subject area "Workforce Management - Checkl…
-
Is it possible to use different BI templates for different Legal Employers in one report?Summary: Is it possible to use different BI templates for different Legal Employers in one report? Content (please ensure you mask any confidential information): Is it p… -
The custom dashboard in the UI of the DEV environment is redirecting to the PROD dashboard.Summary: When I try to open the custom dashboard located in My Client Groups in Dev it is redirecting in Prod Custom Dashboard Content (please ensure you mask any confid…
-
SQL query for absenceSummary: Hi, I have to create a query with 2 types of abcence. The data model is ready but i have to show each absence day in the seperate row,example: E123123 2023-10-2…
-
Data Removal - How to treat records with Work Relationships in multiple countriesSummary: Hi all So we have been configuring a process to remove data with the Person Removal Tool. This works amazing for those who have one or more Work Relationships w…
-
Document of Records Letter Generation Does Not Have Proper Values or Has No DataSummary: The issue can be reproduced at will with the following steps: 1. Employee adds a document record by navigating to Me > Document Records 2. Select Document Type … -
How to add logo inside approval notifySummary: Content (please ensure you mask any confidential information): Hi everyone, We are customizing the approval notifications that reach a customer's employees to a…
-
We need a value set through which we can auto generate the incident numbers.Summary: We are looking to setup a value set through which we can auto generate incident numbers where incident number is a DFF on DOR. We are trying to create a Value s…Pravesh Jain 63 views 6 comments 0 points Most recent by Rambabu Laveti-Oracle Human Capital Management