Tuesday, 7 October 2014

Oracle Order Management DropShip Flow for R12

In this blog I will explain Oracle  Drop Ship Flow for R12i.
What is Dropship Order - In dropship Order, sales order line creates a requisition line that becomes a PO and sent to your supplier. You instruct your supplier to send the item or configured item directly to your customer only and items never physically pass through your warehouse, and therefore you do not pick, pack or ship them yourselves

In this blog I will explain the R12 Dataflow of Dropship order from OM to Oracle Payables.
Topics covered in this blog are
Drop Ship Sales order creation and booking.
Requisition Import
Auto Creation of PO
Receipt against PO
AP against PO




Since in Dropship we don’t receive the goods in our warehouse, SOURCE_TYPE will be “External”, where as for non-dropship orders it is Internal. Once Book, we cannot Changes SOURCE_TYPE.

We can change the SOURCE_TYPE as “External” for an item at the time of order creation, or we can define it permanently in the Item creation Setup, by setting Default SO Source Type = External.

Also as we don’t have any shipping activity in dropship orders, Receiving Transaction Processor (RTP) , triggered after Submitting the receipt will push the workflow from Shipping activity to Fulfillment.
R12 Dataflow of Dropship order from OM to Oracle Payables.
Step1 - Drop ship Sales Order Creation
Step2 - Source Type = External

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifQsq1868hNY3M6W5R904r1ZSJBfn5uH2fpv9rShrbKM9E7NVoI2xcdOSlCMGunK2WP9uifi-3b0zyKgfe9kgItPKioN6NcH2xzJkdWI6kOCnI-7MlNpl3H6i5Tt2u5gA9FeV1lLhgTGmy/s400/02-Source_External.bmp
Step3 -Once order is Book, order line workflow will be at Purchase release Deferred Status .

Step4 -Submit Workflow to progress the Order line workflow.

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEAGuPYK2545c5GC9JAxuAqYO1DcS99GwX2jjNvui00L3x28rs_VN4SFefPSihDhItSuxlQ6MEiDtsRum4e0gpdb-tcvXFtvmisDDkRvHpewZcMO3mB_fwcvC0j8Gp4OI59ZDSyFrXwPoD/s400/04-WFBAACK.bmp

Step5 -Submit the requisition Import to create Requisition for Drop Ship

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisBeJMVeanNWgMmfEUhz3CbvHdHQNZcsRanhE1hN-fZkiayTjqHz9RoZphcApmpE7w7j6X3hCxoGyisJdRlNS0bNOLhQWjgMEvY3eBIpaOCt1FHfZzCMR7AIcQLSWgi6XMP4EPfXGgoscY/s400/05-req_import.jpg
Step6 -Once requisition Import Completed successfully , Navigate to Order lines Action >Additional Information and then go to DropShip tab.

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgujBaZRf5d5811vPZSoM6P3X-YGxfMYNJkMw703ZbQGBYYJABp41T_TIJ0yBarvlmBBWq_dKBo5UA4SbWtkiz2jQIJmUA65nNLyhXd9dnqpifIH0JrmanKo9kTFSiJfG9s8kZZ2tKniTuo/s400/06-Line_ADD_Info.bmp

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjy6Wwp7K5A2qalAcBpg2KUAt4zjIiNLO0VenAHVvd7ZTVfdxc8LMPQzhGLy2QBvqVP8em-HvK4lewx26ZFW8RreTxvxDuVpTagiTMT-NcX8279ym1EuJDQPv3WZvn7QP2IlfWwB8hDYiNw/s400/07-Req_created_frpm_SO.bmp
Step7 - Switch to Purchasing Responsibility and Navigate to Requisition Summary

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitD9CvdK81QLx16MSaHjiZHobjOENh0wTa7Sr2mXsxgtFmWio-K48Ti6IfBhDSq1nEH0KOX6fqF3-jhtMPXA3hAP49azKAlXEhAy_dHBBrfGxO6vcRNwT1ygpmJisgHkPJ1WhsZVqOGUTS/s400/08-req_Summ.bmp

