My Oracle Support Banner

"Table STG_CORRESPONDENT_ACCOUNT is part of an existing Extract/Definition but doesnot exist in the new SourceModel" Saving STAGING Data Source in 8.0.7 (Doc ID 2596918.1)

Last updated on SEPTEMBER 29, 2023

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Oracle Financial Services Profitability Management - Version 8.0.7 and later
Information in this document applies to any platform.
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)
Table to Table (T2T) Data Mapping
Data Management Tools (DMT)

Symptoms

On OFSAAI 8.0.7.1.0 after PFT 8.0.7 Application Pack installation, when trying to generate the source model for STAGING, the below error occurs in the Generate Source Model Log:

ERROR

[23-09-19 18:32:16,482 GMT PM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~CHECKING VALIDITY OF EXTRACT -->T2T_CORRESPONDENT_CASA
[23-09-19 18:32:16,506 GMT PM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~Table STG_CORRESPONDENT_ACCOUNT is part of an existing Extract/Definition but doesnot exist in the new SourceModel.
[23-09-19 18:32:16,506 GMT PM] [DEBUG] [SYSADMN] [DMT] [SMGHandler]~[writeLog]~So please delete or remove the table from the EXTRACTS DEFINITION

1.STG_CORRESPONDENT_ACCOUNT table does not exist in the database
2.STG_CORRESPONDENT_ACCOUNT does not exist in the delivered PFT 8.0.7 model

The issue can be reproduced at will with the following steps:
1. Data Management -> Data Sources -> Edit "STAGING SOURCE"
2. Generate Model - Catalog selected
3. Fails with on screen popup error:

[665530] Edit failed
[311502] Error validating source model with the previous version
[665536] Check /ftpshare//INFODOM/dmt/source/STAGING/log/STAGING_SMG.log file for more details

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.