Columns and Coefficients in Static Table Driver Missing After Save
Last updated on JANUARY 05, 2018
Applies to:Oracle Financial Services Profitability Management - Version 184.108.40.206 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On Oracle Financial Services Profitability Management (PFT) 220.127.116.11, 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.
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.
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
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