Please follow Document ID from Oracle 2560426.1
Tuesday, October 19, 2021
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
|
APEX$TASK_PK
APEX$TASK_PK is a substitution string holding the primary key value of the system of records
-
The XDOLoader utility is a Java-based command line program to load template (RTF, PDF, and XSL-FO), XML, and XSD files to the XML Publis...
-
SELECT aca.check_number ,aia.invoice_id ,aia.invoice_num ,aia.invoice_amount ,distribution_line_number ,aida.accrual_p...
-
Serial_number_control_code column contains values as 1,2,5 &6 in mtl_system_items_b table. Inorder to find meaning for this values r...