Order Management - EBS (MOSC)

MOSC Banner

EDI Drop Ship Order Not Converting to Purchase Requisition

Comments

  • Km-Oracle
    Km-Oracle Posts: 1,862 Gold Trophy
    edited Dec 16, 2009 1:30PM
     Hi,
    Could you please let us know the following details:

    01. What are the exact steps you are following after booking the sales order?
    02. Do you see any workflow errors with respect to the line workflow? While keeping the cursor on the line, click on Tools -> Workflow Status in the toolbar to see this
    03. Also what is the order line status?
    04. Can you please execute the following query to confirm if data is present in the PO requistion interface table
    ----------
    select interface_source_code, interface_source_line_id
    , quantity, Destination_type_code, transaction_id
    , process_flag, request_id, trunc(creation_date)
    from po_requisitions_interface_all
    where interface_source_code = 'ORDER ENTRY'
    and interface_source_line_id in (
    select drop_ship_source_id
    from OE_DROP_SHIP_SOURCES
    where header_id = &order_hdr_id
    and line_id = &order_line_id);
    ----------
    04. Also can you tell us if you executed the requisition import program? Did it error out? If yes, what was the error?

    Also when raising any query on the communities, we would kindly advise that you use the "start new discussion link" instead of the "create new document" link

    Regards
    Krishna
  • chandra-2007043
    chandra-2007043 Posts: 448 Bronze Badge
     Hi,
    Could you please let us know the following details:

    01. What are the exact steps you are following after booking the sales order?
    02. Do you see any workflow errors with respect to the line workflow? While keeping the cursor on the line, click on Tools -> Workflow Status in the toolbar to see this
    03. Also what is the order line status?
    04. Can you please execute the following query to confirm if data is present in the PO requistion interface table
    ----------
    select interface_source_code, interface_source_line_id
    , quantity, Destination_type_code, transaction_id
    , process_flag, request_id, trunc(creation_date)
    from po_requisitions_interface_all
    where interface_source_code = 'ORDER ENTRY'
    and interface_source_line_id in (
    select drop_ship_source_id
    from OE_DROP_SHIP_SOURCES
    where header_id = &order_hdr_id
    and line_id = &order_line_id);
    ----------
    04. Also can you tell us if you executed the requisition import program? Did it error out? If yes, what was the error?

    Also when raising any query on the communities, we would kindly advise that you use the "start new discussion link" instead of the "create new document" link

    Regards
    Krishna
      Hi,

     

    Can you test a manual Drop ship and see if this gets interfaced to PO ?  - if successful

    Then get the interface data? and compare with the un successful records - I believe this is an data issue

     

    There are good metalink notes on Drop ship setup

    Flow for Simple Drop Ships across Set of Books - ID 295074.1

    Thank you - Chandra.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center