Data Models
Discussion List
-
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… -
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:… -
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 :… -
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… -
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 -
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…
-
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-272206 21 views 6 comments 0 points Most recent by Punam Roy Karmokar-272206 Human Resources -
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?
-
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… -
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… -
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…
-
Need Oracle Database table for "Time card Required" fieldsContent Hi I need Oracle Database table for "Time card Required" fields for BI report. The field is on Manage Payroll Relationship page. Version 21 b
-
HCM Extract - With Document of Records Delivery typeSummary HCM Extract - With Document of Records Delivery typeContent Hi Experts, I have a requirement to store the Report in Document of records, for that we have used HC…
-
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.
-
SQL to find the representatives of an active employee's assignment recordSummary SQL to find the representatives of an active employee's assignment recordContent Hi Experts, I am looking for the AoR report that fetches all the active employee…
-
Transaction ID column blankSummary Transaction ID column blankContent Hi, We have enabled ESS and employees are doing transactions. We are now having some issue with the ESS Transaction report (us… -
How can we read Person Number and set report parameter in a Report URL on Employment page(Person ManSummary How can we read Person Number and set report parameter in a Report URL on Employment page(Person Management)Content How can we read Person Number and set report …
-
Oracle HCM Cloud: HSDL for Seniority Date updatesContent Oracle HCM Cloud: HSDL for Seniority Date updates. We are trying to create an HSDL template for Seniority date updates but it seems there is a structural issue w…
-
PER_PERSON_ALLOCATED_TASKS_DFF SQL TypeContent Hello Guys, We would create a task to allow the employee to confirm their Hire Date. We used "Configurable Form" by configuring the DFF "PER_PERSON_ALLOCATED_TAS… -
Need SQL Query/ table names to get termination and reverse termination details of an employeeSummary Need SQL Query/ table names to get termination and reverse termination details of an employeeContent Hi All, What I need is to get termination and reverse termin… -
Need SQL Query/ table names to get Document Records attached to an employeeSummary Need SQL Query/ table names to get Document Records attached to an employeeContent Hi All, What I need is to get document records attached to an employee in fusi…
-
Show preferred nameSummary Can we show the preferred name "only" if existsContent We would like to apply the following condition when we show the names if the preferred name exists then sh… -
SourceSystemId - PersonLegislativeData - GenderContent Hi, When we tried to upload Worker HDL getting the below error message while uploading the HDL Message ErrorYou can't update this record because the SourceSystem…
-
Difference in Subject AreasContent hi What is the difference between the data in Subject Area: Human Capital Management - Approval Notification Archive Real Time and the Subject Area: Human Capita…