Data Models
Discussion List
-
How to avoid Line Manager seeing personal and family contact names in ReportsSummary: How to avoid Line Manager seeing personal and family contact names in Reports Content (required): How to avoid Line Manager seeing personal and family contact n… -
Deeplink document of recordsHello everyone, I would need to create a deeplink to an employee's document of records page. I found this deeplink, https://hdeh-dev1.fa.em3.oraclecloud.com/fscmUI/faces…User_2025-02-07-06-30-13-200 31 views 3 comments 1 point Most recent by User_2025-02-07-06-30-13-200 Human Capital Management -
SQl query for fetching data to enter GL Cost Center details at department level using HDLContent (required): Hi everyone I need help to define the SQL query in a data model to fetch the information for the following Metadata-line to be used in HDL:…Daniel Lundsteen Minke 3K views 1 comment 0 points Most recent by MandeepGupta Human Capital Management -
RestAPI for organization treeSummary: I need to extract organization tree using RestAPI but I cannot find the information other than a list of items /hcmRestApi/resources/11.13.18.05/organizations :…Charline 11 views 4 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Human Capital Management -
Mass Assignments Update Using HDLSummary Mass Assignments Update Using HDL for Location, Departments etcContent Hi Please find the attached Queries which extract the current assignment records and chang…Mansur Khalil 183 views 10 comments 7 points Most recent by Shanna Oppenheim Human Capital Management -
HDL for Terminate and Re-HireSummary We have a requirement to Terminate & Re-Hire An Existing EmployeeContent We have a requirement to Terminate & Re-Hire An Existing Employee with All The Details E… -
Education Column/Field in Oracle Fusion HCMContent Dear All, We want for our reporting purpose the column Higher Education from HCM Regards, Shaikh Azaz Version OBIEE 12c -
LTRIM Function in eText templateSummary LTRIM Function in eText templateContent Hi Experts Select LTRIM('0012345', '0') from dual; is working as expected and result '12345' in BI Publisher Data Model. … -
Element Entries DetailsContent Hi I would like to fetch below highlighted columns in BIP report , any idea which table column hold this data? Navigation :Person Management > search for person …
-
Same report template for multiple workflow notificationsContent Hi - is it possible to use a common report template for multiple workflows ? Currently, the "Promote" process uses the "PromotionReport" template and the "Admini…
-
HDL Questionnaires with Conditional Questions failsContent Hi all, I have been loading questions with HDL to Fusion which in the main works but fails when I have conditional questions and answers. The Oracle documentatio… -
21B Data Model Update Causing IssuesSummary 21B Data Model Update Causing IssuesContent Hello Everyone, After installing update 21B we noticed that our workflow notifications that are based upon the Employ…
-
How to update the Contact Relationship of an Employee if it was stored 'wrongly' the first time?Content During our contact upload, the source system had wrongly identified few relationships as 'Others' when it should have been 'Domestic Partner'. Now we found this …
-
SQL to fetch Manage employment Contract detailsContent Hi All, Could you please provide SQL for Manage employment Contract details section EFF columns. I searched in per_assignment_extra_info_m, it does not have all …Punam Roy Karmokar 40 views 6 comments 0 points Most recent by Punam Roy Karmokar Human Capital Management -
HCM Extract: How to generate custom file extension like file_name.xyz?Summary HCM Extract: How to generate custom file extension like file_name.xyz?Content hi All, I need to generate output from HCM extract with custom file extension. Curr…
-
Procedure Element in HCM ExtractContent Can anyone explain what is a Procedure element and where I can see the list of PROCEDURE ELEMENT? And any white paper introduces how PROCEDURE ELEMENT works? Ver…
-
Identifying appropriate user entity to use for HCM extractSummary Looking for guidance regarding identifying the appropriate user entity to use for a HCM extractContent Hi Looking for guidance regarding identifying the appropri…
-
how to report what vacation rules have been defined?Summary how to report what vacation rules have been defined?Content Is there an analysis or a query that can be used in a data model? Version 19C
-
Do we have any delivered/custom reports which fetches all the contact information of all the EmployeContent If so,could you please let me know the name or share the underlying SQL for any custom reports you have written?Tanmay Pillai 26 views 3 comments 1 point Most recent by Julian Challenger-Oracle Human Capital Management
-
Historical Data Migration - EmployeesSummary Best approach for historical data migrationContent Hi All - My client wants to migrate 15 years of historical data into HCM cloud. They are current on Peoplesoft…User_2025-01-22-19-45-53-158 325 views 13 comments 1 point Most recent by Ashish Mangal Human Capital Management
-
SQL to fetch only the future dated employment changes includes salary changes, Work data changes, TSummary SQL to fetch only the future dated employment changes includes salary changes, Work data changes, Terminations from the system run date.Content Hi Team, I am loo… -
Need HDL to load results of a BI report regularlyContent Hi, Is it possible to schedule an HDL ran regularly, wherein the file it processes is the output of a BIP report that is sent over to webcenter? I have seen this…
-
How can i delete the uploaded Contact data uploaded into Production environment twice by mistake?Content Hello While loading the contact information,I found few errors and then while correcting them I uploaded the another file which had a different SourceSystemId. N…
-
Document of records delivery channel in HCM Extract is not working.Summary Document of records delivery channel in HCM Extract is not working.Content I have created a HCM extract with document of records as delivery channel and when I r…Vamsi KM 26 views 1 comment 1 point Most recent by Raj Ventrapragada-Oracle Human Capital Management
-
Need table name which store the fields : Threading Database item, Root Data Group and Threading ActiSummary Need table name which store the fields : Threading Database item, Root Data Group and Threading Action.Content Need table name which store the fields : Threading…
-
Forgot contract in worker hdl fileContent hello! I have uploaded 4 workers but forgot their contract info. According to the docs: You supply the Contract component of the Worker object when creating work…
-
DFF for Employee ListContent Hello All, Can anyone advice on creating a DFF field in assignment screen which includes list of all employees ? Regards, Veena.
-
CSV Extension File from HCM extractSummary CSV OutputContent Team, Could someone please let me know if we can generate CSV from HCM extract using XSL template ? I did refer one document from Oracle CoE bu…