Step8 -Query for Requisition Number

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2TZAI6V_ImUKYAZreZqmMc6jJObEXr7o4NAZg8bFTeelIfvHeWlQ8kCkRWE5mn6fW2scQAzhRfgMSjAsDMw3TcVOOb8g1rodr-97hd7-tuOQbUmrHiN3tPbLvz1hy-AbAo2OjYWORZnAi/s400/09-Req_Imported_As_App.bmp

Step9 – Open the Auto Create Window and Query for Requisition #

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgI4tOxLuLXCW1j4Dtxm-ZWAZ8OdN323kT0NC6hjVZAAI84QBxE0e4vRdz7L_fKhZCnDitg60PeT8LkAc9QKDrycPeNE3zJPWAVavWryhGlVOuJtlTX7qO2eBHBB_JxbX88B80OPgAH-fe4/s400/10-Find_Req.bmp

Step9 –Auto Create
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipSKTopjvAjTZGpc0qKoIbdJNIUmr1EAdAjWWNQbUBky32uQxrn0_NIMOiVV_L0BIdoRxtvtpOTO60lkNfPhZD4tMd9CnfjJ4X2UTZipi02Omk_wbpG-x5UuEJiU2aiH8DfoQUssU6uFA9/s400/11-AutoCreate.bmp

Step10 -Approve the PO
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifi_mYxUWlKt1vtjiq24aYznMMC47XvX7x0qpKSFuOBXKqSLDTWDD18LbMgiqhrK6nsOJ1cpdu1We7nAhPLpQWNHjwc9w0_V06KlGf8YBEapz4ZR90MWeeeTN23SgKE0dT8QKpkQY_zdyY/s400/12-DropShip_PO.jpg

Step11 - Browse the Shipment Details of PO , (Shipment Button)

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8VawPmHmqbWTbPp5NYb5pa1zwmrXgyyGbCejPS5w92RyKHD8LmkC4kwf-5xTqYNDO2qRg0xI9RlWZf1U_LAC_GVXKJTs2gXDThzAu8Ifow-qOFplMp8rUB1kOb0MdgYLcET3I3vbEQI9X/s400/13-PO_Shipment_Details.jpg

Step11 - Browse the Shipment Details of PO, (Shipment Button).We can select the Approval Level and Invoice Match Option based on your business requirements.

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUGKhMZeYE9lPJg5vii60lUW6_uvN34DVIOZItIInlUr3SBVR8Lu8IGa5TMxCoIV6bPejedwRvDkF7-T-abVVgqKIhPfIIzQRk3klcTa9IVISEfZ1v9euLUgzT-fRN_Gnx43NxvLgBwS7b/s400/13-PO_Ship_drop.jpg

Step11 - Browse the Shipment Details of PO , (Shipment button).
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKhfSIQAJ-DW4XGCfd0JqZkjEJZcfeI5E7DXuCQ28OTA3FbBaPvtuMMb7huoluHW1pWwEXNDNHy_5H2KCKC7LcrOiQwxPcOOj2IONPLAY9u8X4Imo1NFTmTwtxejQ-WBUh6Gx5v1GZ7q9i/s400/13-PO_Ship_status.jpg

Step11 - Browse the Shipment Details of PO , (Shipment Button), it will display Qty Ordered/billed/shipped etc.

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvxa33EafckgMrcaX_IbQJOyVaGXG0ltdhzfrGccRdHwRoZFK1jkILNb38hQ5m_oXW2jr7kU0jZuU68C80MSpwNLH09rUrlKx0hkvXbcf6DUC3gwoZ7kR__uL80jSwLJegIjGthJmBISzS/s400/14-PO_Ship_more.jpg



https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYx-e-lL1DeXToyYSWt7nAWWBRO9yL_dKeiwuILY_y9VlSARUv93ZCFVJKfjobJGjh9fmgxrFC0_6RmDRs2-ER6v4WeCBNhPT2wJCKLvn2FaOTYYWdzuBXt8ONVegEzjRHuVHQS6O-d0Vd/s400/14-PO_Ship_more1.jpg

