You are browsing the archive for Oracle Warehouse Management.

Oracle Warehouse Management System Overview

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.

Wave Planning – Catch Exceptions

 

NAME: Wave Planning – Catch Exceptions
SHORT CODE: WMS_WP_EXCEPTIONS
MODULE: Oracle Warehouse Management

Description:
Navigation: Oracle Warehouse Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_exception_name : Name of the Exception
  • p_organization_id : Organization id
  • p_wave : wave header id
  • p_exception_entity : Entity name
  • p_progress_stage : Progress Stage
  • p_completion_threshold : Completion Threshold
  • p_high_sev_exception_threshold : High Severity Exception Threshold ( Hrs )
  • p_low_sev_exception_threshold : Low Severity Exception Threhold
  • p_take_corrective_measures : Take Corrective Measures
  • p_release_back_ordered_lines : Release Backordered Lines
  • p_action_name : Task Update Action Name

 

Wave Planning Initiate Process

 

NAME: Wave Planning Initiate Process
SHORT CODE: WMS_WAVE_PLANNING
MODULE: Oracle Warehouse Management

Description:
Navigation: Oracle Warehouse Management Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_template_name :
  • p_wave_header_id :
  • p_Org_Id :