Unprocessed Shipping Transactions Troubleshooting Techniques (文档 ID 262979.1)

转自：https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=424746486989148&id=262979.1&displayIndex=5&_afrWindowMode=0&_adf.ctrl-state=1c8kev1z9c_278#q1

In this Document

 Purpose Troubleshooting Steps  Conditions Troubleshooting Details 1. Unprocessed Shipping Transactions Records already processed through Inventory 2. Unprocessed Shipping Transactions Records not visible in Inventory References

---

APPLIES TO:

Oracle Inventory Management - Version 11.5.10.0 and later
Oracle Shipping Execution - Version 11.5.10.0 and later
Information in this document applies to any platform.
This document applies to release 12 too.

*** Checked for relevance on 18-SEP-2015 ***

PURPOSE

Unprocessed Shipping Transactions Troubleshooting Guide
Pending Shipping Transactions Troubleshooting Guide for Closing Accounting Period

TROUBLESHOOTING STEPS

These are techniques directed to resolve issues related to Pending Shipping Transactions when attempting to close Inventory Accounting Periods. 

Please note that these Pending Shipping Transactions displayed in the Closing Accounting Period form represent data that must be updated in the Shipping tables or the Sales Orders need to be processed successfully through Order Management.

Conditions

There are Unprocessed Shipping Transactions in the Inventory Accounting Periods Form that prevent the inventory accounting period from closing. bottom of this document.

Troubleshooting Summary

1. Unprocessed Shipping Transactions Records already processed through Inventory

2. Unprocessed Shipping Transactions Records not visible in Inventory

---

Troubleshooting Details

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 accounting 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 HTMOMSE Sales Order diagnostic script (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 HTMOMSE Sales Order diagnostic script.

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. 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 accounting 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 HTMOMSE Sales Order diagnostic script (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 HTMOMSE Sales Order diagnostic script.

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