Results 1 to 2 of 2

Thread: xml list - invalid column name

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    xml list - invalid column name

    Hi Guys,
    I'm trying to use xml interoperability for the interface. I learned the example here: http://docs.oracle.com/cd/E24705_01/...htm#EOTIN00485
    I wrote below xml file and submit it to JDE. But JDE always response "invalid column name". I tried many revisions with column name/instance/alias in <CLAUSE TYPE="WHERE"> statement but same error shows.
    Could you help on this? Thanks.

    <?xml version="1.0"?>
    <jdeRequest pwd="*" type="list" user="UTL011" role="*ALL" session="" environment="CNQA910" sessionidle="1800">
    <ACTION TYPE="CreateList">
    <TABLE_NAME VALUE="F0005"/>
    <TABLE_TYPE VALUE="OWTABLE"/>
    <FORMAT VALUE="UT"/>
    <RUNTIME_OPTIONS>
    <DATA_SELECTION>
    <CLAUSE TYPE="WHERE">
    <COLUMN NAME="" TABLE="" INSTANCE="" ALIAS=""/>
    <OPERATOR TYPE="EQ"/>
    <OPERAND>
    <COLUMN NAME="" TABLE="" INSTANCE="" ALIAS=""/>
    <LITERAL VALUE=""/>
    <LIST>
    <LITERAL VALUE=""/>
    </LIST>
    <RANGE>
    <LITERAL_FROM VALUE=""/>
    <LITERAL_TO VALUE=""/>
    </RANGE>
    </OPERAND>
    </CLAUSE>
    <CLAUSE TYPE="OR">
    <COLUMN NAME="" TABLE="" INSTANCE="" ALIAS=""/>
    <OPERATOR TYPE="EQ"/>
    <OPERAND>
    <COLUMN NAME="" TABLE="" INSTANCE="" ALIAS=""/>
    <LITERAL VALUE=""/>
    <LIST>
    <LITERAL VALUE=""/>
    </LIST>
    <RANGE>
    <LITERAL_FROM VALUE=""/>
    <LITERAL_TO VALUE=""/>
    </RANGE>
    </OPERAND>
    </CLAUSE>
    </DATA_SELECTION>
    <DATA_SEQUENCING>
    <DATA SORT="ASCENDING">
    <COLUMN NAME="" TABLE="" INSTANCE="" ALIAS=""/>
    </DATA>
    </DATA_SEQUENCING>
    </RUNTIME_OPTIONS>
    </ACTION>
    </jdeRequest>

    I can submit below xml to JDE successfully.
    <?xml version="1.0"?>
    <jdeRequest pwd="*" type="list" user="UTL011" role="*ALL"
    session="" environment="CNQA910" sessionidle="1800">
    <ACTION TYPE="GetTemplate">
    <TABLE_NAME VALUE="F0005"/>
    <TABLE_TYPE VALUE="OWTABLE"/>
    <TEMPLATE_TYPE VALUE="OUTPUT"/>
    </ACTION>
    </jdeRequest>
    Last edited by catthunder; 01-18-2017 at 01:42 AM.
    E1 8.12,Windows Server 2003,Oracle

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, Oracle or Peoplesoft.