Enter your keyword

Oracle Fusion Technical with Oracle Integration Training

Oracle Fusion technical with Oracle Integration

Oracle Fusion Applications are enterprise resource planning software applications from Oracle Corporation. Oracle Fusion Cloud Applications is the world’s most complete, connected SaaS suite. Oracle Fusion Cloud gives clients the power to adapt business models and processes quickly so that they can reduce costs, sharpen forecasts, and innovate more.

What you will learn

  • Understand Fusion Cloud Application, Navigation, and Technical Terminologies 
  • Explore In Depth various reporting options available in Cloud – BIP, OTBI, Smart View (basics)
  • Build Inbound Integrations using various loader options – FBDI, SDL and HCM Data Loader
  • Build HCM Extracts, Fast Formulas, BPM Approvals and Notifications
  • Using Sandboxes to customize UI in fusion applications
  • Build Outbound Integrations using BIP, HCM Extracts and SOAP/REST Web Services
  • Certification guidance and help you with Resume & Interview Preparation
  • Understanding of Oracle Integration
  • Development and deployment of Integrations using Oracle Integration


    Training Course Structure

    Course Outline

    • Course Content Overview 
    • Introduction to Oracle ERP Cloud
    • Oracle Cloud Application Product Families
    • Type of Projects & Consultants
    • Architecture of Oracle Cloud Application
    • Data Loading (Inbound Integrations) into Cloud
    • Data Extraction (Outbound Integrations) from Cloud
    • Cloud Reporting Tools – BI, OTBI, FRC
    • Fusion Customization & Personalization
    • Fusion Security in cloud – Role Based Access Control
    • Workflows in Fusion Application

    • Navigation in Oracle Cloud applications
    • News Feed home page layout
    • Banner Layout
    • How to switch between layouts
    • Predefined themes for home page layout
    • Understanding Application Security – 3 W Security Concept
    • Understanding Security Console – User, Roles, and Security Profiles
    • Basic Tools & Utilities – Preferences, File Import, UCM Server
    • Basic Navigation – Search & Edit Person Record, Creating Invoice

    • Introduction to BIP reports
    • Understand Report Use Case and Basic Navigations
    • Build Data Model for dynamic data source using SQL Data Sets
    • Build Data Model for dynamic data source using multiple SQL Data Sets
    • Build Data Model for dynamic data source using different grouping concepts
    • Build Data Model for static data source using CSV, Excel, CSV Data Sets
    • Build Data Model using parameters and defaulting parameter values
    • Building Report – using Wizard
    • Building Report – Auto Generated Report Layout and finetune it as per client output
    • Building Report – using custom RTF layout from scratch
    • Building Report – using custom eText layout from scratch
    • Building Report – using custom Excel layout from scratch
    • Understand Bursting Concepts and Implement XML Bursting in BIP Report
    • Burst BI Report output to FTP, UCM, and Email
    • Understand how PGP encryption works and Set up SFTP server in BI
    • Burst report output, encrypt it using PGP and deliver it in UCM
    • How to give access of BIP report to others and migrate them
    • Registering and executing BIP Report as Payroll Flow
    • Registering and executing BIP Report as ESS Job
    • How to give access of custom ESS Jobs to users
    • Understand steps involved in customizing seeded BIP report
    • Customize seeded BIP report
    • Deploy and test the report

    • Advantages and Limitation of OTBI over BI Publisher Reports
    • Understand OTBI components Subject Areas, Dimensions and Attributes
    • Understanding Filters, Table Prompts, Sections, Prompts
    • Understanding Table and Column Properties
    • Build OTBI Report through wizards
    • Build OTBI Detail report to order invoice, supplier, and their site details
    • Build OTBI Detail report to print employee and their assignment details
    • Build OTBI Summary report to print report output in graphical format
    • Build OTBI calling Fusion Forms from Reports using Interactions
    • Build OTBI Master Details Reports using Interactions
    • Understand and use Action Links to drill down and navigate to BI Components
    • Understand Column and View Selector
    • Understand Compound Layouts
    • Understand and Schedule OTBI Reports using Agents
    • Understand Dashboards and Usage
    • Build OTBI Dashboard and plug in above created reports
    • Build OTBI Dashboard with Multiple Tabs 
    • Adding BI Publisher Report to OTBI Dashboard
    • How to Deploy and Migrate OTBI reports

    • HCM Data Loader Overview
    • Roles required to access HCM Data Loader
    • Understand HDL Data Loading Process
    • Understand HCM Configuration Properties
    • Understand available Keys in HCM Data Loader
    • Data file preparation in HDL format for Creating Work Structures
    • Data file preparation in HDL format for Creating Worker (mandatory business objects)
    • Data file preparation in HDL format for Creating Worker (non-mandatory business objects)
    • Data file preparation in HDL format for Creating Element Entry
    • Data file preparation in HDL format for uploading Person Images 
    • Data file preparation in HDL format for uploading Document of Records
    • Uploading Translations for Business Objects
    • Updating Business Object using User Key
    • Execute HCM Data Loader (HDL) process for Error handling and reconciliation

    • HCM Spreadsheet Data Loader Overview
    • Using Oracle provided HSDL for Creating and Updating Job Details
    • Execute HCM Spreadsheet Data Loader (HSDL) process
    • Error handling and reconciliation
    • Custom Data Template preparation in HSDL format for Worker Load
    • Custom Data Template preparation in HSDL format for Element Entry Load

    • SDL Overview
    • Data file preparation in SDL format
    • Download and Installation ADFDi 
    • Excel Properties and Settings
    • Create and Update Invoices using SDL 
    • Execute Spreadsheet Data Loader (SDL) process
    • Error handling and reconciliation

    • FBDI Overview
    • Understanding Data file preparation in FBDI format
    • Business Case – Creating Suppliers, Suppliers Sites, Address, Contacts, Banks etc. 
    • Understand and Execute File Based Data Import (FBDI) seeded business process

    • Approval Management Overview
    • Approvals and Transaction Console Overview
    • Understand how to enable or bypass approvals for different scenarios
    • Writing custom business rules for approvals for creating Jobs
    • Configure Approvals using different combinations of business rules
    • Test the approvals and notifications using real time scenarios

    • Introduction to Sandboxes
    • Overview and Accessing Fusion Applications UI
    • Understand options to extend/customize/personalize Fusion Application
    • Make changes in UI with sandbox – Ex: Make fields required/read only/hidden
    • Registering and executing BIP Report as One Click through Navigator or Springboard
    • Use expression language to write complex conditional logic

    • Fast Formula overview
    • Fast Formula syntax and structure
    • Writing basic fast formulas – HDL Transformation Fast Formula
    • Building complex fast formulas and Common compilation errors
    • Using fast formulas in fusion applications

    • Overview of HCM Extracts
    • Understand HCM Extract Screens and Navigation
    • Understand HCM Extract Components
    • Understand Submit, Copy, Deactivate, Import and Export
    • Understand User Entities and Data Base Identifiers (DBI)
    • Run Seeded Oracle Provided HCM Extracts
    • Design and Create complex HCM Extracts from scratch
    • Use multiple data groups, filter criteria, record groups and attributes in HCM extracts
    • Configure Extract Output and Delivery Options to deliver HCM Extract in UCM
    • Explore User Entities and other options in HCM Extracts
    • Create and use fast formulas in HCM Extracts
    • Build an incremental HCM Extract – most common use case in real time

    • Overview of Oracle Integration and it’s feature
    • Understanding of Oracle Integration terminologies
    • Understanding of Integration Styles
    • Understand of different type Adapters
    • Understanding and creating Lookups
    • Understanding and working with projects
    • Understanding and creating libraries
    • Understanding of integration development workflow
    • Develop and deploy first integrations
    • Understand Parameters, Request Payload, Response Payload
    • Understanding of Integrations Actions such as  Loggers, Notifications ,Loop, Parallel, Stitch, etc. 
    • Understand Data Stich and Stage File Operations – Read, Write, Zip, Unzip
    • Understanding and using FTP File Operations – Read, Write, Delete, Download, Move
    • Understand and using ATP Operations – Insert, Update, Delete
    • Understand Exception Handling – Fault Tolerance, Global Handling, Throw Exception
    • Building Complex Integration – end to end (stitching all components together)

    Training Details

    Training Schedule

    Timings: 06:30 to 08:30 PM IST / 09:30 to 12:00 PM EST

    Days: Saturday and Sunday

    Total Duration: 45 hours

    Start Date: 27th Jul

    Mode: Online