My Oracle Support Banner

"Error. Multiple Source table for dimension not supported " Error Running Fn_STGDimDataLoader After Upgrade (Doc ID 2738558.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.0.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

On 8.1 after upgrade from 8.0.7 version, the fn_STGDimDataLoader Dimension Loader is failing with errors. From the TRANSFORM DATA_INFODOM_ICC_DRM_CUSTOMER_LOADS_20201231_1_Task1_DTCPP.log:

ERROR

[15-12-20 13:02:32 GMT PM][INFO][BACKEND][OFSAA][DTCPP] Stmt : update AAI_DMT_PLC_EXECUTE set v_status='F' where v_Infodom_Code='INFODOM' and v_obj_id='9248ACFC5BBD29A3E0534C62120A8B6A'
[15-12-20 13:02:32 GMT PM][INFO][BACKEND][OFSAA][DTCPP] Task status : 1
[15-12-20 13:02:32 GMT PM][INFO][BACKEND][OFSAA][DTCPP] Task Failure


The FSI_MESSAGE_LOG shows the following error:

Error. Multiple Source table for dimension not supported

The issue can be reproduced at will with the following steps:
1. Upgrade to 8.1 from 8.0.7
2. Run the Dimension Loader for the Customer Dimension

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.