Data Models
Discussion List
-
Action and Action Reason usages mapping reportSummary Action and Action Reason usages mapping reportContent Hi all, I am looking for a SQL extract/report that pulls all the list of Actions, associated Action Reasons… -
Unable to find Database Table Name and Column Name for 'Pending Changes' in Manage Grades and ManageSummary Unable to find Database Table Name and Column Name for 'Pending Changes' in Manage Grades and Manage Grade LaddersContent Dear All, Could someone please help to …Gopikrishna Nerella 25 views 1 comment 0 points Most recent by Senthamizh Arasu Govindan Human Capital Management -
Location change report OTBIContent Hi, I need to produce a report in OTBI that gives me back the workers who changed location independently of the actions on today's date. How i can do it? It is p… -
Some Commonly Used Queries In Oracle HCM CloudSummary Some Commonly Used Queries In Oracle HCM CloudContent In any typical ERP Implementation, there are requirements to prepare multiple reports. Most of the Reports … -
Need custom report to fetch the all the configured approval rulesSummary Need custom report to fetch the all the configured approval rulesContent Hi All, Is there any Custom report or Seeded report to fetch all the configured approval… -
Sample Query for Questions and Answers in Chekclist TemplateSummary Sample Query for Questions and Answers in Chekclist TemplateContent Hi Experts, Does any one have any sample query to pull the Question and Answers data from the…
-
Manager Listing by Employee with Multiple ManagersSummary Recent changes limit manager results to "Line Manager" only, or entire hierarchy down to the employee. Users need a simple solution... Here is a workaround.Conte… -
Plot Headcount on a World mapSummary Bi Publisher - Excel- Plot Headcount on a World mapContent Hi Gurus, I am looking for ideas around plotting headcount on a world map. We are trying to use the ex…Sriharsha Devraj 32 views 2 comments 0 points Most recent by Sriharsha Devraj Human Capital Management -
Roles and TerminationsSummary Remove roles post TerminationContent Team, we have a requirement to remove all roles when user is terminated . we are planning to automate this through HDL and c…Harish Chandramohan-83777 58 views 4 comments 0 points Most recent by MandeepKGupta Human Capital Management
-
Roles and TerminationsSummary Remove roles post TerminationContent Team, we have a requirement to remove all roles when user is terminated . we are planning to automate this through HDL and c…Harish Chandramohan-83777 49 views 1 comment 1 point Most recent by Siraj Syed -Support-Oracle Human Capital Management
-
BI Publisher report how can we add banner pic and color formatting to the layout?Summary BI Publisher report how can we add banner pic and color formatting to the layout?Content Hello , We would like to add a BIP report to a picture banner of the com… -
Checklist E-Sign FunctionalitySummary Checklist E-Sign Functionality Report ParamtersContent The guide is incorrect as to the parameters: 1. If there is a space in the folder or report name, let the …Savez Shabkhez 42 views 1 comment 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management
-
Onboarding Questionnaire Data ModelSummary Onboarding Questions Report neededContent Does anyone have a data model & report that pulls questions & responses from Onboarding questionnaires? Oracle doesn't …R.Puthoff 114 views 2 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management
-
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…
-
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…Puja Bharati-27866 46 views 2 comments 0 points Most recent by Harish Chandramohan-83777 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…
-
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…Claire Findell 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…Abhradeep Haldar Ext 1.1K views 5 comments 0 points Most recent by Abhradeep Haldar Ext 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… -
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…
-
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. …Muhammed Nafeel A-147080 73 views 2 comments 0 points Most recent by Muhammed Nafeel A-147080 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…vijay salve-151928 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 51 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…Saurabh Kukreja-193152 461 views 4 comments 0 points Most recent by Saurabh Kukreja-193152 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…