Fusion Technical

Demos 

Click Here for Demo Sessions(3 Sessions)

Course Content

Module-1: Introduction to Fusion Technical

• Introduction to Fusion Technical

Module-2: Oracle ERP Vs Fusion Cloud

• Difference Between oracle EBS ERP and Cloud ERP

Module-3: Enterprise Structure Creation

• ESC Creation In Fusion

Module-4: Value Sets

Module-5: Lookups

Module-6: Flex Fields

• DFF
• KFF
• EFF

Module-7: Workflow Configurations

Module-8: Approval Process

Module-9: Fast Formulas

Module-10: Security

• Overview of Security Profiles Roles, Duties & Privileges

Module-11: Data Loading

• Overview of Data Loaders (SDL, FBL, HDL, PBL)

Module-12: Data Loading(Inbound)

• HDL Configurations and Process flow and the Preparations

Module-13: Data Loading(Inbound)

• Spread Sheet Configurations

Module-14: Data Extraction(Outbound)

• User Entities HCM Extraction Flow

Module-15: Data Extraction(Outbound)

• BI Report Design
• HCM Extraction Design
• HCM Extract Execution and Schedule

Module-16: BI Reports

• SQL Quires
• HCM Data Model
• BI Report Process
• BI Design

Module-17: OTBI Reports

• Shared Areas
• Understand Module Shared Areas
• OTBI Dashboard Prepared
• Customization Standard Dashboards
• OTBI Analysis

Module-18: BI/OTBI Reports

• Security On Reports

Module-19: Personalization’s

• ADF Personalization’s SandBox

Module-20: Web Services

• Fusion SOAP Webservices

 

Tools Used 

1. Notepad++ — https://notepad-plus-plus.org/
2. Postman —  Click Here to download plugin (Updated as on 29-Aug-2023) 
3. Soap UI— 
4. Oracle BI Publisher DeskTop plugin for Windows-- Click Here to download plugin (Updated as on 29-Aug-2023)
5. ADFDI Plugin -- Click Here to download plugin (Updated as on 29-Aug-2023)
6. SQL Developer 

Topics: 

Implementation Users

Overview of Infolets and Infotiles in Oracle Fusion Applications

Set Default Value for Date Parameter in BIReport

Bind Parameters -LOV with ALL options with multiple selection

Cycles 

Procure2pay 

Order2 Cash

fusion-tca-om-shipment-Scripts

Flexfields

1. Flexfields -Differences
2. Descriptive Flexfields (DFF)
3. Extensible Flexfields (EFF)
4. Key Flexfields (KFF) 

SandBox Personalizations

1. Field Customization eg. Hide,Unhide,Required,Read only
2. Access Report Via Infolet
3. Steps to change the field label on the Fusion Applications page.
   

SandBox Customizations

Standard Reports Customization 

Report	View	Download
PO PDF	View	Download
Account Analysis	View	Download
Payslip Report -HCM	View
Oracle Fusion Payables Predefined Reports	View

Reports Development -Custom Reports 

Report	View	Module
GL Report	View	GL
GL JE Created after last Reval Report	View	GL
Customer Statement Report	View	AR
Commission For Agent Report	View	AR
TAT Expense Report	View	CM
Negative Bank Balance Report -GL-Bursting	View	GL
PDH-Item FUTURE_HIERARCHY EFF Attribute Report-Bursting -Ess Job	View	PDH
Get UCM Content ID Report --PDH-Used in outbound integration	View	PDH
Inventory Transactions Report - INV/Excel	View	INV
GRN Dump Report/PO Register Report - PO, Receipts, PO - Excel	View	PO, Receipts, AP

Reports Security 

BIP --Fusion HCM --How Can A BI Publisher Report Based On A SQL Query Use The Security Roles In Fusion Applications?

BIP -Report Security Data access using SQL Query 

BIP-Custom User Role and Privileges SQL Queries

Data Migrations

Documentation 

FDD

MD50  for AR 

TDD