Skip to main content

Drop Ship FAQ






1. What are the Item Attributes that affect Drop Ship orders?
Item attributes used for DropShip Processing: 
Purchased (PO) Enabled
Purchasable (PO) Enabled 
Transactable (INV) Enabled 
Stockable (INV) Optional 
Reservable (INV) Optional
Inventory Item (INV) Optional
Customer Ordered (OE) Enabled
Customer Orders Enabled (OE) Enabled
Shippable (OE) Optional
OE Transactable (OE) Enabled
Default SO Source type Optional
Costing Enabled enabled for items that are to be costed
Inventory Asset Value enabled for asset items (non-expense items)

2. How do I drop ship across operating units?
Please Refer Oracle Order Management User’s Guide section "Drop Ship Across SOB Major Features"

3. Is it possible to drop ship ATO/PTO models?
Order Management enables you to enter drop ship sales orders and lines for standard, model and kit, and configured items, although you currently cannot perform a drop shipment for Ship Model Complete (SMC) PTO's. Drop ship functionality allows you to take an order from your customer for ATO and non ship model complete (non SMC) PTO and PTO-ATO hybrid configurations and fulfill it directly from your supplier’s site. 
The functionality does not support dropshipments of ship model complete (SMC) PTO or SMC PTO-ATO hybrid configurations.

4. How are over/under shipments handled in drop shipment?
If part of a drop-ship line ships and you do not wish to fulfill the remaining quantity, cancel the line. Over-shipments must also be handled manually. If the supplier ships more than the ordered quantity, you can bill your customer for the additional quantity or request that they return the item. Use the 'Sales Order and Purchase Order Discrepancy Report' to view differences between your drop-ship sales orders and their associated purchase requisitions and orders. 
Refer to Order Order Management/Shipping User Guides.

5.When the Requisition Import parameter 'Initiate Approval after Import' is set to 'No', the requisition still gets imported in an approved status. Why is this?
The Purchase Release program in the OE module ignores the setting of this parameter. When it is populating the data in the po_requisitions_interface table the field authorization_status is hardcoded with the value 'APPROVED'. Thus in the case of drop shipments, the requisition always gets imported in an approved status. The reason for this is because the sales order has already been 'purchase released'.

6.Why does the ship date for drop ship orders show as Sysdate in Receivables, as opposed to the actual date the product was shipped?
For drop ship transactions the ship_date_actual field which is passed to Receivables is obtained from the transaction_date in the rcv_transactions table. This is the date which shows on the Receiving -> Receipts form in Purchasing when receiving against the PO. In order to reflect the actual date the product was received, if different from the current date, this field should be updated on the form.
NOTE: Prior to the fix in patch 1165312 the ship_date_actual for drop ship lines was passed to Receivables as NULL, which caused the order_date to be used on the invoice.

7.How are cancellations handled in drop ship orders?
Cancel Orders Form allows users to cancel a Drop Ship Order only if the corresponding Requisition is canceled. Consider the following scenarios: 
 i) Canceling an Order with Drop Ship Lines. 
An Order with Drop Ship Lines is allowed to Cancel only if all requisitions for the Order are canceled and no receiving is done for these lines. If Requisition doesnot exist for any of the Drop Ship Lines, then the Order can be canceled. 
ii). Canceling a Drop Ship Line in an Order. 
A Drop Ship Line in an Order can be canceled only when the corresponding Requisition is canceled. Quantity allowed to cancel for this line is Requistion's canceled quantity - Order's canceled quantity (if Order is partially canceled already). If Requisition does not exist, then the Quantity allowed to cancel is Order's ordered quantity - Order's canceled quantity (if Order is partially canceled already). 

Also refer note 393688.1 how you can disable dropship constraints.

8.How can I view the Purchasing information for a drop ship order?
After the requisition import successfully pulls in the data from the PO_REQUISITIONS_INTERFACE_ALL table, and creates the requisition, this information is available from the Sales Orders form as follows: 
Select the sales order line with the externally sourced item and hit Actions -> Additional Line Information Select the Drop Ship tab to view the data

9. Does the Purchase Release concurrent program still exist?

Yes, this program can be run from the Orders, Returns -> Purchase Release menu. If there are holds which prevent the order from progressing through the Workflow normally after the order is booked, these holds must be manually released. Then the externally sourced lines can be sent to Purchasing by running the concurrent program. Alternatively, you can use the Actions -> Progress Order button to push the lines through to the PO_REQUISTIONS_INTERFACE_ALL table for Requisition Import to pick them up.

10. Can an item be used for both Drop Ship and Internal Shipments?
The Source Type attribute (values: Internal or External) on OM order line is what determines whether the item will be sourced internally (shipped from stock) or externally (drop shipped by an external supplier) for that particular order line. Thus, the same item can be fulfilled either way.

11. How can we fulfill a dropship a line form currently On Hand Quantity?
Example: Book a sales order line and then create a PO for this line, we want to ship the line from our warehouse instead of receiving from the PO. Now, cancel the PO but can't seem to perform a pick/release...what attribute do we need to change on the sales order in order to perform a pick release?

Cancel the existing sales order line and then create a new line in the with source type internal.

12. Can not change or cancel a back order line of a Drop Ship order,the following error occurs:
 ERROR
 You are not allowed to cancel Order Line because:
 Order Line has associated Purchase Orders Approved.

Processing constraint prevents in performing above function. You can disable the processing constraint. Please refer to note 393688.1 and Order Management user guide for details.

13. Are Sales Order Attachments Passed To Drop Ship Purchase Order?
OM Development confirmed that current functionality does not support the passing of attachments from OM to PO.

14. How does one view the Purchase Order attached to a drop ship kit?
When you navigate to 'Additional Line Information' > Drop ship tab > the PO does not display.

You can view the Requisition or Purchase Order linked to the PTO kit with these steps:
1. Query the order in the sales order form
2. Tools > Check ' Show Line Details' box so that the kit components display under the PTO kit
3. Navigate to a shippable component line
4. Actions > 'Additional Line Information' > Drop ship tab > the Purchase Order or Requisition will display only for the shippable component lines. Since the kit line does not ship, you will not see a link to a PO on that line.

15. You are trying to split a line on a drop ship order line after purchase release; you receive the message: You are not allowed to split order line because Line is released to purchasing
As per bug 2281449  update, "We can not allow the split of the line once it is purchase released, because we do not have a way today to communicate the newly created line(after split) to PO so that req and PO can be created for this new line. So the seeded constraint is there because no req or PO can be created for the new line created after split"

Comments

Popular posts from this blog

General Ledger FAQ

1.  What responsibility should I use when doing the set up for General Ledger? Use a seeded responsibility like 'Oracle General Ledger Super User'. You may also need to use the System Administrator responsibility. 2.  What are the pre-requisites required to define a new calendar? According to your business needs you need to decide the calendar type required i.e. monthly, weekly or biweekly, the number of periods, adjusting periods and the maximum number of periods within a fiscal year. 3. What are the pre-requisites required to define a new Ledger? Define a Calendar, Chart of Accounts and enable the functional Currency  and convention of subledger accounting method. 4. Why must I check the calendar definition before assigning to a Ledger? The calendar definition cannot be changed once it is assigned to a set of books so it is very important to check that the calendar definition is suitable to the specific business needs, has been d

Difference Between MTS, ATO, MTO ,PTO ,CTO and ETO.

 Make-to-stock (MTS) In MTS environments, products are created before receipt of a customer order. Customer orders are then filled from existing stock, and then those stocks are replenished through production orders. MTS environments have the advantage of decoupling manufacturing processes from customer orders. Theoretically, this enables customer orders to be filled immediately from readily available stock. It also allows the manufacturer to organize production in ways that minimize costly changeovers and other disruptions. However, there are risks associated with placing finished goods into inventory without having a firm customer order or an established need. These risks tend to limit MTS environments to simple, low-variety, or commodity products whose demand can be forecasted readily.  Assemble-to-order (ATO) In ATO environments, products are assembled from components after the receipt of a customer order. The key components in the assembly or finishing process are pla

Accounting entries in Oracle Purchasing and Payables

This document gives in detail different accounts used and the accounting impact of various transactions that take place in Oracle Purchasing and Oracle Payables. Both Standard costing and Average costing methods are considered. The accounts are Oracle Applications specific and might differ from the conventional accounting names. Examples are given wherever required for better understanding of the concept. The sources of these accounts are given. PURCHASING:  Receiving – For Accrual Process for perpetual Accruals Receipts for inventory purchases are always accrued upon receipt. And also use perpetual accruals for expense purchases you want to record uninvoiced purchase liabilities immediately upon the receipt of the expense goods. Receiving Account (Receiving Account) To record the current balance of the material in receiving and inspection. Where to define in Apps: Define Organization                                          Define Receiving Options