3)How to enable contracts at the assignment level?

4)Open-Ended Absence Rules

A, Evaluation Period at Absence Entry
evaluation Extension Period
5)HCM Design Studio.
6)Page Customization, Integration
7) What are the pre-requisites for data migration Setup?

Faced By Narendra.
1)Role for OTBI Reports and BI Reports.
Ans: HR Analyst
2)what to give Permissions in OTBI
Ans: My Folder, under permissions, we can share permissions for users.
3)Role for security Console
Ans: IT Security Manager
4.Roles for Setup and Maintenance.
Ans:
5)what is the Job Process, we need to run In Absence
Ans: Schedule and Monitor Absence Process
6)Mass Update and Mass Assignment Update
We are having New Feature
8)Absence Plan Flow.
Ans: Plan Attributes, Participation, Accruals, Entitlement and Balance, Additional Details.
9)Absence Type Flow.
Ans: Type Attributes, Plan and Reasons, Display Features, Action Items, Additional Items.
10) Incremental, Front Loaded, Vesting, Waiting Period, As of Event.

Vesting and waiting Period.

Whatever the annual plan

3 months,waiting
1 month,
2 month,
3 month
4month (2)

Vesting:3 months.
1.month(2)
2.month(4)
3 month(6)
4 month(8)

Ans:
11)Trees:
Ans: Graphical Representation of an Organisation.
4 Types of Trees, Organisation Tree, Department Tree, Position Tree, Geographic Trees.
Where do we use
Department Trees used in Organization Security Profiles,
Position Trees will be used in Approval Management,
Geographic Trees are used in Absence Management while configuring the absence Schedule.
Organization Trees will be used in, know the enterprise Hierarchy data.

1.What are the Setups required when Migrating Data.

1.What is Manage Implementation Project, How to Create.
2.Job Requisition. - You create a job requisition to specify the requirements of a job for
which candidates are hired.

Here are the main steps to create a job requisition:

1. Initiate the creation of the job requisition.

2. Enter details about the job requisition.
3. Submit the job requisition for approval.
4. Enter job formatting information.

3.Absence work Schedule and Calendar Events

Important DB Tables for the query to get employee details in oracle fusion

1.per_all_people_f
2.per_all_assignments_m
3.per_jobs_f
4.per_jobs_f_tl
5.GL_CODE_COMBINATIONS
6.PER_EMAIL_ADDRESSES
7.per_assignment_supervisors_f
8.per_person_names_f
9.HR_ORGANIZATION_UNITS_F_TL

Talent Review

https://iavinash.com/learn-to-configure-oracle-fusion-talent-review-template-dashboards/

Hi all Please try to update/Post your interview Question here for both (Technical or
Function)

Latest Questions:

1. What is Position Synchronization?

Ans: Position Synchronization is when an assignment inherits the values from a predetermined
Position.

Position Synchronization will be done at an enterprise level.

1. Use HCM Position Hierarchy.

2. Use Position Manager

https://apps2fusion.com/old/oracle-fusion-online-training/165-oracle-articles/2551-position-synchro
nization-in-oracle-hcm-cloud.

CORE HR

1) The person number is already there, why do we require a worker Number?

Ans: Person Number is Unique, if you use a legal employer sequence, the person number
doesn't change when you rehire in the same legal employer. However, the worker number
changes when you rehire in a different legal employer or globally transfer to a different
legal employer.

2) Position was created with DFF values then Employee was hired, However Assignment
DFF does not auto populate when Position is selected? What is the Possible way to get the
scenario achieved?
Ans: If you have defined position synchronization at the legal employer level and haven’t
defined flex field mapping for a legal employer, the position flex fields won’t be
synchronized at the assignment for that legal employer.
3) ** If a person is in multiple assignments which calendar event, he should follow?
If ‘A’ assignments in UK and ‘B’ assignment is in US/India.
Ans: A Person is associated with primary assignment in work schedule the calendar events are
followed as per Primary Assignments.

4) How is HR Manager being common for all? How can we make HR visible to every
employee in common?
Ans: This can be achieved through the AOR concept.
Org tree top node to be selected.

5) Can DFF be synchronized in Position Synchronization?

Ans: Manage Assignment Flex Field Mapping
Employee lap y/n ques.
6) What are the Five steps to be followed during implementation?
Ans:
https://appsfromrajiv.wordpress.com/2011/08/05/phases-of-oracle-implementation/

7) What are the Impacts on global Transfer?

Ans: current work relationship will be terminated.
8) How to revoke the termination and what is the impact?

