🏢 Oracle Fusion Core HR (Global HR) · Complete Interview Q&A

Foundation module of Oracle HCM Cloud that manages employee life cycle: workforce structures, person records, employment, assignments, positions, and global HR data.

Centralized employee repository, position management, workforce structures (BU, Division, Department), legislative data groups, person profiles, flexible security, self-service, HR extracts, and automated workflows.

Legal entities, business units, divisions, and departments that represent the corporate hierarchy. Used for costing, security, and approval routing.

Grouping of legal entities under common legislation, determines statutory rules (holidays, employment laws, payroll statutory units).

Legal Entity: legally registered company; Business Unit: operational unit for transactions; Department: functional unit (HR, Finance).

Legal Reporting Unit / Payroll Statutory Unit – responsible for statutory reporting and payroll compliance.

Division: high-level organizational segment (e.g., North America Sales); Department: lower level unit within division (e.g., Retail Sales).

Person: Employee/Applicant/Contingent Worker; Contact: dependent, emergency contact, beneficiary (no employment relationship).

Classification: Employee, Contingent Worker, Pending Worker, Person of Interest, Former Employee. Determines available actions.

Auto-generated unique identifier per person (via sequence / custom logic). Can be manual or system-assigned.

Link between a person and a job/position with specific dates, department, manager, location, and working hours.

Worker Assignment: employment contract with salary, manager, payroll; Non-worker: dependents, contacts without payments.

Person → Employment Terms (Work Relationship) → One or multiple assignments. Supports multiple assignments per person.

Legal employment contract between person and legal employer, can have multiple assignments.

Defines data access: by department, position hierarchy, location, or person type. Used in roles (HR Specialist, Manager).

Generic role (e.g., Software Engineer, HR Manager) independent of department; defines required competencies, responsibilities.

Instance of a job within a specific department (e.g., 'HRBP - Finance Dept'). Can be budgeted and have headcount limits.

Job: generic, reusable across org. Position: specific, may be one-to-one with employee. Positions support succession planning.

Reporting relationship among positions (e.g., CEO → VP → Director). Used in approvals and security.

Grade defines salary range, pay scale, and eligibility for benefits. Linked to jobs/positions for compensation benchmarking.

Physical address (office, site) associated with assignments for tax, reporting, and work location rules.

Hierarchical views of departments or positions (Manager, Matrix) used for reporting and security.

Set ID groups reference data (jobs, grades) across business units; shares common HR data.

Manage Jobs → Define job code, name, effective date, and optionally Job Family, Grade, Competencies.

Enable Position Sync feature, define position status (Filled, Vacant), assign job & department, control headcount.

Create Person → Specify person type (Employee) → Add employment terms → Add assignment (job, department, manager, grade) → Add salary → Submit approval.

Pre-hire record before official start date; captures candidate information, documents, future assignment details.

Hire: new employee with new work relationship; Rehire: former employee re-joined; Transfer: assignment change within same legal employer.

Transfer that changes legal employer (to different country/legal entity). Triggers new assignment and termination of previous.

Update assignment with new job / grade / salary, effective date. Can trigger approval workflow.

Employee holds multiple assignments simultaneously (primary and secondary) with different roles, departments, or legal employers.

Enter termination date, reason (Resignation, Retirement, Dismissal), final processing date, and final settlement. System ends assignments.

Person type changes to Former Employee; assignments end; benefits might end; data remains for reporting.

End absence record, reactivate assignment if required, update work schedule.

Indicates current state: Active, Suspended, Terminated, Leave of Absence. Controls payroll and benefits eligibility.

Defines how salary is calculated: Annual, Monthly, Hourly, Daily. Linked to grade and payroll element.

On assignment → Salary → Add salary basis, amount, currency, frequency and effective date.

Minimum, mid, maximum for each grade. Ladder defines progression from one grade to next.

Grid of grades and steps for standardized pay determination.

Use HCM Data Loader (HDL) or salary worksheet (Spreadsheet) to update multiple employees.

Temporarily block salary changes for certain assignments via eligibility profile or administrative hold.

Module to define leave types (vacation, sick, unpaid), accrue entitlements, process absence requests, and integrate with payroll.

Defines leave type, accrual policy (calendar or service-based), carryover rules, and payment percentage.

Fast formula determines accrual amount per period based on length of service, grade, and hours worked.

Assigned: employee eligible based on plan assignment; Enrolled: actively participating after enrollment record created.

