1 Reply Latest reply: Jan 30, 2013 4:51 AM by 940828 RSS

    Error in SCD

    940828
      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