|
Troubleshooting Summary
1. Unprocessed Shipping Transactions Records already processed through Inventory
2. Unprocessed Shipping Transactions Records not visible in Inventory
--------------------------------------------------------------------------------
Troubleshooting Details
1. Issue 1 [ Unprocessed Shipping Transactions Records already processed through Inventory ]
Navigation> Inventory> Accounting Close Cycle> Inventory Accounting Periods
Select the "Pending" button
The Unprocessed Shipping Transactions zone shows "Pending Transactions".
Solution:
a) Ensure that all the Sales Orders for this accouting period have status of "Interfaced" in the Shipping Transactions Form.
Navigation> Order Management> Shipping> Transactions
Or use the following to identify any sales orders that have not been Shipped or Inventory Interfaced.
select wdd.source_header_id, ooh.order_number,wnd.delivery_id, wnd.name, wdd.delivery_detail_id,
wdl.pick_up_stop_id, wdd.inv_interfaced_flag
from wsh_delivery_details wdd, wsh_delivery_assignments wda,
wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_trip_stops wts,
oe_order_headers_all ooh, oe_order_lines_all ool
where wdd.source_code = 'OE'
and wdd.released_status = 'C'
and wdd.inv_interfaced_flag in ('N' ,'P')
and wdd.organization_id = &organization_id
and wda.delivery_detail_id = wdd.delivery_detail_id
and wnd.delivery_id = wda.delivery_id
and wnd.status_code in ('CL','IT')
and wdl.delivery_id = wnd.delivery_id
and trunc(wts.actual_departure_date) between '&period_start_date'and '&period_end_date'
and wdl.pick_up_stop_id = wts.stop_id
and wdd.source_header_id = ooh.header_id
and wdd.source_line_id = ool.line_id
b) Run the omse11il.sql (Metalink Note: 133464.1 ) for any Sales Order that may show as Interfaced or Shipped, but it is suspected that it has not been processed through Inventory.
c) Verify that there are NO records for this Sales Order in the Pending Transactions Form or the Transaction Open Interface Form. Address the errors if any. The records retrieved in these forms will list the Sales Order Number under the "Source" or "Transaction Source"columns for the Source TAB respectively.
Navigation> Inventory> Transactions> Pending Transactions
Navigation> Inventory> Transactions> Transaction Open Interface
d ) If records are not in any of these forms, then confirm the Material Transactions Form. Please query by transaction type (Sales Order Issue), and address errors if any. If records are listed in this form for any particular Sales Order, this will confirm that material has been processed out of stores.
Navigation> Inventory> Transactions> Material Transactions
e) If there are records in the Material Transactions Form for the Sales Orders, then confirm the value for the columns WSH_DELIVERY_DETAILS.OE_INTERFACED_FLAG and WSH_DELIVERY_DETAILS.INV_INTERFACED_FLAG. Use the output from the omse11i.sql.
Look for the MTL_MATERIAL_TRANSACTIONS.TRX_SOURCE_LINE_ID and MTL_MATERIAL_TRANSACTIONS.PICKING_LINE_ID to correspond to the OE_ORDER_LINES_ALL.LINE_ID and WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID respectively.
The sum of the primary quantity for sales order records (do not include the records for the Move Order Transactions) should match the original Sales Order line quantity. Unless overpicking is allowed, then the sum of the primary quantity must match the total of deliveries for each line.
select
substr(decode(mmt.trx_source_line_id,NULL,'NULL',mmt.trx_source_line_id),1,9) "Line Id",
substr(decode(mmt.picking_line_id,NULL,'NULL',mmt.picking_line_id),1,9) "Pick Id",
substr(decode(mmt.transaction_type_id,NULL,'NULL',mmt.transaction_type_id),1,9) "Txn Type",
substr(decode(mmt.primary_quantity,NULL,'NULL',mmt.primary_quantity),1,12) "Pri Qty",
substr(decode(wdd.delivery_detail_id,NULL,'NULL',wdd.delivery_detail_id),1,9) "Del Id",
substr(decode(mmt.locator_id,NULL,'NULL',mmt.locator_id),1,9) "Loc Id",
substr(decode(mmt.transaction_type_id,52,'Move Order',33,'Sales Order',mmt.transaction_type_id),1,15) "Type",
substr(decode(ooh.header_id,NULL,'NULL',ooh.header_id),1,9) "Header",
substr(decode(ooh.order_number,NULL,'NULL',ooh.order_number),1,12) "Ord Num",
substr(decode(ool.line_id,NULL,'NULL',ool.line_id),1,9) "OE Line"
from mtl_material_transactions mmt,
wsh_delivery_details wdd, oe_order_headers_all ooh,
oe_order_lines_all ool
where mmt.trx_source_line_id = wdd.source_line_id
and mmt.trx_source_line_id = &line_id
and ool.line_id=mmt.trx_source_line_id
and ooh.order_number = '&order_number'
f) Contact Oracle Support for assistance how to resolve these issues. These flags can be updated, but data must be confirmed prior to conducting any changes to these records and authorized by Oracle Development.
g) Additionally, confirm that there are no records (duplicates) for Sales Orders in the Pending Transactions and Transaction Open Interface Forms. Contact Oracle Support for scripts how to fix duplicate records.
[top]
2. Issue 2 [ Unprocessed Shipping Transactions Records not visible in Inventory ]
Navigation> Inventory> Accounting Close Cycle> Inventory Accounting Periods
Select the "Pending" button
The Unprocessed Shipping Transactions zone shows "Pending Transactions".
Solution:
a) Ensure that all the Sales Orders for this accouting period have status of "Interfaced" in the Shipping Transactions Form.
Navigation> Order Management> Shipping> Transactions
Or use the following to identify any sales orders that have not been Shipped or Inventory Interfaced.
select wdd.source_header_id, ooh.order_number,wnd.delivery_id, wnd.name, wdd.delivery_detail_id,
wdl.pick_up_stop_id, wdd.inv_interfaced_flag
from wsh_delivery_details wdd, wsh_delivery_assignments wda,
wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_trip_stops wts,
oe_order_headers_all ooh, oe_order_lines_all ool
where wdd.source_code = 'OE'
and wdd.released_status = 'C'
and wdd.inv_interfaced_flag in ('N' ,'P')
and wdd.organization_id = &organization_id
and wda.delivery_detail_id = wdd.delivery_detail_id
and wnd.delivery_id = wda.delivery_id
and wnd.status_code in ('CL','IT')
and wdl.delivery_id = wnd.delivery_id
and trunc(wts.actual_departure_date) between '&period_start_date'and '&period_end_date'
and wdl.pick_up_stop_id = wts.stop_id
and wdd.source_header_id = ooh.header_id
and wdd.source_line_id = ool.line_id
b) Run the omse11il.sql (Metalink Note: 133464.1 ) for any Sales Order that may show as Interfaced or Shipped, but it is suspected that it has not been processed through Inventory.
c) Verify that there are NO records for this Sales Order in the Pending Transactions Form or the Transaction Open Interface Form. Address the errors if any. The records retrieved in these forms will list the Sales Order Number under the "Source" or "Transaction Source"columns for the Source TAB respectively.
Navigation> Inventory> Transactions> Pending Transactions
Navigation> Inventory> Transactions> Transaction Open Interface
d )If records are not in any of these forms, then confirm the Material Transactions Form. Please query by transaction type (Sales Order Issue), and address errors if any. If records are listed in this form for any particular Sales Order, this will confirm that material has been processed out of stores.
Navigation> Inventory> Transactions> Material Transactions
Look for the MTL_MATERIAL_TRANSACTIONS.TRX_SOURCE_LINE_ID and MTL_MATERIAL_TRANSACTIONS.PICKING_LINE_ID to correspond to the OE_ORDER_LINES_ALL.LINE_ID and WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID respectively.
The sum of the primary quantity for sales order records (do not include the records for the Move Order Transactions) should match the original Sales Order line quantity. Unless overpicking is allowed, then the sum of the primary quantity must match the total of deliveries for each line.
select
substr(decode(mmt.trx_source_line_id,NULL,'NULL',mmt.trx_source_line_id),1,9) "Line Id",
substr(decode(mmt.picking_line_id,NULL,'NULL',mmt.picking_line_id),1,9) "Pick Id",
substr(decode(mmt.transaction_type_id,NULL,'NULL',mmt.transaction_type_id),1,9) "Txn Type",
substr(decode(mmt.primary_quantity,NULL,'NULL',mmt.primary_quantity),1,12) "Pri Qty",
substr(decode(wdd.delivery_detail_id,NULL,'NULL',wdd.delivery_detail_id),1,9) "Del Id",
substr(decode(mmt.locator_id,NULL,'NULL',mmt.locator_id),1,9) "Loc Id",
substr(decode(mmt.transaction_type_id,52,'Move Order',33,'Sales Order',mmt.transaction_type_id),1,15) "Type",
substr(decode(ooh.header_id,NULL,'NULL',ooh.header_id),1,9) "Header",
substr(decode(ooh.order_number,NULL,'NULL',ooh.order_number),1,12) "Ord Num",
substr(decode(ool.line_id,NULL,'NULL',ool.line_id),1,9) "OE Line"
from mtl_material_transactions mmt,
wsh_delivery_details wdd, oe_order_headers_all ooh,
oe_order_lines_all ool
where mmt.trx_source_line_id = wdd.source_line_id
and mmt.trx_source_line_id = &line_id
and ool.line_id=mmt.trx_source_line_id
and ooh.order_number = '&order_number'
However, if no records are found for the Sales Order, then verify the status of the line. See the next step.
e) If there are no records in the Material Transactions, Pending Transactions, or the Transaction Open Interface Forms, then confirm the value for the columns WSH_DELIVERY_DETAILS.OE_INTERFACED_FLAG and WSH_DELIVERY_DETAILS.INV_INTERFACED_FLAG. Use the output from the omse11i.sql.
f) For records with WSH_DELIVERY_DETAILS.OE_INTERFACED_FLAG or WSH_DELIVERY_DETAILS.INV_INTERFACED_FLAG values "P", please run the Interface Trip Stop process in Order Management to complete workflow for the Sales Order.
Navigation> Order Management> Shipping> Interfaces> Run
Select the Interface Trip Stop - SRS
|
