Month End Speed Up - Unprocessed Shipping Transaction Analysis Part 3

➜ Back to Library
Description
*Unprocessed Shipping Transactions Troubleshooting Techniques (Doc ID 262979.1)*
**Use the following to identify any sales orders that have not been Shipped or Inventory Interfaced***
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 ...  *Unprocessed Shipping Transactions Troubleshooting Techniques (Doc ID 262979.1)*
**Use the following to identify any sales orders that have not been Shipped or Inventory Interfaced***
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

   more
Run Month End Speed Up - Unprocessed Shipping Transaction Analysis Part 3 and other Oracle EBS reports with Blitz Report™ on our demo environment
select 
ooh.order_number, 
ool.line_number, 
ool.ordered_item,
ool.ordered_quantity,
ool.shipped_quantity,
wnd.name "Delivery Name", 
mp.organization_code Warehouse,
decode(wdd.inv_interfaced_flag, 'N','Run I/F from Shipping', 'P', 'Run Inventory I/F') "Inventory Interfaced",
trunc(wts.actual_departure_date) ship_date
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,
mtl_parameters mp
where 
1=1
and wdd.source_code = 'OE'
and wdd.released_status = 'C' --shipped
and mp.organization_id = wdd.organization_id
and wdd.inv_interfaced_flag in ('N' ,'P')  --not yet I/F or pending I/F
and wdd.organization_id = ool.ship_from_org_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
order by 8
Parameter Name SQL text Validation
Warehouse 
organization_code=:warehouse
 LOV Oracle
Order Number 
order_number=:sales_order
 LOV
Download
Related Blitz Reports
ECC Inventory Management, Inventory Trace Sales Orders ONT Sales Order Workflow Status WMS Scheduled Shipment Report (Without Barcodes) WMS Consolidation INV Period close check for open or in error transactions Yanmar - Discount on order lines check XXONT Orders and Lines ONT Orders and Lines PPF_WP3_OM_DETAILS
Blitz Report™

Blitz Report™ provides multiple benefits: