Instrument Table Validation Missing Column Errors After Upgrade to PFT 6.1.1

(Doc ID 2006024.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)
Table Classification
Batch_Table_Class_Req

Symptoms

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:

ERROR

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;

BRANCH_CD
CUR_BOOK_BAL
TEASER_END_DATE
TP_AVERAGE_LIFE
TP_DURATION
TP_EFFECTIVE_DATE
TRANSFER_RATE
TRANSFER_RATE_ALT
TRAN_RATE_REM_TERM
TRAN_RATE_REM_TERM_ALT

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 6.1.1.1.
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.

Changes

 Upgrade to OFSAA 6.1.1.

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