Fusion Technical

Demos 

Click Here for Demo Sessions(3 Sessions)

Demo by Samba 

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 

Click here ==>>  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

 Custom Report Scripts by samba (FA/AP/AR/GL/CM/Supplier)

Click here to Download Excel file

Report Name	Module	For SQL Script
FA Asset Listing Report	FA	Click Here
FA Asset Adjustment Life Method Report	FA	Click Here
FA Asset Retirement Report	FA	Click Here
FA Asset Transfer Report	FA	Click Here
FA Category Accounts Report	FA	Click Here
FA Child Assets Report	FA	Click Here
Fetch Delta data : Report Scheduled : Fetch Delta data : Fetch Incremental Data	FA/COMMON	Click Here
FA Depreciation For Selected Periods Report	FA	Click Here
FA Depreciation Methods Report	FA	Click Here
FA Depreciation Summary By Codept Report	FA	Click Here
FA Inquiry And Retired Asset Report	FA	Click Here
FA Interco Corp Book Transfer Report	FA	Click Here
FA Interco Tax Book Transfer Adjustment Report	FA	Click Here
FA Local Book Converted to USD Report	FA	Click Here
FA Location ReportFA Location Report	FA	Click Here
FA Onsemi Asset Roll Forward Report	FA	Click Here
FA Pending Mass Additions Report	FA	Click Here
AGIS Transactions Report	GL	Click Here
GL Account Analysis Bal And JE Report	GL	Click Here
GL Batch Approval With Final Approver Report	GL	Click Here
GL Cr Dr Memo Report	GL	Click Here
GL CTA Report	GL	Click Here
GL Dept Spend Details Report	GL	Click Here
GL Full Journal Entry Report	GL	Click Here
GL Interco Ar Balances Short Term Report	GL	Click Here
GL JE Created After Last Reval Report	GL	Click Here
GL Journal Entry Drilldown Report	GL	Click Here
GL S401 Balance Drilldown Report	GL	Click Here
GL Tax Trial Balance Report	GL	Click Here
GL Unapproved Batches With Approver Report	GL	Click Here
ON_GL_Balances_TO_FAP_RPT Report	GL	Click Here
Summarized TB BU Report	GL	Click Here
Summarized TB GAC Report	GL	Click Here
AR Adjustment By Selected Users REPORT	AR	Click Here
AR Aging USD EOP Daily Rates Report	AR	Click Here
AR Balance USD Theoretical DSO Report	AR	Click Here
AR Bill to Ship to Party Report	AR	Click Here
AR Cash Application By Invoice And History Report	AR	Click Here
AR Cash Application Summary Report	AR	Click Here
AR Cash Discounts Report	AR	Click Here
AR Cash Receipts Report	AR	Click Here
AR Corp Code Attributes Report	AR	Click Here
AR Credit Memo Applications Report	AR	Click Here
AR Customer Credit Check Report	AR	Click Here
AR Customer Details Credit Limits And Payment Terms Report	AR	Click Here
AR Customer Over Credit Limit Report	AR	Click Here
AR Customer Print Options Report	AR	Click Here
AR Data Fusion to EBS Report	AR	Click Here
AR Invoice Dm Cm Activity Excl Tax Lines With Cust Item Report	AR	Click Here
AR Invoice Summary By Transaction Name Report	AR	Click Here
AR Invoices with Delivery Options Report	AR	Click Here
AR Open Items BU Report	AR	Click Here
AR Open Items Invoices And Payment Hist Report	AR	Click Here
AR Open Items Invoices and Payment Hist with Partnum Report	AR	Click Here
AG Pending Interface Transactions Report	AP	Click Here
AP Acct Analysis Invoices Posted To Acct 21210 Report	AP	Click Here
AP Credit Card Transactions Report	AP	Click Here
AP EBTax Tax Rates Report	AP	Click Here
AP EBTAX US State Registration Report	AP	Click Here
AP Expense Invoice Report	AP	Click Here
AP Inquiry Report	AP	Click Here
AP Invoice and PO Details for Selected PO Dept Report	AP	Click Here
AP Invoice Journal Details Report	AP	Click Here
AP Invoices Payment Report	AP	Click Here
AP Invoices Status Report	AP	Click Here
AP Netting Suppliers Report	AP	Click Here
AP Onsemi Payment Distribution Report	AP	Click Here
AP Paid Capital Invoices Report	AP	Click Here
AP Payables Option Report	AP	Click Here
AP Payment SLA Accounting Report	AP	Click Here
AP Payment Terms Report	AP	Click Here
AP Philippines WHT Invoice Print Report	AP	Click Here
AP Posted Invoice By Vendor and Match Type Report	AP	Click Here
AP Prepayment With Inv Dist Report	AP	Click Here
AP Prepayment With Open Balances Report	AP	Click Here
AP PrePayments Report	AP	Click Here
AP RCV Accrual vs AP Invoice Report	AP	Click Here
AP Receiving SLA Accounting Report	AP	Click Here
AP Receiving Transactions For Inventory Report	AP	Click Here
AP Recon Report	AP	Click Here
AP Recurring PO DUP Invoices Report	AP	Click Here
AP Remit Email Address for EFT Vendor Site Report	AP	Click Here
AP Return To Vendor Transactions Report	AP	Click Here
AP Sales Tax Self Audit Report	AP	Click Here
AP Supplier Bank Accounts At Header Level Report	AP	Click Here
AP Supplier Bank Accounts Report	AP	Click Here
AP Supplier List Report	AP	Click Here
Supplier Master data Report -- Interface to Sync supplier master data from Cloud to EBS - Delta Data using parameters Date range with timestamp	Procurement	Click Here

Supplier Sync Report from Cloud to EBS

 -Delta Data using Date range with timestamp

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