OFSA Instrument Allocation Is Accumulating Column Values After an Undo
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.
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:
- Log into Oracle Performance Analyzer
- Create an instrument table Allocation ID
- Run the Allocation ID for two or more months
- For the 2nd month, after running the Allocation the first time, undo it
- After undoing, reset any columns that need to be reset (the undo process zeroes out columns
even if they previously held a value)
- Re-run the Allocation ID and the results will be double-counted
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms