My Oracle Support Banner

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

Last updated on MARCH 02, 2023

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)


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.

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.


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

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