Inventory Management - EBS (MOSC)

MOSC Banner

need to populate who columns in sql * loader

edited Dec 14, 2013 3:05AM in Inventory Management - EBS (MOSC) 2 commentsAnswered
 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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center