Skip to Content
avatar image
Former Member

SBO_SP_PostTransactionNotice error in Hanna

if :Object_Type = '67'  and (:Transaction_Type = 'U' or :Transaction_Type = 'A') THEN

begin

update "VISIONTEST"."OPDN" set "VISIONTEST"."OPDN"."U_GRNS" = 'Released'

from "VISIONTEST"."OPDN"

where OPDN."DocNum" = (Select Top 1 TO_NVARCHAR( OWTR."U_grn")

  from "VISIONTEST"."OWTR" where OPDN."DocEntry"= To_Nvarchar(OWTR."U_grn") and  OWTR."DocEntry"=:list_of_cols_val_tab_del);

end ;

END IF;

Error .jpg (110.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 09, 2015 at 10:54 PM

    Hi,

         Try this

    if :Object_Type = '67'  and (:Transaction_Type = 'U' or :Transaction_Type = 'A') THEN

    begin

            update "VISIONTEST"."OPDN" set "VISIONTEST"."OPDN"."U_GRNS" = 'Released'

            where OPDN."DocNum" = (Select Top 1 TO_NVARCHAR( OWTR."U_grn")

            from "VISIONTEST"."OWTR" WHERE OWTR."DocEntry"=:list_of_cols_val_tab_del)               AND OPDN."DocEntry"= (SELECT To_Nvarchar(OWTR."U_grn") FROM

           "VISIONTEST"."OWTR" WHERE  OWTR."DocEntry"=:list_of_cols_val_tab_del );

    end ;

    END IF;

    Regards,

    Manish

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      this TN is working on SQL perfectly but i cnt convert it on HANNA.

      if @object_type = '67'  and (@transaction_type = 'U' or @transaction_type = 'A')

      begin

      update OPDN set OPDN.U_GRNS = 'Released'

      from OPDN

      where OPDN.DocNum = (Select Top 1 convert( int,OWTR.U_grn)

        from OWTR where OPDN.DocNum = convert(int,OWTR.U_grn) and  OWTR.DocEntry = @list_of_cols_val_tab_del)

      end

  • Jan 09, 2015 at 06:24 AM

    Hi,

    Try:

    if :Object_Type = '67'  and (:Transaction_Type = 'U' or :Transaction_Type = 'A') THEN

    begin

    update "VISIONTEST"."OPDN" set "VISIONTEST"."OPDN"."U_GRNS" = 'Released'

    from "VISIONTEST"."OPDN"

    where OPDN."DocNum" = (Select Top 1 ( OWTR."U_grn")

      from "VISIONTEST"."OWTR" where OPDN."DocEntry"= To_Nvarchar(OWTR."U_grn") and  OWTR."DocEntry"=:list_of_cols_val_tab_del);

    end ;

    END IF;

    Thanks & Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 09, 2015 at 08:38 AM

    Hi,

         Can you explain a little that what you want to achieve with this command

    (Select Top 1 TO_NVARCHAR( OWTR."U_grn")


    my reason of asking is because this command is giving the result in an undefined order .



    Regards,

    Manish

    Add comment
    10|10000 characters needed characters exceeded