Oracle Order Management: Oracle Order Management 報告學生:劉振榮


Outline: Outline Order Management Concept Oracle ERP Overview Order Management Process Pricing Manage Customers Enter Import Orders Pick & Ship Process (four steps)


Outline: Outline Order Management Concept Oracle ERP Overview Order Management Process Pricing Manage Customers Enter Import Orders Pick & Ship Process(four steps)


Order Management Concept : Order Management Concept 「訂單管理」是接觸顧客的最前線 「顧客訂單」是企業營運的來源，有了顧客訂單，企業才有服務的對象，進而才有獲利的機會


Order Management Concept (con’t): Order Management Concept (con’t) 訂單管理是為了用來整合製造與配銷系統的企業流程，其目的為規劃和滿足生產/服務訂單的相關活動，並滿足顧客的需求 最低成本 最有效率的運送 高品質服務


Outline: Outline Order Management Concept Oracle ERP Overview Order Management Process Pricing Manage Customers Enter Import Orders Pick & Ship Process (four steps)


Oracle ERP Overview: Oracle ERP Overview 銷售預測 FCST 顧客訂單 orders 物料需求規劃 MRP 產能需求規劃 CRP 生產排程 schedule 採購訂單 PO 收料作業 receive 在製品管理 WIP 發料作業 issue 出貨作業 shipping 應付帳款 AP 付款作業 payment 應收帳款 AR 收款作業 receipt 會 計 總 帳 GL 粗略產能規劃 RCCP 倉儲管理 inventory 主需求排程 MDS 主生產排程 MPS 採購需求 PR


Outline: Outline Order Management Concept Oracle ERP Overview Order Management Process Pricing Manage Customers Enter Import Orders Pick & Ship Process (four steps)


Order Management Process: Order Management Process Basic Order Business Process Basic Order Process Flows Order Management Flow Drop Ship Process Internal Order Flow


Basic Order Business Process: Basic Order Business Process Enter Order Book Order Standard Order Process Schedule Inventory Pick/ Ship GL Invoice Customer


Basic Order Process Flows: Basic Order Process Flows Standard shippable (Distributor) Standard shippable (Manufacturer) Invoice only Customer requests order Enter order Book order Schedule Release order to Manufacturing Ship product and update inventory Invoice the customer Complete Complete Complete 1 2 3 4 1 2 3 4 5 6 1 2 3 4 5 6 7


Order Management Flow: 選配件產品 訂單輸入 發票開立 出貨管理 退貨審核 貨品退回 銷貨折讓 訂單排程 重排程 保留 可承諾量查詢 庫存餘額更新 未交訂單管理 撿貨 定義各項流程次序 定義流程元件 定義企業運作流程 - 設定規則訂單處理流程 - 授信核度檢查 - 退貨管理 - 訂單排程 訂單處理流程定義 授信額度檢查 出貨確認 例外管理 訂單保留 - 自動 - 手動 訂單解除管制 訂價 訂單審核 確認客戶基本資料 線上查詢庫存餘量 -可承諾量 - 保留量 授信額度檢查 退貨管理 Order Management Flow 訂單完成


Drop Ship Process 投送模式流程: Drop Ship Process 投送模式流程 Supplier Order Entry Purchasing Receivables Enter customer Enter order Create PO Receive PO Ship Order Shipment Notification Shipment Notification Received Create invoice Close order


Internal Order Flow: Internal Order Flow Requestor Approve requisition Demand Order entry Schedule order Pick Release Direct Intransit Receive Inventory Expense Inventory Expense Import or reschedule requisitions Manually create Create internal sales order Ship confirm 買方：子公司A 賣方：子公司B


Outline: Outline Order Management Concept Oracle ERP Overview Order Management Process Pricing Manage Customers Enter Import Orders Pick & Ship Process (four steps)


Pricing Concept: Pricing Concept Price concept considerate following questions: Who use this price? How should I adjust the price? What is the item or service? Qualifiers Product Hierarchy Product Attributes Modifiers


