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 ... more
**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 ... 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 |
|
LOV Oracle | |
Order Number |
|
LOV |