Skip to main content

Setup steps for Drop Shipments in Oracle EBS


 

Oracle Order Entry and Oracle Purchasing integrate to provide drop shipments. Drop shipments are orders for items that your supplier ships directly to the customer either because you don't stock or currently have the items in inventory, or because it's more cost-effective for the supplier to ship the item to the customer directly



SETUP

A) Associate drop shipments with a receiving location.
B) Drop shipments support a Destination Type of Expense or Inventory only.
C) We can handle returns of drop shipments using standard Order Entry/Shipping or Purchasing functionality. There are different ways you may want to handle returns depending on whether the customer returned the item to you or directly to the supplier.
We have to consider the following setup:

1- Inventory Setup 

Inventory Setup : (Define and Maintain The Item)
The drop ship inventory organization, item and subinventory must be setup prior to creating any drop ship orders. All drop ship subinventory must have the Reservable box checked.
Below are list of the required item attributes for a drop ship item. All of these attributes MUST be enabled unless otherwise specified.
Inventory Attributes: Inventory Item , Stockable, Transactable, Reservable
Purchasing Attributes: Purchased, Purchaseable
Costing Attributes: Costing Enabled – this should only be checked for items that are cost enabled, Inventory Asset Value – this should only be checked for asset items (non-expense items)
Receiving Attributes: Receipt Routing set to Direct – this is not required, but preferred since it makes receiving process one step versus two or three
Order Management Attributes: Customer Ordered, Customer Orders Enabled, OE Transactable
As a Troubleshooting tips on creating a drop ship item and subinventory:
  •  Make sure the subinventory is Reservable.If the subinventory is not Reservable, the sales order issue transaction will not be created in MTL_TRANSACTIONS_INTERFACE.
  •  Make sure the item has the above mentioned item attributes in the drop ship organization. If the above item attributes are not set, problems will arise in various places during the drop ship transaction process.

2- OM Setup

  • Make sure the sales order line Source Type is External. If the source type is not External, workflow will not distinguish the line as being a drop shipment and will not insert any data into the purchasing module’s requisitions interface. 
  • For customer, enter internal ship to location.
  • Customer must have a valid ship-to and bill-to locations. 
  •  Make sure that either the schedule ship date or request date is populated.If both of these are null, the requisition will not be imported into the purchasing module’s requisitions interface. 
  •  Make sure there are no holds against the line. If there is a hold, the hold must be removed and then the order can be progressed or the line must be manually purchased release.
    Verify in HR, that the employee has an active status and has not been terminated.
For more details metalink
Note 99888.1: Drop Shipments – Setup
Note:99886.1 : Drop Shipments – FAQ
Note:99889.1 : Drop Shipments - Troubleshooting

3- PO Setup

  • Make sure the Import Source parameter list of values contains ORDER ENTRY.
    If ORDER ENTRY appears in the Import Source parameter list of values, then it means that the Workflow Background Processor successfully inserted a requisition into PO_REQUISITIONS_INTERFACE_ALL. If ORDER ENTRY is not visible in the Import Source parameter list of values, then no rows were inserted into the table. Review the setup under Order Management. 
  • User should be setup as a valid PO Buyer.
  •  Make sure the Group By parameter is actually set the user wants the requisitions grouped.


Click to add to Favorites


Comments

  1. Wonderful information.
    For more related information visit us. ERP Software Solution.

    ReplyDelete
  2. It's interesting to read the blog, exactly the information i needed.

    Thanks for sharing.
    ERP Software Solution.

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete

Post a Comment

Popular posts from this blog

Use of Who Columns in Oracle APPS table

Oracle APPS : WHO COLUMNS WHO columns are used to track the information updated or inserted by the users against the tables. FND_STANDARD package is used for this purpose. FND_STANDARD.SET_WHO Procedure is used to update the WHO columns in a Table when a DML operation s (i.e. INSERT, UPDATE) performed. Steps required to Track WHO Information in our form   1. ALTER the table by adding WHO columns in the table.   2. Open TEMPLATE.fmb in form Builder.   3. Perform all the pre‐requisites to develop a form.   4. Include all the WHO columns in the Data Block with NULL Canvas.   5. Call FND_STAND.SET_WHO procedure in Pre‐Insert and Pre‐Update triggers       at Block Level.   6. Save and Compile the Form.   7. Perform all the pre‐requisites to register the form Note: 1. WHO Columns need not register with the table registration option.           2. Table registration will be done only for KFF and DFF col...

Oracle APPS Create Responsibility and User in Oracle EBS

How to create Responsibility and User in Oracle EBS How to Create a Responsibility? Step 1: Connect to Oracle Application with APPSADMIN/APPSADMIN User. Step 2: Go to Application Administrator. Step 3: Go to Security then Responsibility then Define Step 4: Enter the Data in the opened Window. Note: Above Information of Responsibility is stored in FND_RESPONSIBILITY Table. How to Create a User? Step 1: Connect to Oracle Application with APPSADMIN/APPSADMIN User. Step 2: Go to Application Administrator. Step 3: Go to Security then User then Define Step 4: Enter the Data in the opened Window. Note: Above Information of User is stored in FND_USER Table. User Responsibilities stored in FND_USER_RESP_GROUPS Table.