My Oracle Support Banner

How To Write An Allocation To Get The Difference In Two Sets Of Data In Ledger_Stat (Doc ID 283178.1)

Last updated on FEBRUARY 17, 2020

Applies to:

Oracle Profitability Manager - Version 4.5.39 and later
Oracle Financial Services Profitability Management - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA)
Oracle Performance Analyzer (PA) - Version: 4.5

Goal

For data in LEDGER_STAT table, you want an allocation which finds the difference between the sum of four lines, and the sum of three other lines (delineated by combination of leaves). For example, you would like to see the following:

FE            ORG          COMMON            AMOUNT
100          1001          302145             $100
100          1002          302145             $200
100          1003          302145             $300
100          1004          302145             $350

SUM = $950

FE           ORG           COMMON       AMOUNT
100          1001          302155       $ 50
100          1002          302155       $100
100          1003          302155       $400

SUM = $550

OUTPUT:  
FE              ORG         COMMON         AMOUNT
15005          9999         302155         $400

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!


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