My Oracle Support Banner

OFSA Instrument Allocation Is Accumulating Column Values After an Undo (Doc ID 431068.1)

Last updated on MAY 18, 2007

Applies to:

Oracle Financial Services Applications (OFSA) 4.5.39
Oracle Performance Analyzer - Version: 4.5.39
This problem can occur on any platform.


In Oracle Performance Analyzer 4.5, when multiple months of data exist, an instrument table Allocation ID is accumulating values in an instrument table column after an undo is run.  The Allocation takes an instrument table column and adds it to another instrument table column. The result is written to the first instrument table column.  After the Allocation is undone and re-run, the output double counts the first instrument table column and then adds the second instrument table column.


Note: Results for previous months exist in the instrument table for this Allocation.  The prior months results contains the same IDENTITY_CODE_CHG value.

Allocation Setup:

Filter On: FEM Consumer Loans.Adjustment_Total ($1,700.00)
Field: FEM Consumer Loans.Interest Income/Expense ($1,500.00)

Debit: FEM Consumer Loans.Interest Income/Expense

When the Allocation is run the first time, the result is correct: $3,200.00. When you undo the Allocation and run a second time, the result is $4,700.00. The Interest Income/Expense column is double counted: $1,500 + $1,500 + $1,700 = $4,700.00.

Steps To Reproduce:


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.