Recent Posts

Tuesday, 28 February 2017

Drop Ship Sales Order In Order Management | Oracle SCM Functional Order Management


Drop Ship Sale Order 


Satisfying the customer demand through third party vendors.Drop shipment on the
other hand is a method of order fulfillment where the organization taking the order
does NOT maintain their own inventory for the drop shipped product, but fulfill their
orders through 3rd party vendors who directly ship to the end customer ordering the
product.

NOTE: Supplier directly ships material to the customer.

Step 1

Define the item and apply template to the item, assign the item to all organization.
Enter list price in purchasing tab.



Source type should be external, Set it in Order Management tab as shown below.
We can set source type as external in three levels 

Item level, Transaction level, Sales Order line level. 



Assign item to all the organizations as shown below 



Step 2

Create Sales Order and Book the sales order with source type as external 

Initial status is entered




Check the Header status is Booked




Check line level status is also Booked





Step 3

Run workflow background process to move the data from OM base table to PO Interface table.




Check the request completed 




Header Status Booked
Line status is Awaiting receipt




Step 4

Switch to Purchasing responsibility Run the Requisition import program




Check the request and view the output






Step 5

Find the requisition number
here we have two ways to find the requisition 

a) query the sales order go to line level click on action select the additional line information to click on drop ship tab see the requisition number




b) go to requisition summary enter the item name click on find 




See the requisition number as shown below  





Step 6

Based on generated requisition number,crate purcahse order through auto create
process and approve it

Select the line click on Automatic





Click On Create





Note the PO number and Approve it





Click on OK




Check the PO Status





After PO Approved we have additional tab (Drop Ship) in PO form as shown in below





Step 7

Open the periods in Purcahsing responisbility to do the misclleanies receipt 





Chage the Period status never opned to open
Save the changes 





Select the ledger and click on find





Click on Open Period






Step 8

Do the logical Receipt againest the Purchase Order 
Enter the po number 





Select the line  Chose the subinventory and save it 





Check the request Completed 





Here we can see the Receipt number 





Check the on hand quantity 





Query the sales order check the line staus





Thats All about Drop Ship Sales Order

Monday, 27 February 2017

Back to Back Sales Order in Oracle Order Management | Oracle Apps SCM R12 Functional.

Back to Back Sales Order 


Oracle Order Management

To Crate the back to back sales order these are the pre-requisites

 ATO CheckBox should be enabled (It uses ATO workflow)

2.    List price should be entered.
3.    A user should be a buyer.

Note: Remove value at site level for profile option “MRP: Default Sourcing Assignment Set”

steps:

1 Define an item
  • while creating the item apply the template to item (custom template or existing template)
  • enter the list price
  • go to order management tap enable the ATO ( Assemble To Order) flag
  • make sure the item as a buy in general planning tap (buy an item)
2  Create sales order enter all required information and book the sales order.
status: line level: Supply eligible  
status: header level: Booked

3. Place the cursor bar in any field then right click select the progress the order.
status; line level External Requisition is requested.

4. Switch to purchasing responsibility and run the requisition import program select the import source as CTO.
status: External Request is open

5. Find the requisition number from the requisition summary window

6. Create the purchase order with the help of requisition through auto create process and get approvals for the PO
status: PO Open

7. Receive the material against the PO
status: Awaiting Shipping

8. Pick the material from source sub inventory to stage sub inventory
status: Picked

9. Ship the material to the customer 
status: shipped




Step 1
Navigate Inventory responsibility > Items > item master enters all required details as shown below.

for buy items the will be moving into purchasing tables.
if it makes the item, the data will be moved into WIP module



Step 1 Cont...

Go to order management tap enable the ATO ( Assemble To Order) flag



Step 2
Create sales order enter all required information and book the sales order.
status: line level: Entered  
status: header level: Booked


Step 2 Cont...

Status: line level Supply Eligible



Step 3


Place the cursor bar in any field then right click and select the progress the order.




Step 3 Cont...
status; line level External Requisition is requested





Step 4

Switch to purchasing responsibility and run the requisition import program select the import source as CTO.
status: External Request is open




Check the request status-completed 




then see the output.
Number of approved requisition created 1




Step 5

Find the requisition number from the requisition summary window
Purchasing -> Requisitions -> Requisition Summary



Step 5 Cont...



Step 6


Create the purchase order with the help of requisition through auto create process and get approvals for the PO
status: PO Open

Purchasing -> Auto create
Enter requisition number click on find




Select the line and click on automatic



Click on Create




PO form will open automatically and po number generated 




Click on approve




Step 7

Receive the material against the PO
status: Awaiting Shipping

Step 8 
do the same process to standard sales orders

Pick the material from source sub inventory to stage sub inventory

status: Picked

Step 9
Ship the material to the customer 
status: shipped


?