Instrument Table Validation Missing Column Errors After Upgrade to PFT 6.1.1
Last updated on AUGUST 04, 2017
Applies to:Oracle Financial Services Profitability Management - Version 6.1.1 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
On Oracle Financial Services Profitability Management (PFT) 6.1.1, after upgrade to 6.1.1 from 6.1, several user defined tables are failing table classification 310 Instrument Profitability. The following errors are found in FSI_MESSAGE_LOG after running the Instrument Table Validation Batch_Table_Class_Req procedure:
FAILED: Column BRANCH_CD was not found for table XX_D_INSTRUMENT in rev_tab_columns
FAILED: Column CUR_BOOK_BAL was not found for table XX_D_INSTRUMENT in rev_tab_columns
Many columns are found to be missing that are not required in the user defined instrument tables:
select * from rev_property_columns
where table_property_cd in (select distinct table_property_cd
from rev_table_class_properties where table_classification_cd = 310)
order by column_name;
The issue can be reproduced at will with the following steps:
1. Merge model from 6.1 data model into 6.1.1 as part of upgrade from PFT 6.1 to PFT 188.8.131.52.
2. Perform model upload successfully
3. Run Batch_Table_Class_Req Instrument Table Validation batch
==> Find it fails on Instrument Profitability 310 for the instrument tables.
Upgrade to OFSAA 6.1.1.
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