My Oracle Support Banner

V_ACCOUNT_MANAGER_CODE Data Length is Inconsistent (Doc ID 2561493.1)

Last updated on MAY 10, 2021

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.5 to 8.1.0.0.0 [Release 8 to 8.1]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Goal

On 8.0.5 version,  V_ACCOUNT_MANAGER_CODE data length is inconsistent for STG_ACCOUNT_MGMT_MASTER versus other Staging and Dimension tables.

The following queries show differences:

Query 1
select * From rev_tab_columns where column_name = 'V_ACCOUNT_MANAGER_CODE';
--ALL STG_* tables, DIM_*, FACTS have data type size of 20 characters; but in STG_ACCOUNT_MGMT_MASTER data type size is 50 characters.


Query 2
select * From rev_tab_columns where column_name = 'V_PARENT_MANAGER_CODE';
--DIM_MANAGEMENT, STG_ACCOUNT_MGMT_MASTER data type size are both 25 characters.
 

The out of the box SCD configuration - 62 (map_ref_num) fails, when the data present in the STG_*_MASTER table holds values greater than 20 characters (since the limit is 50 chars).

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.