Sales Order Can't Consume MDS(Oracle ERP )

Jonyson · 发表于 2003-8-6 14:02

到目前為止,還沒有找到解決問題的方案.不過我有在Oracle Metalink 上找到一個說明如下,供各位大俠參考.

*********************************************************
MDS DID NOT GET RELIEVED BY THE SHIPMENT OF A SALES ORDER:
---------------------------------------------------------
Verify that the Planning Manager is Active.

Make sure that the Profile Option, MRP: Consume MDS is set to Yes

Make sure that the relief box is checked when you create your MDS
Name.
Run the following query to determine if the sales order shipment triggered the creation of a relief entry in MRP_RELIEF_INTERFACE.  If your sales order shipment did not create a record in this table, MDS consumption  would not have occurred for this shipment:

select substr(mdo.demand_id,1,10) dmd_id,
         substr(ola.line_number,1,4)||'.'||substr(ola.shipment_number,1,4) line_num,
         substr(mri.transaction_id,1,10) tran_id,
         substr(mri.last_update_date,1,10) ls_update,
      substr(mri.new_order_quantity,1,10) relief_qty,
      substr(mri.relief_type,1,8) rel_type,
      substr(mri.process_status,1,8) proc_stat,
      substr(mri.error_message,1,200) error_msg
from mrp_relief_interface mri, mtl_sales_orders mso,
         mtl_demand_omoe mdo,
         oe_order_headers_all oha,
         oe_order_lines_all ola
where mso.sales_order_id = mdo.demand_source_header_id
and mri.disposition_id = mdo.demand_id
and mso.segment1 = oha.order_number
and oha.header_id = ola.header_id
and mdo.demand_source_line = ola.line_id
and mdo.demand_source_header_id =
(select sales_order_id from mtl_sales_orders where segment1 ='&your_sales_order_number');

If this query does not return any rows, please log a tar with  Inventory Support, as it is the Inventory code in the file, inldqc.ppc, that triggers the creation of a relief record into MRP_RELIEF_INTERFACE when a sales order line is shipped.
If you can see a record in mrp_relief_interface for your sales    order shipment, then what is the process_status?  If the process_status    is 4, that means that the record has errored in the interface.
MDS relief would not have occurred for that record.
Run the following query to get the error message:

select  error_message
from mrp_relief_interface
where transaction_id = <transaction_id returned from query above>;

Fix the error and run the following update script to reset the record so it can be processed by the Planning Manager:

update mrp_relief_interface
   set process_status = 2,
         error_message = NULL,
         request_id = NULL
where transaction_id = &transaction_id;
commit;

If you can see a record in mrp_relief_interface for your sales order shipment    and the process_status = 5, then this record should have consumed an    MDS entry for the same date.  Run the following query to determine    which MDS entry was consumed. If this query returns no    consumptions for the schedule date that you expected to be relieved,    please contact Oracle MFG Support :

select substr(msd.schedule_designator,1,10) Sched_name,
            substr(msc.transaction_id,1,10) tran_id,
            substr(msi.segment1,1,15) item_num,
            substr(ola.line_number||'.'||ola.shipment_number,1,8) ,
         substr(msd.schedule_date,1,10) sched_dt,
         substr(msc.order_quantity,1,9) order_qty,
            substr(msc.relief_quantity,1,10) relief_qty,
         substr(msc.relief_type,1,10) relief_type
from    mrp_schedule_consumptions msc,
         mrp_schedule_dates msd,
         mtl_system_items msi,
         oe_order_headers_all oha,
         oe_order_lines_all ola,
      mtl_sales_orders mso
where msc.transaction_id = msd.mps_transaction_id
      and msd.inventory_item_id = msi.inventory_item_id
      and msd.organization_id = msi.organization_id
      and oha.header_id = ola.header_id
      and msc.line_num = ola.line_number
      and msd.source_sales_order_id = mso.sales_order_id
      and mso.segment1 = oha.order_number
      and mso.segment1 = '&your_sales_order_number'
      and msd.schedule_level = 2
      and msd.supply_demand_type = 1
order by 1,3,2;
***************************************************************************************
根據它的說明,我有執行上述兩個Sql,但第一個Sql 為空,按照它說明的意思是為Inventory Manager 沒有將一筆做Ship Confirm 的S/O資料寫進MRP_relief_interface 造成的.我想請問各位大俠, 對這個說明,我應當怎樣在MRP 與INV兩個模塊間找原因?

thanks in advance