Data Models
Discussion List
-
In Blanket Agreement, how to get name of level one approver in partial approved stateIn oracle fusion we have implemented two level of approval for blanket agreements. When the level one approver has approved the agreement and it is pending for approval … -
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 111 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… -
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 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 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 581 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 … -
Email Bursting not workingI have the below Email bursting definition configured. The Schedule job completes successfully, however I never actually receive an email from it, even though there was …KDR 1.1K views 6 comments 0 points Most recent by Sreekanth Chennabathini BI Publisher Learning Center
-
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 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… -
How to add column in a seeded BI report with existing package, ESS jobs, before/after event triggerHi, I am trying to add two columns in a "Payables Payment Register" seeded report but i am getting errors like and I would need to add column "PAYMENT_INSTRUCTION_ID"fro…
-
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…
-
How to read AUDIT_CHANGE_BIT_MAP_Hello Guys I am in need to read data from tabel: FND_VS_VALUES_B_ Because i need to understand which field has been changed in the Value set I've activated the audit and…Pedro Teixeira 173 views 0 comments 2 points Most recent by Pedro Teixeira BI Publisher Learning Center -
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…