Order Management Basis Setups

Oracle Order Management Setups

Oracle Order management is one of the most important part of the oracle EBS. The Order Management Application provides many flexible features enabling you to set up your system to begin processing order information. These orders can be created in Oracle Order Management Suite as well as in some other front-desk application. We can integrate these applications with Oracle Order Management for keeping a controlled track of orders and proper business flow. We can create different types of orders using this application can be for inventory stock items or for services.
You must define your business order policies, such as how you classify your orders, as well as various control features prior to processing orders within the application.

Important Setup Steps for Order Management

Click on the links to go to individual setup steps

Step	Optional or Required
1. Define multiple organizations in Oracle Inventory	required
2. Setup Multi-Org (Multiple Organization) Access Control	optional
3. Define key and descriptive flexfields	required under certain conditions
4. Define inventory organizations (warehouses), parameters, subinventories, and picking rules in Oracle Inventory	required
5. Define Profiles	required
6. Setting OM System Parameters	required
7. Define invoicing information, Payment Terms	required under certain conditions
8. Define your sales representatives	optional
9. Define Tax Features	required
10. Define Quickcodes	required under certain conditions
11. Define header and line processing flows	required
12. Define Document Sequences for Order Numbering	required
13. Define Order Import Sources	required under certain conditions
14. Define the units of measure	required
15. Define item information	required
16. Define the items that you sell	required
17. Define the configurations that you sell	required under certain conditions
18. Define price lists	required
19. Define customer profile classes	required under certain conditions
20.Define information on your customers	required
21. Define item cross references	required under certain conditions
22. Define your sourcing rules	optional
23. Define Order Management Transaction Types	required
24. Set up Cost of Goods Sold Accounting flexfield combination	required under certain conditions
25. Define Processing Constraints	optional
26. Define Defaulting Rules	optional
27.Define Credit Checking Rules	required under certain conditions
28. Define Automatic Holds	required under certain conditions
29. Define Attachments	optional
30. Define Freight and Special Charge Types	optional
31. Define shipping parameters	required

Sourcing Rule in Oracle Purchasing

Sourcing rule is used to automatically replenish materials in an organization or business.
Sourcing rules determine the movement of materials between organizations in a global enterprise; these organizations include the suppliers and the materials include those items made at the manufacturing organizations.

Profile Options

• MRP:Default Sourcing Assignment Set (set the value of the assignment set where you have added your item) 
• PO: Automatic Document Sourcing (Yes) 
• PO: Allow Auto-generate Sourcing Rules (CREATE AND UPDATE) 
• PO: Allow Autocreation of Oracle Sourcing Documents (Yes)
• MSC: ATP Allocation Method (User-Defined Allocation Percentage)

Define an Item

Noted Attributes:

• Select any Inventory Planning method
• Select the item Make or Buy
• Enter a List price
• Enter a default Buyer (this will help to assign a buyer during planning and in the requisition) 

Define Supplier and Supplier Sites

You can define supplier and supplier sites as required

Purchasing –> Supply Base –> Suppliers

Defining Sourcing Rule

Purchasing -> Supply Base -> Sourcing Rule

Notes:

• You can use this rule across all orgs by Selecting All Orgs
• If you want to use in specific org, the select the Org

Shipping organization type is 3 types

• Buy From: Buying from a supplier
• Transfer From: If you want to transfer the item from another organization in your business
• Make At: This is for making the item in the selected organization

Allocation percentage: This is to identify how much % of the amount will be sourced from which org. This is helpful when you want to maintain multiple sources and want to split the sourcing amount between different sources, so you can split that by allocation%.
Master Scheduling/MRP uses these allocation percentages when creating planned orders, which Purchasing imports as requisitions through Requisition Import. In a group of requisitions imported from Master Scheduling/MRP, those requisitions show the percentage allocation you define. In other words, at the end of a planning period, orders–as a group–to those suppliers approximately equal the percentage split you defined. However, when you create a requisition in Purchasing, Purchasing sources to the supplier with the highest allocated percentage. The Approved Supplier List (ASL) entry for that supplier is then referenced in order to pick up source document information (from a blanket purchase agreement or catalog quotation), if source documents exist

