Month End Speed Up - Unprocessed Shipping Transaction Analysis Part 3

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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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