Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications


Posted on September 2nd, 2017 by Sanjit Anand ||Email This Post Email This Post

GCC Apart from India GST new in recent past , In another milestone towards the implementation of VAT across the Gulf Cooperation Council, the Unified Agreement for VAT was published in the official gazette of one of the member states, Saudi Arabia.

The Unified Agreement provides the framework for the operation of VAT across the GCC.

Each GCC member state will implement the framework through legislation and other instruments. This milestone is another reason for companies operating in the Middle East to put in place or further their VAT implementation plans.. Companies in these region already started for Implemnating GCC .

Let’s have a quick look :

The Gulf Cooperation Council (GCC) was formed in 1981 to create unity and economic stability amongst the member nations.

The International Monetary Fund recommended the introduction of an indirect tax system to increase revenue for the member countries.

All member states signed the VAT Framework Agreement, which establishes the main principles for the application of the VAT regime in the member countries.

Here are Key Highlights for KEY Unified VAT Framework


Currently , GCC Member Nations

  • Bahrain
  • Kuwait
  • Oman
  • Qatar
  • Saudi Arabia
  • United Arab Emirates (UAE)

Each member will issue VAT legislation.

Majority of Tax system provide Tax Engine and Integration:

  • Logic to natively support Goods and multiple Services type transactions in the Kingdom of Saudi Arabia and the United Arab Emirates
  • Domestic, Intra-GCC, and International (Import and Export) transactions are all supported

Why GCC is getting some much attention

Reason , a deadline is given for these countries

  • United Arab Emirates and Saudi Arabia in Q4 2017
  • Qatar, Oman, Bahrain, Kuwait in 2018 (dependent on legislation)

Though , It’s official: 2018 will see the start of implementation of a value-added tax (VAT) across the Gulf states

Business Functional Area where get impacted [TRANSITION-RELATED CHALLENGES]

Businesses will face the impact of VAT in two ways: by the additional investments needed for compliance,as well as the higher input cost of the new VAT, itself .

However, companies may refrain from passing on the entire input VAT to consumers owing to the fear of losing business.

Some key Challenges can be best understood as :

In Procurement : Major Trabsition Releated challenges might be

  • Formulate new procurement strategies
  • Vendor management
  • Revisit contracts and arrangements

Accounting & IT System

  • Update financial and point of sale systems
  • VAT coding for payables and receivables
  • Electronic documentation/process automation [ if any]

Sales & Pricing

  • Assess impact of VAT on demand/current contracts
  • Pricing strategy and terms of payment
  • Customer management

Knowing Where to Start

So, where do you start to determine which approach is best for you? Deploy a new ERP in the cloud? Keep your core ERP and connect cloud VAT services? Should go with Tax vendor ?

There are a number of factors to consider:

  • What is the age of your existing ERP system? Are you running the latest version of the software, or are you on an old vesrion?
  • In how many countries do you do business?
    • The more geographies, currencies,and languages you operate in, the more rules, regulations, and compliance issues you will need to consider.
    • It might be worth a full-scale migration to cloud in order to keep on top of all the permutations.
  • How many transactions does your ERP process in a day?
    • The higher the transaction volume, the more important it is that your core system be scalable enough to meet demand.
  • Are you looking at a full ERP replacement in the near future?
    • If so, it might make sense to take a phased, “outside-in” approach—starting with tax applications in the cloud to meet the immediate VAT deadline, and then moving core ERP to the cloud at a later date.

No matter which approach you decide on, VAT is coming. Every GCC business will need to comply. I recommend that you form a project team as soon as possible to understand how VAT will impact your business and operating model.

Assess the capability of your existing systems to comply with the new regulations.And then, choose an implementation partner and a software vendor with the real experience and capabilities to meet your needs.

More Reading

You can get more reading

Closing Thoughts

As per The UAE Ministry of Finance

The system for VAT registration and payment is being developed to meet the very best global standards using leading-edge technology. All services will be online and accessible 24/7, responding to the requirements of business. This reflects the UAE’s aim to be a leader in innovation and technology across all aspects.