Allocation Rank: To select the sequence in which sources will be identified during planning

Sourcing Rule Assign set, add the item for the sourcing rule

Once sourcing rules are defined, now time to assign the rule to Item or organization as you need

Purchasing à Supply Base à Assign Sourcing Rules

Here you can assign the sourcing rules at 4 different levels

• Item 
• Item-Organization
• Organization
• Global

Add the supplier to Approved Supplied List

This is optional, if you have checked ASL in Item attribute

Purchasing à Supply Base à Approved Supplier List

Run Min Max planning for the item

Inventory à Planning à Min-Max Planning

Submit the request for the item and make sure restock parameter selected as Yes

Then run requisition Import

This will create the Purchase Requisition and in turn submit the Create Releases Program which will in turn create the Purchase Order

Internal Requisition to Internal Sales Order

Creation Of Item

Create an Item and assign that to both the source and destination organization

Attributes

• Purchased
• Purchasable
• Internal Order Enabled
• Shippable
• OE transactable

Creation of Internal Requisition

Now go ahead and create and Internal Requisition

Go to Purchasing Responsibility

Requisitions -> Requisitions

Note: You should have been defined as an employee/ buyer to create a requisition

1. Type should be Internal Requisition
2. Enter the item in Lines Tab
3. Enter Quantity
4. Enter Need By Date
5. Select the Destination Organization
6. Destination Location
7. Select Source Organization

Click on Save, It will generate the Requisition Number. Note down the requisition number
Now need to Approve the Requisition
If you want to approve this requisition, then you should have required approval authority.
Lets do the required setup
Go to Human Resources (if Installed) responsibility
People -> Enter and Maintain

else in purchasing
Go to Setup -> Personnel -> Employees
Find the employee (if not created already, select new and create one)

Select Assignment

Here assign a Job

Now lets go and check whether this Job has Requisition Approval authority or not

For this, navigate to Purchasing responsibility

Setup -> Approvals ->Approval Assignments

In this form, select the Job which you have assigned to the employee

Now you can see which all document types are authorized to approve

Make sure Approve Internal Requisitions is entered here

If you can’t see this, then add the value

Make sure the Approval Group which you are assigning here that has the approval limit authorization with in which your IR amount comes

As in this case

Here the limit is max $50,000 and our IR amount is only $100

Now Go back to the requisition and approve the same

Query the requisition and click on the approve button

Make sure Submit for Approval selected (it should be by default) then click on OK

Wait for few min as the background process will check and clear the Approval workflow

And re-query the IR again

If Workflow Background Process not scheduled, you can go ahead and manually submit

Now again requery the IR from requisition summary form

You will see the IR is approved

Creation of Internal Order

Next step is to Run the Create Internal Order concurrent program which will interface the data to Order management for creating internal order

Go to View -> Requests -> Submit a new request -> Single Request

Select Create Internal Orders and submit

Once the program is completed, check the log file,

It means the data transferred to Order Entry

Now lets go to Order Management and import the data to create the Internal Order

Navigate to Order Management responsibility

Go to Orders, Returns -> Import Orders -> Order Import Requests

Now enter the below parameters

1. Source as Internal
2. Select your IR number in Order Reference field

Then Click Ok and Submit.

This will spawn another child order import program

Now go ahead and query your Internal order which is just created by importing the data in order organizer form

Orders, Returns -> Order Organizer

Give today’s date to refine

Select the source as Internal and give the IR number in the Order Source Reference

Now Click on Open.

Your internal order is ready

WMS Outbound Consolidation

