Oracle Fusion

(Inception: 2010-09; Release 9: (2019): Introduction of advanced analytics and AI features'. Release 14: (2024): Latest updates with a focus on AI and machine learning.)

The main modules in Oracle Fusion:

• Financial Management: Manages financial transactions, accounting, and reporting.
• Procurement: Streamlines the procurement process, including supplier management and purchasing.
• Project Portfolio Management (PPM): Helps manage projects, resources, and budgets.
• Human Capital Management (HCM): Manages HR functions such as payroll, recruitment, and employee management.
• Customer Relationship Management (CRM): Manages customer interactions, sales, and marketing.
• Supply Chain Management (SCM): Oversees supply chain operations, including inventory and logistics.
• Enterprise Performance Management (EPM): Supports planning, budgeting, and forecasting.
• Governance, Risk, and Compliance (GRC): Ensures compliance with regulations and manages risk.
• Manufacturing: Manages production processes and operations.
• Order Management: Handles order processing and fulfillment.
• Sales: Manages sales processes and customer relationships.
• Service: Manages customer service and support operations.

Oracle Database 19c

(released 2019-01 )

• Oracle Fusion Applications typically run on Oracle Database 19c. Oracle Database 19c supports Flashback Query and Flashback Database allow users to quickly recover from user errors; database sharding; JSON data; Multitenant architecture; In-Memory Database Enhancements; Partitioned Hybrid Tables; Transparent Data Encryption (TDE) ; Oracle Real (RT) Application Clusters (RAC); Autonomous Database Capabilities==Automatic indexing and Automatic workload tuning.

Oracle Database 23c

( released 2023-09 )

• Oracle Database 23c is the latest long-term support release of Oracle’s converged database. It includes several enhancements aimed at improving performance, security, and support for various data types and workloads. Key features include:

• Enhanced AI and Machine Learning: Built-in algorithms and tools for data mining and machine learning, including improvements to XGBoost and Generalized Linear Models.

• Support for Modern Data Types: Native support for JSON, blockchain, XML, Graph, Spatial, Text, and Relational data, SQL innovations, making it versatile for various applications.

• High Availability and Performance : Continued focus on providing top-notch performance and reliability for mission-critical applications

FREE DOWNLOAD Supports technologies like Parallel Query, Real-Time Materialized Views, In-Memory Columnar Store, etc., ensure fast and scalable execution.

Oracle Database 23ai

( released 2024-05 )

• Oracle Database 23ai12. This version focuses heavily on integrating AI capabilities to enhance data management and application development. It is not a part of Oracle Fusion. It could be integrated.

Oracle Fusion Financials

• Oracle Fusion Financials, whether deployed on-premises or in the cloud, has the same core sub-components. These components are designed to manage an organization's financial operations and include:

• General Ledger (GL): Records and tracks all financial transactions.

• Accounts Receivable (AR): Manages customer invoices, payments, and credit management.

• Accounts Payable (AP): Manages vendor invoices, payments, and expense reporting.

• Cash Management: Optimizes cash flow and manages bank accounts, treasury functions, and currency exchange.

• Fixed Assets: Tracks and manages fixed assets, including depreciation, maintenance, and disposal.

• Project Costing: Tracks and manages costs associated with projects, including labor, materials, and overhead expenses.

• Financial Reporting: Generates financial reports, including income statements, balance sheets, and cash flow statements.

• Financial Consolidation: Consolidates financial data from multiple subsidiaries or business units into a single financial statement.

• Financial Planning and Budgeting: Creates and manages financial plans and budgets, including forecasting and variance analysis.

It's quite common for corporations to migrate only specific components of Oracle Fusion to the cloud while leaving others on-premises. This approach is often referred to as a hybrid cloud strategy. The modules that are migrated to the cloud as first usually are:

• Financial Management on Fusion
• Human Capital Management (HCM)

It us so because these modules due to their core functionality have low volume or do not have at all customization and dependency on external systems.

The competitors: SAP S/4HANA Finance has common module for all countries with Country-specific master data; Microsoft Dynamics 365 Finance and Operations supports 44 localizations through configuration.

In Oracle Fusion Financials, localization is achieved through prebuilt localizations and configurable features tailored to meet country-specific financial, tax, and regulatory requirements. These localizations allow businesses to operate globally while complying with local laws and regulations. Country-Specific Configurations: Oracle Fusion provides localization packs for over 130 countries, enabling compliance with each country’s regulations. These packs include configurations for tax rules, legal reporting, accounting standards, and currency handling that automatically apply based on the legal entity's location.

ATP

• Key points about ATP's application:

• It's exclusively a cloud offering, either in Oracle's public cloud or through Cloud@Customer.

• It's not available as a traditional on-premises product that customers manage themselves.

• The same core Oracle Database technology underpins ATP, but with added layers of automation and machine learning.

• ATP can be configured for transaction processing (ATP) or data warehousing (ADW - Autonomous Data Warehouse) workloads.

• In essence, ATP is not a separate database product, but rather a cloud service delivery model for Oracle Database that incorporates extensive automation and machine learning capabilities to enhance management, security, and performance.

---

main objects/tables in some of these modules:

1. General Ledger (GL) GL_JE_HEADERS: Stores the journal entry headers. GL_JE_LINES: Stores the individual journal lines linked to the headers. GL_BALANCES: Holds balance data for various accounts and periods. GL_LEDGERS: Information about ledgers used in the General Ledger module. GL_PERIOD_STATUSES: Maintains information about the status of accounting periods.
2. Accounts Payable (AP) AP_INVOICES_ALL: Stores information about invoices, including header data. AP_INVOICE_LINES_ALL: Holds detailed information about each invoice line. AP_SUPPLIERS: Information about suppliers. AP_PAYMENT_SCHEDULES_ALL: Contains payment schedule information for invoices. AP_CHECKS_ALL: Stores data related to payments (checks). AP_HOLDS_ALL: Holds records about invoices under hold.
3. Accounts Receivable (AR) AR_INVOICE_HEADERS_ALL: Stores invoice header data. AR_INVOICE_LINES_ALL: Holds detailed invoice line information. AR_RECEIPTS_ALL: Information about receipt transactions. RA_CUSTOMERS: Stores customer-related data. RA_CUST_TRX_TYPES_ALL: Transaction types associated with AR invoices.
4. Fixed Assets (FA) FA_ASSETS: Stores data about fixed assets. FA_DEPRN_SUMMARY: Contains depreciation summary for each asset. FA_BOOKS: Tracks assets across different accounting books. FA_ADDITIONS: Records for asset additions.
5. Cash Management (CE) CE_BANK_ACCOUNTS: Stores data related to bank accounts. CE_STATEMENTS: Contains information related to bank statements. CE_TRANSACTIONS: Data related to bank transactions and reconciliation.
6. Subledger Accounting (SLA) XLA_AE_HEADERS: Stores header data for accounting entries. XLA_AE_LINES: Accounting entry lines linked to the headers. XLA_EVENTS: Events that trigger accounting entries.