Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Oracle Fusion Cloud HCM Technical(BI Reports Development)

Name: Oracle Fusion Cloud HCM Technical(BI Reports Development)
Rating: 4.3 (223 reviews)

Oracle Fusion Cloud HCM Technical(BI Reports Development & Customization) , Integrate with OICS , BI Reports Security

Created byChandra Mohan

Last updated 5/2026

English

English [Auto],

What you'll learn

Development and Customization of Oracle Fusion HCM BI Reports in Global HR , Payroll and Absence Management
Registration of BI Reports with ESS jobs as well as ESS Job Sets
Get the Complete Knowledge about the Global HR , Payroll and Absence Management Business Flow as well as Data Model
Get the Complete Knowledge about the Global HR , Payroll and Absence Management Data base tables , Primary keys and Foreign Keys
Will be able to Develop .rtf , E-text and Excell Sheet BI Reports Development

Course content

8 sections • 47 lectures • 12h 10m total length

Course Introduction & Syllabus7:48
Explore bi report development for Oracle Fusion Cloud HCM, learning data models, key tables, security, and output formats from simple reports to bursting and scheduling.

What is Cloud ?15:11
Define cloud as virtual servers in data centers and compare top providers like AWS, Azure, Google Cloud, Oracle Cloud, and Salesforce Cloud.
What is Oracle Cloud ?23:49
Explore Oracle cloud, fusion ERP, and global data centers for finance, supply chain management, HCM, CRM, and fusion financials careers in functional and technical roles, licensing considerations.
What is Oracle Fusion Cloud ?18:06
Oracle Fusion Cloud Initial Navigations6:41
Oracle Fusion Applications User creation & Add Implementation Roles8:36
Learn how to create users in Oracle Fusion Cloud, assign implementation roles, and manage functional setups via the FSM, including security console access and environment migrations.
What is Oracle Fusion Cloud Implementation Project28:17
Explore how to create and manage an Oracle Fusion cloud implementation project, including offerings, task lists, assignments, and project status for effective team collaboration and reporting.
How to Assign Implementation Project to users12:46

Oracle Fusion Cloud Global HR (GHR) Module Business Flow9:54
Oracle Fusion HCM Enterprise Structure Configurator (ESC) Functional Flow19:22
Oracle Fusion HCM Enterprise Structure Configurator (ESC) Tables-117:00
Oracle Fusion HCM Enterprise Structure Configurator (ESC) Tables-216:32
Oracle Fusion HCM Enterprise Structure Configurator (ESC) Tables-39:20
Query the GL_ledgers table to verify ledgers and view attributes, then use the classification table to distinguish business units, divisions, and legal entities.
Oracle Fusion cloud HCM Jobs and Job Family Tables9:34
Learn how Oracle Fusion cloud HCM models jobs and job families, with primary keys like job_family_id, and how per underscore jobs supports retrieving job_id, job_code, and job_name.
Oracle Fusion HCM Position Tables11:15
Explore how Oracle Fusion HCM links jobs and positions, create positions under a job, and query positions by job using job ID and position ID with front-end parameters.
Oracle Fusion Cloud Table Suffixes information _f _ALL _M _TL _VL11:30
Oracle Fusion HCM Department,Job,Position & Locations Tables & Report developmen39:35
Build a business unit input parameter driven HCM report showing position name, job name, location, department, hiring status, and position type by joining HCM tables.
Oracle Fusion HCM Cloud Master Detail Report Development40:29
Oracle Fusion Cloud BI Report migration process4:59
Oracle Fusion HCM Input Parameter with All values Setup and ESS Job registration40:29
Oracle Fusion Cloud HCM Technical BI Reports Simple Report development -122:47
Develop a simple BI report in Oracle Fusion Cloud HCM by building a data model with SQL queries, designing the layout, and exporting results for analysis.
Oracle Fusion Cloud HCM Technical BI Reports Simple Report development -25:41
Oracle Fusion Cloud HCM Technical BI Reports Simple Report development -310:29
Learn how to deploy a BI report as an SS job, register it in the enterprise scheduler, and run it via the scheduled process for end-user access.
Oracle Fusion Cloud HCM Employee hiring Tables information and DateTrack details18:43
In this Lecture we will be discussing , How to Hire employee which table contains Employee Information and How to manage the Employee history date when we are using UPDATE mode and CORRECT Mode.
Oracle Fusion Cloud HCM Sub Template configuration and Logo change30:48
In this session we will be discussing about Oracle BI Publisher Sub template configuration
Oracle Fusion Cloud HCM Style Template Development (Emp Supersior Hierarchy)24:35
Master style template development for Oracle Fusion Cloud HCM BI reports by attaching fixed style sheets, contrasting subtemplates with style sheets, and applying templates after report execution.
Oracle Fusion Cloud BI Reports Independent and Dependent parameters13:39
Configure independent and dependent value sets in Oracle Fusion Cloud BI reports. Link purchase order types to corresponding numbers and enable refresh on change for dependent PO numbers.