• Consolidation is the process of bringing materials from different locations of warehouse to a consolidated location for packing and shipping.
• Consolidation can occur at one or more points during outbound process
• Mostly this has been performed during picking, so that picked materials can be consolidated for packing before shipping
• Some warehouses do this even after packing to consolidate in pallets which can be shipped later

Oracle WMS allows 8 types of system directed consolidation based on following key factors

• Should material be consolidated in a consolidated locator or directly in a staging lane
• Should consolidation occur at LPN level
• Can material from different deliveries be consolidated based on the operation plan while upholding the consolidation rules such as no loose material is allowed in the outer most LPN

LPN Based Consolidation in a Staging Lane Within Delivery

• This is the default method for outbound consolidation.
• This allows consolidation of materials in a single delivery directly to a LPN in a staging lane
• System suggests the last LPN dropped off for this delivery in this staging lane

Direct Consolidation in a Staging Lane across Deliveries

• This allows to consolidate materials across deliveries in a staging lane
• Don’t consolidate material in a consolidation LPN within a staging lane
• System does not suggest a drop LPN for the dropping

Direct Consolidation in a Staging Lane within Deliveries

• This allows to consolidate materials for a single delivery
• System will not suggest any LPN

LPN based Consolidation in Consolidation Locator Across Deliveries in Staging Lane

• This allows to consolidate materials across deliveries into a consolidated LPN in a consolidation locator
• After consolidation, materials can be moved to staging lane using mass move functionality

LPN based consolidation in Consolidation Locator within Delivery in Staging Lane

• This allows to consolidate materials within a delivery into a consolidated LPN in a consolidation locator
• After consolidation, materials can be moved to staging lane using mass move functionality

LPN Based consolidation in Staging Lane Across Deliveries

• This allows to consolidate materials across multiple deliveries into a consolidation LPN in a staging lane

Locator based Consolidation in Consolidation Locator Across Deliveries in Staging Lane

• This allows to consolidate each deliveries in separate consolidation locator
• Then consolidate material for multiple deliveries in same staging lane

Locator based Consolidation in Consolidation Locator within Delivery in Staging Lane

• This allows to consolidate materials for a delivery in a consolidation locator
• Then move the materials to staging lane

Basic Setups for consolidation

 Define Default Consolidation Mode in the Organization Parameters window

Define consolidation locators

Define locator dropping order

Define operation plan selection rules

Consolidation Validation

• All lines in the From and To LPN, if the material resides in an existing LPN, must be assigned to a delivery
• The destination LPN must be in a locator type Staging
• The destination LPN must not have any loose material. If LPNs are nested, the nested LPNs can contain loose material
• All tasks loaded into the From LPN and To LPN must have an operation plan if the consolidation method set to across deliveries

SQL Script to find Concurrent Request Details in Oracle

select req.request_id,
       req.argument_text,
       req.requested_start_date,
       req.actual_start_date,
       req.actual_completion_date,
      (select meaning
          from apps.fnd_lookup_values
         where lookup_type = ‘CP_STATUS_CODE’
           AND lookup_code = req.phase_code
           and start_date_active is not null) phase,
       (select meaning
          from apps.fnd_lookup_values
         where lookup_type = ‘CP_STATUS_CODE’
           AND lookup_code = req.status_code
           and start_date_active is not null) status,
       (usr.user_name || ‘ – ‘ || usr.DESCRIPTION) requested_by,
       fcpt.user_concurrent_program_name,
       (SELECT responsibility_name
          FROM apps.fnd_responsibility_tl
         WHERE responsibility_id = req.responsibility_id) resp,
       req.logfile_name,
       req.outfile_name
  from apps.fnd_concurrent_requests    req,
       apps.fnd_user                   usr,
       apps.fnd_concurrent_programs_tl fcpt,
       apps.fnd_concurrent_programs    fcp
 where req.concurrent_program_id = fcpt.concurrent_program_id
   and fcp.concurrent_program_id = fcpt.concurrent_program_id
   and usr.user_id = req.requested_by
   and req.request_id in (&req_id);

