My Oracle Support Banner

Legal Entity ID Column V_LV_CODE Missing from STG_OTHER_SERVICES & Related T2T Data Mapping (Doc ID 2620200.1)

Last updated on JUNE 11, 2021

Applies to:

Oracle Financial Services Data Foundation - Version 8.0.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Data Foundation (FSDF)

Symptoms

In FSDF 8.0.6, the Out of the Box (OOTB) T2T_OTHER_SERVICES is missing a mapping for LEGAL_ENTITY_ID on FSI_D_OTHER_SERVICES.  You tried adding a new mapping that is similar to the mappings used by other key dimensions:

NVL(DIM_LEGAL_ENTITY_B.LEGAL_ENTITY_ID, -1)

However, when you run the T2T, you get the following error in the logfile in /<ftpshare>/logs/<MIS Date>/<Infodom>/LOAD DATA:

DIM_LEGAL_ENTITY_B.LEGAL_ENTITY_ID : invalid identifier

Reviewing the T2T definition, there is no join between DIM_LEGAL_ENTITY_B and STG_OTHER_SERVICES because the column V_LV_CODE does not exist on STG_OTHER_SERVICES.  The T2Ts for other staging tables use this column to join to DIM_LEGAL_ENTITY_B and populate LEGAL_ENTITY_ID.

As a result of the missing column, you cannot move Legal Entity values from the staging table to the data table.

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


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