Data Models
Discussion List
-
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…
-
SQL to get Checklist Status for EmployeesSummary: SQL to get Checklist Status for Employees Content (required): If we have a requirement to get Checklist status for Employees, below SQL can be leveraged. Versio… -
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 241 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 81 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… -
Incumbent on positionSummary: I cannot see the Incumbent Position Entry Date, Position Exit Date, Status, Type information in any columns in the hr_all_positions_f and hr_all_positions_f_tl … -
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 11 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 61 views 6 comments 0 points Most recent by Rambabu Laveti-Oracle Human Capital Management
-
Can we rename notification button.Summary: Hi Expert. Good day! Just wanted to know can we rename the "Reject button" Example - for inida Legal entity it should (Revoke) and for US legal entity it should…
-
which table has VISA Comments and Notes?i need to create a BIP report including Visa information. But i can't find the right table for VISA Comments and Notes. Does anyone know about it please?
-
Mass Update ChangesSummary: Content (please ensure you mask any confidential information): Hi everyone, We are configuring the actions and fields relating to the Mass Update action made av…
-
In which table is the Document of Record attachments stored?Summary: In which table is the Document of Record attachments stored? Content (please ensure you mask any confidential information): In which table is the Document of Re…
-