Table Layout
CREATE TABLE FR_CAT5_CAPTION_REF ( 
  REPORT_SHORT_DESC_TX    VARCHAR2(20)   NOT NULL , 
  REPORT_CAPTION_DESC_TX  VARCHAR2(100)  NOT NULL , 
  ACTUAL_CALC_TX          VARCHAR2(4000)  NOT NULL ,
  BUDGET_CALC_TX          VARCHAR2(4000)  NOT NULL ,
  VARIANCE_CALC_TX        VARCHAR2(4000)  NOT NULL ,
  CONSTRAINT FR_CAT5_CAPTION_REF_PK PRIMARY KEY (REPORT_SHORT_DESC_TX,REPORT_CAPTION_DESC_TX)
)

Table Load Script
OPTIONS (DIRECT=FALSE,SKIP=1,BINDSIZE=2500000)
LOAD DATA
INFILE '$download/$file_name.dat'
BADFILE '$bad_data/$file_name.bad'
DISCARDFILE '$bad_data/$file_name.dsc'
TRUNCATE
INTO TABLE IO.FR_CAT5_CAPTION_REF
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
-- Identified Columns --
  (   REPORT_SHORT_DESC_TX     "TRIM(:REPORT_SHORT_DESC_TX)"
  ,   REPORT_CAPTION_DESC_TX   "TRIM(:REPORT_CAPTION_DESC_TX)"
  ,   ACTUAL_CALC_TX           "TRIM(:ACTUAL_CALC_TX)"
  ,   BUDGET_CALC_TX           "TRIM(:BUDGET_CALC_TX)"
  ,   VARIANCE_CALC_TX         "TRIM(:VARIANCE_CALC_TX)"
  )


ERROR MSG
Record 1: Rejected - Error on table IO.FR_CAT5_CAPTION_REF, column ACTUAL_CALC_TX.
Field in data file exceeds maximum length


Data File
REPORT_SHORT_DESC_TX|REPORT_CAPTION_DESC_TX|Syntax - Actual|Syntax - Budget|Syntax - Variance to Budget
Value Map|Total Capital|BS."Total Assets".PTD_ACTUAL - BS."Total Current Liabilities".PTD_ACTUAL + BS."Bank Loans".PTD_ACTUAL + BS."Current Portion of Long-term debt".PTD_ACTUAL - BS."Other Long Term Liabilities".PTD_ACTUAL - BS."Accrued Employee Future Benefits Liability".PTD_ACTUAL|BS."Total Assets".PTD_BUDGET - BS."Total Current Liabilities".PTD_BUDGET + BS."Bank Loans".PTD_BUDGET + BS."Current Portion of Long-term debt".PTD_BUDGET - BS."Other Long Term Liabilities".PTD_BUDGET - BS."Accrued Employee Future Benefits Liability".PTD_BUDGET|Value Map."Total Capital".PTD_ACTUAL - Value Map."Total Capital".PTD_BUDGET