Cannot Undo an Instrument to Ledger Stat Allocation with All Zero Balances (Doc ID 1461317.1)

Last updated on MAY 29, 2012

Applies to:

Oracle Financial Services Profitability Management - Version 5.2 to 5.6 [Release 5]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT) 5.2, you have rows in LEDGER_STAT created by instrument table to Ledger Stat Allocations with all 0 values in the MONTH_xx balance columns.  When you run undo for an Allocation that is associated with one of the all zero rows, the row is not deleted from LEDGER_STAT.  Rows are deleted from FSI_DATA_IDENTITY and FSI_M_DATA_IDENTITY_DETAIL.  As a result, you end up with all zero rows left in LEDGER_STAT that do not have a corresponding entry in FSI_DATA_IDENTITY.

You expect the Undo process to remove all rows from Ledger Stat associated with the Allocation, including rows with all zero balances.

Cause

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 hundreds of Community platforms