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 in OE_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 into MTL_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 table WSH_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
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;
