Sample control file for GL daily rates interface program in Oracle Apps R12

-- Sample control file

Options (Skip =2)

Load data

infile '$XBOL_TOP/bin/xe.csv'

badfile '$XBOL_TOP/bin/xe.bad'

discardfile '$XBOL_TOP/bin/xe.dis'

insert into table xxgl_exchange_rates_stg

fields terminated by ','

optionally enclosed by '"'

Trailing nullcols

(from_currency

,amount

,from_conversion_date

,to_currency

,conversion_rate)