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 184.108.40.206.0 [Release 8 to 8.1]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
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:
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.
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).
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