F2T Extract Batch Fails with 'Mapping File is not the Latest'

(Doc ID 1676932.1)

Last updated on JUNE 06, 2014

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) infrastructure, when you run an F2T (File to Table) extract, the F2T batch fails. The following message is listed in the Batch Monitor screen under "Event Log" when you select the Task row:

[7924] Mapping file is not the latest. Save the mapping file to reflect the changes in the definition.

The following messages are in the DS_*.log in $FIC_DB_HOME/log/dmas:

Log Message here 1: Tue May 20 18:56:38 2014||DEBUG||CheckIfMappingIsValid : Definition file name : STG_PRODUCTS_B_INTF
Log Message here 1: Tue May 20 18:56:38 2014||DEBUG||CheckIfMappingIsValid : Source name : FS_SOURCE
Log Message here 1: Tue May 20 18:56:38 2014||INFO||CheckIfMappingIsValid : Mapping query : SELECT V_INFODOMAIN FROM ETLCONTROL WHERE upper(V_INFODOMAIN)='<infodom>' AND V_SOURCENAME='FS_SOURCE' AND V_FILENAME='STG_PRODUCTS_B_INTF'
Log Message here 1: Tue May 20 18:56:38 2014||INFO||CheckIfMappingIsValied : Before Create statement
Log Message here 1: Tue May 20 18:56:38 2014||INFO||CheckIfMappingIsValied : After Create statement
Log Message here 1: Tue May 20 18:56:38 2014||INFO||CheckIfMappingIsValied : Before Fetch data
Log Message here 1: Tue May 20 18:56:38 2014||INFO||CheckIfMappingIsValied : After Fetch data
Log Message here 1: Tue May 20 18:56:38 2014||SEVERE||CheckIfMappingIsValied : Before Number of rows fetched > 0
Log Message here 1: Tue May 20 18:56:38 2014||SEVERE||CheckIfMappingIsValied : Before Return -3
Log Message here 1: Tue May 20 18:56:38 2014||INFO||fic_loading : After mapping check
Log Message here 1: Tue May 20 18:56:38 2014||INFO||DmasServer, Error : Returning FAILURE


The error prevents you from loading data from the text file specified by the F2T Extract into the STG_PRODUCTS_B_INTF table using a Batch.

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