It's All About the Platform.

  • February 14, 2013

Tailoring Fusion Applications in the Cloud Explained

Richard Bingham
Senior Development Manager


This brief article is intended to clarify what you can and cannot do to Fusion Applications (Release 5) that are deployed as Software-as-a-Service (SaaS) via the Oracle Cloud. We’ve seen lots of questions on this subject and this article is intended to provide some clarity.  This does not cover options for private or hybrid Cloud deployments, such as through Oracle Managed Cloud / Oracle On-Demand. These dedicated environments may permit deeper system access, such as connections via JDeveloper, and therefore it is possible to perform more invasive customization work. For SaaS deployments personalization and customization is performed using the Composer family of tools, accessible from within Fusion Applications itself.

Oracle’s cloud services are evolving at a rapid pace, and as such where possible we have marked the applicable release. We will create new posts similar to this with any significant changes in each new release.

In addition, customers and partners are working on solutions outside the standard services and products, and these may include addition options for tailoring and extending the core functionality. An example of which is a recently deployed custom J2EE application in the Oracle Cloud Java Service that is integrated (via webservices) to an Oracle Cloud Fusion HCM instance.

Common Requirements Checklist

The following is a short list of activities that are commonly part of tailoring an Enterprise Application and provides confirmation if this is possible for an Oracle Cloud / SaaS deployment, and in which release.

Category Task Available
Flexfields Manage Descriptive Flexfields (DFF) and Manage Extensible Flexfields via FSM tasks Y

Import flexfield seed data Y

Include DFF in OTBI reports (a deployment option), but not EFF yet Y

Migrate flexfields from T2P via FSM export/import Y

Business Processes Edit or add SOA Composite Applications N

Edit existing Approval Rules Y

Add new approval processes to existing BPEL processes N

Use all standard AMX routing options N

BI & Reporting Add-to or edit the seeded BI Publisher (PDF) reports Y

Add-to or edit the BI Analytics reports Y

Edit the existing OTBI charts embedded in pages N

Add new all reports content to the custom folder of the BI Catalog Y

ESS Add a report to an new ESS Job Definition Y

Manually schedule a new ESS Job Y

Edit the VO-based input parameters used in an ESS Job N

Edit the application logic to use a new ESS job definition N

User Interface Change the regions of the UI Shell (although some options exist in the CRM Application Composer) N

Make a page personalizable if it is not by default, or change what can be personalized N

Change the Fusion Applications Skin – the look-and-feel including logos and colors N (coming soon)

Change the standard Fusion Applications Menu items N

Edit mobile-specific pages N

Translate text added via customization N

Change the seeded ADF task flows N

Add an entirely new page N

Change existing pages and workareas, including labels, layouts, and hide/show fields Y

Add/edit existing ADF Business Object field use on a page Y

Add Expression Language code to page components to extend validation logic Y

Change and extend the User Assistance / Help content (although not the embedded page content) Y

Summary and References

The table above is intended to answer some of the more common questions around what you can and cannot do in a SaaS-Cloud deployment of Fusion Applications. Of course there are many more options and features available than are listed here, and items that are not currently possible may be possible in the future. If you have business cases for any of these please let us know.

A more comprehensive list of what you can do with each of the Fusion Applications tools (Composers and JDeveloper) is provided in Tables 1-2 to 1-8 in Chapter 1 of the Fusion Applications Extensibility Guide.

There are some useful tips and recommendations in the MyOracleSupport notes entitled ‘Guidance for Managing Customizations in Oracle Cloud Application Services’, such as 1510580.1, 1510578.1, 1510577.1, and 1510288.1.

Join the discussion

