Showing posts with label Oracle Fusion. Show all posts
Showing posts with label Oracle Fusion. Show all posts

Tuesday, May 11, 2021

Components of Fusion Accounting Hub

Oracle Fusion Sub Ledger Accounting to perform accounting transformations on external system data

  • Oracle Fusion General Ledger
  • Oracle Fusion Financial Reporting Center
  • Integration with Oracle Hyperion Data Management, Fusion Edition for chart of accounts and hierarchy maintenance
  • Applications coexistence integration with the Oracle E-Business Suite and Oracle PeopleSoft General Ledgers
  • Integration with Oracle Hyperion Planning, Fusion Edition and Oracle Hyperion Financial Management, Fusion Edition.

Technology Stack of Fusion Application

Following table shows different components which varies from Oracle e-Business Suite to Oracle Fusion Applications. 

Component

Oracle e-Business Suite

Oracle Fusion Applications

Database

Oracle Database 10g

Oracle Database 11g

Application Server

Oracle Application Server

10.1.2 (Forms)

Oracle Application  Server

10.1.3 (OC4J)

Oracle WebLogic

User Interface

Forms, JSPs

Oracle ADF + ADF

Java Server Faces

Portal

Oracle Portal

Oracle Webcenter

Data Model

Oracle eBS Data Model

Oracle eBS Data Model +

Siebel + PoepleSoft

(Trees, Data Effectivity, person Model)

Attachments/Imaging

BLOBs

UCM/Stellant

Workflow/Approval

PL/SQL

BPEL

Reports

Reports (11i), Discoverer

BI Publisher

Analytics

Discoverer

OBIEE

Financial Reporting

Financial Statement Generator

Hyperion

Integration

AIA

AIA + BPEL +

More web services

XML Gateway

XML Gateway

BPEL, B2B Adapter

 

Technology Difference between E-business Suite and Fusion Applications


Component

Oracle E-Business Suite

Oracle Fusion Applications

Database

Oracle Database 10G

Oracle Database 11G

Application Server

Oracle Application server 10.1.2

Oracle WebLogic

User Interface

Forms, JSPs

Oracle ADF+ADF Java Server Pages

Portal

Oracle Portal

Oracle Web Center

Data Model

Oracle EBS Data Model

Oracle EBS Data Model + Siebel + PeopleSoft (Trees, Date Effectivity, Person Model)

Attachments / Imaging

BLOBs

Stellant

Workflow / Approval

PL /SQL

BPEL

Reports

Reports (11i), Discoverer

BI Publisher

Analytics

Discoverer

OBIEE

Financial Reporting

Financial Statement Generator

Hyperion

Integration

AIA

AIA +BPEL + more web services

XML Gateway

XML Gateway

BPEL w/B2B Adapter

 

Oracle Fusion Middleware Components

Below are the Oracle Fusion Middleware Components: 

  • Oracle WebLogic Server: Java application server that helps to deploy multiple applications in a robust and scalable environment.
  • Oracle WebLogic Communication Services: provides click-to-dial functionality through contextual Actions which further helps users with information and actions.
  • Oracle Identity Management: automatically manages user access and provides services and interfaces for third party application developments.
  • Oracle Web Center: combines user interface technologies for building social applications.
  • Oracle Business Intelligence: offers a complete to generates and delivers analyses for fusion application.
  • Oracle SOA Suite: comprehensive software for building and deploying service-oriented architecture.
  • Oracle Application Development Framework: a java framework to simplify application development by minimizing code writing
  • Oracle JDeveloper: for building service-oriented applications using industry standards 

Fusion Accounting Hub

  • Oracle Fusion Accounting Hub (FAH) is a single source for managing all financial requirement as well as Reporting requirements against transaction and provides complete set of accounting tools and access to financial data. 
  • FAH receives data from multiple third party transactional system and also from the various Fusion Applications Products [ Sub ledgers ] and applies accounting rules to meet the regulatory reporting and business reporting requirements.
  • Oracle Fusion Accounting Hub is integrated with Oracle Hyperion Financial Management (HFM) as the latter is a powerful consolidation solution to collect other non-financial information. 
  • Oracle acquired Hyperion and started using benefits of Hyperion for consolidation, allocation and reporting in Fusion. 
  • Hyperion has been leader in financial domain for years together.
  • Fusion Accounting Hub (FAH) acts as integration platform for centralized accounting and its ability to generate multiple accounting representations (e.g., IFRS, local GAAP, industry, regulatory) for a single sub ledger transaction. 
  • FAH is a Next-Generation Financial Analysis for Centralized Reporting. 
  • Configurable accounting rules helps to capture transaction information used to create accounting. 
  • This feature of Fusion is highly configurable to satisfy capturing of transactions and to create different representation requirement for a company.
  • Fusion Accounting Hub deals with transactional details and is intended for day-to-day operational reporting and analytics. 
  • Hyperion Financial Management (HFM) deals with period-end balances, not transactional details, and is generally not used as an intra-period reporting system.

Tuesday, December 4, 2018

Why COA Structure Separated from the Instance(Oracle EBS GL vs Oracle Fusion GL)

  • In R12 EBS, Data Access Sets were limited to ledgers that shared the same COA and Calendar.We intended to expand Data Access Sets to be set at the COA structure level where you have the same shape, but you might have different value sets for different countries.
  • Best practice is to have a one to one relationship between the chart of accounts structure and charts of accounts instance.
  • Do NOT have multiple COA instances share the same structure.

Wednesday, October 10, 2018

Access Control in Oracle EBS and Oracle Fusion

Access Control
Oracle EBS
Oracle Fusion
Responsibility
Data Role
Top Level Menu
Job Role
Abstract Role
Sub Menu
Duty Role
Form Function
Privilege
Executable
Permission

Organization Structure in Oracle EBS and Oracle Fusion

Oracle EBS R12:-



Oracle Fusion 11g:-

APEX$TASK_PK

  APEX$TASK_PK is a substitution string holding the primary key value of the system of records