How to default currency code in control file
I have the need to default the value of 'ZAR' in my control file for bank statement loading as the current bank statements do not carry the currency code. With R12.2 this is now a requirement.
How can I change my control file to cater for this and what changes must be made to my setup.
This is the current control file:
LOAD DATA
REPLACE
into table ce_stmt_int_tmp
fields terminated by ","TRAILING NULLCOLS
(rec_no RECNUM,
rec_id_no "decode(:rec_no ,1,'0001',2,'0002',3,'0003',DECODE(:column2,'CLOSE ','0009','0036'))",
column1 "decode(:rec_no,2,:column1, ltrim(:column1,'0'))",