Step12 - Browse the Distribution Details of PO , (Distribution Button).

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTKmExEHGxA1FL-PsGZOZFTjoJiDCI-0BcaYn0e6RoxbSdthEsUXX5xkUwIfNP8BsBvNSmBmp8LlbVuRK1lGDsm8v4XY9eXGXG1yDkFBp7ZrKz5hswmr12eikY57_slW3ntabRGFShFzjR/s400/15-PO_Dist_Details.jpg

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicuCtQ9cLn-E1FbIbdbcugxVu1fbShHt69UkvS6JoM6ojaqRxYQ7qtSipi7K9YztptGALb_dVM5Mj7AW5atxZqrHwO6Msa1RT9knnAFYvGwthl9wMZMfP75g0d58I6i3wC942CnJ-AG5Op/s400/15-PO_Dist_Details_1.jpg
Step13 - Navigate to receipts.

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5LCuHkAQCUz4wrloGWXQAdtmrMwvET_Pqe9RkBMtqPi2TNoRFrI0bHHCJAuDZUF1_EU0rRZBejHfp1SMu5hFcEW18rWfaMHj3EFSiysbU3a1o2ADlQC5eX2ojsd8zLjwP7oeTVcvCxKs5/s400/16-Receipt_Resp.bmp

Step13 - Navigate to Receipt , system will prompt for Inventory Org , Select your Inventory Organization.
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXwZW50bGkqmWxl-u2GZ5ajIEwLt7zb2FDM9X4ouIfqND_RIIHZWcu1qohnv6skEMyx8hn7OXtCL-U7dVh_OKaaiuL7B3zCqO4-556sxNTJk-4xcs0kMTNhrA3NyJQzHsfvXtQEaEEdy0m/s400/16-receipt_ORG.bmp
Step14 - Enter Receipt against PO.

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvntkdsYEva-w19y3U1wInjXhVRlIpYlV7sU-liXrARFiTKFpQpNeknptqHUOcTVq0O-Iiu_XexgJgSw0cUPhIq6dyf3g1Rvm9HGN899iLw5g88SNibdmFUPvi-Jvau4y5a76g1KC0aS7z/s400/16-Receipt_DS.bmp
Step14 -
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSoJWZYRXLvf2GF72prGFrYjtX3UMCRmf1biOIdiiYume6F8BCIVrA0TvLzvMGO-IawBI5NLYbd8hCYt2m1eMRjJdoZlxnFyJHFvkcedOuUIRbeNihHHPJ6tVgWDh6BrzX8qERbnD5SSrs/s400/16-SubInventory_DS_0.bmp
Step14 -
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiW2ubUjRTfOEYmJWUB_I6NVKkQpAh2Z996zOiG29Rp2CvxQSu-IcVJCEwxQ59V5YwhcVlsw_hGCOBVg15cuWjtePMTAqtD2yzwVMa6X6fbv7qWiwSB9qgi2iotuYPMzQzWMxMv9_Hgk_f/s400/16-SubInventory_DS.bmp

Step15 - Once you save the Receipt , System will submit Receiving Transaction processor.

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhXe1ZBJInp4A1fJcWcL_izASPmQcv8LgCkfTvYGFI1p4J-ZSdiF8-QiprqIMQbcG7Np-sL-Go5Y8VZXQhgyGBNAgiW268zUKxPBzxnyt77qsCs52R_AieKRLnNRik5CTMjdtY_sGZWXnH/s400/17-rtp.bmp

Step16 - RTP on successful completion Progress the OM Workflow and Line status change from Awaiting receipt to SHIPPED.

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjw_qrmCjkZ6R9nhNErQHrulfThRYCmJngOLDCGBtIndTFN7iwIq61IggAB4H58cAlcmNb-Tw1a1ni6OUZJpHbRbew7LpjK5yXaevewexcu4XY4zZSRvyvV4_bzQiZMjWu_h8uEsBsF8JQy/s400/18-Status-Shipped.bmp
http://img1.blogblog.com/img/icon18_email.gif


No comments:

Post a Comment