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

How to schedule PO workflow schedule process

create or replace PACKAGE APPS.XXXX_PO_WF_SCHEDULING_PKG IS    --|==========================================================================...