Posted in Finance, Functional, Fusion Application, Oracle Cloud * | No Comments »

Financial Reporting Center (FRC)

Posted on June 24th, 2015 by Sanjit Anand ||Email This Post Email This Post

Financial Reporting Center (FRC) includes Financial Reporting (adapted from Hyperion Financial Reporting) that allows one to create board room ready balance sheet and profit and loss statements with live drill down to transaction sources with embedded charts and graphs.

FRC enables reporting based on multi-dimensional general ledger balances and hierarchies.

Live reports that are based on real-time data can be analyzed and viewed in multiple output formats, such as HTML, Adobe PDF, Microsoft Excel and other Microsoft Office products. Cloud Reporting Solutions also includes tools like Account Inspector, Account Monitor, and Smart View Excel plug-in. Account Inspector allows you to perform multi-dimensional analysis and drill down on your financial data.

The good is , users can setup exception based monitoring of certain accounts (actuals and budgets) using Account Monitor and enables real time monitoring of variances.

Key Components

Financial Reporting Center is comprised of numerous components:

  • Financial Reporting: Financial users and analysts access live reports and books or published snapshot reports and books from previously scheduled batches in a variety of formats. Other functionality includes:
    • Refreshing report data using runtime points of view or parameters
    • Drill through capability from parents to other parents
    • Drill down to detail balances, journal lines, and subledger transactions.
  • Oracle Hyperion Smart View, Fusion Edition: Financial analysts view, import, manipulate, distribute, and share data from your Oracle Fusion General Ledger balances in Microsoft Excel.
  • Account Monitor and Account Inspector: Financial analysts monitor and track key account balances in real time at every level of your dimensions and hierarchies. These tools provide multidimensional account analysis and drill down capability.
  • Workspace: Reporting administrators create, open, save, and delete folders and store report objects, reports, and snapshot reports.
  • Oracle Hyperion Financial Reporting Studio: Report authors use an object-oriented graphical report layout with report objects, such as text boxes, grids, images, and charts, to design reports

One of the best parts of reporting is the way that data is summarized with tree-like capability, allowing you to see data at any level of detail and actually seeing the balances.

Posted in Fusion Application, Oracle Cloud * | No Comments »

Integration Options with Oracle Fusion Cloud Service

Posted on October 20th, 2014 by Sanjit Anand ||Email This Post Email This Post

Do you know Oracle Fusion Financials Cloud Service is built with Oracle’s Application Development Framework (ADF) and provides four primary methods of integration with other applications:

  • ADF Services (commonly referred to as Web Services)
  • ADF Desktop Integration
  • File Based Data Import
  • Reporting Tools

ADF Services

A web service provides a standardized way of integrating two web-based applications.

A web service is a program that can be accessed remotely using different XML-based languages.

For example, abanking web service may implement functions to check an account, print a statement, and deposit and withdraw funds.

These functions are described in a web service description (WSDL) file that any consumer can invoke to access the banking web service.

As a result, a consumer does not have to know anything more about the web service than the WSDL file that describes what it can do. A web service consumer (such as a desktop application or other application) invokes the web service by submitting a request in the form of an XML document to the web service provider.

Fusion Integration Options ADF Services

Above Figure 1 illustrates the architecture of ADF Services,

ADF Desktop Integration

ADF Desktop Integration (ADFdi) is also part of the ADF framework and enables desktop integration with MS Excel spreadsheets to manage large volume data uploads into Fusion Applications.

The integration provided with ADFdi includes interactivity that enables web picker to search for valid values, perform validation during data entry, display error messages, and immediately submit transactions directly from MS Excel.

Fusion Integration Options ADFDI

Figure 2 illustrates the architecture of ADF Desktop Integration, which comprises of the following components:

  • ADF Desktop Integration
  • ADF Desktop Integration remote servlet
  • ADF Model layer

File Based Data Import

