need to populate who columns in sql * loader
HI,
i am trying to load the flat file data into staging table but in the mean time i need to capture who clumns and request if in that table
and my control file is
load data
infile'&1'
append into table xxmsninvstg
fields terminated by ','
optionally enclosed by '"'
trailing nullcols
(item_name
,item_desc
,uom_code
,template
,status
,organization_id
,organization_code
,error_msg
,error_flag constant 'N'
,process_flag constant 'N'
,last_updated_date sysdate
,created_by "fnd_global.user_id"
,creation_date sysdate
,last_updated_by "fnd_global.user_id"
,request_id " :fnd_global.conc_req"uest_id)
0