2 Replies Latest reply on Jun 30, 2016 6:01 PM by PamNL

    SQL*Loader-350 Error

    3001785

      Hi,

       

      I'm getting:

      SQL*Loader-350 : Syntax error at line 28.

      Token longer than max allowable length of 258 chars

       

      When i upload my file from EBS SQL Loader concurrent program.

      From Windows it works fine.

       

      This my CTL file:

      OPTIONS(SKIP=1,ERRORS=50)

      LOAD DATA INFILE * --'C:\ACG\PO\CargaRequi\LAYOUT_DE_CARGA_SIC.csv'

      APPEND

      INTO TABLE PO_REQUISITIONS_INTERFACE_ALL

      FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

      TRAILING NULLCOLS

      (REQUISITION_TYPE --"PURCHASE"

      ,LINE_TYPE

      ,ITEM_SEGMENT1

      ,QUANTITY 

      ,UNIT_PRICE

      ,NEED_BY_DATE

      ,NOTE_TO_BUYER

      ,DESTINATION_TYPE_CODE  --'INVENTORY" ,"EXPENSE"

      ,destination_organization_code

      ,CHARGE_ACCOUNT_SEGMENT1

      ,CHARGE_ACCOUNT_SEGMENT2

      ,CHARGE_ACCOUNT_SEGMENT3

      ,CHARGE_ACCOUNT_SEGMENT4

      ,CHARGE_ACCOUNT_SEGMENT5

      ,CHARGE_ACCOUNT_SEGMENT6

      ,CHARGE_ACCOUNT_SEGMENT7

      ,CHARGE_ACCOUNT_SEGMENT8

      ,ACCRUAL_ACCOUNT_ID  CHAR "substr(:ACCRUAL_ACCOUNT_ID,1,instr(:ACCRUAL_ACCOUNT_ID,'-',1)-1)"

      ,DELIVER_TO_LOCATION_ID EXPRESSION "(select location_id from  PO_HR_LOCATIONS where location_code  like ':destination_organization_code%')"

      ,BUDGET_ACCOUNT_ID   EXPRESSION

      "(select code_combination_id from gl_code_combinations_kfv where concatenated_segments = :CHARGE_ACCOUNT_SEGMENT1||'-'||:CHARGE_ACCOUNT_SEGMENT2||'-'||:CHARGE_ACCOUNT_SEGMENT3||'-'||:CHARGE_ACCOUNT_SEGMENT4||'-'|| :CHARGE_ACCOUNT_SEGMENT5||'-'||:CHARGE_ACCOUNT_SEGMENT6||'-'||:CHARGE_ACCOUNT_SEGMENT7||'-'||:CHARGE_ACCOUNT_SEGMENT8)"

      ,VARIANCE_ACCOUNT_ID EXPRESSION

      "(select code_combination_id from gl_code_combinations_kfv where concatenated_segments = :CHARGE_ACCOUNT_SEGMENT1||'-'||:CHARGE_ACCOUNT_SEGMENT2||'-'||:CHARGE_ACCOUNT_SEGMENT3||'-'||:CHARGE_ACCOUNT_SEGMENT4||'-'||

      :CHARGE_ACCOUNT_SEGMENT5||'-'||:CHARGE_ACCOUNT_SEGMENT6||'-'||:CHARGE_ACCOUNT_SEGMENT7||'-'||:CHARGE_ACCOUNT_SEGMENT8)"

      ,PREPARER_ID EXPRESSION "(select employee_id  from FND_USER WHERE user_id = FND_GLOBAL.user_id)"

      ,DELIVER_TO_REQUESTOR_ID EXPRESSION "(select employee_id from FND_USER WHERE user_id = FND_GLOBAL.user_id)"

      ,INTERFACE_SOURCE_CODE CONSTANT "INV"

      ,SOURCE_TYPE_CODE CONSTANT "VENDOR"

      ,AUTHORIZATION_STATUS CONSTANT "INCOMPLETE"

      ,GROUP_CODE  EXPRESSION "(select user_name from FND_USER WHERE user_id = FND_GLOBAL.user_id)"

      ,created_by  "fnd_global.user_id"

      ,last_updated_by  "fnd_global.user_id"

      ,creation_date  sysdate

      ,last_update_date  sysdate

      )

       

      This is my data file:

       

      TIPO DE REQUISION (REQUISITION_TYPE),TIPO DE LINEA (LINE_TYPE),ITEM (ITEM_SEGMENT1),CANTIDAD (QUANTITY) ,PRECIO (UNIT_PRICE) ,FECHA NECESARIO PARA,NOTA AL COMPRADOR (NOTE_TO_BUYER),TIPO DE DESTINO (DESTINATION_TYPE_CODE)",CODIGO DE ORGANIZACIÓN (DESTINATION_ORGANIZATION_CODE),COMPAÑÍA (CHARGE_ACCOUNT_SEGMENT1 ),UBICACIÓN (CHARGE_ACCOUNT_SEGMENT2),CUENTA NATURAL (CHARGE_ACCOUNT_SEGMENT3),SUB CUENTA (CHARGE_ACCOUNT_SEGMENT4),CENTRO DE COSTO (CHARGE_ACCOUNT_SEGMENT5),"PRODUCTO (CHARGE_ACCOUNT_SEGMENT6),INTERCOMPAÑIA (CHARGE_ACCOUNT_SEGMENT7),FUTURO(CHARGE_ACCOUNT_SEGMENT8),COMPAÑÍA (ACCRUAL_ACCOUNT_ID)

      PURCHASE,Servicios (Cantidad),SV0054,10,15,25/06/2016,Nota al Compador,EXPENSE,GMX,04,09003,5300,1220,518,000,00,000000,3108-CGEB

      INTERNAL,Bienes,SV0054,15,10,25/06/2016,Nota al Comprador,INVENTORY,CMX,04,09003,5300,1220,518,000,00,000000,130388-CNATIT

      PURCHASE,Servicios (Cantidad),SV0054,10,15,25/06/2016,Nota al Compador,EXPENSE,GMX,04,09003,5300,1220,518,000,00,000000,3108-CGEB

      INTERNAL,Bienes,SV0054,15,10,25/06/2016,Nota al Comprador,INVENTORY,CMX,04,09003,5300,1220,518,000,00,000000,130388-CNATIT

       

      What do you suggest me to avoid this error?