File Based Data Import (FBDI) is another option for getting information into your Fusion Financials Applications. The process of using FBDI is quite simple: download an excel template that identifies all of the fields, populate the spreadsheet with data from the external system, save the file as a .csv file type, upload the file to the server, and run processes to transfer the data to the interface tables and import into the various applications. All of the data is validated during import to insure its integrity

Fusion Integration Options FBDI

Reporting Tools
Fusion Cloud Service uses four primary reporting tools which can be used to extract data and import into your external systems.

  • BI Publisher delivers high volume transactional reports, can be configured to extract the data in Rich Text Format or XML.
  • Oracle Transactional Business Intelligence provides the ability to build custom queries on transactional data, and the output can be downloaded to Excel.

You can get more detail from OER

Posted in Fusion Application, Oracle Cloud * | No Comments »

Oracle Fusion Applications Update

Posted on January 4th, 2013 by Sanjit Anand ||Email This Post Email This Post

Oracle Fusion – search for “the world changed in the past 5 years”

  • 400 customers on Oracle Fusion Applications

Interesting article on the state of the Oracle Fusion Apps.

Must read it.

Posted in Fusion Application | No Comments »

Oracle Fusion Applications Documentation Library

Posted on December 12th, 2012 by Sanjit Anand ||Email This Post Email This Post

Oracle Fusion Applications Documentation Library for links to release notes, guides, licensing information,and more can be found here


You can use this page to learn about Oracle Fusion Applications . You can use the tabs to find user guides, implementation guides, and other documentation resources for each product family.

dgreybarrow Other Documentation Links

  • Oracle Fusion Applications Technology Library : You can use these library for technical guides such as install, patching,implementation, and extensibility. click here to get .
  • Oracle Enterprise Repository : You will get technical information about integrating with other applications,including services, operations, composites, events, and integration tables. click here to get .
  • Oracle Fusion Applications Documentation Info Center : To access this you need my Oracle support access. If you have valid access rights , you can get white papers, release notes, What’s New and other resources.

Posted in Fusion Application | No Comments »

What Do We Mean by Tailoring in FusionApps

Posted on October 10th, 2012 by Sanjit Anand ||Email This Post Email This Post

Those who are coming from EBS background, might aware of these terms.

  • Configuration: Implementation changes that you make to set up your application
  • Customization: Any changes that you make to existing features in the application
  • Extension: New features that you might create in the application
  • Personalization: Changes that an individual user makes for themselves to new or existing features
  • Localization: Changes that you make to provide specific functionality to an area or region

In OracleFusion Application World , Business Needs not satisfied by the default functionality can be added to a separate metadata repository, using “threecustomization/extensibility processes:

  1. Personalizations – User Level changes to the user interface, using Page Composer
  2. Runtime Customizations and Extensions – Business Analysts could make changes for all or a subset of users for certain business objects, defining security for new objects and customization of reports
  3. Design Time Customizations and Extensions – Oracle Jdeveloper is used to make customizations to more complex changes that cannot be done by personalizations or runtime customizations. Changes could be adding new functionality or an entirely new application

The extensibility of Oracle Fusion Applications is important for customers to understand for three fundamental reasons:

  • The customization process is more efficient with Oracle Fusion Applications because there’s no need to pass customizations to the IT department.
  • The extensibility process enables businesses using Software as a Service, or SaaS, as well as on-premise software, to reduce their IT workload. Users don’t have to turn to the IT department to implement customizations because they can apply the customizations themselves.
  • Any tailoring that users do is upgrade-safe and patch-friendly, so there is no need to redo customizations when the company moves to a more current version of software.

1 Documentation

You can find more details in these two documentation.

  • Fusion Applications Extensibility Guide for Business Analysts (E16691-11) covers items including customizing pages using Composers, using Flexfields, customizing and extending BPMN Processes, and customizing Reports and Analytics.
  • Fusion Applications Extensibility Guide for Developers (E41852-01) covers setting up JDeveloper and customizing and extending SOA, ADF, BPM Templates, ESS and more.

