My Oracle Support Banner

Table <Table Name> is part of an existing Extract/Definition but doesnot exist in the new SourceModel (Doc ID 2692671.1)

Last updated on JULY 23, 2020

Applies to:

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

Symptoms

When attempting to generate the Source Model in Data Management Tools > Data Sources, you get the error below in the log in /<ftpshare>/<Infodom>/dmt/source/<data source>/log when opening the data source and saving:

[01-07-20 16:14:38,669 GMT PM] [INFO ] [WEB] [RWATTON] [DMT] [SMGHandler]~[writeLog]~[SMGHandler] [SMGLog for Source STAGING ]
Table <Table Name> is part of an existing Extract/Definition but doesnot exist in the new SourceModel.
[01-07-20 16:14:38,669 GMT PM] [INFO ] [WEB] [RWATTON] [DMT] [SMGHandler]~[writeLog]~[SMGHandler] [SMGLog for Source STAGING ]
So please delete or remove the table from the EXTRACTS DEFINITION

As a result of this error, you cannot use T2T extracts associated with the source.

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.