Results 1 to 4 of 4

Thread: Orcehstration and string variables in Message service requests (shortcts)

  1. #1
    Member Aarto's Avatar
    Join Date
    Oct 2000
    Location
    Copenhagen, Denmark
    Posts
    400

    Orcehstration and string variables in Message service requests (shortcts)

    Hi all!

    I have created an orcehstration which has these steps
    1. Data request service to retrieve all changed purchase orders (returns a data set)
    2. A message service request to iterate through the data set and send e-mail for each changed purchase order. The e-mail contains the PO type and number + Related sales order number
    The message also contains a shortcut to P4310 where i pass the order type, order number to form interconnects

    My problem is that the e-mail shows all string values inside double quotes like Order number 123456, order type "OP" (i can live with that) but it also passes the double quotes to the form the interconnects. So when user opens the link to P4310 form, it is populated with order type "O instead of OP (i.e. it passes the double quote character and not just the values inside the double quote)

    I tried creating a separate orchestration for sending the message (using a connector from the first orchestration to the second)
    In the second orchestration, i changed the orcehstration input variables to all be of numeric type. But this did not change the behaviour, the double quotes persist in the message and shortcuts

    This is on orchestrator studio v8

    I am hoping someone else has experienced this and may have found a solution? Because this behaviour makes the shortcut in message totally useless
    Thanks in advance
    Aarto
    Aarto Reponen

    Senior JD Edwards/Serialization consultant, xperitus Denmark Aps - Your JDE experts in Scandinavia
    Part of Redfaire International, Oracle platinum partner
    LinkedIn

  2. #2
    Member
    Join Date
    Oct 2001
    Location
    New Zealand
    Posts
    439
    I just whipped up the same thing - a DataRequest over F4311, followed by a Message service request that iterates over the Data Request. The Data request has a name defined for the record set, and Return Fields defined with names e.g. OrderCompany etc. The FormInterconnect uses P4311.W4311G. In the Message Request's Form Interconnect values I just entered the output variable names defined in the Data request, e.g. ${OrderCompany} etc.

    It just works for me. This is on TR 9.2.4.1
    Contract JD Edwards Development Consultant.
    EnterpriseOne Xe through 9.2. Windows/Unix/OS400. SQLServer/Oracle/DB2 for i.
    ER, C/C++, BI Publisher, SQL, DSI dcLink

  3. #3
    Member Aarto's Avatar
    Join Date
    Oct 2000
    Location
    Copenhagen, Denmark
    Posts
    400
    Thanks.. Hmm.. I forgot to mention, we're on tools 9.2.3.2 Orcehstration studio 7.1.1.0 so this is probably fixed in later tools releases
    Aarto
    Aarto Reponen

    Senior JD Edwards/Serialization consultant, xperitus Denmark Aps - Your JDE experts in Scandinavia
    Part of Redfaire International, Oracle platinum partner
    LinkedIn

  4. #4
    Member
    Join Date
    Oct 2001
    Location
    New Zealand
    Posts
    439
    Quote Originally Posted by Aarto View Post
    Thanks.. Hmm.. I forgot to mention, we're on tools 9.2.3.2 Orcehstration studio 7.1.1.0 so this is probably fixed in later tools releases
    Aarto
    That could well be it. The 9.2.4 studio is so much nicer and the improvements to orchestration components do tend to be things you wished were there in earlier releases.
    Contract JD Edwards Development Consultant.
    EnterpriseOne Xe through 9.2. Windows/Unix/OS400. SQLServer/Oracle/DB2 for i.
    ER, C/C++, BI Publisher, SQL, DSI dcLink

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.