'Column LEGAL_ENTITY_ID which is not in the table DIM_ACCOUNT' Error Running Source Model Generation

(Doc ID 2024545.1)

Last updated on JUNE 26, 2015

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT) or Asset Liability Management (ALM) 8.0, you get the following error in the log file after running the Source Model Generation for the "Staging" data source:

CHECKING VALIDITY OF EXTRACT -->T2T_STG_CASA_TXNS_SUMMARY
Column LEGAL_ENTITY_ID which is not in the table DIM_ACCOUNT
So please delete or remove the column from the EXTRACTS DEFINITION

Note: The log file is located in /<ftpshare>/STAGE/<DataSource>.

Steps to Reproduce:

  1. Go to Data Management Tools
  2. Go to Data Sources
  3. Under "Mapped Sources", select the PFT/ALM Staging Data Source
  4. Under "Map", in "Source Applications", click on the PFT/ALM Staging Data Source
  5. Select "Generate Source Model"
  6. Click Ok to replace the existing source if prompted
  7. Click on Generate in the Generate Source Model window

You get the message "[4048] For more information check the log file".  The error is found in the log file in /<ftpshare>/STAGE/<Data Source>.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms