FILLER Fields Created Randomly in F2T Extract Causes Load to Fail (Doc ID 1969958.1)

Last updated on AUGUST 18, 2016

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 7.3, after you update a F2T File Extract to set a column to a constant value, when you try to execute it, the F2T does not load successfully.  When you look at the SQL*Loader log file in /<ftpshare>/<indodom>/logs/<data source>, there are "FILLER" columns between the columns being sourced by data and the columns set to a constant value.

For example:

N_BREAK_FUNDING_AMT                  NEXT     *   ,       CHARACTER            
V_SOURCE_ACCOUNT_NUMBER              NEXT    50   ,       CHARACTER            
FILLER49                             NEXT     *   ,       CHARACTER            
  (FILLER FIELD)
FILLER50                             NEXT     *   ,       CHARACTER            
  (FILLER FIELD)
FILLER51                             NEXT     *   ,       CHARACTER            
  (FILLER FIELD)
N_INCR_MAINT_EXP                                          CONSTANT
    Value is '0'
N_INCR_ORIG_EXP                                           CONSTANT
    Value is '0'
N_INCR_TRANS_EXP                                          CONSTANT
    Value is '0'


These FILLER columns cause the F2T load to fail.  They trigger errors like the following in the SQL*Loader log:

Record 1: Rejected - Error on table STG_TD_CONTRACTS, column FILLER49.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 2: Rejected - Error on table STG_TD_CONTRACTS, column FILLER49.
Column not found before end of logical record (use TRAILING NULLCOLS)

The source data file does not have any extra unused fields in any records.  You do not understand why the FILLER fields are added.

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