Data Models
Discussion List
-
Enabling Seniority Dates Audit - Performance Impact/ConsiderationsSummary: We received a use case to enable Seniority Dates audit via business objects for Global Human Resources. We are in need to identify if by enabling this object/au… -
Can we segregate Document Records with Remove Person Information ToolSummary: Can the 'Remove Person Information Tool' segregate specific document records? Content (please ensure you mask any confidential information): We have a client wh…Ivy__Valverde 34 views 3 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management -
How to get Approver Information for completed and In Progress transactionsSteps Followed 1)Initiated Transfer Process from Manager login for an employee(My teams>>My teams>>Transfer) 2)Login as Approver1 and Approved the workflow notification …Rama Krishna Annam 22 views 7 comments 0 points Most recent by Parag Hiremath Human Capital Management
-
OTBI Transaction Analysis Real Time to BIP ReportSummary: Hi all, I'm trying to create a BIP report with all history transactions. I see that in OTBI Analyis there is a field "Process Category" that I can't find in the…teresa.marciano 13 views 4 comments 0 points Most recent by Vikash K-Oracle Human Capital Management
-
Can we display transaction ID in the approval emailsSummary: Can we display transaction ID in the approval emails. If a DOR is submitted, approvers will get email or notification with task number. How can we display trans…
-
Customizations done on AssignmentResignationReport is not showing on Resignation notificationsSummary: Customizations done on AssignmentResignationReport is not showing on Resignation notifications Content (please ensure you mask any confidential information): I … -
How to get the source of user login(Mobile/Browser)Summary: We are looking for improving the Application usage by all staff and hence wanted to track the login frequency and source of login ( Mobile/Browser). We are able…Pavan Kumar Thummalapalli 74 views 1 comment 0 points Most recent by MandeepGupta Human Capital Management -
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 102 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 631 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 …DebayanB-147509 42 views 2 comments 0 points Most recent by DebayanB-147509 Human Capital Management
-
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 31 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 22 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 448 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… -
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