Oracle Cloud Applications (aka Oracle Fusion Applications) Overview

Over the past few years oracle has acquired numerous competitors in the appliactions and technology market which has resulted in a large product portfolio. All the acquired products represented best of breed in their respective areas,
Oracle decided to build a new application suite from scratch and fusion application is a result of it.

Fusion Applications were designed from the ground up based on open standards, making it possible for them to coexist with legacy Oracle products. Fusion Applications can also take full advantage of Fusion Middleware capabilities, providing for applications that can span complete business processes with a consistent user experience.
Oracle Fusion Applications were designed, from the ground, up using the latest technology advances and incorporating the best practices gathered from Oracle's thousands of customers. They are 100 percent open-standards-based business applications that set a new standard for the way we innovate, work, and adopt technology.

Fusion Applications have simpler, more user-friendly user interfaces. In addition, Oracle embedded social networking capabilities directly into business processes.
Fusion Applications also provide mobility capabilities that support both real-time and offline data access. Organizations can use Fusion's open standards to build custom mobile apps. Fusion Applications have business intelligence features for collecting data on individual application transactions built in.

- Oracle Customer Relationship Management
- Oracle Fusion Financials
- Oracle Fusion Governance, Risk and Compliance
- Oracle Human Capital Management
- Oracle Fusion Procurement
- Oracle Fusion Projects Portfolio Management
- Oracle Fusion Supply Chain Management

Embedded Cloud:

Oracle Fusion Financials:

Oracle Fusion Procurement Management:

Oracle Fusion Supply Chain Management:

Oracle Fusion Inventory Management:

Oracle Fusion applications is called now as Oracle Cloud Applications:

Oracle Fusion Applications:

Oracle ERP Cloud Integration Services:

1.Embedded intelligence within the context of business transactions to offer “actionable insight” for users. Embedded intelligence is displayed in the same window where users enter transactions so they do not have to drill down or invoke a separate popup.  The Projected Balances pane on the right provides that information as the journal is entered prior to posting

2.Spreadsheet Integration to reduce Errors & Manual work : Extensive spreadsheet integration across Financials, allowing Finance users to work in a familiar environment that is highly efficient. Spreadsheets are seamlessly integrated with the applications for high volume data entry and one-click uploads

3. Financial report designing made easy using Financial Reporting Center ; Produce snapshot reports with static data, or define live reports. Change users point of view or report parameters, end-users can instantly refresh results on-the-fly. Again, this is all live data that works off of pre-aggregated multi-dimensional balances,export results to MS Office, such as Word and PPT, and dynamically refresh results within those office products.

Oracle Enterprise repository (OER) Process:

The Oracle Enterprise Repository (OER) for Oracle Cloud provides visibility into service-oriented architecture assets to help you manage the lifecycle of your software from planning through implementation, testing, production, and change control. OER includes the spreadsheet templates and information to help you prepare external data for upload and import. Each template includes specific instructions, guidelines, formatted spreadsheets, and best practices for preparing the data file for upload. Use the templates to ensure that your data conforms to the structure and format of Oracle ERP Cloud Service interfaces.

Oracle Enterprise Repository (OER) - Oracle Fusion Application

 Oracle Enterprise Repository(OER) for fusion application provides the definitive catalog of integration related content to simplify Customization, Extensions and integration.

 

Fusion Application  Architecture:

Scenarios:

File based Loader (FBL):  FBL is a Data Loading Tool for Oracle Fusion Applications.

Full list of FBL Spreadsheet Loader available for Fusion Financials be found
The information exists in Oracle Enterprise Repository ( OER)

•     Navigate to https://fusionappsoer.oracle.com
•      Select the following parameters
•     Version - The version you need the information for
•     Product Family - Financials
•     Type: Depending on what kind of service you need select either: ADF Service, ADF Service  Data Object or File Based Data Import

 File-Based Data Import: Shows which business objects can be imported into Oracle Fusion Applications using the File-Based Data Import tool.


File base Loader:  most of the fields are supported through FBL, like Supplier Creation, Customer Creation, CoA structure etc.

 To transfer the data file to the integrated content management server.

This is a required step when Using External Data Integration Services for Oracle Cloud to load data into Oracle Fusion Applications from external sources, such as legacy systems and third-party application


Login to Oracle Fusion Application

 Navigator > Tools > File  Import/Export.

 

ADFdi  (ADF Desktop Integrator) Vs FBL:

• Both options based on Excel sheets, the number of rows that can be uploaded at any one time is limited to around 65,000. 
• File based import or the Bulk Journals sheet in ADFdi would be faster since these sheets do not have any validations.
• If using the Multiple Journals Sheet which has some validations, uploading in chunks of 10,000 to 20,000 rows would be faster than uploading 65,000 rows in one go.
• The Journal Entry UI has a limit of 500 journal headers per batch and 100,000 lines per journal header. The journal will not be viewable if it exceeds these limits. 

Ref: Oracle Fusion apps user guide and implementation guide and support notes.