Mismatch in Size Between V_ORG_UNIT_CODE on STG_ Table and ORG_UNIT_CODE on DIM_ Table
(Doc ID 2438191.1)
Last updated on SEPTEMBER 27, 2019
Applies to:Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Data Foundation - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
For Oracle Financial Services Profitability Management (PFT) 8.0.x, there is a mismatch in size between the source 'Code' column and target 'Code' column for the Org Unit dimension tables:
DIM_ORG_UNIT_B - ORG_UNIT_CODE: VARCHAR(20)
STG_ORG_UNIT_B_INTF - V_ORG_UNIT_CODE VARCHAR(40)
This mismatch in column size can result in the following error when loading dimension data:
ORA-01438: value larger than specified precision allowed for this column
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