OFSAA 5.5 REV_COLUMN_REQUIREMENTS Insert Statements in the dm_common_ins_5_5.sql Script Are Incorrect
Last updated on FEBRUARY 03, 2012
Applies to:Oracle Financial Services Profitability Management - Version: 5.5
Oracle Financial Services Funds Transfer Pricing - Version: 5.6 and later [Release: 5 and later]
Oracle Financial Services Analytical Applications Infrastructure - Version: 7.2.8 and later [Release: 7 and later]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.5
The assigned REV_DATA_TYPE_CD in the REV_COLUMN_REQUIREMENTS table is "9" FREQ for the new multiplier fields.
The new fields with incorrect data types:
Expect correct rev_data_type_code assignments for frequency and multiplier fields.
The issue can be reproduced at will with the following steps:
1. Apply OFSAA 5.5 patches.
2. Check REV_COLUMN_REQUIREMENTS.REV_DATA_TYPE_CODE for the following fields:
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