Thursday, October 19, 2023

How to Create Custom Pages using Application Composer in Oracle Fusion Cloud

"Can we have some new pages/forms created in ERP Cloud ?" or "Business requires to collect and maintain some additional information in ERP Cloud. Is this possible?"
These are some inevitable questions asked by many ERP users, especially after transitioning from Oracle EBS to Oracle ERP Cloud. Well, the answer is 'Yes'. 
Application Composer is a powerful tool that enables us to create custom pages as per business requirements. Let's see how to use Application Composer.

Roles Required:

First of all, in order to be able to access Application Composer tool, one needs to have
'Custom Objects Administration Role'. Role Code is ORA_CRM_EXTN_ROLE.
Additionally, one may be granted these roles:
Customer Relationship Management Application Administrator
Application Implementation Consultant
Master Data Management Application Administrator

Now, lets access Application Composer and we'll create a new page to capture view, and maintain Customer Details (PS. This has no relation to AR Customers. This will be an independent page with it's own data structure in the backend).

Activate Sandbox:

First of all, we have to activate a new Sandbox. Let's name it CustomerDetails and select Application Composer under Tools. Create and Enter the Sandbox.

Application Composer:

Now, you will see a new option named 'Application Composer' under Configuration menu. Open it.

Now we have entered the Application Composer tool.

Let's change Application to ERP and SCM Cloud.

Custom Objects:

Now you will see various options in the Right pane. Click on Custom Objects.

Now, enter the information in order to create new Custom Object as shown below:

Display Label: This defines a user-friendly name for an object.

Plural Label: The plural label is used when the object is displayed as the detail section of a master-detail page, such as on a subtab.

Record Name Label: This field is used to specify the display label for the object's RecordName field.

Record Name Data Type: Choose between Text or Automatically Generated Sequence.

Prevent Duplicate Values: With this box checked, one can prevent users from inputting duplicate record names.

Object Name: This is the internal identifier of the object and needs to be unique.

Description: Description of the object.

Now, our custom object named 'Customer Details Page' has been created.


Now, we need to create the Fields. These are basically the columns we need to capture information into.

Navigate to Customer Details Page object and click on Fields in Left Pane.

Now, lets click Create a custom field button in Right Pane.

This brings a pop-up page asking for the Data Type for this field. Let's select Text for our use case and click OK.

Now, let's create three fields by following above process.

Customer Name:

Customer Email:

Customer Address:

Here, we have marked Customer Name and Customer Email fields as Searchable. This will enable users perform search on the existing data set based on these two fields.

Here's the snapshot of all our fields:


Now, let's build the Pages and show above fields on the same for Viewing as well as Data Entry purpose.

Navigate to Pages and click on 'Create Default Pages'

We will see this message while it created Default Pages for us.

Once completed, we should see primarily three Pages -

Landing Page: As the name indicates, this is the first/landing page we will see when we enter Customer Details area.

Creation Page: This is the page which enables us to create new records and is shown when user clicks on Create button.

Details Page: This page lets us see more details of a particular record and is shown when user clicks on a particular record from the search results.

Now, let's click on Default custom layout option under Landing Page Layout

Here, click on Edit option under Summary Table

Now, let's select all the desired columns and move them to the Selected Fields section

Save and Close


Similarly, let's click on Default custom layout option under Creation Page Layout

Here, we need to click Edit option under PageCreate section as shown below:

Now, let's select all the desired columns and move them to the Selected Fields section

Save and Close


And finally, click on Default custom layout option under Details Page Layout

Here, we need to Edit the SubTab:Summary section as shown below:

Let's select all the desired columns and move them to the Selected Fields section

Save and Close


At this stage, we are pretty much done with the steps to create our Customer Details page.

Here we can either chose to Preview the Sandbox OR Publish it.


Using either of the above options, we will return to the home page of Fusion Applications.

Navigate to Others tab and we will see our newly creates 'Customer Details Page'.

OR the same can be accessed from the Others submenu under the hamburger menu:

Once we open the Customer Details, we will see below screen.

Here, we can see a section with No results found. This is our Landing page.

Let's click on Create button to open our Creation Page and well enter test data and Save.

Once we return to the Landing Page, we will now see the test Customer we just created.

Now, if we click on the Customer1 field, it will take us to Details Page where we will see all the details of this customer

Details Page:

This way we can create custom pages using the Application Composer tool in Fusion Cloud.



Post a Comment