My Oracle Support Banner

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)

Symptoms

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

Cause

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
Symptoms
Cause
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.