Before approving the Purchase Order & when the PO is in INCOMPLETE status, Oracle allows us to delete the same from the Purchase Order Form. The same can be achieved using the following mentioned API. But we need to remember few points before using this API for deleting Incomplete PO. – The PO Should be […]
Performing Back Order in a Move Order Line Using inv_mo_backorder_pvt API *********************************************************************************What Happens during Pick Release?*************************************• A pre-approved Move Order is automatically created in Inventory.• A Move order is a request for a subinventory transfer from the source (stocking) subinventory to the destination (staging) subinventory.• A Move order is created for every Sales Order Line […]
Performing Pick Release Using WSH_DELIVERY_PUB API************************************************************ Creating Deliveries:===============• A Delivery is required to perform Ship Confirm. It represent all the goods that were shipped from the same warehouse, going to the same Customer location.• A Delivery can be created automatically or manually from the Shipping Transaction form at any time after the order lines have […]
Ship Confirm Process================What happened during Ship Confirm:******************************************The results of the picking process are recorded against a Delivery. • Ship Confirm can only be performed on Deliveries with Delivery Lines that have been Pick Confirmed.• Ship confirming a delivery records the results of the picking process. These results could be shipped, backordered, staged or cycle count […]
DECLARE l_user_id NUMBER;l_resp_id NUMBER;l_appl_id NUMBER;l_header_rec_in oe_order_pub.header_rec_type; — pl/sql table and record definition to be used as IN parametersl_line_tbl_in oe_order_pub.line_tbl_type; — pl/sql table and record definition to be used as IN parametersl_action_request_tbl_in oe_order_pub.request_tbl_type;– Used to assigining Book Order related input parametersl_header_rec_out oe_order_pub.header_rec_type; — pl/sql table and record definition to be used as OUT parametersl_line_tbl_out oe_order_pub.line_tbl_type;l_header_val_rec_out oe_order_pub.header_val_rec_type;l_header_adj_tbl_out […]
Recent Comments