What is Pick Release?
Pick release perform process starts, once the Order is scheduled
and booked, then we need to release the order to warehouse for
shipping
1: ENTER THE SALES ORDER
Once order is entered.
The Header information stored in OE_ORDER_HEADERS_ALL and the
Line information stored in OE_ORDER_LINES_ALL, when the order is entered.
The Column: Flow_Status_Code is available both
OE header and line tables, to define status of order at each
stage
Flow_Status_Code consists of 4 types
1. Entered
2. Cancelled
3. Closed
4. Booked
For initial stage, once order enters = > Column: Flow_Status_Code inOE_ORDER_HEADERS_ALL is
‘Entered’
When the order is booked, Flow_Status_Code column in header
change accordingly
2:BOOK THE SALES ORDER
Tables Affected:
OE_ORDER_HEADERS_ALL - Column: Flow_Status_Code => ‘Entered’
OE_ORDER_LINES_ALL - Column: Flow_Status_Code => ‘AWAITING_SHIPPING’
Records will be created in the table WSH_DELIVERY_DETAILS
WSH_DELIVERY_DETAILS – Column Released_Status
=> ‘R’(Ready to release)
Also record into inserted into WSH_DELIVERY_ASSIGNMENTS
At this stage,”DEMAND INTERFACE PROGRAM” runs in the
background and inserts intoMTL_DEMAND
3:PICK RELEASE
In Release Sales order window.
In shipping tab:
Auto Create Delivery: Yes
Auto Pick Confirm: Yes
Auto Pack Delivery: Yes
In Inventory Tab:
Auto Allocate: Yes
Enter the Ware house like M1 ,M2, Etc
Click on “Execute button”, After successful completion ,
you will get popup message
Now , Pick Release process in turn will kick off several
other request program like
ü Auto Pack report
ü Shipping Execution Report
ü Pick Slip Report
Tables Affected:
If Autocreate Delivery is set to ‘Yes’ then a new record is
created in the tableWSH_NEW_DELIVERIES.
DELIVERY_ID is populated in the table WSH_DELIVERY_ASSIGNMENTS.
The RELEASED_STATUS in WSH_DELIVERY_DETAILS => set
to ‘Y’ (Pick Confirmed)
if Auto Pick Confirm is set to
Yes otherwise RELEASED_STATUS => ‘S’ (Release to
Warehouse).
IF Auto Pick Confirm in the above step is set
to NO, then the following should be done.
Navigation: Inventory Super User > Move Order>
Transact Move Order
In the HEADER tab, enter the BATCH NUMBER (from the above step)
of the order. Click FIND. Click on VIEW/UPDATE Allocation, then Click TRANSACT
button. Then Transact button will be deactivated then just close it and go to
next step
4. SHIP CONFIRM THE ORDER
Once Shipping Transaction Successfully completed, After then few
Concurrent program will be trigger .i.e.,
ü INTERFACE TRIP Stop
ü Commercial Invoice
ü Packing Slip Report
ü Bill of Lading
Tables Affected:
WSH_DELIVERY_DETAILS - Column : Released_Status=>
‘C’ (Ship Confirmed)
OE_ORDER_HEADERS_ALL – Column: Flow_Status_Code
=> ‘Booked’
OE_ORDER_LINES_ALL – Column : Flow_status_Code
=> ‘Shipped’
… The Final process move into Invoice
Hints :
Pick Release Status – WSH_DELIVERY_DETAILS
Column Name: Released_Status .
B. Backordered – Line failed to be allocated in Inventory
C: Shipped – Line has been shipped
D: Cancelled – Line is cancelled
N: Not ready to release -Line
is not ready to be released
R:Ready to release - Line is ready to be released
S:Released to warehouse -Line has been released to Inventory
for processing
X:Not Applicable -Line is not applicable for Pick Release
Y:Staged - Line has been picked and staged by Inventory
SELECT wnd.NAME Delivery,
shipped_quantity Qty, TRUNC (wdd.date_requested) Reqd_Date,
TRUNC (wdd.date_scheduled) Sched_Date,
'* ' || UPPER (flv.meaning) || ' *' Status,
wdd.source_header_id,
wdd.source_line_id
FROM
wsh_delivery_details wdd,
wsh_delivery_assignments wda,
wsh_new_deliveries wnd,
fnd_lookup_values flv
WHERE
wdd.delivery_detail_id = wda.delivery_detail_id
AND
wda.delivery_id = wnd.delivery_id(+)
AND
flv.lookup_type = 'PICK_STATUS'
AND
flv.LANGUAGE = 'US'
AND
flv.lookup_code = wdd.released_status
Sample Scripts / List of Tables
OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL,WSH_DELIVERY_DETAILS,
WSH_DELIVERY_ASSIGNMENTS,
MTL_DEMAND
Sample script :1
SELECT oha.order_number sales_order,
oha.org_id,
ola.line_number,
ola.shipment_number,
ola.flow_status_code,
wdd.delivery_detail_id,
wdd.inv_interfaced_flag,
wdd.oe_interfaced_flag,
Decode
(wdd.released_status,'C','Shipped','B','Backordered','D','Cancelled','N','Not
Ready for Release','R','Ready to Release', 'S','Released to
Warehouse','X','Not Applicable','Y','Staged')as Released_Status
FROM apps.oe_order_headers_all oha,
apps.oe_order_lines_all ola,
apps.wsh_delivery_details wdd
WHERE
oha.header_id
= ola.header_id
AND
oha.org_id
= ola.org_id
AND
oha.header_id
= wdd.source_header_id
AND
ola.line_id
= wdd.source_line_id
AND
oha.booked_flag
= 'Y'
AND NVL (ola.cancelled_flag, 'N')
<> 'Y'
AND wdd.released_status in
('R','B')
AND ola.flow_status_code = 'CLOSED'
–Change condition i.e., 'AWAITING_SHIPPING'
AND oha.order_number = 12341719 --
pass Order number
AND oha.org_id = 201; -- pass Org
id
Sample Script :2
SELECT wnd.delivery_id,
wnd.name delivery_name,
wdd.source_header_number so_order_number,
oola.line_number so_line_number,
wdd.source_header_id so_header_id,
wdd.source_line_id so_line_id,
wdd.shipping_instructions,
wdd.inventory_item_id,
wdd.requested_quantity_uom,
msi.description item_description,
msi.revision_qty_control_code ,
wdd.ship_method_code carrier,
wdd.shipment_priority_code
priority,
wdd.organization_id,
wnd.initial_pickup_location_id,
Decode
(wdd.released_status,'C','Shipped','B','Backordered','D','Cancelled','N','Not
Ready for Release','R','Ready to Release',
'S','Released to
Warehouse','X','Not Applicable','Y','Staged')as Released_Status,
wdd.source_code
FROM mtl_system_items_vl msi,
oe_order_lines_all oola,
wsh_delivery_details wdd,
wsh_delivery_assignments wda,
wsh_new_deliveries wnd
WHERE
wnd.delivery_id = 2323 --- pass
delivery ID
AND
wda.delivery_id = wnd.delivery_id(+)
AND wdd.delivery_detail_id =
wda.delivery_detail_id
AND wdd.inventory_item_id =
msi.inventory_item_id(+)
AND wdd.organization_id
= msi.organization_id(+)
AND
wdd.source_line_id = oola.line_id
AND wdd.source_header_id =
oola.header_id;