Ans: Reverse Termination steps Guideline:

https://rpforacle.blogspot.com/2020/09/reverse-termination-in-oracle-fusion-hcm.html

Impact: After the termination is reversed: Work relationships and assignments are
restored to their previous statuses. Previous employee roles are provisioned again.
User accounts are restored.
https://docs.oracle.com/en/cloud/saas/j4s/srred/to-reverse-a-termination.htm
9) **What are Legacy Technologies?
Ans : people soft to hcm, Ebs to hcm, Sap to hcm.

10) **From Which legacy technology are they Migrating to Fusion? (PeopleSoft or EBS)
Ans: HDl/ HSDL - tools. Create flex fields in the system for an unknown object.

11) **Legal Employer can be changed from country to country and how can it be Changed?

Ans: yes, it can be changed, through mass legal employer changes.

12) When i am changing the tree version, when uploading data, I get an error. What is the
possibility?
Ans: Effective Start Date, status - inactive/ active
13) What is a work relationship and do you have an idea?
Ans: A work relationship defines how a person and legal employer are related.
The work relationship is created when you use any of these processes:

● Hire
● Rehire
● Global Transfer
● Global Temporary Assignment
● Create Work Relationship

You select the worker type and legal employer values when you create the work
relationship of a person.

Employee, contingent worker, non-worker,

14) Is it possible to change assignments from single to multiple and what we need to take care
of?
Ans: Yes, we can change, through the Manage Enterprise HCM information page.
15) What are the restrictions for reversing the Termination?
Ans: Restriction for Reversing a Termination
You can't reverse the termination if the same legal employer has rehired the worker at the
same time.

If Department Version is changed? What are the Attributes we should change in HDL Load? Will it
throw errors or will it get Load? If so, what will be the error? And what should we do to load?
Ans: when department tree version is changed, we have changed the effective start date and end
date. Then we have to update the metadata line in the column of update tree version name.
16) What are the requirements you will gather from the Technical Team?
Ans: Reports - hint
17) If I am a client, what will you ask me if I want to configure DFF Fields?
18) What is a responsive and classic screen?
Ans : classic screen will be
19) What is EFF then tell me live example when and where you used?
20) What is Journey sub task?
21) Difference between Enterprise and workforce structure?
22) What is check in in review template.
23) What are core HR setup.
24) What is global Transfer?
Ans: Global transfer is transferring Employee from one legal entity to another legal entity. Then
Existing work Relation/ assignment will be terminated and the assignment status will change to
active - no payroll in the system. Worker numbers will be changed.
The new assignment will be copied and the new assignment will be Active- Payroll.
Impact: Existing work-relation will be terminated!
 HDL:

1. What are the keys used in HDL? → 4 keys

Ans: 1. User Keys - used for loading new data in the system
Surrogate Keys - used for updating Purpose for already loaded items
Source keys (Source System Owner and Source System ID) - used for loading new
data in the system .
GUID (Globally Unique Identifier) - used for updating Purpose for already loaded items
2. Where can we check HDL errors? → error tables and logs
3. Which table stores source key information?
Ans: HRC_integaration_key_Map Table.
4. How to declare DFF columns in HDL load?
Ans: To pass Global Data Segment and their respective flex field column in meta data
5. How to change the Effective start Date for an employee in HDL?
Ans: We have to take the Business Object (BO) in Job .dat file update the job column with
job id and return the flag status as Y in Replace First effective Date. Then Give the date in
effective start Date Column
6. How to change termination details using HDL? → Ans: Work Relationship metadata
7. What are Mandatory Objects for Worker load? → 5 metadata’s
Ans: Worker Assignment, Work terms, Work Relationship, Person Name and Person Legislative
information.

8. Is it possible to load Assignment without Work Terms? → No

9. What are the steps to load Data files through HDL? → Navigation steps
Ans: Navigator→My Client Groups→Data Exchange→Import and Load→Import file→select file
from local system and submit. Refresh until import and load successfull.
10. Which role is needed to access HDL?
Ans: HR Specialist role
11. What are the errors while loading salary data using PBL loader?
12. What is requisition?
13. What is the mandatory Object for job and to load new employee?
14. Migration done from Another technology where in unidentified columns how to relate or
define in hdl?

Absence:

