This course will help you to learn and build strong technical competency in Oracle Fusion HCM Applications. After completing this course, you should be able to present yourself as skilled and experienced Fusion HCM Technical consultant who can understand simple or complex business requirements and propose technical solutions. At a very high level the work performed by a technical consultant and associated technologies/tools can be classified as below:
- Data Load and Migration
- Data Extraction and Reports
- Application Integration
- Security and Approvals
- Customizations
What you will Learn?
- Learn about the Fusion Cloud Application, Navigation, and Functional Setup Manager.
- Understand Security in Fusion Cloud Application through Role Based Access Control
- Explore In Depth various reporting / data extraction techniques available in Fusion HCM Cloud – BIP, OTBI, HCM Extract
- Build Inbound Integrations using various loader options – SDL and HCM Data Loader
- Build HCM Extracts and using Fast Formulas,
- Design Custom Workflow Approvals and Notifications
- Utilizing Sandboxes to Customize the User Interface in Fusion Application
COURSE SYLLABUS
Data Extraction – Business Intelligence Publisher Reports
- Getting Started with BI Publisher
- What is BI?
- Features of BI?
- Benefits of BI
- Components of BI Reports
- Tools required for BI Report Development
- Overview of Fusion Tables
- Accessing Table Repository
- HCM Table Normalizations
- Key HCM Tables
- Type of Tables
- Understanding – Date Tracking
- Understanding Joins
- Basics of SQL (Structured Query Language)
- Query Structure
- Column & Rows Restriction
- Joins
- Sub-Query
- BI Report in Cloud Application
- Roles required to build BI Report
- Introduction to BI Data Model
- Overview of Delivered BI Reports
- Different Data Sets
- CSV
- Excel
- SQL
- Web Service
- Data Sets Grouping
- Using Subquery
- Group Based
- Element Based
- Report Templates and its importance
- Dynamic Auto Generated
- Rich Text Format (RTF)
- Excel Based
- E-text Based
- Creating Parameterized Reports
- Single Parameter
- Multiple Parameters
- LOV based Parameters
- Dependent Parameters
- Parameter Properties
- Label, Data Types, Ordering
- Mandatory Parameters
- Defaulting Data Parameter
- Reports based on Secured Views
- Secured Views
- User or Role Based Access
- Password Protected Reports
- Static Password
- Dynamic Password
- Language Translation Feature in BI Reports
- Report Migration
- Report Bursting
- Concept and Use Case
- Type of Bursting
- FTP
- UCM
- Bursting Query
- Understanding Parameters
- Building Bursting Query
- Enabling Bursting
- Admin Configuration and Settings
- Real Time Business Case
- Dynamic Bursting File Name
- Password Protected Files
- Encrypted File
- Additional Default Attachment
- Scheduled Jobs
- Navigation and Overview of Schedule Jobs
- Useful Seeded Jobs
- Creating Custom Scheduled Jobs for BIP Report
- No Parameter
- Single Parameter
- Multiple Parameter
- Date Parameter
- Reading Log and Output Files of Custom Scheduled Job
- Enabling and Sending Notification of a Scheduled Job
- Submitting a Scheduled Job
- Enabling Security in a Scheduled Job
Data Extraction - Oracle Transactional Business Intelligence (OTBI)
- Getting Started with OTBI
- Introduction of OTBI
- Different types of Subject Area
- Presentation Folders
- Dimensions
- Attributes
- Navigation and Components
- Creating First OTBI Analysis from UI
- Creating a simple OTBI Analysis from BI Server
- Single Subject Area
- Multiple Subject Area
- Understanding Analysis Properties
- Label Format
- Ordering
- Adding Filters
- Font and Formatting
- Prompts & Dashboards
- Parameters & Prompts
- SET Operations in OTBI Analysis
- Agents and their Usage
- Dashboard
- Understanding Views
- Adding Views
- Tabular
- Graphical
- Bar Graph
- Pie Chart
- Line Graph
- Adding Views
- Managing Analysis
- Import and Migration
Data Extraction - HCM Extracts
- HCM Extract Overview & Advantages
- Use and Type of User Entities
- Oracle Delivered Seeded Extracts
- Running
- Clone/Coping
- Extract Phases
- Define
- Design
- Validate
- Delivery
- Extract Components
- Parameters
- Blocks
- Block Links
- Records
- Filters (Basic and Advance)
- Data Elements
- DBI Based
- Extract Rule FF
- Record Calculation
- Static Value
- Parameters
- Extract Validation & Compilation
- Running Extracts
- Scheduling Extract
- Using Schedule Fast Formula
- Extract Delivery Options
- None
- CSV
- UCM
- FTP
- Integration with BIP
- Extract Fast Formula
- Extract Rule
- Extract Criteria
- Flow Schedule
- Extract Record
Data Loading - HCM Data Loader
- HCM Data Loader Overview
- Role and Navigations
- Data File preparation in HDL Format
- Zip File Structure
- Dat File Structure
- File Line Instruction Tags
- File Discriminators
- Line Structure
- Line Ordering
- Metadata Line Validation
- Data Line Validation
- Supported Keys and Overview
- User Key
- Surrogate Keys
- GUID Keys
- Source System Keys
- Execute HCM Data Loader (HDL) process
- Work Structures
- Job Family
- Job
- Grade
- Location
- Loading Worker – Mandatory Business Objects
- Loading Worker – Non-Mandatory Business Objects
- Employee Transactions
- Terminate Employee
- Reverse Terminate
- Load Salary
- Loading Translations
- Deleting Data
- End Dating Data
- Seeded Business Process
- Manager Hierarchy
- Name Keyword Search
- Error Handling and Reconciliation
Data Loading - HCM Spread Sheet Data Loader
- HCM Spreadsheet Data Loader Overview
- Using Seeded HCM Spread Sheets for data load.
- Lookups
- Jobs
- Data file preparation in HSDL format
- Execute HCM Spreadsheet Data Loader (HSDL) process
- Error handling and reconciliation
Business Approvals
- Approval Management Overview
- Approvals and Transaction Console Overview
- Understand how to enable or bypass approvals for different scenarios
- Write business rules for approvals
- Configure Approvals using different combinations of business rules
- Real-time scenarios are used to test the approvals and notifications.
- Creating or Updating Work Structure
- Performing Employee Transactions
Integration
- What is Web Service
- Understanding XML and JSON
- Web Service Basics
- Explore seeded SOAP/REST services provided by Oracle
- Use SOAP/REST services to import/export data from Fusion Cloud
- Basis of OIC (Oracle Integration Cloud)
Practical Examples
- Creating Data Sets based on various data sources (SQL, XLS, CSV, Webservice)
- Create a Simple Data Model using multiple SQL Data Sets
- Creating parameterized Data Model
- Creating Dependent Parameters in Data Model
- Developing a Data Model with necessary and optional parameters
- Associating a LOV with parameter
- Creating a Simple BI Report
- Creating RTF Template
- Creating Excel Template
- Creating E-Text Template
- BI Bursting – Email and UCM
- Creating Security enabled BI Report
- Creating letter format reports
- BI Report encapsulated in ESS Job
- Running an ESS Job
- Sending Report output via email
KEY FEATURES
- 60 Hrs Instructor Led Training
- Certification & Job Assistance
- 25 hrs of Lab Sessions
- Pay in 2 Installments
- Interview Questions & Answers
- 24 x 7 Lifetime Support
Register for Free Demo
PROJECTS
- To test your knowledge on Oracle Fusion Technical Training, you will be required to work on two industry-based projects that discuss significant real-time use cases. This will also ensure hands-on expertise in Oracle Fusion TechnicalOnline Training concepts.
- These projects are completely in-line with the modules mentioned in the curriculum.
CHOOSE THE TRAINING THAT’S BEST FOR YOU
- Learn at your convenient time and pace
- Gain on-the-job kind of learning experience through high quality Oracle Fusion Technical videos built by industry experts.
- Learn end to end course content that is similar to instructor led virtual/classroom training.
- Explore sample Oracle Fusion Technical training videos before signing up.
- Live demonstration of features and practicals.
- Get LMS access of each Oracle Fusion Technical Online training session that you attend through GotoMeeting.
- Gain guidance on certification.
- Explore sample Oracle Fusion Technical training videos before signing up.
- Self-Paced/Live Online/Classroom modes of training available.
- Engage in Oracle Fusion Technical Classroom Training lecture by an industry expert at your facility.
- Learn as per full day schedule with discussions,exercises and practical use cases.
- Design your own course content based on your project requirements.
- Gain complete guidance on certification.
Oracle Fusion Technical Training- UPCOMING EVENTS
Register for Free Demo
CERTIFICATION
reviews
I Enjoyed Every Lesson!
Undoubtedly the best place for Oracle courses..I did my Oracle HCM course from here and was much satisfied..The indepth details provided by the Instructor gives a clear outlook to the course,also the timely clarification of any problem faced during implementation in a demo environment is top class...I would like to thank them for giving such a top clarity in Oracle ERP.....
Surya Kumar
Fantastic! Great instructor!
Good quality content and delivery of training. Kumar of Trio Tech is an excellent trainer with Fusion product knowledge and industry insight.
Andrew Sikuku
I'm learning Oracle fusion HCM technology here. Faculty is Kumar Sir.He is just awesome. If you want to learn advance level then you go to his classes. and the notes he is giving is very useful for cracking the interview easily. and if u miss any class of him he is take a backup class. the way he interacts with students. Hope this review help you.
Mohammad Gouse
If you are looking for Oracle Fusion HCM, then kumar sir is the best faculty in Trio Tech. He is a knowledge bank. He has high professionalism. He will teach you from scratch to very advance level. It's a Worth learning from him. He is an outstanding trainer I have ever seen.
Emmanuel Madhukar
One of the BEST institute in Hyderabad for Oracle. This institute has a well experienced faculty when compared to others in Hyderabad. After lots of research I have joined in this institute considering all the plus points here.
Damodharan Reddy
Excellent Training On Oracle Fusion HCM by Kumar. The way of his explanation is very clear and anyone can understand very easily. I am sure no one else can explain like him. He is the Best. If anyone is planning to learn HCM can join in Trio Tech without thinking.
Ravindra B
Good experience in triotech... And now I am very confident to say that I was ready for interview. .very responsible it's pleasure to be here
ramakrishna k
The best coaching institute, specially would like to mention Mr. Kumar one of the best faculty ever seen. He monitor, guide and make every one learn. I personally seen many success stories of his students.
Shanmukhsai Garapati
Excellent teaching by Mr. Kumar sir. He gave easy process to understand. Automatically build a Confidence that we can get a job by hearing Oracle HCM class . Thank you very much for your Valuable Guidance
yashwanth reddy
Trio Tech technologies is one of the best institute's in Hyderabad with very good teaching staff (Kumar sir) for (Oracle fusion HCM)they teach with many examples and detailed explanation on every topic's.
praveen p
Excellent training institution! Just completed my training on Oracle Fusion HCM. Presentation was clear & easy to follow and the materials given are rich and useful.
Chânduluri Arjun Chøwdâry
After a lot of research i choose to join triotech for fusion scm training.i found it’s value for money and all the trainers are having decade experience and covers real time scenarios faced in their implementations.i strongly recommend this place when compared to others
Mounisha enturi
I am from pune and my friend joined for Oracle technical training at triotech. Excellent communication and technical support for trainees. Thank you so much triotech for giving us the real time experience
PALLERLA SHANKAR
hey I’m from Bengaluru...I’ve joined fusion Hcm online course at Triotech software trainings... Training sessions are really appreciable & worth to join.... Institute provide videos with good quality with immediately access after classes & has latest instance access to practice....
sree ram
I am glad to learn oracle financials in triotech software trainings before coming to this institute i joined other institutes but i didn't get a job because of lack of proper guidance there..thank you so much triotech you are a life saving one
Soumya Enturi
One of best institute to grow yourself strong on technical aspects from foundation to expertise level specifically to get practical exposure and creates a path to become industry expert ..I can confidently mention this that everyone who attends the training will for sure add this institute in their recommended list for all. Special thanks to efforts and enthusiasm of Mr.Kumar for his teaching to take the institute to next level to get industry experts
