My Oracle Support Banner

'Table STG_INSTRUMENT_CONTRACT_MASTER Is Part of an Existing Extract/Definition' Generating FTP Source (Doc ID 2882833.1)

Last updated on OCTOBER 30, 2023

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.1 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.1.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)


In an environment where FTP 8.1.x is the only application installed, you are unable to generate Data Source in Data Management Tools > Data Source.  When attempting to save the data source for the first time post model upload, you get the errors below:

[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.

When checking the STAGING_SMG.log, the following error exists:

[22-06-22 21:05:02,643 GMT PM] [DEBUG] [<ADMIN USER>] [DMT] [SMGHandler]~[writeLog]~CHECKING VALIDITY OF EXTRACT -->T2T_ASSET_BACK_SEC
[22-06-22 21:05:02,683 GMT PM] [DEBUG] [<ADMIN USER>] [DMT] [SMGHandler]~[writeLog]~Table STG_INSTRUMENT_CONTRACT_MASTER is part of an existing Extract/Definition but doesnot exist in the new SourceModel.
[22-06-22 21:05:02,683 GMT PM] [DEBUG] [<ADMIN USER>] [DMT] [SMGHandler]~[writeLog]~So please delete or remove the table from the EXTRACTS DEFINITION

As a result, you cannot update the data mapping extracts in this data source.


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

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