Oracle Warehouse Management System Overview

October 28, 2012 in Oracle Warehouse Management

Oracle Warehouse Management System (WMS) is advanced inventory module with lot of unique features that improves productivity of distribution centers, manufacturing or inventory handling facilities. Oracle WMS supports manual data entry, bar code readers scanning for data entry as well as Radio Frequency Identification (RFID) scanning. WMS can be enabled at Inventory organization level.

Key business processes supported by Oracle WMS:

  • Inbound Logistics (Receiving, supplier returns, corrections)
  • Stocking and internal inventory movements
  • WIP Job assembly completion, component issues
  • Outbound Logistics (pickimg, packing, shipping)
  • Reverse logistics (customer returns)

License Plate Numbers (LPN): LPN is an object carries the location where it is residing and items that are holding. LPN need not be a physical object, it could be logical grouping. LPN simpley a group of items represented systematically. The major advantage of LPN is less number of transactions. Entire LPN can be transacted at once instead of by each line that LPN holds.

Material Status: This is one of the beautiful features of WMS, you can assign status to an item, lot or serial number. Each status is defined with a list of permissble transactions. Eg. if you have status called ‘No Sale’ and set the rules such that shipping is not allowed but all other internal inventory movements are allowed. Material status can enforce this kind of business rules.

Label printing: WMS partially supports this fucntionality. You can define label formats and fields (data) needed, you can associate this with WMS rules to print the label automatically. WMS can generate xml output, but you need a 3rd party label printing/formatting tool to actually print.

Cost groups: This is another major functionality offered by WMS module. In standard Inventory module Inventory valuation accounts are derived by subinventory setups. In WMS based on cost group rules you can have different valuations independent of subinventories.

Putaway Rules: When a matrial is received you need to receive into stock. In a major distribution center it is often complex to know where to store the material. WMS offers putaway rules that can be setup based son business criteria. Eg. If all hazarad material categy must be received into hazardous area then putaway rules can be setup.

WMS Rules engine: WMS rules engine enforces the rules defined for putaway, cost group or label printing. You can simulate the results based on set of rules defined.

Oracle Apps Modules List

August 23, 2012 in Oracle Applications

VISIT HOME PAGE FOR ORACLE APPS MODULES TUTORIAL LIST

Oracle Apps is a short name for Oracle Applications. There are many other names that are in use for Oracle Apps, some of them are

  • Oracle Applications
  • Oracle ERP
  • Oracle eBusiness Suite
  • Oracle Fusion Applications

Oracle Apps is ERP system developed by Oracle Corporation.

It consists many modules, often grouped into product families. Oracle apps ERP is in use since 30+ years, initially started with oracle financials and expanded to manufacturing, logistics, supply chain planning, product life cycle management & customer relationship management. Industry specific modules are also available for Healthcare, Aerospace, Life Sciences, High Tech industries.

Oracle Apps product families and related module offerings:

Application Administration

  • i Setups
  • Alerts
  • Trading Community Architecture

Integration

  • e-commerce gateway
  • Workflow
  • XML gateway
  • Report Manager
  • Web Applications Desktop Integrator

Marketing and Sales

  • Marketing
  • Trade Management
  • TeleSales
  • Field Sales
  • Sales for Handhelds
  • Quoting
  • Partner Management
  • Proposals
  • Incentive Compensation
  • Price Protection
  • Contracts
  • Sales Contracts
  • Sales offline
  • Territory Manager
  • Web Analytics and Administration

Order Management

Logistics

Supply Chain Planning

Procurement

Manufacturing

  • Work In Process
  • Bills Of Material
  • Engineering
  • Quality
  • Manufacturing Execution Systems
  • Manufacturing Operations Center
  • Landed Cost Management
  • Enterprise Asset Management
  • Costing
  • Flow Manufacturing
  • Manufacturing – Subcontracting
  • Shop Floor Management
  • Process Manufacturing Cost Management
  • Process Manufacturing Process Planning
  • Process Manufacturing Process Execution
  • Process Manufacturing Product Development
  • Process Manufacturing Quality Management
  • Process Manufacturing Regulatory Management
  • Process Manufacturing System Administration
  • Capacity
  • Manufacturing Scheduling
  • Master Scheduling/MRP and Supply Chain Planning

Service

  • TeleService
  • Service Contracts
  • Field Service
  • Depot Repair
  • iSupport
  • Install Base
  • Service Contracts
  • Advanced Scheduler
  • Knowledge Management
  • Mobile Field Service
  • Spares Management

Projects

  • Project Costing
  • Project Resource Management
  • Project Collaboration
  • Project Management
  • Project Portfolio Analysis
  • Project Contracts
  • Project Billing

Real Estate Management

  • Property Manager

Product Life cycle Management

Financials

  • Accounts Payables
  • Accounts Receivables
  • General Ledger
  • Advanced Collections
  • Internet Expenses
  • iReceivables
  • Treasury
  • Internal Controls Manager
  • Financial Consolidation Hub
  • Financial Services Accounting Hub
  • Accounts Receivable Deductions Settlement
  • Chaannel Rebate and Point of sale management
  • Revenue Management
  • Supplier Ship and Debit
  • Assets
  • iAssets
  • Cash Management
  • Treasury
  • Bill Presentment
  • Credit Management
  • Advanced Global Intercompany
  • Public Sector Budgetting
  • Public Sector Financials
  • U.S. Federal Financials
  • E-Business Tax
  • Lease and Finance
  • Enterprise Performance Foundation
  • Performance Management