1.Create Vacation absence Type is the requirement by the client, what is the process and how you
show it in the System.
2.Name of the rule so you configure absence leave.
3.**Do you have data migration experience?
4.How do you confirm absence Type so it should not impact other assignment.
5. What is Front Loaded and Incremental?
6. What’s the difference between eligibility profile and derived factor?
7.How to configure an accrual plan.
8.** Absence certification validation in BU if absence exceeds 5 days in different Location.?
Ans: Page Level Customization.
9. What are the elements that you configured in absence?
10)Explain about different plan types available in Fusion absence management?

Ans: These are the three kinds of plans in Oracle Fusion’s absence management.

● Accrual – This plan is for creating the absence of paid leaves. Ex: vacation plan.

● Qualification – This plan is for creating the absence of paid leaves for which the employees are

entitled to the leaves and pay. Ex: maternity leave, Paternity.

● No entitlement – It keeps track of all paid and unpaid leaves so that the accumulated balance of

leaves and payment is not there .Eg, Casual Leave

● Lop - loss of Pay in which payment will be cut from the salary.

Security:

1.Have you created custom roles in Oracle HCM?

Ans: By creating Data roles the Security Profiles are created - custom Roles
Data roles are inherited from job roles.

2.Custom Role creation Process?

Copying the oracle seeded role.

3.How many Security Profiles are in the system? What are they?
1-person security profile. Country security profile, 2 Organization Security Profile, 3 Position
Security Profile, 4 LDG security profile, 5 document type security profile, 6 transaction Security
profile, 7 Job requisition security profile, 8 candidate security Profile, 1-person security profile.

4.How can we restrict the security Profiles?

Payroll:

1.why I am loading salary data, and it is getting error, so what can be the possibility of it, in
terms of data loader.
2. What is a deduction card Group?
4. 200 employees have problems while running the payroll, how do you find them?
BIP Reports Question:

1.BIP Report creation steps?

Ans: Navigator→Tools→Reports and Analytics→Browse Catalog→ Create→Report
2.How to set Default value of Parameters in BIP reports?
3. Difference between HCM Extracts and BIP Reports?

Extracts:

1.What are Extract Creation steps?

Ans: create (+)--> enter details—>create Data Groups→Records→Attributes→Delivery
Options→Execution tree→compile and validate→submit.

2.What is Full profile, HR Archive Profile in extract?

3. What modes are in HCM Extracts changes only? –> 6 Modes
Ans: 1. All Attributes
2.Changed with previous values
3.changed and marked attributes
4. Changed and marked attributes with previous values
5.Changed and marked attributes under Threading group
6.Changed and marked attributes with previous values under Threading group
4. What is the Always Display checkbox in HCM Extract?
5. What is Marked as Change checkbox in HCM Extract?
6. How to print M as Male and F as Female, dob format should be year using HCM Extracts?
7. What is a Threading Database Item?
8. Which Delivery type is used to get the data from the server? —> Web content server
9. How to schedule HCM Extracts? Ex: Daily, weekly…etc.

WORK FLOWS:
1) What are Approval types?
2)
SANDBOX:
1) What is personalization in sandbox?

Brila soft:
1) Dff and eff difference
2) What is 9 box matrix in the talent template?
3) What is performance template?
4) Goals can be shared by colleagues?
5) Enterprise and workforce structure difference
6) Personalization or page customization?
7) Hands on Bip?
8) What is check in template? (performance)
9) Data Roles a job role, aggregate and privilege
10) How do you migrate data from dev to test?
11) What is core hr setup?

L2 Questions:

1) Can we customize DFF in AOR person management page? - Ans NO

2) In Absence plan on prorate basis accrual for a month is 2 leaves and when he can apply
leave if he should avail those leaves only for next year not for current year i.e. 13th month how it’s
possible.?

3) How is the plan enrolled for an employee? How is the system detecting that this employee
is eligible for that plan? how?
Ans: when hiring happening system will backend will evaluate eligibility profile
Already existing employees update their accrual plan.

Data Migration Tools: HDL, HSDL, Batch Uploader.

Integration tool: Oracle Taleo- Recruiting tool.

Data Migration: Pre-requisites?

What is the role?

A role is some kind of privilege that you can assign to the user allowing them to perform
certain type actions in the application.
Hierarchy Of Roles:

JOB ROLE:
1. Oracle seeded roles are called job roles for all the business areas.
For core hr - Human resource Manager, Human Resource Specialist
For Payroll: Payroll Manager

Data Role:
1. Data Roles are nothing but custom Job roles that are created by copying seeded job
role.
2.Basically the data roles which inherits the job role.Eg,

Abstract Role:
1. Roles which are oracle delivered roles
Eg : Line Manager, Employee and contingent worker.

Duty Role,
Aggregate/ Privilege role.