Sunday, 17 June 2018

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)

No comments:

Post a Comment

Query to find request set and its responsibility

  SELECT FA.application_name,        fr.responsibility_name program_attached_to,        frg.request_group_name,        fcp.request_set_name,...