Pricing Business Scenario: Pricing Business Scenario INPUT OUTPUT PRICING ENGINE Final Price Price Lists Formulas Modifiers Agreements Adjustments Qualifiers Eligibility Attributes What One Customer One Item


Pricing Business Scenario: Pricing Business Scenario INPUT OUTPUT PRICING ENGINE Final Price Price Lists Formulas Modifiers Agreements Adjustments Qualifiers Eligibility Attributes What


Pricing Engine: Pricing Engine Calling Application (OM, CRM) Pricing Engine Search Engine Calculation Engine Pricing Request Phase


Qualifiers: Qualifiers Who can receive particular prices, discounts, surcharges, promotions, and benefits： Customer groups Order types Order amount You link them to price lists and modifiers.


Pricing Business Scenario: Pricing Business Scenario INPUT OUTPUT PRICING ENGINE Final Price Price Lists Formulas Modifiers Agreements Adjustments Qualifiers Eligibility Attributes What


Pricing Business Scenario: Pricing Business Scenario INPUT OUTPUT PRICING ENGINE Final Price Price Lists Formulas Modifiers Agreements Adjustments Qualifiers Attributes What Customer: EASTAR


Pricing Business Scenario: Pricing Business Scenario INPUT OUTPUT PRICING ENGINE Final Price Price Lists Formulas Modifiers Agreements Adjustments Qualifiers Attributes What Customer: EASTAR


Attributes: Attributes Control by pricing engine Price Modifier Ability to map to Customers Items


Pricing Business Scenario: Pricing Business Scenario INPUT OUTPUT PRICING ENGINE Final Price Price Lists Formulas Modifiers Agreements Adjustments Qualifiers Attributes Customer: EASTAR Item: EA Monitor Warranty: Transportation Charge


Pricing Business Scenario: Pricing Business Scenario INPUT OUTPUT PRICING ENGINE Final Price Price Lists Formulas Modifiers Agreements Adjustments Qualifiers Attributes Customer: EASTAR Item: EA Monitor Warranty: Transportation Charge


Price Lists: Price Lists Contain prices and currencies for products and services Specific products and services Product groups


Price Lists：Price types : Price Lists：Price types Unit price：Fixed price Percent price：Percent of another item’s price Price break(Point and range)：Price varies by quantity ordered


Pricing Business Scenario: Pricing Business Scenario INPUT OUTPUT PRICING ENGINE Final Price Price Lists Formulas Modifiers Agreements Adjustments Qualifiers Eligibility Attributes What


Pricing Engine: Pricing Engine Calling Application (OM, CRM) Pricing Engine Search Engine Calculation Engine Pricing Request Phase


Pricing Business Scenario: Pricing Business Scenario INPUT OUTPUT PRICING ENGINE Final Price Price Lists Formulas Modifiers Agreements Adjustments Qualifiers Attributes Customer: ABC Computers Territory: Western Region Item: Monitor Product Group: Computer Warranty: Gold Service Corporate Price List: Computer 275.00 Corporate Price List: Gold Service 27.50 Promotion Price List: Monitor, Qty 15 475.00


Formulas: Formulas The pricing engine can use formulas to determine item prices. Formulas are algebraic relationships constructed of individual terms. Each terms can be A numeric constant A combination of pricing attributes (e.g. thickness and height) and factors (e.g. 1 to 5, 5 to 10, and more than 10) The price of the item in a specific price list The price on a specific price list line A customizable function


Formulas (con’t): Formulas (con’t) Apply formulas Statically：Before submitting pricing requests, execute a concurrent process to evaluate the formula and calculate a list price for the item on the price list. Dynamically：Each time the pricing engine receives a pricing request, it evaluates the formula and calculate a list price for the item.


