Technology Stack - EBS (MOSC)

MOSC Banner

how to use fnd_global.conc_request_id as default value in sqlload ctl file?

edited Oct 17, 2018 5:00AM in Technology Stack - EBS (MOSC) 2 commentsAnswered

I have a sqlload program to load data into DB table, so when I submit the concurrent to run the sqlload program, and one column group_id need to be default as concurrent request id in control file, I have tried fnd_global.conc_request_id,but return -1,so any suggestion would be appreciate.

my control file:

OPTIONS(SKIP=1)

LOAD DATA

INFILE *

INTO TABLE cux.xxar_sessions

APPEND

FIELDS TERMINATED BY ','

OPTIONALLY ENCLOSED BY '"'

TRAILING NULLCOLS

(  company_code,

   period_num,

   contract_id,

   client_id,

   brand_id,

   session_id "cux.xxar_sessions_s.nextval",

   group_id "fnd_global.conc_request_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