My Oracle Support Banner

Columns and Coefficients in Static Table Driver Missing After Save (Doc ID 1990148.1)

Last updated on JANUARY 05, 2018

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.0.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On Oracle Financial Services Profitability Management (PFT) 6.1.0.3, when attempting to update a large static table driver using the Excel Import, there are columns and co-efficients missing from static table driver after saving. This issue is intermittent.

ACTUAL BEHAVIOR
After saving the table, some of the columns in the table are missing or the coefficients are shifted to the left. Checking the the FSI_M_ALLOC_TABLE_DETAILS table, there also appear to be missing values which is causing the incorrect display in the UI.


EXPECTED BEHAVIOR
Expect proper save of large import of values from Excel Import in Static Table Driver.

The issue seems to appear when we use values imported from Excel and not when we manually input the values. The issue also seems random. Even when using the same test data, it does not always appear. For example, during latest testing with screenshots, issue only appeared on the seventh time attempted, after the logs were emptied. Issue does not reproduce using a small number of key and target dim members.

Similar issue also appears even when not using Excel export/import feature for edit or creation of any larger Static Table Driver.

The issue can be reproduced at will with the following steps:
1. Created a large Static Table Driver: Profitability Management -> Rule Specification -> Static Table Driver
2. Add a large number of dimension members as the key and target leaves
3. Export to Excel Spreadsheet
4. Make updates to co-efficient values
5. Import values from spreadsheet and Save
6. Re-open Static Table Driver and check FSI_M_ALLOC_TABLE_DETAILS

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.