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 laterOracle 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! |