You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • Agent action error Stored procedure calls within DIRECT SQL Update are not enabled

    in Transportation Management 4 comments

    Hi Team,

    OTM cloud instance version is 24c- 24.3.1-20240830

    We don't have any stored procedure at the moment (used to have it in this project before migrating to cloud). The DSU agent action is of statement type Plain SQL statement wherein we are trying to insert a shipment remark from an order remark.

    It is a simple insert statement with operator nextval in it like below

    insert_into shipment_remark (shipment_gid,REMARK_SEQUENCE,REMARK_QUAL_GID,REMARK_TEXT,DOMAIN_NAME)
    (select $gid,remark_sequence.nextval,'XYZ.xy',orm.remark_text,'XYZ' from order_release_remark orm, order_movement om, shipment s where s.shipment_gid = om.shipment_gid and om.order_release_gid = orm.order_release_gid and s.shipment_gid = $gid and orm.remark_qual_gid='XYZ.xy')

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!