Oracle Fusion cloud HCM Absence Management Business Flow5:34
Learn the Oracle Fusion Cloud HCM absence management business flow with high level setups, options management, and leave plans that calculate accruals and support approvals.
Oracle Fusion cloud HCM Absence Reasons Tables & Query11:54
Explore how to query Oracle Fusion Cloud HCM absence reasons tables to retrieve active options reasons, including descriptive flexfields and multi-language translations for accurate absence management.
Oracle Fusion cloud HCM Absence Certifications Tables & Query4:17
Identify the certification table and its translation table for options certifications, write queries to fetch certification name and description, and avoid duplicates by filtering language to the user environment language.
Oracle Fusion Cloud HCM Absence Plans Tables & Query12:58
Explained about ANC_ABSENCE_PLANS_F Table in Oracle cloud HCM
Oracle Fusion Cloud HCM Absence Plans and Eligibility profile Tables & Query16:09
Explained about Oracle fusion cloud HCM Plan , Eligibility profile tables , ANC_ABSENCE_PLAN_F
ANC_PLAN_ELIG_PROFILES_F
BEN_ELIGY_PRFL
Oracle Fusion Cloud HCM Absence Type and Plans Tables & Query9:34
Explained about absence type table and Plans table ,
How to Join Type and Plans table , ANC_ABSENCE_TYPES_F
ANC_ABSENCE_TYPE_PLANS_F
ANC_ABSENCE_PLANS_F
Oracle Fusion Cloud HCM Absence Type and Existing leave details Tables & Query10:42
In this Lecture explained how the employee can apply for leave and what are the tables are used to get the employee existing leave details. ANC_PER_ABS_ENTRIES ,
PER_PERIODS_OF_SERVICE ,
PER_ALL_PEOPLE_F ,
ANC_ABSENCE_TYPES_VL

Oracle Fusion Cloud HCM Payroll Business Flow3:58
Learn how the payroll module calculates salaries, handles payments, and creates accounting entries, with key concepts like consolidation groups, payment methods, payroll definitions, elements, and standard payroll flows.
Oracle Fusion Cloud HCM Consolidation , Payroll Tables10:02
Oracle Fusion Cloud Orgpayment method Table , Payroll Definition Query21:07
Oracle Fusion Cloud HCM Employee and Payroll Query22:54
Learn to write a query that retrieves employee details and payroll information, including legal employer, business unit, and payroll name, by linking HR data in Oracle Fusion Cloud HCM.
Oracle Fusion Cloud HCM Payroll Elements Tables , Joins and Queries15:04
Oracle Fusion Cloud Custom BI Report Customization Process5:12
Learn how to customize Oracle Fusion Cloud BI reports by locating the report in the HCM folder, editing the data model and layout, and adding parameters and filters.
Oracle Fusion Cloud Standard BI Report Customization Process10:20
Learn to customize Oracle Fusion Cloud standard BI reports using the Xmlrpc server, enabling copy-to-custom-folder workflows and updating data models for tailored payroll and benefits reports.
Oracle Fusion Cloud Multi Language Report Configuration10:22

Requirements

Basic SQL Required to learn this Course

Description

What's this course about?

Learn Oracle Fusion Cloud HCM Technical Consultant in BI Reporting and dive deeper into it. Understand the Technical components of Oracle Fusion HCM Cloud Technical(BI Reports), the Development, Customization, Migration, and integration strategies.

What do you expect end of this course?

By the end of the course, you will be equipped with all the knowledge of Oracle Fusion Cloud HCM as a Technical Consultant in BI Reporting Components - Migrations and Integrations, Customization, implementation security, and how to automate the manual processes of these, and clear understanding of Reporting capabilities available at Fusion Cloud,

Who's teaching you in this course?

My name is Chandra I have 10+ Years of experience in Fusion Cloud, SaaS &PaaS Environment, and I am passionate about helping more people to learn Fusion Cloud .

It's my goal to get you started with Oracle Fusion Cloud HCM Technical Consultant in BI Reporting as soon as possible and ensure your success. I want everyone to get benefit from this course and for me, helping others is the best way of learning. So Let's Learn together!

Is this course for you?

This course is for you if ...

you want to upskill with Oracle Fusion Cloud HCM Technical Consultant in BI Reporting skills

What's inside the course? Module Business Flows Global HR, Payroll, and Absence Management module Business Flows. we will be discussing the data model of all three modules.

ESS Jobs - ESS Job Status, Job Submission, and Scheduling, Create Custom ESS Job, ESS Job Parameters, LOV with Lookup and Value Sets, Secure ESS Job

Module Database Objects: Will be Discussing the Tables in these modules and how to Develop the BI reports by writing Simple as well as complex queries.

We will be Developing the Master details reports with Multiple parameters and also working with multiple Layouts as per the client's requirement.

Different Templates: Developing E-text, Excell, PDF output templates with sub-templates as well as multi-language templates, BI reports with Bursting Concept in HCM

.. and much more!

Who this course is for:

Fusion Cloud Functional & Technical Consultants

ERP (EBS/Peoplesoft/ JDE) Consultants

Programmers/ Developers

Freshers Who wants to enter into Oracle Cloud Technologies

Who this course is for:

Beginers Who are looking for Opportunity in Oracle Cloud Technical
People who are working in Oracle Fusion Cloud as Functional wants to become as Technical Consultant
People who are working as Oracle Fusion HCM Functional Consultant
Oracle Fusion Cloud HCM Payroll , OTL , ORC Consultant

Oracle Fusion Cloud HCM Technical(BI Reports Development)

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 8min

Oracle Fusion Cloud Fundamentals ( For Beginners)7 lectures • 1hr 53min

Oracle Fusion Cloud HCM Introduction & BI Reports Introduction19 lectures • 5hr 57min

Fusion Cloud HCM Reports Excel Template Developments2 lectures • 37min

Oracle Fusion cloud HCM Absence Management Technical Reports and Development7 lectures • 1hr 11min

Oracle Fusion Cloud HCM BI Report Bursting2 lectures • 36min

Oracle Fusion Cloud HCM Payroll Data Model , Tables , Joins , Queries , Reports8 lectures • 1hr 39min

Oracle Fusion Cloud OICS Introduction and BI Reports Integration1 lecture • 10min

Requirements

Description

Who this course is for: