This discussion is archived
1 Reply Latest reply: Jan 30, 2013 2:51 AM by 940828 RSS

Error in SCD

940828 Newbie
Currently Being Moderated
Hi,

I am using version 11.1.1.

I am using SCD type 1 for column vendor type .(Oracle to Oracle) ->IKM Oracle SCD

ODI-1228: Task Dim_Vendor (Integration) fails on the target ORACLE connection BEKIS_POC_DB.
Caused By: java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification

     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

Code is as below:


update     POC.VENDOR T
set     (
     
     ,T.VENDOR_TYPE
     ) =      (
          select     
               ,'DEFAULT'
          from     POC.I$_VENDOR X
          where     X.PLANT_VENDOR_NO     = T.PLANT_VENDOR_NO
          and     X.VENDOR_SOURCE_SID     = T.VENDOR_SOURCE_SID
          and     X.IND_UPDATE     = 'U'
          )
where     (T.PLANT_VENDOR_NO, T.VENDOR_SOURCE_SID)
     in     (
          select     S.PLANT_VENDOR_NO, S.VENDOR_SOURCE_SID
          from     POC.I$_VENDOR S
          where     S.IND_UPDATE     = 'U'
          )
and     T.VENDOR_CUR_FLAG     = 1
and     VENDOR_END_DT     = to_date ('01-01-2400', 'mm-dd-yyyy')

I see that there is an additional " , " in the UPDATE SET statement. Not sure why this has come. Please help.

Regards,
HPR

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points