New and Changed Features in Oracle WMS in R12 Release

New and Changed Features in Oracle WMS in R12 Release

Oracle WMS automates and optimizes material handling processes to reduce labor costs, improve facility utilization, increase order accuracy and provide innovative services to customers. Oracle Warehouse Management supports inbound, outbound, and reverse logistics, finished, raw and work in process materials, manufacturing and distribution environments and advanced value-added services such as kitting and cross docking.

Oracle Warehouse Management is part of the Oracle Supply Chain Execution solution and integrates seamlessly with other Supply Chain Execution products, including Oracle Order Management, and Oracle Transportation Planning.

Features

Distributed WMS Deployment

Customers interested in using WMS to manage warehouse operations now have much more flexibility in choosing the deployment mode. Prior to this release, WMS can be installed only as an integrated module within the E-Business Suite instance. With this feature, it’s possible to deploy WMS in a distributed environment that is physically decoupled from the E-Business Suite instance. This feature also comes with a predefined integration based on Oracle Data Integration (ODI) tool. The ODI maps can be used to interface master data and transaction information between distributed WMS and host system.

This feature makes it possible to leverage the latest features in WMS R12.1.1 with an EBusiness suite installation that is on an older application release e.g. 11.5.10. Distributed WMS can potentially also be used with a non-EBS host system.

Distributed WMS also ensure greater availability of WMS instance. Since WMS will be a physically distinct deployment, any patching or maintenance activity on the host EBusiness suite will not impact WMS.

Advanced Wave and Task Planning

Warehouses that fulfill a large number of small orders can streamline their execution process using Wave Planning. Wave Planning offers a flexible and powerful tool to group order lines into waves. The planning features include tools to check stock and labor availability prior to releasing the wave to the warehouse floor. Wave Dashboard provides full visibility and monitoring of waves in real time from release to shipment.

Wave Planning also comes with an exception engine that can be configured to generate exceptions whenever wave execution deviates from acceptable standards. These exceptions allow warehouse management to take corrective action in a proactive mode.

Wave Planning also includes task planning features that can be used to group and dispatch tasks based on execution criteria.

Forward Pick Replenishment

Forward pick area replenishment is an important activity in a warehouse. By replenishing a forward pick area, a distribution center disaggregates material stored in reserve or bulk area and moves it into a pick area that is optimized for unit picking. In this release the following replenishment features are available for use:

• Pull Replenishment: This type of replenishment is useful for items with high uniform demand in forward pick area. A replenishment suggestion will be auto-created as soon as a shortfall is detected during order release process.
• Push Replenishment: This type of replenishment is useful for items with irregular demand in forward pick area. Using push replenishment, the aggregated future demand for an item is replenished to a forward pick area for future order picking activity.
• Dynamic Execution: The dynamic replenishment execution feature orchestrates the warehouse tasks in such a way that pick tasks to a forward pick area will be dispatched only when replenishment has been completed. Similarly a replenishment task will be dispatched only when a forward pick area has enough capacity to receive the replenished material.

These features provide tremendous productivity benefits to a warehouse engaged in distribution activity. Replenishment to forward pick area will allow distribution center to reap the benefits of bulk procurement and optimized storage in a reserve area as well as optimized picking for order profiles with smaller quantities.

Mobile User Interface Personalization

A major benefit of Warehouse Management’s mobile data entry capability is to ability to record a material movement at the point of usage. Data entry at the point of usage enhances inventory accuracy and records real time information. Mobile personalization goes one step further by providing the user with the flexibility to record data that is most relevant for the transaction without compromising the accuracy of transaction. In addition, mobile personalization can record additional use defined data in flex fields for specific transactions. Using this feature a warehouse can immediately realize the following benefits:

• Improve transaction execution speed by hiding or defaulting fields on a mobile transaction form.
• Improve transaction accuracy by defaulting a value in field using a user defined logic.
• Allow recording of additional data on a mobile transaction form using flex fields.
• All the above changes to a mobile transaction form can be made using a user friendly configuration screen without resorting to code changes that are expensive to complete and difficult to maintain.

