Data Models
Discussion List
-
Person Security - Custom Criteria SQLSummary SQL Query to restrict the person data based on the division associated with an assignment department.Content Team, Here is an example of data. Department is asso…Mano Haran-61126 138 views 13 comments 0 points Most recent by User_2025-02-06-00-27-22-829 Human Capital Management -
DBI Bank Code is not picking up the data.Content Hello Everyone, I have created an extract where I have to pull out the Bank and payment details so I am using Personal_Payments UE. When I am pulling Bank Accoun…User_2025-01-25-06-20-12-259 46 views 2 comments 0 points Most recent by User_2025-01-30-20-47-14-770 Human Capital Management -
How to Import Geography structure and hierarchy for countries which is not listed with Nokia and LogSummary How to Import Geography structure and hierarchy for countries which is not listed with Nokia and LogateContent Hello Experts, I am looking to import geography st…sameer ashturkar 73 views 8 comments 1 point Most recent by User_2025-02-06-05-38-10-231 Human Capital Management
-
SQL query / tables for data security policies > business unit for data setContent Hi, I am looking for tables or an sql query to identify the business units that limit a data set through the data security policies. To clarify what I'm looking …
-
Print Org Chart in Excel - Removing ColumnsSummary Removing columns from the result when printing the spreadsheet in org chartContent Hello we would like to remove columns from the spreadsheet in the print mode i…User_2025-01-28-19-07-44-962 71 views 4 comments 1 point Most recent by Julian Challenger-Oracle Human Capital Management
-
SQL to extract all valid grades for all jobsSummary SQL to extract all valid grades for all jobsContent Hi All, I am looking for an SQL query to get all active job name and associated valid grade. I tried but coul…User_2025-01-31-15-30-09-194 1.4K views 5 comments 0 points Most recent by User_2025-01-31-15-30-09-194 Human Capital Management
-
Impact of turning on Position SychronizationSummary Impact of turning on Position SychronizationContent Hi Team, Does anyone can give us some pointers on the impact of turning on ‘Position Synchronization’ please?…Prosenjit Manna 53 views 6 comments 0 points Most recent by Prosenjit Manna Human Capital Management
-
Any way to query for *future* approvers in the approval chain?Content I know that we have the ability to query current and past approvers in an approval transaction (hrc_txn_data / fa_fusion_soainfra.WFTASK)... but is there any way…User_2025-01-22-18-30-18-571 148 views 1 comment 3 points Most recent by Tarun Mehra Human Capital Management
-
Meaning of assignment statusesSummary Meaning of assignment statusesContent Can someone explain meaning of each of the below assignment status or any doc would be helpful. Active - Payroll Eligible A…Vaibhav DL 131 views 2 comments 2 points Most recent by User_2025-10-31-01-06-01-706 Human Capital Management
-
Hire and Rehire in single DAT fileSummary Trying to do Hire and Rehire of employee in single dat fileContent Hi Everyone, I am trying to load hire record along with the rehire record in single dat file. …User_2025-02-04-22-04-57-073 72 views 2 comments 0 points Most recent by User_2025-02-04-22-04-57-073 Human Capital Management
-
Scheduled Processes ReportContent Hello, Is there a report or SQL to get the list of all "Scheduled" scheduled processes? Thank you! -
Data Loader for Manage Worker UnionsSummary New Data Loader Needed to Create Worker UnionsContent Good morning everyone, I would like to build a data loader for uploading worker unions into HCM. Does anyon…Daniel McMillian 37 views 2 comments 0 points Most recent by Daniel McMillian Human Capital Management
-
20A Upgrade - Enterprise Onboarding Checklist not attaching automatically and not triggered WelcomeSummary 20A Upgrade - Enterprise Onboarding Checklist not attaching automatically and not triggered Welcome emailContent Hai all, we had 20A upgrade last week and after … -
Do we have any document which will provide the information of subject area along with base table.Summary Do we have any document which will provide the information of subject area along with base table.Content Hi Expert, Do we have any document which will provide th…User_2025-02-05-01-04-36-989 33 views 4 comments 2 points Most recent by Prateek Parasar - GTUK, ACE Pro Human Capital Management
-
List of DFF created across the domainsSummary How can we see the DFF that have been created in fusionContent HI, Can we have report or query where we can get the list of Dff created in the system with the ex…Farooq Syed, CPA, PMP, CISA 50 views 1 comment 2 points Most recent by User605866-Oracle Human Capital Management -
PAY_PEOPLE_GROUPSummary Data is not available in PAY_PEOPLE_GROUP TableContent Hi, We have enabled people group flex field in oracle fusion HCM. We have enabled segment1 for a field shi…User_2025-02-06-14-29-32-866 560 views 4 comments 0 points Most recent by User_2025-02-06-14-29-32-866 Human Capital Management
-
how to fetch Bargaining Unit (Union Code) fom Fusion HCM TableSummary Bargaining Unit (Union Code)Content Hi , i want to display Bargaining Unit (Union Code), i have added BARGAINING_UNIT_CODE from Per_all_assignments_M but its not…
-
How to find the table name and OTBI subject area for any values using in functional partSummary How to find the table name and OTBI subject area for any values using in functional partContent Hi All, I want to find the Exact table name and subject area for …Umesh D 705 views 1 comment 1 point Most recent by Julian Challenger-Oracle Human Capital Management -
No results from BI analysis when using subject areaContent Hi, I am trying to run a simple subject area analysis using BI, the subject area I am using is "Workforce Management - Person Real Time", but when I try look at …
-
how to hide other countriesSummary How to hide the other countries from listContent We want to show only Saudi Arabia list of Document.Bilalemail 32 views 3 comments 0 points Most recent by Rambabu Laveti-Support-Oracle Human Capital Management -
Document of Record in Approval Creating TemplateSummary I want to a .rtf template of Document of Record which status is pending approvalContent Hi All, I need to crate a template of Document of Record with using sql. …User_2025-02-05-02-38-04-251 51 views 2 comments 0 points Most recent by User_2025-02-05-02-38-04-251 Human Capital Management
-
AORs and Global Temporary AssignmentsSummary HR Admin user with AOR for country 1 can see EE assignment in country 2Content Hello, I am looking for other users' experiences of Global Temporary Transfer and …
-
HCM Talk RadioContent Welcome to the HCM Talk Radio Blog! Thank you for tuning in! Please share your questions and/or comments on existing shows, or suggestions for future shows here.…Frank Cowell-Oracle 128 views 8 comments 1 point Most recent by Frank Cowell-Oracle Human Capital Management -
HCM Cloud Talk Radio: Changing the Future of HCM with Adaptive Intelligent AppsSummary HCM Cloud Talk Radio: Changing the Future of HCM with Adaptive Intelligent AppsContent Would you like to hear how Oracle is adding Adaptive Intelligence to its O…Frank Cowell-Oracle 30 views 0 comments 1 point Most recent by Frank Cowell-Oracle Human Capital Management
-
Is there a dictionary of HCM database fields vs the screens that display those fields?Summary Is there a dictionary of HCM database fields vs the screens that display those fields?Content When we want to hide a field in HCM Employee Self Service, Manager …
-
Auto Upload a Report (BI Publisher) to Employee's Document of Record?Summary Auto Upload a Report (BI Publisher) to Employee's Document of Record?Content All, Can we auto-upload reports generated or scheduled in BI / OTBI to be added or b…User_2025-02-05-22-13-16-277 75 views 7 comments 2 points Most recent by Sricharan Monigari Human Capital Management
-
All Active Employee details reportSummary Looking for all active employee details reportContent I am not finding a standard report to list all active employee details. It needs to have information Employ…User_2025-02-05-00-45-15-648 121 views 2 comments 0 points Most recent by Phani Sajja Human Capital Management
-
Excel Template for UAT & CRP Scenario gathering?Summary Excel Template for UAT & CRP Scenario gathering?Content Hi All, is anyone has an excel template to gather the UAT scenario? particularly made for Oracle Fusion H…Mithun Abhisheka 161 views 1 comment 1 point Most recent by Dr Surlina Yin-Oracle Human Capital Management -
Data access to collective agreementsSummary Data access to collective agreementsContent User has privilege ORA_PER_WORKFORCE_STRUCTURES_MANAGEMENT_DUTY which inherits manage collective agreements privilege…
-
How to find workflow notification BI report name for workflow taskname?Summary Our customer implimented HCM and want to add more fields to notification template.How I know which notification template is used by each task?Content Hi All, I a…