Photo by fabio on Unsplash

Integrating Capital Module with Financials in Oracle EPM

Arun Raj

--

Many of you already know this. However, I have seen time and again running into the same questions from consultants regarding the option of integrating capital module data with financials module.

In this post, I want to make it easy for you.

High Level Process Overview

At a high level the entire process can be broken down into 3 different sub-categories.

  1. Account dimension setup
  2. Financial Statement Mapping
  3. Data Map to Push data to Financials module

Let’s dive into each one in more detail.

Account Dimension Setup

The first thing to configure are the accounts that you want to use in Financials to capture the data from Capital Module. Let’s focus on few of expenses, mainly, depreciation, insurance, maintenance and repairs.

You need to configure the financials accounts you want to use as shared members rolling up to OFS_Capex_FinStmt_Integration.

The above screenshot shows you the 4 accounts being configured as children and rolling up to the OFS_Capex_FinStmt_Integration account. Remember that these are created as shared accounts.

Financial Statement Mapping

The various expenses are captured in Capital Module using the out of the box account members. We need a way to move the data from those account members to the Financial Accounts you have configured in Step 1.

The below screenshot shows you all those accounts.

Let’s see how we can map these members to the financial accounts. Head over to Application > Configure > Capital > Map Capital Accounts to Fin Statement (Tangible Assets).

Once you are in the form, you will see the Asset Classes on the rows and Capital Expense…

--

--

Arun Raj

Mostly write about Oracle Cloud ERP and EPM related Topics. Interested about emerging AI technologies, Python and Low Code Tools