Extensibility Enhancements

Task Extensibility features provide tremendous implementation flexibility in the execution of WMS tasks. This feature will deliver a public API to modify, update, split and cancel a WMS task. Using these features, WMS task functionality can be extended for customer or industry specific needs. The following list of business scenarios illustrates the applicability of this API:

• A user defined application that dispatches tasks to warehouse workers. Task API will be used to modify task status from unreleased to pending
• An extension that assigns a task to a warehouse operator based on a customer specific logic
• An extension to the cartonization algorithm that can split a task and assign a cartonized LPN to tasks
• An extension that supplements the warehouse control system layer to allow the warehouse automation system (for example and automated storage and retrieval system) to enable the automation system to drive updates to the lots, serials or quantities picked

Dock Scheduling and Load Sequencing

Organizations leveraging both Oracle Transportation Management (OTM) and Oracle Warehouse Management (WMS) can now make use of additional integrations between the two products to drive distribution efficiencies. OTM can schedule shipments to dock doors and sequence the loading of trailers at the doors based on time required, door availability and stop sequence for drop offs. With this feature, the dock doors, the dock door appointments and sequence of loads into a trailer can be synchronized with WMS.

WMS will use this additional information to plan outbound activities such as:

• Release of shipments for pick execution based on dock door schedule
• Sequencing of drops in the staging area for a multi-stop shipping itinerary
• Sequencing of tasks for picking when a multi-stop shipping itinerary is being used

LPN Status

Even in the most efficient manufacturing and distribution networks, quality issues may arise. Packages may arrive damaged from transportation; defects may be detected in manufacturing long after the product has left the production center; or quality issues may affect only some of the LPNs produced in a manufacturing batch. With this feature, the material status model has been extended to provide License Plate (LPN) level holds.

This will enable warehouse users to:

• Put individual pallets, cases or totes on hold without impacting the rest of the lot or the batch.
• Place holds on material that is neither lot nor serial controlled without moving that material to a quarantine location for speedier intervention when issues are discovered.
• Separate the physical movement of material and changes to the material status into different responsibilities, which will prevent the accidental change of material status when material is moved.

UCC-128 and Case Picking Enhancements

In consumer packaged goods industry, its common requirement to have the goods packed into containers with UCC-128 labeling. While the ability to print UCC-128 label already exists in WMS R12, this feature makes it easy to manage varied compliance needs of customers in consumer packaged goods industry based on customer’s ASN preference e.g. pallet level ASN or case level ASN, order type e.g. bulk order, store order, etc. This feature will also allow printing of sequential carton count on label e.g. “1 of 3”, “2 of 3”, etc. and also allow generation of ITF-compliant (I 2 of 5 labeling standard) labels with shipping information.

This feature also introduces support for efficient “Case Picking”. The case labels printed at order release can be assigned to pick operators. The operator can now perform case picks and either perform “Pick to Belt”or “Pick to Pallet” by scanning multiple case labels.

Over-Allocation Using WMS Rules

This feature is useful to pick items that are difficult to fulfill in exact order quantity.

Examples of such items are: Metal strips, Gas cylinders, fluid containers, paper rolls, wire bobbins, etc. Such items are typically stored or packed in non-standard quantities in the warehouse. Over shipment is a very common business practice for such items since it’s not cost effective to cut, split or unpack the items in order to ship the exact ordered quantity.

In this feature WMS rules can be configured to over allocate containers that are within over shipping tolerance and at the same time closest to the requested quantity on the order. In this way WMS operators are directed to pick containers that require minimal material handling without entering any pick exception codes even though the pick quantity may be greater than requested quantity.

LPN Over Allocation during Pick Release

