Data Models
Discussion List
-
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 30 views 6 comments 0 points Most recent by Punam Roy Karmokar Human Capital Management -
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 315 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… -
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
-
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 …Rakesh Kumar-189257 25 views 2 comments 0 points Most recent by Nivya Mathire Human Capital Management
-
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 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…Dhanuka Chamal 2.3K views 4 comments 2 points Most recent by Dhanuka Chamal Human Capital Management -
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…User_2025-01-28-07-47-26-775 202 views 12 comments 1 point Most recent by Chris Borsh-Oracle Human Capital Management
-
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…Kiran Kancherla 153 views 2 comments 0 points Most recent by Yaswanth_Pappu-Oracle Human Capital Management
-
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…
-
Connect comment to specific assignmentContent Hello, Can you advise me how to do the connection between specific assignment and comments ? For example, when creating an Internal Move in the UI, the user is e…
-
Rehire Recommendation queryContent I was trying to search if there is a way for me to query the Rehire Recommendation field or if there is already a query made for this. Person Management>Select P…User_2025-02-05-16-39-03-485 73 views 3 comments 0 points Most recent by Sricharan Monigari Human Capital Management
-
Update BIP Business Process NotificationsContent Hello, I'm currently working on customizing some of the BIP workflow notifications. I've followed the below links on how to update them (also waited over 24 hour…User_2025-01-31-00-25-12-234 44 views 5 comments 0 points Most recent by SantoshKumarBhairi Human Capital Management
-
Workforce Modeling reports/AnalyticsContent Hi Everyone There is any standard reports or analytic for hcm workforce modeling? Thanks for the answer Version 20DLuis Fernando Lat 47 views 3 comments 3 points Most recent by Luis Fernando Lat Human Capital Management
-
Depreciated BIP Columns for HCM - 21 A UpdateSummary Depreciated BIP Columns for HCM - 21 A UpdateContent Do we have the list of depreciated table columns for 21 A. Thank you, Vijay -
LDG for LEContent Hi Could you please let give me table/sql for getting the LDG detals for Legal Entity ?, we are creating BIP report to display the details. Thanks
-
Close the access to BI Report PageSummary Close the access to BI Report PageContent Hi Team , How to close access to reports and analytics page for employees . In front end i have closed that option but …
-
Reporting on Sexual OrientationSummary Where can I find the Sexual Orientation attribute in OTBI?Content Hello I have created a basic diversity data report in OTBI, obtaining fields for Religion, Ethn…
-
HDL for Person DisabilitySummary Which attribute is connected to the field 'self declared disability'?Content Hello I'm trying to load Disability data using HDL. In particular we want to use the…
-
HDL Load fails with the error when trying to load work state on a worker recordContent Hi, I am getting an error when trying to correct a work state for the worker. The error says, ****_ATTRIBUTE1 is not a valid attribute. What attribute/field can …User_2025-01-30-21-52-52-008 29 views 6 comments 0 points Most recent by User_2025-01-30-21-52-52-008 Human Capital Management
-
Checklist Task Report for Electronic Signature tasks & Attaching completed tasks to Person's DocumeSummary Seeking a data model and report layout (xdm & xdo) to leverage the report path & enhanced electronic signature task type in Checklist tasksContent Hi community! …