Custom Asset Funding Source Extension in Oracle Fusion

 

Custom Object/Form creation in Oracle Fusion

1. Introduction / Use Case

In many organizations, asset acquisition is not funded by a single source. A single asset may be financed through multiple channels such as departmental budgets, grants, project funds, loans, or external sponsors, with each source contributing a specific portion of the total asset cost. While Oracle Fusion Assets provides strong standard capabilities for asset creation and accounting, it does not natively offer a way to capture detailed multi-source funding information at the asset level. This creates a challenge for organizations that require funding traceability, audit support, and consolidated reporting. To bridge this gap, a custom extension built through a sandbox-based object and form can be used to store funding source details and funded amounts for each asset, while still leveraging Oracle Fusion’s native tools for bulk upload and reporting.

2. Solution Overview

The proposed solution extends Oracle Fusion using a custom object to store asset funding source details. A custom form or UI allows users to enter and maintain funding lines against an asset. This extension works alongside Oracle standard asset records without changing the delivered Oracle functionality.

The design supports:

• Capturing one or many funding sources for a single asset
• Storing the funded amount by source
• Bulk uploading data using Oracle Fusion’s native Excel-based integration
• Reporting using BI Publisher by joining the custom object with Oracle asset base tables
• Improving auditability and funding transparency for finance and asset teams
• The access to custom user interface controlled by job role

 

3. Implementation steps

·         To create these custom objects, you require "Custom Objects Administration" Job Role assigned to your user.

·         And you can create Custom Objects only in Sandbox with "Application Composer" tool.

·         After entering Sandbox, click on Sandbox tools-> Application Composer Or click on Navigator expand the group "Configuration" and you will find "Application Composer".

·         Select the Application Name as ERP and SCM Cloud, Click on plus sign on Custom Objects.

Custom Objects

 Click to Add the custom object

·         Adding Custom object and the object details as below, note the object name as you will use later to find out which table Oracle Fusion is storing the custom object details to use for BI Publisher reporting later.

Include Object Details

Asset Funding Source details

·         Object components

Now the object is created, we will proceed to add Fields to the Object

Add Fields

Create Fields

Select the Field type based on format and proceed to add details

Field Type,

·         Then Save and Close. You can Add any number of Fields

·         Below is the detail of all the field created.

·         Navigate to pages as shown below to configure the page.

·         You should be able to see the Landing page layouts under Application pages and Click on Layout name

·         Then see the Landing page layout and click on summary table

·         Select all the fields that need to be on the page. Select the fields in Available fields after that click on Right Arrow Icon to move the fields to selected fields  

 

·         Once you selected all fields then click on Save and close and Done

·         Review the Creation page layouts under Application pages and Click on Layout name

·         Click on Asset Funding Source Name

·         Choose the field you want to be available in page for create action.  Select the fields in Available fields after that click on Right Arrow Icon to move the fields to selected fields.

·         Once you selected all fields then click on Save and close and Done

 

·         Review the Details page layouts under Application pages and Click on Layout name

·         Click on Summary

 

Choose the field you want to be available in the detail page. Select the fields in Available fields after that click on Right Arrow Icon to move the fields to selected fields.

·         Once you selected all fields then click on Save and close and Done

·         To test the asset funding source form created click on Navigator, expand the others and you will find Asset Funding Source

·         Click on Create button

·         Enter the Required information

·         Then Click on save and close, See the result

·         Once satisfied with the results then You can then Publish the Sandbox and the Custom Object is created. Now let's see how to use this custom object.

·         Navigate to Application Composer and select Application i.e. ERP and SCM Cloud. Then select Metadata Manager and Click to Generate the Configuration Report

 

Once the Configuration Report is generated then select Export button to download the report. You will be able to see the Custom Object details created in the sheet. You can use the column names with the table name information to fetch the details added in the Custom object.

----- Below query to find the table that contains custom object columns.

SELECT OBJECT_ATTR_NAME AS ATRRIBUTE, TXN_VO_ATTR_TABLE tab_name, TXN_VO_ATTR_COL col_name

FROM FUSION.MKT_IMP_OBJECT_DETAILS D, FUSION.MKT_IMP_OBJECT_ATTRS A

WHERE D.OBJECT_DETAIL_ID=A.OBJECT_DETAIL_ID

AND A.OBJECT_ATTR_COL LIKE '%EXTN_ATTRIBUTE%' AND A.CREATED_BY != 'SEED_DATA_FROM_APPLICATION'

AND D.OBJECT_DETAIL_TABLE != ' MOT_REF_ENTITIES'

Get the table name and object name for the custom object from above query and use in the below query to get the data stored in custom object. Since, Asset number is one of the column in custom object so it can be joined with FA_ADDITIONS_B.asset_number to produce meaningful report of asset, category and funding source and funded amounts.

 SELECT

 RECORD_NUMBER

,RECORD_NAME

,EXTN_ATTRIBUTE_CHAR006  " Asset Number"

,EXTN_ATTRIBUTE_CHAR007  "Funding type"

,EXTN_ATTRIBUTE_CHAR008 "Funding Source"

,EXTN_ATTRIBUTE_NUMBER006 “Funding Amount”

,EXTN_ATTRIBUTE_TIMESTAMP001 “Funding Start Date”

,EXTN_ATTRIBUTE_TIMESTAMP002 “Funding Expiration Date”

,EXTN_ATTRIBUTE_CHAR009  “Regulatory Restrictions”

,EXTN_ATTRIBUTE_CHAR010  “Retirement Restrictions”

,CREATED_BY

,CREATION_DATE

,LAST_UPDATED_BY

,LAST_UPDATE_DATE

FROM MOT_REF_ENTITIES /*GET THE TABLE NAME FROM ABOVE QUERY HERE EXAMPLE MOT_REF_ENTITIES*/

WHERE ATTRIBUTE_CATEGORY = ' :P_CUSTOM_OBJECT'  /* GET THE CUSTOM OBJECT NAME FROM PREVIOUS QUERY */

4. Conclusion

By implementing a custom object and form to capture asset funding sources, organizations can extend Oracle Fusion beyond its standard capabilities and gain meaningful financial transparency. Leveraging native Excel-based integrations enables efficient bulk data uploads, reducing manual effort and ensuring data consistency at scale. Furthermore, by joining this custom extension with Oracle’s asset base tables, finance teams can generate comprehensive reports that clearly map assets to their respective funding sources and amounts. This approach not only enhances reporting accuracy but also supports better decision-making, audit readiness, and financial traceability—turning a functional gap into a strategic advantage.