Certain industries and business situation require that an Order can not be fulfilled in the exact quantity. A good example is primary metal where an order for an item such as steel sheets can not be exactly fulfilled because it’s expensive to cut a steel sheet to match the exact order quantity. In such situations, over allocation or under allocation is a normal business practice. This feature in Oracle WMS facilitates over allocation of an entire LPN provided it’s within over shipment tolerance defined on the Order Line.

Directed Putaway of Reserved LPNs

In a made to order manufacturing environment, the finished material is often packed into LPNs at manufacturing completion. In order to ensure that the manufactured material is fulfilled correctly, the entire LPN is reserved to the sales order. However it’s a common business scenario to putaway the LPN within the warehouse prior to its eventual shipment to the customer. This feature allows a reserved LPN to be transferred or putaway within the warehouse while retaining the reservation for the customer. The reservation guarantees the supply for the order line while the system enables you to move reserved lots within an LPN throughout the warehouse.

Reusing LPNs

The REUSE_LPNS API enables you to reuse LPNs and to review an LPN history. This API enables you to physically re-use returned containers after their contents have been issued out of stores, or returned using an RMA (return materials authorization).

Cluster Pick by Label

One Step Pick and Pack Process i.e. picking of products directly into a shipping carton offers huge productivity gains as no downstream packaging is required. Oracle Warehouse Management System currently supports One Step Pick and Pack Process using cartonization and “pick by label” picking. This feature makes it possible to pick one or more orders (the cluster) directly into their respective shipping cartons (pick by label). With this feature it’s now possible to get further productivity boost using one step pick and pack for several orders at once.

With cluster pick by label, labels are printed at pick release and manually distributed to operators based on criteria such as cart capacity. An operator scans multiple labels, and WMS facilitates interleaving of picks from several orders in one pass of the warehouse.

Distributed WMS Deployment

Distributed WMS deployment is an added feature delivered as a patch on R12.1. Until now Oracle E-Business Suite (EBS) Warehouse Management System (WMS) required the transaction source systems like Purchasing and Order Management and execution systems like WMS reside and operate within the same instance. With Distributed WMS deployment, it’s possible for WMS to be installed on a separate physical instance that is independent from remaining applications of E-Business Suite such as Order Management, Purchasing and Financials. This feature gives powerful choices to customers to deploy WMS either as an “integrated” as a module within EBS or as a “distributed” and independent solution installed on a separate instance. Customers who want the latest WMS features in R12.1 can have WMS deployed on a separate instance without upgrade of the entire application suite. This feature also makes it possible to use Oracle WMS for warehousing operations along with an EBS or non-EBS host system. In addition, Warehouse with network connectivity issues can also consider a distribute WMS installation for an “always on” WMS solution.

The feature also ships with an integration framework based on Oracle Data Integration (ODI) tool

Advanced Wave Planning

Advanced Wave Planning is also being released as a patch on R12.1. Advanced wave planning provides advanced Pick Wave management functionality over and above what currently exists in pick release. Wave Planning is particularly useful for warehouses that fulfill a high volume of small order lines. Wave planning makes it easier to manage large order volume by grouping orders into waves and subsequently releasing them for execution and monitoring.

Using advanced Wave Planning warehouse managers can select order using simple criteria and group them into pick waves. In addition, advanced filters similar to WMS rules engine can be used to select orders for waves as well as create waves by constraining them to be within certain line count, weight, cube or value. Wave planning provides preview of lines and tasks, expected completion, fill rate and labor needs prior to release of the wave. Advanced wave planning also comes up with Wave Dashboard that can be used to view wave progress and drill down to detailed line or task status. The exception engine in wave planning can be configured for specific business case to proactively look for exceptions such that corrective action can be taken. For example, a severe exception can be triggered if 80% of the lines in a wave are not loaded to the trailer 30 minutes prior to dock appointment end time.

The other advanced wave planning feature is task planning. The task planning criteria can be used to configure the conditions under which tasks will be released automatically for execution.


Source: Oracle