Posted in Fusion Application | No Comments »

Oracle Fusion Tap

Posted on October 9th, 2012 by Sanjit Anand ||Email This Post Email This Post

Oracle recently announced the availability of Oracle Fusion Tap, native application for the iPad ,which is capable of completely changing the way users employ their smartphones in order to realize enhanced productivity.

With Oracle Fusion Tap application, users can:

  • browse key performance indicators and view up to the minute analyses;
  • obtain a complete view of the workforce through the blending of human resource and with job specific information, such as worker performance correlated to sales performance;
  • manage CRM Sales opportunities, contacts, accounts and activities and more;
  • browse organization and view critical worker information including predicted performance and attrition; browse the product catalog and manage revenue lines;
  • compare multiple workers in order to determine top performers, compensation distribution across teams, and which workers are available to support initiatives;
  • leverage existing fusion application content and extend Fusion Tap through easy to use composers; and more.

Oracle Fusion Tap is now available in the app store via itune!

Oracle Tap for iPad cann’t used by those who bought Fusion hardware as this runs off cloud-based enterprise applications and across Oracle Application Cloud Services.

You can find more insights in this clip

Refrence Note

  • Doc #1430761.1 on My Oracle Support
  • Oracle Press Release
  • Link for Oracle Fusion Tap

Posted in Fusion Application | No Comments »

Learn more about Oracle’s next generation applications, Fusion Applications

Posted on March 23rd, 2012 by Sanjit Anand ||Email This Post Email This Post

Want to learn more about Oracle’s next generation applications, Fusion Applications.Here are some of the post , that helps you to understand better.

ORACLE FUSION APPLICATIONS is the integration of Oracle applications such as E-Business Suite, PeopleSoft, JD Edwards & Siebel into a set of next generation applications based on open industry standards.Fusion Applications is build on top of the Oracle Fusion Middleware Technology Stack using Oracle’s Fusion Architecture as blueprint.

Oracle Fusion Applications provide a complete applications portfolio and a host of deployment options(On premise,Public cloud,Private cloud,Hybrid public/private cloud).This include over 100 modules across seven core enterprise application product areas:

Additional products exist to add significant incremental business value span the entire suite:

  • Oracle Fusion Accounting Hub (Oracle Fusion Financials)
  • Oracle Fusion Talent Review (Oracle Fusion Human Capital Management)
  • Oracle Fusion Territory Management (Oracle Fusion Customer Relationship Management)
  • Oracle Fusion Distributed Order Orchestration (Oracle Fusion Supply Chain Management)

Oracle Fusion Middleware is the underlying Technical Platform used to build Oracle Fusion Applications. Oracle Fusion Architecture is the blueprint that ties together the Fusion Applications, Middleware Platform and Grid Technology.

As an EBS user, the concepts that we have learned over the years are all made obsolete. In their place many of the PeopleSoft concepts has taken over.

  • Identity Manger replaces FND User
  • Business Units replace Operating Units
  • Date Effectivity replaces Date Track
  • ESS replaces Concurrent Manager
  • Access Control Governor replaces OICM

Extensible Attribute Framework introduced allowing unlimited set of attributes with more powerful features than Descriptive Flexfields (DFF). All attributes can be inherited or discovered by business intelligence, business rules, business processes, transactional UI and transactional logic. Gone are the days where one must add custom tables due to limitations of DFF fields. Will align to ‘Rethink Customization Strategy’

Sub-ledger Accounting (SLA) architecture is carried into Fusion Applications combined with Business Unit mapping providing a basis for an excellent Service Provider Model.

Fusion Application Security is built using the Security Manager Tool (part of Fusion Middleware) this means the concept of Responsibilities that EBS users are familiar with are gone and in its place Role based access mechanism is implemented.

Fusion have almost all Technology Stack

Tools and Framework

SOA Suite

Web Center Suite

Content Management

Identity Management

Oracle Data Integrator (ODI)Development Environment –
Oracle J-Developer

Application Developer Framework (ADF)

