sexta-feira, 23 de janeiro de 2015

Pick Release Sales Order

Pick Release é o processo onde a ordem de venda já programada e reservada, é liberada do estoque para que o material seja entregue. Aqui temos o passo-a-passo de cada ação desse processo. 

Está em inglês, pois achei mais simples de entender, pois os campos e tabelas sempre serão apresentados dessa forma.


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 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
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;
Postar um comentário