OFSAA 5.5 REV_COLUMN_REQUIREMENTS Insert Statements in the dm_common_ins_5_5.sql Script Are Incorrect (Doc ID 1350483.1)

Last updated on FEBRUARY 03, 2012

Applies to:

Oracle Financial Services Profitability Management - Version: 5.5 and later   [Release: 5 and later ]
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
PFT

Symptoms

On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) 7.2.9 / 5.5  Oracle Financial Services Profitability Management (OFSPM) / Oracle Financial Services Funds Transfer Pricing (FTP),  the install 5.5 scripts have incorrect REV_DATA_TYPE_CODE values for the new multiplier columns. In addition, the associated frequency columns with these multipliers have incorrect data types assigned as well.

ACTUAL BEHAVIOR
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:

ACCRETING_FREQUENCY
ACCRETING_FREQUENCY_MULT
PAY_LATER_FREQ
PAY_LATER_FREQ_MULT
EXERCISE_FREQUENCY
EXERCISE_FREQUENCY_MULT

EXPECTED BEHAVIOR
Expect correct rev_data_type_code assignments for frequency and multiplier fields.

STEPS
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:

ACCRETING_FREQUENCY
ACCRETING_FREQUENCY_MULT
PAY_LATER_FREQ
PAY_LATER_FREQ_MULT
EXERCISE_FREQUENCY
EXERCISE_FREQUENCY_MULT

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