It's All About the Platform.

  • January 29, 2013

The Four Fusion Application Composers Explained

Richard Bingham
Senior Development Manager


The solution is to eliminate programming all together, get the business leaders to visually define what they want directly in their dashboards, pages, and reports. This lets the system take care of the behind-the-scenes technical implementation.

This has proven difficult to achieve, with past attempts often creating more complexity than they actually solve. This time it is done right, supported by the whole technology stack, and end-users just see the magic (see Arthur C. Clarke's third law).

There are four dimensions to making Enterprise Application changes, split by a combination of intent and technology behind them. Fusion Applications, via its underlying middleware, includes a Composer tool for making adjustments in each dimension. Having separate composers allows each to be relatively simple to use, increases governance over changes, and speeds deployment. The four dimensions are:

  •     The Application User Interface, supported by the Page Composer
  •     The Application Data Model, supported by the Data Composer
  •     Business Process Management, supported by the Process Composer
  •     Business Analytics, supported by the BI Composer

Currently the CRM Product Family has one additional composer, the CRM Application Composer, providing more advanced functionality for creating custom business objects and actions. This is confined for use with the CRM products currently, however its features will become universal across Fusion Applications in the future.

The composers are generally intended for Super User, Domain Manager, or Business Analysts type roles, with standard Personalization (with a few features from Page Composer) serving the needs of end users. For more extensive and invasive technical projects a connection between a local JDeveloper IDE (with the required setup) and a Fusion Applications instance is required. The tools to use for each type of activity are highlighted in the Fusion Applications Extensibility Guide.

Purpose and Intent

To illustrate the functionality provided by the composers the following is a short list of the most common customization-type requirements and which composer supports it:

  • Change a Page Layout for one or more users (Page Composer)
  • Change Field Labels (Data Composer)
  • Discover, Implement, and Add Seed Data to Flexfields (Page Composer)
  • Add a new Field onto a page (Page Composer)
  • Change a BPEL process and adjust the Human Workflows (Process Composer)
  • Create new fields for an existing or new business object (Data Composer)
  • Add and adjust reports to include new attributes and data sources (BI Composer)


Figure 1 - Adding a flex-field to the page using the wrench icon provided by the Page Composer.

Safe Changes

Fusion Applications implements a sandbox framework, whereby all Composer changes can be first made and stored in a virtual sandbox environment of your choosing. This ring-fences them so they can be safely tested and verified, whilst invisible to other users on the live system. Once complete they can be published one at a time or all together into the system for general use.

All supported customizations and extensions are stored and applied in the context of a Meta Data Services (MDS) Layer. MDS defines the context for which the customization will be applied over the standard features at runtime. Some commonly used examples of MDS layers are a User, a Job Role, an Organization, or across a whole Site.


Figure 2 - Setting the MDS Layer for a page customization for the 'Customers' page, such that it is only shown to users with the Sales Analyst role.

Page Composer

With its origin in Oracle WebCenter, the Page Composer options are the most immediately obvious, supporting most of the user interface adjustments you might like to make. This is the main tool used for both standard Personalization - applying to just one user, as well as the more extensive Admin Personalizations that apply to a group of users. This includes changing layouts, showing or hiding components, and adding standard ADF components from a predefined resource catalog.

Figure 3 - Page Composer offering the addition of content and a change to a two column layout

Data Composer

Where basic options like flexfields are not enough to support the additional data attributes required for your business operation, the Data Composer allows access to edit and create ADF Business Objects. Just to be clear, these are not new database fields or records, but the abstraction of them based on real-world entities, such as Purchase Orders or Customers. It is the ADF Business Objects that are used at runtime by the user interface.

Whilst Data Composer is currently only available within the CRM Application Composer, plans exist to extend it across the board.


Figure 4 - Data Composer allows manipulating ADF Business Objects to better support specific information requirements.

Process Composer

As part of Oracle SOA Suite, the Oracle Business Process Management Suite contains a design-time tool for creating and adjusting BPMN 2.0 compliant BPEL processes, known as the Process Composer. Logically, as this tool can make significant changes to the way functionality runs, it is not therefore for use by normal end-users or  administrators, and so is not found embedded inside Fusion Applications.

The Process Composer contains extensive options for creating new processes, as well as importing, adjusting, and redeploying the standard BPEL processes provided by Fusion Applications. Amongst other things, this includes support for manipulating Oracle Business Rules (OBR) to add complex conditional processing logic, as well as Human Workflow for interacting with users for hands-on activities, such as approvals. More details can be found in the Business Process Composer User's Guide.


Figure 5 - The Process Composer showing an approval flow for editing.

BI Composer

This composer is embedded in Fusion Applications, under Reports and Analytics, thanks to OBIEE Server option for integrating its native composer tool with any ADF application (including your own custom ones). This allows users to modify the embedded page analytics, such as adding content from the BI Catalog, as well as adjusting existing content such as modifying the analysis' columns, add alternative views, sort and filter the data, and apply conditional formatting.

For more information on using the BI Composer to customized your page analytics see the OBIEE Developer's Guide.

For customizing standard reports like those used for printing, use the separate Oracle BI Publisher tool, as described in Chapter 8.2 of the Fusion Applications Extensibility Guide and explained in depth the BI Publisher Report Editor Guide.


Figure 6 - Creating custom reports and analytics via the embedded BI Composer features.


Whilst feature rich, you may have noticed that most of the composers capabilities are inherited from the underlying technology components. Reusing standardized and proven solutions make sense, however there are also cases where Fusion Applications would benefit from some extra capabilities that increase simplification and add context-sensitive options.

An example is CRM Application Composer mentioned earlier, which will evolve in releases to come. This tool is unique to Fusion Applications and allows the addition of custom data fields and Business Objects, and some limited application logic such as adding relationships between new object, implementing security, adding groovy script, and defining object workflow. Whilst powerful on its own, this tool is still simpler and less invasive than using JDeveloper, and retains the benefits of making changes inside the application itself.

As we work with customers and partners we will learn about popular tailoring requirements and best practices, and use this to drive the evolution of the composers. If you have requirements or have embarked on related projects please share your experiences by contacting us or simply adding comments below.


  • Fusion Applications Extensibility Guide for Release 5 (on Page Composer in Chapter 3, CRM Application Composer in Chapter 4, and BI Composer in Chapter 8)
  • Oracle Business Intelligence Enterprise Edition Developer's Guide (on BI Composer)
  • Oracle Business Process Management Suite Users Guide (on Process Composer)

Join the discussion

Comments ( 8 )
  • Alex Thursday, February 14, 2013

    At the risk of being branded as "picky", I would like to point out that the screenshot does not show the BI Composer.

    BTW: Is the Process Composer already available?

    have a nice day


  • Richard Bingham Friday, February 15, 2013

    Hi Alex. Thanks for spotting that, and whilst it was supposed to illustrate some embedded custom analytics, I agree it wasn't quite in keeping with the other images. As such I've put a fresh one that shows the actual tooling. Thanks for helping improve this post.

    Kind regards


  • Richard Bingham Friday, February 15, 2013

    Oh and yes the Process Composer is available. It is under the CRM Application Composer, from its homepage there is a Business Process icon. Please note you'll need the right privleges for access, as per the extensibility guide, section 7.1.4 (http://docs.oracle.com/cd/E15586_01/fusionapps.1111/e16691/ext_bpmc.htm#BABHHBEE)

  • Jae Kim Tuesday, July 29, 2014

    Hi, CRM Application Composer, providing more advanced functionality for creating custom business objects and actions. What's the advanced functionality that CRM application composer additionally provides ? Any related documentations to compare CRM application composer vs. Fusion Application Composer ? Thank you.

  • Richard Bingham Tuesday, July 29, 2014

    Hi Jae.

    To clarify, there is curently one "Application Composer" feature in the Fusion Applications product suite, and it exists in the CRM products at this time. It has embedded the Data Composer feature for extending custom objects and fields.

    Beyond this, there is Page Composer (for the UI) and Process Composer (for BPM). Check out other blog articles on Application Composer and our YouTube site for demos.



    Kind regards


  • Jae Kim Tuesday, August 5, 2014

    Thanks, Richard.

  • Juan Monday, January 11, 2016


    Maybe this is a little out-of-topic, but do you know how can I extend the Oracle ERP Cloud (https://cloud.oracle.com/en_US/erp-cloud)? Does it has a PageComposer, Groovy, etc?

    As far as I could see, every cloud "product" has its own custominzing approach, is that correct?

    thanks in advance


  • Richard Bingham Monday, January 11, 2016

    Hi Juan

    All families (including ERP Cloud) have Page Composer, plus you have Sales, Projects, and Innovation Management also having Applications Composer at this time (r10). For more, see here: https://blogs.oracle.com/fadevrel/entry/application_composer_in_fusion_projects

    Kind regards


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.