Pricing Business Scenario: Pricing Business Scenario INPUT OUTPUT PRICING ENGINE Final Price Price Lists Formulas Modifiers Agreements Adjustments Qualifiers Attributes Customer: ABC Computers Territory: Western Region Item: Monitor Product Group: Computer Warranty: Gold Service Corporate Price List: Computer 275.00 Corporate Price List: Gold Service 27.50 Promotion Price List: Monitor, Qty 15 475.00


Modifiers: Modifiers Set up price adjustments, benefits, freight and special charges, simple discounts and surcharges, and advanced deals and promotions.


Modifiers: Modifiers Discount Freight/Special Charge Surcharge 10% off item A 10% surcharge for purchase of under 100 units of item A 450 currency unit freight cost on entire order


Modifiers (con’t): Modifiers (con’t) Item Upgrade Other Item Discount Terms Substitution For the price of 100 ml of item A get 200 ml of item B Purchase over 1000 currency units on entire order, receive 30/60/90 terms instead of NET 20 terms Buy items A, and B ; get 20% off item B


Modifiers (con’t): Modifiers (con’t) Promotional Goods Price Break 1-100 units item A, 100 currency units each 101-500 units item A, 75 currency units each More than 500 units item A, 50 currency units each Coupon Issue Buy item A ,B and C; get one item D for free Buy over 1000 currency units, receive a coupon for 100 currency Units off a future purchase Point: Order 150 item A, receive 150 item A @ 75 currency units each Range: Order 150 units item A, Receive 100 item A @ 100 currency units each and 50 item A @ 75 currency units each


Pricing Business Scenario: Pricing Business Scenario INPUT OUTPUT PRICING ENGINE Final Price Price Lists Formulas Modifiers Agreements Adjustments Qualifiers Attributes Customer: ABC Computers Territory: Western Region Item: Monitor Product Group: Computer Warranty: Gold Service Corporate Price List: Computer 275.00 Corporate Price List: Gold Service 27.50 Promotion Price List: Monitor, Qty 15 475.00 Computer Promotion: 5% Discount 13.75 Computer Promotion: Free Printer 100% Discount on 100.00


Pricing Business Scenario: Pricing Business Scenario INPUT OUTPUT PRICING ENGINE Final Price Qualifiers Attributes Customer: ABC Computers Territory: Western Region Item: Monitor Product Group: Computer Warranty: Gold Service Corporate Price List: Computer 275.00 Corporate Price List: Gold Service 27.50 Promotion Price List: Monitor, Qty 15 475.00 Computer Promotion: 5% Discount 13.75 Computer Promotion: Free Printer 100% Discount on 100.00


Pricing Business Scenario: Pricing Business Scenario INPUT OUTPUT PRICING ENGINE Final Price Price Lists Formulas Modifiers Agreements Adjustments Qualifiers Attributes


Agreements: Agreements Results of negotiations with your customers that define: Prices Payment terms 30 Net 2/10, Net 30 Last Day Month … Freight terms Prepaid: The shipper take responsibility for paying the freight costs. Prepay & Add: The shipper can prepay the freight costs and charge your customer a fixed amount. Collect: The freight carrier bills the customer directly. …


Pricing Business Scenario: Pricing Business Scenario INPUT OUTPUT PRICING ENGINE Final Price Price Lists Formulas Modifiers Agreements Adjustments Qualifiers Attributes


Outline: Outline Order Management Concept Oracle ERP Overview Order Management Process Pricing Manage Customers Enter Import Orders Order Processing Business Flow Pick & Ship Process (four steps)


Manage Customers: Manage Customers Create customer profile classes Assign customer to profile classes Enter customer information Create customer relationships Eliminate duplicate information Review customer information


Manage Customers: Manage Customers Create customer profile classes Assign customer to profile classes Enter customer information Create customer relationships Eliminate duplicate information Review customer information


Profile Classes: Profile Classes You can use profile classes to describe and group customers with similar financial characteristics. Use profile classes to enter new customers quickly and consistently.


