Overview of the Financial Reporting Center

The Financial Reporting Center basically offers the state-of-the-art reporting with analytical capabilities, helps you to generate reports from the Oracle Journal Ledger Balances Cube for consistent, timely, and accurate information, and also performs multi-dimensional analysis and enables you to drill down to journal details and to both Oracle and Oracle subledger transactions as well, so which means once the balances have been posted, you had the flexibility to access the balances by submitting various reports.

Then also helps you to retrieve results from the report objects and definitions that are stored in the Enterprise Performance Management System workspace. And you can access those reports under the BI catalog.

The Financial Reporting Center basically includes the access to different type of reports, including financial reports. These are those records that are designed by using a tool called Oracle Financial Reporting Studio. Oracle Financial Reporting Studio basically helps you to design fixed format financial reports that are fetching the data from the balances cube directly.

Account Group and Sunburst

Account Group and Sunburst are tools used to enter key accounts which should always be under watch. When a user creates an account group, it becomes visible in the Financial Reporting Center. And you can also use the Sunburst visualization tool to keep a track about the activities that are happening within an account. The Sunburst visualization tool enables you to interact with your account balances across various business dimensions in order to view balances from different perspectives.

Smart View

Smart View is a spreadsheet-based, multi-dimensional pivot analysis tool that is combined with the full Microsoft Office functionality. To access the balances from your cloud environment, you must ensure that you have installed the Smart View add-in on your local machine. Otherwise, you will not be able to establish a connection with the cloud environmental.

Smart View enables you to interactively analyze your balances and define reports by using the familiar spreadsheet environment. These queries are mainly for users who are operating within the GL application. And one user can upload a query by using workspace. And then from differential reporting center, another user can download the query to the local drive for utilization. So it's like kind of shared option is also available.

Overview of Oracle Transactional Business Intelligence in Oracle Fusion Applications.

Overview of Oracle Business Intelligence Publisher in Oracle Fusion Applications

Users with access to the Financial Reporting Center

• General Accounting Manager
• General Accountant
• Budget Manager

For more full-detailed Tutorials and Tips, check out #TheOracleProdigy at https://lifeofanoracleprodigy.blogspot.com/

Follow The Oracle Prodigy on Facebook (https://www.facebook.com/theOracleProdigy/) and Twitter (https://twitter.com/D_OracleProdigy)

Advantages of using Oracle Fusion Applications over E-Business Suite

Last Updated: March 30, 2019

Just sharing some of my notes on some advantages of using Oracle Fusion Applications as compared to Oracle E-Business Suite R12. This might get updated over time as I go along my journey on the Cloud. :)

• Oracle Fusion Applications already has seeded Business Intelligence & Analytics, and Essbase (formerly known as Hyperion) is already integrated with General Ledger for Multi-Dimensional reporting. On the other hand you would need to purchase separate licenses for Oracle E-Business Suite, Hyperion and Oracle Business Intelligence.
• Has already built-in Invoice Imaging for invoice integration with third-party organizations. A Vendor just needs to send a scanned copy of an Invoice to a specific email address used by the system and Oracle Fusion automatically puts it into the Interface for processing.
• Allows the use of SOAP Web Services for data integrations with third-party organizations (using the built-in ERP Integration Service) and already supports data encryption.
• Simplified Look and Feel and easier navigation.
• Oracle Fusion Applications already has a Social Network within the application for messaging and file-sharing within the organization (though I believe this will be highly unused as Microsoft already has an established messaging application such as Teams and Skype for Business).
• The fact that you won't need to install a Java plugin makes everything so much easier. Just navigate to the application's URL and you're already set.
• You only need to setup your configurations from one place ("Setup and Maintenance") unlike in EBS where you have to navigate to each application's Super User responsibility.
• The use of Business Intelligence applications such as Infolets, Infotiles and Sunburst for better and faster decision-making based on real-time data.
• Centralized Financial reports in Financial Reporting Center (FRC) and provides a multitude of seeded reports that cater to government requirements
• Easily accessible from Mobile phones, just use a browser
• Spreadsheet Integration for most Financial Applications (Recievables, Payables, Assets, GL, etc.) to be used for data entry, correction, deletion or data updates.