Oracle Fusion Application

Fusion Applications

Oracle Fusion Applications (OFA) is a suite of ERP applications distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management.

Oracle Fusion Applications were released in 2011, after Oracle's acquisition spree of PeopleSoft, JD Edwards, and Siebel Systems.

Oracle Fusion applications offer an array of flexible deployment options, providing customers with unprecedented choice without the need to commit to any one delivery mechanism. Choices of on-premise, on-demand, SaaS (public or private cloud) or hybrid are all available, enabling ultimate flexibility and choice for your organization as it grows and evolves.

Verifying Geographies in Oracle Fusion Application

Geography information is used in Oracle Fusion applications for address entry and geography-based business processes, such as territory management and shipping. Before defining enterprise structures, the implementation team must verify predefined geographies and load any additionally required local geography.

1.Select Manage Geographies from Setup & Maintenance, On the Manage Geographies page select the country to create geography setup and content.

2-Click the green checkmark for each type of geography data you want to verify.

A- Address Cleansing Defined:

B- Structure Defined: Create a geography type

C- Hierarchy Defined:

D- Validation Defined: Attach the UAE geography type to City attribute

3- Verify the information on each page and make necessary changes, then click Save and Close.

Comparison in Organizational structure units between Oracle Fusion Application and E-Business Suite

Fusion Application	E-Business Suite
Enterprise	Business Group or Instance
LDG Legislative Data Group	Business Group
Payroll Statutory Unit	Tax Group
Legal Employer	Reporting Organization
Tax Reporting Unit	Government Reporting Entity

Key Flex Fields in Oracle Fusion Application

If you Search for in Job Key Flex Field or Position key Flex Field in Oracle Fusion Application

In Oracle Fusion HCM, Key Flex Fields (KFFs) are only found for Cost Allocation KFF, People Group KFF, there is no KFFs for jobs, grades, positions … etc.

Jobs have a code and a description and links to job family and functions. It is a bit simpler than EBS, So you can go to Manage Workforce Structures and navigate through the pages to find Descriptive Flex Fields though on all these work structures if you need to store additional information.

(Manage Descriptive Flex Fields).

Comparison between Key FlexFields in Fusion and Key FlexFields in E-Business Suite (EBS)

	Fusion Key Flexfields	EBS Key FlexField
Types	- People Group - HR - Cost Allocation - Payroll	- Personal Analysis - Grade - Job - Position - People Group - Cost Allocation
Table Information	information is stored in same table. Ex: Job data is stored in per_jobs_f	Information is stored in different tables. Ex: per_jobs_f and per_job_definitions

Commonly used database tables in Fusion HR application

Most of the tables in Fusion Applications are inherited from Oracle eBusiness Suite, but there are additions and modifications in the data model. The tables are more normalized and represents the information it is storing. Some of the commonly used tables are -

Table Name	Alias Name	Suggested Join

PER_ALL_PEOPLE_F	PAPF
PER_PERSON	PP	PAPF.PERSON_ID = PP.PERSON_ID AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
PER_NATIONAL_IDENTIFIERS	NID	PAPF.PERSON_ID = NID.PERSON_ID AND NID.NATIONAL_IDENTIFIER_TYPE = 'SSN'
PER_ETHNICITIES	PE	PAPF.PERSON_ID=PE.PERSON_ID
PER_PERSON_NAMES_F	PPNF	PAPF.PERSON_ID = PPNF.PERSON_ID AND UPPER(PPNF.NAME_TYPE)='GLOBAL' AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE
PER_PHONES	PPH	PAPF.PERSON_ID = PPH.PERSON_ID PPH.PHONE_TYPE = 'H1'
PER_PEOPLE_LEGISLATIVE_F	PPLF	PAPF.PERSON_ID = PPLF.PERSON_ID AND TRUNC(SYSDATE) BETWEEN PPLF.EFFECTIVE_START_DATE AND PPLF.EFFECTIVE_END_DATE
PER_EMAIL_ADDRESSES	PEA	PAPF.PERSON_ID = PEA.PERSON_ID AND PEA.EMAIL_TYPE = 'W1' AND TRUNC(SYSDATE) BETWEEN PEA.EFFECTIVE_START_DATE AND PEA.EFFECTIVE_END_DATE
PER_PERSON_ADDR_USAGES_F	ADRU	PAPF.PERSON_ID=ADRU.PERSON_ID AND ADRU.ADDRESS_TYPE = 'HOME' AND TRUNC(SYSDATE) BETWEEN ADRU.EFFECTIVE_START_DATE AND ADRU.EFFECTIVE_END_DATE
PER_ADDRESSES_F	PA	ADRU.ADDRESS_ID = PA.ADDRESS_ID AND TRUNC(SYSDATE) BETWEEN PA.EFFECTIVE_START_DATE AND PA.EFFECTIVE_END_DATE
PER_PERSON_TYPE_USAGES_M	PPTU	PAPF.PERSON_ID = PPTU.PERSON_ID AND TRUNC(SYSDATE) BETWEEN PPTU.EFFECTIVE_START_DATE ANDPPTU.EFFECTIVE_END_DATE
PER_PERSON_TYPES	PT	AND PUF.PERSON_TYPE_ID = PT.PERSON_TYPE_ID AND PT.SYSTEM_PERSON_TYPE IN ('CON',’EMP’)