Manage Customers: Manage Customers Create customer profile classes Assign customer to profile classes Enter customer information Create customer relationships Eliminate duplicate information Review customer information


Enter Customer Information: Enter Customer Information The only information that is required for a new customer is a customer name, customer number, and address. If you do not assign a profile class, the system assigns the profile class 'DEFAULT' to each new customer you enter.


Enter Customer Methods: Enter Customer Methods Standard Quick Interface Enter complete details Enter limited information Import from other systems


Standard : Standard Attribute for Customer Attribute for Each Address


Standard : Standard Attribute for Customer Attribute for Each Address


Enter Customer Information (con’t): Enter Customer Information (con’t) C2 Ship-To C3 Ship-To Bill-To Ship-To Statements C1 AA Relationships 付款 Multi site


單一地址: 單一地址


多重地址(一): 多重地址(一)


多重地址(二): 多重地址(二)


Enter Customer Methods: Enter Customer Methods Standard Quick Interface Enter complete details Enter limited information Import from other systems


Manage Customers: Manage Customers Create customer profile classes Assign customer to Profile classes Enter customer information Create customer relationships Eliminate duplicate information Review customer information


Customer Relationships: Customer Relationships Create customer relationship to control Payment of unrelated invoices Sharing of pricing entitlements Consolidation of business addresses


Outline: Outline Order Management Concept Oracle ERP Overview Order Management Process Pricing Manage Customers Enter Import Orders Order Processing Business Flow Pick & Ship Process (four steps)


Enter Import Orders: Enter Import Orders Order Creation Methods Head & Line Information


Order Creation Methods: Order Creation Methods Enter order or return online Copy an order or return EDI Import from other systems Order or return Order Import


Enter Import Orders: Enter Import Orders Order Creation Methods Head & Line Information


**Practice(1): **Practice(1) Create a new customer：CUS######## Responsibility：Order Management Super User, Vision Operations (USA)


**Practice(2): **Practice(2) Create a sales order & Book order Prerequisite Practice(1) were finished Responsibility：Order Management Super User, Vision Operations (USA)


Outline: Outline Order Management Concept Oracle ERP Overview Order Management Process Pricing Manage Customers Enter Import Orders Pick & Ship Process (four steps)


Configuration Process(four  steps): Configuration Process(four steps) Open Ship Transaction Form Create Delivery Pick Release Ship Confirmation


Shipping Transaction Form: Shipping Transaction Form Verify arrival and departure of Deliveries and Stops Execute Pick Release and Ship Confirmation Support multileg shipments


Delivery: Delivery Consolidation of Sales Order Lines by attributes Based on user defined criteria： Mandatory grouping criteria consists of： Customer Ship From location Ultimate Ship To location


Create Delivery: Create Delivery


Pick Release: Pick Release Pick Release finds and releases eligible order lines that meet the release criteria; creates Move Orders that move the inventory to staging areas; and optionally, calls inventory Pick Release to reserve items and print the pick slips.


Pick Release (con’t): Pick Release (con’t) Four methods for Pick Release are： Online Concurrent Standard Report Submission (SRS) Select “Launch Pick Release” in the Shipping Transactions window


撿貨單處理狀態(Stage/Pick Confirm): 撿貨單處理狀態(Stage/Pick Confirm)


Ship Confirmation: Ship Confirmation The material picking process ends when the items are ship confirmed out of inventory. Ship-confirming the items removes from the stage area, and reduce existing reversion.


Ship Confirmation: Ship Confirmation


Ship Confirmation (con’t): Ship Confirmation (con’t)


出貨單: 出貨單


Practice(3): Practice(3) Prerequisite Practice(1) & Practice(2) were finished Pick & Ship -Query your sales order -Launch pick release -(Generate a Pick Slip Report) -Ship confirm -(Generate a Commercial Invoice) Responsibility：Order Management Super User, Vision Operations (USA)