Transcript Document

Oracle Mobile Supply Chain- UnPlugged
August 15, 2008
Venetian 2 3:00 PM – 3:40 PM
Presented By
Ashok Kowdle PMP
[email protected]
1
Agenda
Overview of Oracle Mobile Supply Chain
Architecture of Oracle Mobile Supply Chain
Transactions Supported in MSCA
Key Benefits
Support for Changing MSCA Screens
Process Flows & Data Flows
Questions and Answers
2
MSCA Overview
 Oracle® Mobile Supply Chain Applications
(MSCA) enables automated mobile user
operations. This is performed using hand held
radio frequency (RF) devices, PDA’s, and lift
truck mounted RF scanners.
 Oracle MSCA is part of the Oracle Supply Chain
Management solution, the integrated suite that
streamlines design, planning, manufacturing
and fulfillment.
3
MSCA Overview
4
MWA Architecture
 Main Server Components

MWA Server

Telnet Listeners

Presentation Manager

Connection Manager
5
MWA Architecture
6
Mobile Apps Structure
 Mobile Application Components

Menu Item Java Bean

Page Java Bean

Field Java Bean

Field Listener Java Bean
7
Modules Supported in MSCA
 Mobile Manufacturing
 Mobile Quality
 Mobile Materials Management
 Warehouse Management
8
Manufacturing Transactions
 Moving assemblies
 Completing assemblies
 Scrapping and rejecting items and assemblies
 Issuing, returning, and scrapping material
 Work order-less completions and returns
 Flow completion, return, and scrap
transactions
 Charging resources
9
Quality Transactions
 Collect quality data
 View specifications
 Work in Process transactions
 WIP Work Order less completions
 Flow Manufacturing completions
10
Material Management Transactions
 Receiving & RMA
 Inventory transactions and inquiries
 Kanban transactions and inquiries
 Cycle Counting and Physical Inventory
 Pick Confirm
 Ship Confirm
 Intra-organization replenishment
11
WMS Transactions
 Inbound Logistics

Receiving, Cross Docking, Directed Putaways & Inspections
 Inventory Controls

Lot, sub lot, serial and revision control, Material Attribute Tracking &
Flexible Material status and holds
 Task Management

Rules based task dispatching, Guided consolidation, Cartonization &
Configurable Exception Management Workflow
 Outbound Logistics

Rule Based Product Allocation, Directed Picking, Consolidation &
ASN Generation
 Mobility

Mobile RF Based user interfaces, Material Handling Systems
Integration
12
Key Benefits
 Improve Inventory Accuracy

Reduce Data Entry Errors with Bar-Code scanning

Improve Transaction Accuracy with Real-Time Data Validation

Reduce Latency using Mobile Devices
 Improve Worker Productivity

Accelerate Data Entry using Mobile Devices

Simplify Transaction Entry with Mobile User Interface

Reduce Latency using Mobile Device
 Adapt to Rapidly Changing Mobile Technology
 Support Existing Manufacturing & Distribution
Processes out of the box
 Increase customer satisfaction by improving
inventory accuracy, shipment confirmation and
quality tracking
13
Personalization & Customization
 Personalization

Supports all Personalizations
 Customizations

Ability to change List of Values

Ability to add new fields to the existing pages

Adding new custom pages to the flow

Adding new validations to fields using field listeners
 Customization for Batch Mode Processing



Create new pages using MCL Designer
Save transactions either on Scanner Memory or Memory card as a
comma separated file
Process records by calling corresponding API’s
14
Personalization
15
Customization
16
Customization
17
Available Listeners
 Field Entered- Called when a Particular field is
entered
 Field Exited- Called when a Particular field is exited
 Page Entered- Called when a Particular page is
entered
 Page Exited- Called when a Particular page is exited
 App Entered- Called when a Particular App is
entered
 App Exited- Called when a Particular App is exited
 Special Listeners for Hiding fields, showing fields,
Additional Validations, etc
18
Batch Mode Processing
Main Menu
Sub Inventory Transfer
Item Number
Miscellaneous Issue
Item Number Barcode Scan
Quantity
Miscellaneous Receipt
Qty Barcode Scan
Sub Inventory Transfer
From Sub Inventory
From Sub Inventory Barcode Scan
Review File
To Sub Inventory
To Sub Inventory Barcode Scan
Save & Next
Save & Done
19
Process Flows and Data Flows
 Process Flows for Online Warehouses using
Oracle MSCA
 Process Flows for Offline Warehouses using
Oracle MSCA
20
Online Warehouses
Barcode
Scanner
Login into Oracle
MSCA
Transact in MSCA
Validated Records
Oracle Server
Request for Label
Printing
Send Request to
Barcode Printer
Label printing
Inventory
Application
Process Flow for Online Warehouses using Mobile Supply Chain Applications
Completed Data
fed into API’s
Process Records
Verify Records
Complete
Transaction
21
Offline Warehouses
Barcode
Scanner
Capture Data
Save Data to
Local Memory
chip
Sync Data
Login to Oracle
Run Concurrent
Request
Inventory
Application
Oracle Server
Loaded Custom
Application
Screens
Local Laptop or
PC
Process Flow for Offline Warehouses using Custom Applications
FTP File to Server
Insert Records into
Interface Tables
Validate Data
Process Records
Verify Records
22
MWA Testing & Error Logging

Configuration Files




MWA Server Startup and Shutdown




mwactl.sh: This file is used to start/stop the MWA listener on specific port.
mwactl.sh start <port no> to Start the services on the Listener
mwactl.sh -login <userid/pwd> stop_force <port no> to stop the services on the Listener
File Location






mwa.cfg: This file has information about the DBC file location, Log Dir Location, Telnet Port
no Location. This info will be used by Mobile Applications on runtime.
default_key.ini: This file is used to map the keys of the mobile device to some specific
functionality. Use the default file if you don’t want to customize anything.
deviceIP.ini: This file maps the configuration files and host name with the mobile device
$MWA_TOP/bin
$MWA_TOP/secure
$INST_TOP/admin/scripts
$INST_TOP/admin/install
In R12, INST_TOP may look like: /u01/appldev/DEV/inst/apps/DEV_w-oraap01
Log Files




The log files are located under $INST_TOP/logs
The Logging Levels are Fatal, Error, Warning, Debug & Trace
All the log files start with Telnet_port_no as a prefix
-rw-r--r-- 1 appldev dba 255626 Feb 8 13:28 10240.INV.log
Simpler way to look for logs tail -f 10240.INV.log
23
Questions and Answers
Questions and Open Discussions
Contact Information
Ashok Kowdle PMP
Email: [email protected]
Phone: 630-778-1180
Presentation Copy
www.astcorporation.com/papers/ncoaug
24