BI Publisher

Web ServicesApplication

Integration Architecture (AIA)

Business Process Execution Language (BPEL OSB)

Oracle SQL, PL/SQL
Java 2 Enterprise Edition (J2EE)

Hyper Text Markup Language (HTML)/Extended Markup Language (XML)

Cascading Style Sheets (CSS)

Extensible Style Sheet Language (XSL)/JAVA ,

These technology stack create ample opportunity to Functional Analyst,Technical Developer and Application Architects.
Combines the best-in-breed functionalities of EBS, Siebel CRM, PeopleSoft and JD Edwards Enterprise One Applications.All of the current applications mashed up along with usability and business process optimization resulting in a new set of better application.

There is choice of adoption scenarios in order to move to Oracle Fusion Application. Co-existence option ie adding on specific Oracle Fusion application module .

Fusion application Business Intelligence comprises of Oracle Transactional BI (OTBI) a real time self service reporting directly off Fusion Apps data. Oracle BI Applications (OBIA) is a prepackaged data warehouse enabling historical analysis and cross domain insight. Whereas specialized Domain specific Analytics include financial statements, sales territory planning and Project Performance built on Essbase technology. White space analysis built on Real Time decisions and Oracle Data Mining Technologies.

Oracle Fusion Functional Setup Manager provides a single user interface for performing all tasks related to Oracle Fusion Applications setup after installation and helps you to easily move the setup data between instances to reduce implementation time.

More References from Oracle

Posted in Fusion Application | 1 Comment »

Fusion Application Security

Posted on December 14th, 2011 by Sanjit Anand ||Email This Post Email This Post

Oracle Fusion Applications is very secure and security approach consists of tightly coordinating the following aspects of security.

  • Role-based access control (RBAC)
  • Function security via OPSS
  • Standard Data security
  • Privacy
  • Access provisioning and identity management
  • Segregation of duties policies
  • Enforcement across tools, technologies, data transformations, and access methods

The Oracle Fusion Applications security approach supports a reference implementation of roles and security policies that address common business needs.

dgreybarrow Fusion Application Security Architecture

As a first step, you need to understand what security capabilities are offered by Fusion Application. The figure below illustrates the Fusion Application Security .

(Click on the image to enlarge it)


As per architecture you can see lot many security tools are been used . some of them as:

  1. Single Sign on
    • Oracle Access Manager (OAM)
  2. Identity Management Tools
    • Oracle Identity Manager (OIM)
    • OIM SPML Interface
    • Identity Governance Framework (IGF)
    • Oracle Virtual Directory (OVD)
    • Oracle Internet Directory (OID)
  3. Authorization Management tools
    • Authorization Policy Manager (APM)

Posted in Fusion Application | No Comments »

What is Sandbox Manager in Fusion ?

Posted on November 27th, 2011 by Sanjit Anand ||Email This Post Email This Post

sandbox Fusion


In fusion , in order to try any customizations and extensions , you need an environment for testing, before deploying to Production.In Fusion World this is magaed via SandBox Manager. The other terminology you need to get expose is Composer.

Sandbox Manager is a tool that provides a place where users can define and design their changes before putting them into production.


The three types of sandboxes are avaiable

  • Metadata, such as non-flexfield UI page customizations :This sandbox supports making changes to the application’s metadata stored in the MDS repository.
  • Security :This sandbox supports making data security changes.
  • Generated flexfields based business components

Sandbox Manager has the following features:

  • This stored all changes in the sandbox
  • You can have sandboxes to specfic to a user
  • Can have many sandboxes running (different users) at the same time
  • Make changes over a period of time (long-running sandbox)
  • All documents changed can be saved or reverted with one operation
  • Migrate sandbox in its entirety from test to production

Usually , there are two types of sandboxes:

  • Sandboxes intended to be published.
  • Sandboxes intended for “test-only” purposes.

Hope this helps. Next will explore more on “Composer”

Posted in Fusion, Fusion Application | No Comments »

« Previous Entries