Oracle Fusion Technical Online Training - Trio Tech Software Trainings

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:

  1. Data Load and Migration
  2. Data Extraction and Reports
  3. Application Integration
  4. Security and Approvals
  5. Customizations


What you will Learn?

COURSE SYLLABUS

  1. Getting Started with BI Publisher
    1. What is BI?
    2. Features of BI?
    3. Benefits of BI
    4. Components of BI Reports
    5. Tools required for BI Report Development
    6. Overview of Fusion Tables
      1. Accessing Table Repository
      2. HCM Table Normalizations
      3. Key HCM Tables
        1. Type of Tables
        2. Understanding – Date Tracking
        3. Understanding Joins
    7. Basics of SQL (Structured Query Language)
      1. Query Structure
      2. Column & Rows Restriction
      3. Joins
      4. Sub-Query
  2. BI Report in Cloud Application
    1. Roles required to build BI Report
    2. Introduction to BI Data Model
    3. Overview of Delivered BI Reports
    4. Different Data Sets
      1. CSV
      2. Excel
      3. SQL
      4. Web Service
    5. Data Sets Grouping
      1. Using Subquery
      2. Group Based
      3. Element Based
    6. Report Templates and its importance
      1. Dynamic Auto Generated
      2. Rich Text Format (RTF)
      3. Excel Based
      4. E-text Based
    7. Creating Parameterized Reports
      1. Single Parameter
      2. Multiple Parameters
      3. LOV based Parameters
      4. Dependent Parameters
    8. Parameter Properties
      1. Label, Data Types, Ordering
      2. Mandatory Parameters
      3. Defaulting Data Parameter
    9. Reports based on Secured Views
      1. Secured Views
      2. User or Role Based Access
      3. Password Protected Reports
        1. Static Password
        2. Dynamic Password
    10. Language Translation Feature in BI Reports
    11. Report Migration
  3. Report Bursting
    1. Concept and Use Case
    2. Type of Bursting
      1. Email
      2. FTP
      3. UCM
    3. Bursting Query
      1. Understanding Parameters
      2. Building Bursting Query
      3. Enabling Bursting
    4. Admin Configuration and Settings
    5. Real Time Business Case
      1. Dynamic Bursting File Name
      2. Password Protected Files
      3. Encrypted File
      4. Additional Default Attachment
  4. Scheduled Jobs
    1. Navigation and Overview of Schedule Jobs
    2. Useful Seeded Jobs
    3. Creating Custom Scheduled Jobs for BIP Report
      1. No Parameter
      2. Single Parameter
      3. Multiple Parameter
      4. Date Parameter
    4. Reading Log and Output Files of Custom Scheduled Job
    5. Enabling and Sending Notification of a Scheduled Job
    6. Submitting a Scheduled Job
    7. Enabling Security in a Scheduled Job
  1. Getting Started with OTBI
    1. Introduction of OTBI
    2. Different types of Subject Area
      1. Presentation Folders
      2. Dimensions
      3. Attributes
  2. Navigation and Components
    1. Creating First OTBI Analysis from UI
    2. Creating a simple OTBI Analysis from BI Server
      1. Single Subject Area
      2. Multiple Subject Area
  3. Understanding Analysis Properties
    1. Label Format
    2. Ordering
    3. Adding Filters
    4. Font and Formatting
  4. Prompts & Dashboards
    1. Parameters & Prompts
    2. SET Operations in OTBI Analysis
    3. Agents and their Usage
    4. Dashboard
  5. Understanding Views
    1. Adding Views
      1. Tabular
      2. Graphical
        1. Bar Graph
        2. Pie Chart
        3. Line Graph
  6. Managing Analysis
    1. Import and Migration
  1. HCM Extract Overview & Advantages
  2. Use and Type of User Entities
  3. Oracle Delivered Seeded Extracts
    1. Running
    2. Clone/Coping
  4. Extract Phases
    1. Define
    2. Design
    3. Validate
    4. Delivery
  5. Extract Components
    1. Parameters
    2. Blocks
    3. Block Links
    4. Records
    5. Filters (Basic and Advance)
    6. Data Elements
      1. DBI Based
      2. Extract Rule FF
      3. Record Calculation
      4. Static Value
      5. Parameters
  6. Extract Validation & Compilation
  7. Running Extracts
    1. Scheduling Extract
    2. Using Schedule Fast Formula
  8. Extract Delivery Options
    1. None
    2. CSV
    3. UCM
    4. FTP
    5. Integration with BIP
  9. Extract Fast Formula
    1. Extract Rule
    2. Extract Criteria
    3. Flow Schedule
    4. Extract Record
  1. HCM Data Loader Overview
  2. Role and Navigations
  3. Data File preparation in HDL Format
    1. Zip File Structure
    2. Dat File Structure
    3. File Line Instruction Tags
    4. File Discriminators
    5. Line Structure
    6. Line Ordering
    7. Metadata Line Validation
    8. Data Line Validation
  4. Supported Keys and Overview
    1. User Key
    2. Surrogate Keys
    3. GUID Keys
    4. Source System Keys
  5. Execute HCM Data Loader (HDL) process
    1. Work Structures
      1. Job Family
      2. Job
      3. Grade
      4. Location
    2. Loading Worker – Mandatory Business Objects
    3. Loading Worker – Non-Mandatory Business Objects
    4. Employee Transactions
      1. Terminate Employee
      2. Reverse Terminate
      3. Load Salary
    5. Loading Translations
    6. Deleting Data
    7. End Dating Data
  6. Seeded Business Process
    1. Manager Hierarchy
    2. Name Keyword Search
  7. Error Handling and Reconciliation
  1. HCM Spreadsheet Data Loader Overview
  2. Using Seeded HCM Spread Sheets for data load.
    1. Lookups
    2. Jobs
  3. Data file preparation in HSDL format
  4. Execute HCM Spreadsheet Data Loader (HSDL) process
  5. Error handling and reconciliation
  1. Approval Management Overview
  2. Approvals and Transaction Console Overview
  3. Understand how to enable or bypass approvals for different scenarios
  4. Write business rules for approvals
  5. Configure Approvals using different combinations of business rules
  6. Real-time scenarios are used to test the approvals and notifications.
    1. Creating or Updating Work Structure
    2. Performing Employee Transactions
  1. What is Web Service
  2. Understanding XML and JSON
  3. Web Service Basics
  4. Explore seeded SOAP/REST services provided by Oracle
  5. Use SOAP/REST services to import/export data from Fusion Cloud
  6. Basis of OIC (Oracle Integration Cloud)
  • 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

Register for Free Demo

0 +
Students Trained
0 +
Batches
0 +
Instructors
0 %
Success Rate


CHOOSE THE TRAINING THAT’S BEST FOR YOU

Triotech Software Trainings
Triotech Software Trainings
Triotech Software Trainings


Oracle Fusion Technical Training- UPCOMING EVENTS

Online

Regular
  • Batch Starting Soon
  • 07:00 AM IST
Register Now

Corporate

Weekend
  • Batch Starting Soon
  • 07:00 AM IST
Register Now

Classroom

Fasttrack
  • 07:00 AM IST
  • Batch Starting Soon
Register Now

Weekend

Week Day
  • Batch Starting Soon
  • 07:00 AM IST
Register Now

Register for Free Demo


CERTIFICATION

Triotech Software Trainings


reviews

Leave a Comment