Human Resources

  • Human Resources
  • Self-Service Human Resources
  • Advanced Benefits
  • iRecruitment
  • Payroll
  • Time and Labor
  • HR Intelligence
  • Succession Planning
  • Labor Distribution

Learning Management

  • Learning Management (formerly Training Administration)
  • iLearning

Customer Data Management

  • Customer Data Librarian
  • Customer Data Hub

Product Information Management

  • Product Information Management Data Librarian
  • Product Information Management Data Hub

Interaction Center Technology

  • Advanced Inbound Telephony
  • Advanced Outbound Telephony
  • Scripting
  • eMail Center

Communications/Utilities

  • CRL Financial Management
  • Asset Tracking
  • Telco Provisioning
  • Number Portability
  • Telecommunications Billing Integrator

Public Sector/University

  • Student System
  • Financial Aid
  • Student Recruiting
  • Personal Portfolio
  • Grants
  • Loans

Financial Services

  • Regulatory Capital Manager
  • Profitability Manager
  • Transfer Pricing
  • Transfer Pricing Online
  • Budgeting and Planning
  • Risk Manager
  • Financial Data Manager
  • Financial Services Provisioning
  • Lease Management

Healthcare

  • Adverse Event Reporting System
  • Clinical
  • Remote Data Capture
  • Thesaurus Management System
  • Clinical TrialMinder
  • Clinical SiteMinder
  • Life Sciences Data Hub
  • Healthcare Transaction Base

High Tech

  • Shop Floor Management
  • Supply Chain Planning Connector for RosettaNet

Aerospace, Defense and Transportation

  • Complex Maintenance, Repair, and Overhaul

Sales Order Creation

August 20, 2012 in Business Processes

Sales Orders are the core focus of Oracle Order Management module. Sales Order will have all the details of items/goods/services requested by the customer and the due dates.

Sales Order can be entered in multiple ways

  • Manual entry (based on a phone call, fax)
  • Order Import (through API / Concurrent program)
  • Copy from an existing sales order
  • Convert from an Quote
  • From other CRM modules (Service, Sales)
  • From an Blanket Sales Agreement
Enter Sales Order - Oracle Order Management
Description
Sales Orders are entered to capture the sale of product/service. Typically sales order contain the customer, customer address, product, price and terms and conditions.
For detailed tutorial on how to create/enter sales orders in oracle order management visit
http://oracleappscommunity.com/oracle/blog/399/sales-order-creation/

Navigation: Oracle Order Management responsibility -> Orders, Returns -> Sales Orders

This screen opens the sales order header screen.

Sales Order - Header tab

Sales Order – Header tab

Enter important fields required to capture sales order header information

  • Customer
  • Customer PO reference number
  • Customer contact name
  • Blanket Number if the sales order created from an existing blanket sales agreement.
  • Ship to location  – this is the address where items are shipped to the customer.
  • Bill to Location – this is the address where invoice will sent to customer
  • Order Number – Based on setup this can be auto generated or manually entered.
  • Order Type (this controls the order life cycle)
  • Sales Order date – defaults to current date
  • Price List – Determines the price for items/services ordered.
  • Sales Person – to capture metrics and calculate sales compensation
  • Status – displays the current status, when order is entered the status will be ‘Entered’, as sales order progresses its status is updated.
  • Currency – Defaulted from price list
  • Order subtotal, tax, charges, total are summarized for viewing.

Click on ‘Others’ tab for more data entry

Sales Order Header - Others tab

Sales Order Header – Others tab

  • Payment Terms – determines when the payment is due
  • Warehouse – Default warehouse, unless a different warehouse entered at sales order line level, the header level warehouse is used to ship the goods.
  • FOB – FOB point
  • Shipping instructions – additional information for shipping clerk
  • Credit card type, card holder, approval code information for credit card sales orders.
  • Sales channel – used for reporting
  • Shipping method – Air/ground/sea
  • Freight terms – determines how freight charges are handled.
  • Shipping priority – to mark urgent, rush, normal, slow orders.
  • Packing instructions – additional information for packers
  • Payment type – Credit, cash, EFT, Check

Click on the Lines to enter line level information

Sales Orders Lines

Sales Orders Lines

  • Enter Item, quantity, UOM.
  • Unit price will be defaulted from price list.
  • Enter requested date and scheduled ship date
  • Enter order line type (determines sales order line life cycle)

Click on ‘Pricing’ tab for additional pricing related information – Pricing context, calculate price flag, payment terms, sales agreement and pricing date.

Click on ‘Shipping’ tab to enter additional shipping information – Warehouse, source type (internal/external), request date, scheduled ship date, promise date, planning priority, shipping method, shipment priority, freight terms, line level shipping instructions/packing instructions.

Click on ‘Addresses’ tab to enter ship to customer, ship to location, ship to address, ship to contact, bill to customer, bill to location, bill to address, bill to contact, deliver to location and deliver to contact.

Click on ‘returns’ to enter return order information if this order line is for returned item.

Once all the sales order information is entered it can be scheduled, reserved, or booked to process next steps.