EDI Drop Ship Order Not Converting to Purchase Requisition

user1433754

Km-Oracle

 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

 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.