FND_LOOKUP_VALUES_TL	FLVT7	AND PE.ETHNICITY=FLVT7.LOOKUP_CODE AND FLVT7.LOOKUP_TYPE='PER_ETHNICITY' AND FLVT7.LANGUAGE='US'
FND_LOOKUP_VALUES_TL	FLVT8	AND PPLF.MARITAL_STATUS=FLVT8.LOOKUP_CODE AND FLVT8.LOOKUP_TYPE='MAR_STATUS' AND FLVT8.LANGUAGE='US'

PER_ALL_ASSIGNMENTS_M	PAAM	PAPF.PERSON_ID = PAAM.PERSON_ID AND PAM.ASSIGNMENT_TYPE IN (‘E’,’C’) AND TRUNC(SYSDATE) BETWEEN PAAM.EFFECTIVE_START_DATE AND PAAM.EFFECTIVE_END_DATE
PER_ASSIGNMENT_STATUS_TYPES_TL	PASTT	PAAM.ASSIGNMENT_STATUS_TYPE_ID=PASTT.ASSIGNMENT_STATUS_TYPE_ID
PER_ASSIGN_WORK_MEASURES_F	PAWMF	PAAM.ASSIGNMENT_ID=PAWMF.ASSIGNMENT_ID PAWMF.UNIT='FTE'
PER_ASSIGNMENT_SUPERVISORS_F	PASF	PASF.MANAGER_ID=PAPF.PERSON_ID AND TRUNC(SYSDATE) BETWEEN PASF.EFFECTIVE_START_DATE AND PASF.EFFECTIVE_END_DATE
PER_PERIODS_OF_SERVICE	PPOS	PAAM.PERIOD_OF_SERVICE_ID=PPOS.PERIOD_OF_SERVICE_ID

CMP_SALARY	CS	PAAM.ASSIGNMENT_ID=CS.ASSIGNMENT_ID
CMP_SALARY_BASES	CSB	CS.SALARY_BASIS_ID=CSB.SALARY_BASIS_ID


HR_LOCATIONS_ALL_F_VL	HLAFV	PAAM.LOCATION_ID=HLAFV.LOCATION_ID AND TRUNC(SYSDATE) BETWEEN HLAFV.EFFECTIVE_START_DATE AND HLAFV.EFFECTIVE_END_DATE
PER_DEPARTMENTS	PD	PAAMV.ORGANIZATION_ID=PD.ORGANIZATION_ID AND TRUNC(SYSDATE) BETWEEN PD.EFFECTIVE_START_DATE AND PD.EFFECTIVE_END_DATE
PER_JOBS_F_VL	HLAFV	PAAM.JOB_ID=PJFV.JOB_ID AND TRUNC(SYSDATE) BETWEEN HLAFV.EFFECTIVE_START_DATE AND HLAFV.EFFECTIVE_END_DATE
PER_GRADES_F_TL	PGFT	PAAMV.GRADE_ID=PGFT.GRADE_ID AND TRUNC(SYSDATE) BETWEEN PGFT.EFFECTIVE_START_DATE AND PGFT.EFFECTIVE_END_DATE AND PGFT.LANGUAGE(+)='US'
HR_ORGANIZATION_UNITS_F_TL	HOU_TL	PAAMV.BUSINESS_UNIT_ID = HOU_TL.ORGANIZATION_ID AND HOU_TL.LANGUAGE='US' AND TRUNC(SYSDATE) BETWEEN HOU_TL_TL.EFFECTIVE_START_DATE AND HO.EFFECTIVE_END_DATE

Oracle Fusion Application Employment Model

Assignment in Fusion could be 2 tiers or 3 Tiers or Single or multiple assignments. The employment model consists of:

Work Relationship - Relationship between a person and a legal employer. All work relationships must contain at least one assignment.

Employment Terms - Set of terms and conditions to govern one or more assignments

Assignment - set of information, including job, position, pay, compensation, managers, working hours, and work location, which defines a worker's or non-worker’s role in a legal employer. A person can have multiple assignments in a single work relationship.

2 Tiers VS 3 Tiers Comparison

2 Tiers

3 Tiers

· Global Person

· Can Have multiple work relationships

· Each work relationship can have one or more assignments.

· Employee model – 2 tiers (work relationship, assignment)

· Global Person

· Can Have multiple work relationships

· Each work relationship can have one or more assignments.

· Each Employment terms record can have one or more assignments

· Provide a contract as part of the Employment Terms

· Employee model – 3 tiers (work relationship, Employment Model, assignment)

· Default Employment Terms details on the assignments

Work Relationship, Work Terms and Assignment Relationship

Human Resources Job Roles

Job Roles	Description
Human Resource Analyst	1- Analyzes Transactional Business Intelligence information 2- Analyzes Business Intelligence Application content
Human Resource Specialist	1- Analyzes Business Intelligence Application content
Business Intelligence Applications Worker	1- Analyzes Business Intelligence Application content 2- This role is associated with compliance and workforce effectiveness analytics.
Human Resource Manager	1- Analyzes Business Intelligence Application content