Absence entries generate payroll elements (paid leave or unpaid deduction) during payroll run.

Payment for unused leave balance upon termination or annual buyback, processed via compensation element.

Fast formula checking if absence request qualifies based on minimum notice, available balance, etc.

Assigns enterprise/duty roles to users or LDAP groups (HR Specialist, Line Manager, Employee).

Filters person records based on department, position hierarchy, location, or person type for role access.

Job Role: functional duties (HR Manager); Data Role: role with specific data security context (e.g., HR for North America).

Manager security profile limits to direct and indirect reports using position hierarchy.

Employee data management, hiring, terminations, transfers, salary changes, and absence administration.

Person records can be marked sensitive; access is restricted; users need data role to view national ID, salary, etc.

Tailored roles combining specific duties (e.g., Recruiter + HR Analyst).

Use "Run Person Security Profile" or test roles as another user (Proxy access).

Bulk loading tool for worker data: Hire, assignment, salary, address, phone, contact information via CSV/zip files.

Worker, EmploymentTerms, Assignment, Salary, PersonName, PersonAddress, Phone, ContactRelationship.

Configurable extract to produce files for external systems (third-party benefits, reporting, government).

HDL uses dataloader templates (for complex objects). Spreadsheet loader for simpler data (e.g., department, jobs).

Oracle REST endpoints for workers, assignments, contacts, allowing real-time integration with third-party apps.

Used for validation rules, default values (e.g., approver derivation), absence accrual, and custom logic.

Approval process for transactions (hire, promotion, termination) using BPM tasks or approval rules.

Oracle Transactional Business Intelligence – real-time reporting using subject areas (Worker, Workforce Management).

Worker Assignment Real Time, Person Real Time, Workforce Headcount, Absence Real Time, Employment Terms.

Pixel-perfect reports (payslips, contracts, employee letters) using RTF/PDF/Excel templates.

Option to deliver HCM extract via secure FTP to external vendors.

OTBI report using Worker Assignment subject area, filter active assignments, group by department.

Infolets, charts, and analytics cards: Headcount summary, New Hires, Turnover by period.

Assignment updated with new department, manager, location. Security reflects new team. Salary remains unless grade changes.

Mass transfer of direct reports using "Manage Direct Reports" or update each assignment’s manager hierarchy.

Use "Manage Person" → Corrective action → Change start date (needs approval). If payroll impacted, coordinate retro.

Rehire the person with same assignment details, backdated start date, and adjust seniority if needed.

Primary assignment used for main deductions, secondary for earnings with allocation percentages.

Backdate assignment change effective date, system recalculates salary and triggers payroll retro if integrated.

Update salary basis on assignment, end-date hourly salary, create new monthly salary record from effective date.

Use "Manage Person" → Legislative Information → Edit national identifier with effective date.

Update manager on assignment via Manage Employment -> Reporting Manager. Ensure manager has active assignment.

Check effective date filters, assignment status = Active, person type, security profile access, and data refresh status.

End-to-end process from onboarding to retirement, includes events: hire, promotion, transfer, termination, leave, data changes.

Enable mass creation/update of jobs, positions, grades, departments, cost centers via Excel.

User-defined tags on person records for search and reporting (e.g., "High Potential", "Remote Worker").

Defines country-specific fields (passport, national ID formats, address styles) and employment contract templates.

Flexible custom fields to capture country/industry-specific data (emergency contacts, work permit details).

Legislative requirement; Oracle provides extracts for EEOC, VETS reporting using person diversity attributes.

Use "Terminate Workers" flow with spreadsheet upload, specify date and reason, submit for processing.

360° view of employee data: assignments, salary, absence, competencies, performance, documents.

Person: name, contacts, personal details; Assignment: role, department, manager, salary, work location.

Enable Audit for person and assignment objects; use "View Audit History" or HCM Extract for changes.

Conditions based on transaction type, amount threshold, or org hierarchy that route requests for approval.

When position management on, each position has budgeted headcount. Hire fails if position is over budget.

Always use future-effective or past-effective with correction scope. Use update mode rather than delete/recreate.

Use merge option, unique person number, or use start date validation to avoid duplicate person records.

Least privilege principle: assign person security profiles, separate transactional vs report roles, encrypt sensitive data.

Use HDL batch split, avoid peak hours, review parallel processing settings for ESS jobs.

Run extract in trace mode, check log files, validate parameters and date ranges.

Check existing record, update person number sequence, or use manual unique identifier.