My Oracle Support Banner

How To Get Allocations On Transaction or Instrument Tables To Accumulate Not Overwrite (Doc ID 281302.1)

Last updated on NOVEMBER 01, 2019

Applies to:

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


You are looking for a way to have the results of an Allocation ID to a Transaction table accumulate instead of overwrite the current value in the column. For example, when a new Allocation ID writes to Ledger_Stat, an extra row is inserted with the IDENTITY_CODE for that allocation into Ledger_Stat, the original balances are not overwritten.

For example:

You are trying to run some demo fees allocations from a Transaction table. You need to allocate only a part of the fee and keep the rest on the record. The example is as follows:


Multiply By

Debit: Consumer_loans_transactions.Volume

The allocation updates the record in the following manner:
Consumer_loans_transactions.Cost= -33.33

This calculation overwrites the original cost of 100 with the calculated result of -33.33 instead
of adding a row as it does in the Ledger_Stat or writing the result of 66.67.


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.