My Oracle Support Banner

How To Calculate Net Total Income at Management Ledger Level Through PFT Allocation? (Doc ID 2785617.1)

Last updated on JULY 01, 2021

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Key Processing Dimension (KPD)
General Ledger (GL)

Goal

How to set up an allocation to achieve below scenario?

The case is to substract many Income GLs - by several Expense GLs -> for all Key Processing Dimensions (KPD) (such as Org Unit, Customer Segment) in the Management Ledger, to arrive at the Net Total Income for these KPDs.

Example:
Org Unit 1 : Income = 100 & Expense = 30
Org Unit 2 : Income = 60 & No Expense
Org Unit 3 : No Income & Expense = 20

Expected Output for Net Total Income:
Org Unit 1 = 70 (100 - 30)
Org Unit 2 = 60 (60 - 0)
Org Unit 3 = -20 (0 - 20)

The following options were tried, but the output is incorrect:
1. Dynamic - Simple distribution: Only works with macro in Output; hence ignores Org 2 and Org 3 in above data set.
2. Field - Expects the difference in data-set only at 1 KPD leaf value > hence does not work across multiple GLs and FE IDs for same Org Units.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.