Comments ( 32 )
  • guest Monday, May 20, 2013

    Hi Richard,

    I'm afraid that you've made some mistakes in your listing above.

    SaaS installations allow more flexibility for reporting. All of the following are available:

    - Add-to or edit the seeded BI Publisher (PDF) reports

    - Add new content to the BI Catalog

    - Add a new custom BI Report for execution via ESS

  • Richard Bingham Wednesday, May 22, 2013

    Hi. Thanks for this, you're right and I made the Y/N edits above. Regarding ESS, I removed reference to BI as well as the point was really centered around adding new ESS program code. Thanks again, Richard.

  • guest Friday, July 26, 2013

    Hi Richard

    When working with BI pulisher reports on SaaS Oracle cloud, can we create default packages (ie PL/SQL packages in db) for handling report triggers in case of complex reporting requirements ?

    Also, can we create temporary tables to store data so that it makes it easier to perform calcualtions for complex reporting?



  • Oliver Steinmeier Friday, July 26, 2013

    Gaurav, you generally don't have access to the database to create new schema objects or PL/SQL packages when you're using the Cloud solution.

  • somani Wednesday, September 18, 2013

    We have a requirement where we are getting a source file from a 3rd party containing transactions which need to be uploaded as Journal in GL. However with no option to create own staging tables, I am not able to transform data and create file as required by File Based Loader template. Please let me know how i can create my own sql loader file and load gl interface directly or does Fusion SAAS has some other capabilities to manage these requirements.

  • Richard Bingham Monday, October 7, 2013

    Hi Somani, Thanks for your comment and question. Firstly I would recommend that this could be best suited to a Financials functional forum as they'd be able to explain the options and best practices better than I. That said, after a little reading I first noted that GL journal import has support for the ADFdi spreadsheet plugin that might give you tools to transform/convert the raw data before loading into the GL interface table. I also noted that there is the journalImportService webservice as well, as another method/format of moving data into the GL interface. Both are available in SaaS.

    I hope this helps a little, and if I find anything else I'll let you know.

  • Suren Tuesday, October 15, 2013

    Hi - I'm working on Oracle SaaS based Fusion Release 5 & 7 environment, currently we have requirement for developing few OTBI reports - Real time.

    During our analysis and investigation stage - we find that there are couple of additional fields (like DFF) are not available in standard Fusion Business Areas of Procurement and Financials (AP, AR).

    What we would like to know is whether over SaaS is it allowed / possible to create or modify business area from where the OTBI data is fetched?

    If yes - we are allowed to create or modify business areas - how do we proceed any pointers.



  • Richard Bingham Tuesday, October 15, 2013

    Hi Suren.

    Firstly I thought you were considering adding custom fields where DFF's don't exist - which is either Application Composer (selected products) or ADFbc customization (on-premise).

    On re-reading I think you simply want to extend the existing OTBI reports to include some existing fields (such as DFF's) not currently shown. I guess the answer lies in which seeded reports you wish to extend. Items in the BI Catalog can be extended by adding fields, sure, and we do support exposing enabled DFF's in BI reports, often via a special extract job.

    This is quite product and report specific, so if the BI Composer screens are not showing those fields during customization right now, and there is no obvious additional process for their extraction (e.g. Application Composer has a process under 'Custom Subject Areas'), you'll need to get each related Product Dev teams to verify how/if they can get added into their OTBI usage.

    Hope this helps a little.



  • guest Thursday, May 15, 2014


    I am working on Oracle SAAS environment I have a question, can i get access to oracle standard webservices which i can use to create custom ADF application and can deploy it to Oracle java cloud?

    Thanks in advance

  • Richard Bingham Thursday, May 15, 2014


    Yes, you SaaS Fusion Application has externally published webservices you can call from your own ADF application deployed to the Oracle Java Cloud.

    This post from Oliver explains this:


    Also check out the posts tagged 'integration' and 'paas' which explain ways to do this:



    Hope this helps


  • guest Thursday, May 15, 2014

    Hi thanks for the prompt reply, so what you mean is that i can use my current SAAS environment webservices exposed....on which i can build a adf application. if i understand this right, then how can i achive this.

  • Richard Bingham Friday, May 16, 2014


    You are right. In terms of "how" then please review the blog posts to understand what web services are available, and the different ways you can call them from you own applications (including from an ADF app deployed on Java Cloud).

    Kind regards


  • guest Monday, May 19, 2014

    Hi Richard. Is there much change between version 5 & 7? Is this listing available for Version 7/8? Thanks.


  • Richard Bingham Friday, May 23, 2014

    Hi Grant.

    Only a few changes actually.

    In R8 you can now do more text customizations (including basic translations) using the User Interface Text tool, described here.


    Coming in Release 9 is the ability to customize the skin using an online editor tool.

    Since Release 7 you can customize the navigator and other menus more than before. See our video library for examples (youtube.com/fadevrel).

    Hope this helps


  • Sujoy Thursday, July 24, 2014

    Hi Richard,

    The FA Developer Relations channel (http://www.youtube.com/user/FADeveloperRelations) provides a lot of examples and are indeed helpful. But is there any way to know which of these are allowed on SaaS implementation?



  • Richard Bingham Thursday, July 24, 2014

    Hi Sujoy,

    Thanks for the feedback on the YouTube channel, glad it's helpful. The only content which is not applicable to SaaS are those featuring JDeveloper - which is just the ADF playlist and a couple of videos from the SOA-ESS playlist. All the rest are suitable.

    I hope this clarifies.

    Kind regards


  • Sujoy Thursday, July 24, 2014

    So anything which involves Jdeveloper/design-time customizations is not allowed on a SaaS implementation.

    Thanks for the clarification Richard!

  • Oliver Steinmeier Monday, July 28, 2014


    correct, you cannot deploy design-time customizations created with JDeveloper to SaaS implementations.

    (you can, however, extend Fusion Applications with JDeveloper using a PaaS offering like Java Cloud Service and deploy new UIs created with JDeveloper there)

  • Jeremy Thursday, February 12, 2015

    What about AMX in rel 9? I understand AMX is now extensible in R9.

  • Nitin Friday, February 13, 2015

    Dear Richard -

    Please could you revisit the page and update the relevant items with respect to Release 9.

    Also, could you confirm if the Application Composer is available for Financials, Procurement & HCM Product Lines. I understand that it is currently available only for Sales. Are there any plans to extend it to other product lines?

    Thanks in Advance,


  • Richard Bingham Friday, February 13, 2015


    As mentioned at the start of this article, it was originally written for Release 5 and things have obviously evolved. I will create a new post for Release 9 and share in the coming weeks.

    Jeremy, AMX by its nature is flexible in the options for setting up your approval rules, and with uptake of later releases more options become available. With Release 8 the interfaces for this evolved for many products, providing business administrators some simpler methods for creating the configurations. Was there something specific in AMX that you were looking to leverage?

    Nitin, You are right - Application Composer is only available in Oracle Sales Cloud. I cannot comment about future uptake in other areas, sorry.

    Kind regards


  • Nitin Friday, February 13, 2015

    Dear Richard -

    Thanks for your response back.

    I shall wait for your new post on Release 9 Extensions and Customizations.

    Best Regards, Nitin

  • Jeremy Friday, February 13, 2015

    My company is looking at Cloud Procurement. We have heavily customized workflows in R12. The procurement approvals are driven by purchasing categories along with the $$ amount using AME. Would like to know if we can reproduce AME rules in AMX.

    No clear documentation or I can't find it.

  • Richard Bingham Saturday, February 14, 2015

    Hi Jeremy

    Whilst I am not specialized in Fusion Procurement, Yes, on the whole AMX in Fusion Applications has equivalent features to AME in R12, and obviously configuring approvers based on purchasing document attributes is core to this. Take a look at the SOA channel from our YouTube video for examples, and as above bear in mind R9 has evolved.


    There are also some great content (articles and whitepapers) on setting up PO approvals for Fusion Procurement in the product documentation and in MyOracleSupport, such as the following:

    FAQ for Document Approval Setups in Fusion Procurement Products (Doc ID 1320368.1)

    How To Setup Approval Management (AMX) Rules (Doc ID 1320392.1)

    Setting Up Document Approvals In Oracle Fusion Procurement (Doc ID 1527190.1)

    Kind regards,


  • Jeremy Sunday, February 15, 2015

    Thanks Richard. Great info.

  • AS Tuesday, July 14, 2015

    Hi Richard ,

    I have to create journals in CLoud imple. Can you suggest Pros and cons of FBDI over webservice .

  • Richard Bingham Thursday, July 16, 2015


    Whilst I am not a Fincancials/GL expert there are certainly a few general considerations.

    1. Volume. The loaders are preferred for high volumes

    2. Real-time vs Batch. Again loaders for old data and WS for more current/new data via integration.

    3. Data cleanliness. The loaders offer more detailed correction/feedback if the data is invalid, whereas WS may respond with generic error messages.

    Usually both mechanisms will invoke the same business rules upon record creation, although please review the GL documentation for specific considerations.

    Hope this helps a little.


  • Bhargav Tuesday, August 18, 2015

    What are the customizations that can be and cannot be done in oracle sales cloud mobile application ?

  • Oliver Steinmeier Thursday, August 20, 2015

    Hello Bhargav,

    Thank you for your comment. Have you looked at this section of the doc?


    Please let us know if you need clarifications.



    Fusion Apps Developer Relations

  • Satyam Wednesday, June 21, 2017
    I have a requirement to build a new ESS Job Scheduling and reprocessing page. How do I start with it. I need to show the parameters values, Job Description and several other things related to Job. I can see the pages in SaaS but how do I go about to build a new component and deply it to my application.

    Thanks and Regards,
  • Federica Tuesday, July 18, 2017
    I have a question about Fusion Expenses: in which case can an expense auditor receive an email notification?

    Thanks and Regards
  • Oliver Steinmeier Thursday, July 20, 2017
    Hi Federica, we are unfortunately not functional experts, and the answer may very well depend on the version of Fusion Expenses. I recommend you reach out to Oracle Support via Service Request or their community forum at


    Hope this helps,
    Fusion Apps Developer Relations
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.