EBS Customizations (MOSC)

MOSC Banner

SQL Loader Character " issues

edited Sep 12, 2018 11:02AM in EBS Customizations (MOSC) 18 commentsAnswered

Hi All,

I have csv data file with comma separated and using Optionally enclosed " to load this data (fields terminated by "," OPTIONALLY ENCLOSED BY '"')

For one column (Description) i have data like this below and loader is failing with error

Record 3762: Rejected - Error on table XXPAG.XXPAG_FA_DEPRN_PRO_STG, column DESCRIPTION.

no terminator found after TERMINATED and ENCLOSED field

--Description Data examples

199.5"FSV Mast,72" Fork,S/S Fork Positioner, Diesel, Peuma

Laptop HP - 19"

Can someone pls help me in fixing this. I tried checking online and need expert advise here.

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