Announcement

Collapse
No announcement yet.

Inbound XML integration setting and procedure

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Inbound XML integration setting and procedure

    Hello,

    I want to create a procedure to let system can generated an inbound XML to post data to glogowner.document,

    I found the XML can generated but failed to post the date to the table, I tried to export the XML out and manual upload into system, that's available.

    so I think the issue may happen on the query insert into table i_transmission and i_transaction.

    The XML which I create in procedure can manual upload into system successfully, but failed when I try to run the query.

    is there anyone could help to advise an sample for inbound XML insert into i_transmission and i_transaction query.

    in other words, how to create XML trasnsmission using EDI inbound .

    thanks a lot !
    -----------------
    INSERT INTO i_transaction (i_transaction_no,
    i_transmission_no,
    transaction_code,
    written_by,
    status,
    element_name,
    object_gid,
    data_query_type_gid,
    xml_blob,
    domain_name,
    INSERT_USER,
    INSERT_DATE)
    VALUES (v_transaction_no,
    v_transmission_no,
    'I',
    'XMLStage',
    'INBOUND',
    'Document',
    'ABCD.'||v_document_filename,
    'ORDER RELEASE',
    v_transmission_clob,
    'ABCD',
    'ABCD.ADMIN',
    SYSDATE);

    INSERT INTO i_transmission (i_transmission_no,
    transaction_count,
    create_date,
    --sender_host_name,
    username,
    PASSWORD,
    is_inbound,
    --sender_transmission_id,
    xml_blob,
    external_system_gid,
    stop_process_on_error,
    xml_blob_type,
    --contact_gid,
    --ext_sys_com_method_gid,
    domain_name,
    add_xml_declaration,
    add_transmission_wrapper,
    -- transmission_wrapper_element,
    --ext_sys_com_info,
    INSERT_USER,
    INSERT_DATE)
    VALUES (
    v_transmission_no,
    1,
    SYSDATE,
    'ABCD.ADMIN',
    'Welcome',
    'Y',
    v_transmission_clob,
    NULL,
    'N',
    'T',
    'ABCD',
    'N',
    'N',
    'ABCD.ADMIN',
    SYSDATE);
    ----------------------------------------------------------
    Last edited by Aquarius_JF; July 4th, 2019, 05:58.
Working...
X