Fusion Technical

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: 

Excel for Interviews --Click Here to Download

Data Collection -P2P O2C Entities 


Cycles 
Procure2pay 

Click here ==>>  Order2 Cash





Flexfields



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 

 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

Bar Code Report

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



SNOReport NameModuleFor SQL Script
1FA Asset Listing ReportFAClick Here
2FA Asset Adjustment Life Method ReportFAClick Here
3FA Asset Retirement ReportFAClick Here
4FA Asset Transfer ReportFAClick Here
5FA Category Accounts ReportFAClick Here
6FA Child Assets ReportFAClick Here
7Fetch Delta data : Report Scheduled : Fetch Delta data : Fetch Incremental DataFA/COMMONClick Here
8FA Depreciation For Selected Periods ReportFAClick Here
9FA Depreciation Methods ReportFAClick Here
10FA Depreciation Summary By Codept ReportFAClick Here
11FA Inquiry And Retired Asset ReportFAClick Here
12FA Interco Corp Book Transfer ReportFAClick Here
13FA Interco Tax Book Transfer Adjustment ReportFAClick Here
14FA Local Book Converted to USD ReportFAClick Here
15FA Location ReportFA Location ReportFAClick Here
16FA Onsemi Asset Roll Forward ReportFAClick Here
17FA Pending Mass Additions ReportFAClick Here
18AGIS Transactions ReportGLClick Here
19GL Account Analysis Bal And JE ReportGLClick Here
20GL Batch Approval With Final Approver ReportGLClick Here
21GL Cr Dr Memo ReportGLClick Here
22GL CTA ReportGLClick Here
23GL Dept Spend Details ReportGLClick Here
24GL Full Journal Entry ReportGLClick Here
25GL Interco Ar Balances Short Term ReportGLClick Here
26GL JE Created After Last Reval ReportGLClick Here
27GL Journal Entry Drilldown ReportGLClick Here
28GL S401 Balance Drilldown ReportGLClick Here
29GL Tax Trial Balance ReportGLClick Here
30GL Unapproved Batches With Approver ReportGLClick Here
31ON_GL_Balances_TO_FAP_RPT ReportGLClick Here
32Summarized TB BU ReportGLClick Here
33Summarized TB GAC ReportGLClick Here
34AR Adjustment By Selected Users REPORTARClick Here
35AR Aging USD EOP Daily Rates ReportARClick Here
36AR Balance USD Theoretical DSO ReportARClick Here
37AR Bill to Ship to Party ReportARClick Here
38AR Cash Application By Invoice And History ReportARClick Here
39AR Cash Application Summary ReportARClick Here
40AR Cash Discounts ReportARClick Here
41AR Cash Receipts ReportARClick Here
42AR Corp Code Attributes ReportARClick Here
43AR Credit Memo Applications ReportARClick Here
44AR Customer Credit Check ReportARClick Here
45AR Customer Details Credit Limits And Payment Terms ReportARClick Here
46AR Customer Over Credit Limit ReportARClick Here
47AR Customer Print Options ReportARClick Here
48AR Data Fusion to EBS ReportARClick Here
49AR Invoice Dm Cm Activity Excl Tax Lines With Cust Item ReportARClick Here
50AR Invoice Summary By Transaction Name ReportARClick Here
51AR Invoices with Delivery Options ReportARClick Here
52AR Open Items BU ReportARClick Here
53AR Open Items Invoices And Payment Hist ReportARClick Here
54AR Open Items Invoices and Payment Hist with Partnum ReportARClick Here
55AG Pending Interface Transactions ReportAPClick Here
56AP Acct Analysis Invoices Posted To Acct 21210 ReportAPClick Here
57AP Credit Card Transactions ReportAPClick Here
58AP EBTax Tax Rates ReportAPClick Here
59AP EBTAX US State Registration ReportAPClick Here
60AP Expense Invoice ReportAPClick Here
61AP Inquiry ReportAPClick Here
62AP Invoice and PO Details for Selected PO Dept ReportAPClick Here
63AP Invoice Journal Details ReportAPClick Here
64AP Invoices Payment ReportAPClick Here
65AP Invoices Status ReportAPClick Here
66AP Netting Suppliers ReportAPClick Here
67AP Onsemi Payment Distribution ReportAPClick Here
68AP Paid Capital Invoices ReportAPClick Here
69AP Payables Option ReportAPClick Here
70AP Payment SLA Accounting ReportAPClick Here
71AP Payment Terms ReportAPClick Here
72AP Philippines WHT Invoice Print ReportAPClick Here
73AP Posted Invoice By Vendor and Match Type ReportAPClick Here
74AP Prepayment With Inv Dist ReportAPClick Here
75AP Prepayment With Open Balances ReportAPClick Here
76AP PrePayments ReportAPClick Here
77AP RCV Accrual vs AP Invoice ReportAPClick Here
78AP Receiving SLA Accounting ReportAPClick Here
79AP Receiving Transactions For Inventory ReportAPClick Here
80AP Recon ReportAPClick Here
81AP Recurring PO DUP Invoices ReportAPClick Here
82AP Remit Email Address for EFT Vendor Site ReportAPClick Here
83AP Return To Vendor Transactions ReportAPClick Here
84AP Sales Tax Self Audit ReportAPClick Here
85AP Supplier Bank Accounts At Header Level ReportAPClick Here
86AP Supplier Bank Accounts ReportAPClick Here
87AP Supplier List ReportAPClick Here
88Supplier Master data Report -- Interface to
Sync supplier master data from Cloud to EBS - Delta Data using parameters Date range with timestamp		ProcurementClick Here
89BarCode ReportProcurementClick Here
90
91
92
93
94
95
96
97
98
99
100
Supplier Sync Report from Cloud to EBS
 -Delta Data using Date range with timestamp



Reports Security 





Data Migrations




Documentation 

FDD
MD50  for AR 

TDD






No comments:

Post a Comment

Subscribe to: Posts (Atom)