Oracle-电子商务解决方案蓝图

1、,Oracle Corporation,Oracle 電子商務解決方案藍圖,買端 Buy side,賣端 Sell side,內部 Inside,企業資源規劃 ERP,商業智慧系統BI,供應鏈管理 APS,電子統購 IP,Oracle9i/Enterprise Manager,Oracle exchange,電子市集 Marketplace,eCommerce gateway,訊息交換 Message exchange,無線傳送 Wireless PTG (Portal To Go),客戶入口網站Customer Portal,供應商入口網站Supplier Portal,策略性企業管理 SE

2、M,生產控制管理 OSFM (MES),電子商店 iStore,Oracle Portal,客戶關係管理 CRM,ORACLE ERP 全方位解決方案示意圖,總 帳 系 統,客戶訂單,主生產排程 MPS,要徑產能 模擬 RCCP,物料需求 計劃 MRP,請購作業,採購作業,收料作業,生產指示 Discrete Repetitive Flow Project Process,生產發料,生產控制 製程移轉,生產入庫,出貨作業,細部產能 模擬 CRP,應付帳款 立帳,付款作業,票據管理,成本管理,主需求排程 MDS,固定資產管理,料品管理, 產品結構, 生產製程 ,客戶 ,供應商,供應鍊管理 最佳化

3、排程 APS,銷售預測 FCST,彈性企業組織架構 - 彈性管理法則- 管理決策支援BI- 工作流程- 開放界面,統一發票管理,收款作業,應收帳款 立帳,The Internet DrivesNew Ways of Doing Business,To,From,彈性管理規則定義,客戶授信額度定義 業務訂單流程 線上簽核 收料流程 供應商控管 可承諾量ATP定義 ABC分析 倉庫設定 .,彈性訂單流程設計範例,Order,Fulfillment,Order,Create PO,Your,Customers,Approve?,EDI,Supplier,依規則為基準的採購範例,C U S T O M

4、 E R S,S U P P L I E R S,AR,Planning,AP,GL,Receiving,Shipping,Inventory,AR,Planning,AP,GL,Receiving,Shipping,Inventory,製造工廠 大陸,泰國,.,配銷中心 美國,日本,.,Order Entry,Purchasing,WIP/ SFC,Order Entry,Purchasing,GL,總公司,BOM,全球運籌管理,CEO,Director,Manager,Requisitioner,核准層級,Approval workflow : 1. By USER 2. By AMOUN

5、T 3.By Job,內部公司往來Intercompany Order Fulfillment (1),Taipei Set of Book(NTD),China Set of Book(RMB),E,E. Shipping Site issues I/C Receivable,D,D. Selling Site issues invoice to Customer,C,C. Products to Customer,A,A. Customer places order to Taipei “Selling Site”,Mfg & InventoryChina,USCustomer,Finan

6、cials,Taiwan,China,D & E,D & E . Products to Hub,A,A. Customer places order to Taipei,F. Issue I/C Receivable For Internal Sales Order,F,C,C. Internal Sales Order By system,I,I. Issue AR for Customer,H,H. Products to Customer,內部公司往來Intercompany Order Fulfillment (2) HUB,新產品開發量試-量產作業,研發試作,量產製造,Define

7、 Item 料品定義 (Engineering),Define BOM 產品結構 (Engineering),Define Routing 生產製程 (Engineer),Item Control 料品控制,Define Item 料品管理,Item 料品 (Manufacturing,BOM 產品結構 (Manufacturing),Define Routing 生產製程 (Manufacturing),ECN(mfg),Implement,ECN(Eng),Implement,BOM ITEM,BOM ITEM,PDM,API,Transfer,Flexible definition of

8、 ATP rules (Available to Promise ),Periods F 1 2 3 Opening on hand qty 0 10 0 Supply 50 50 50 Demand 40 70 50 Period ATP 10 - 10 0 Cum ATP 10 0 0,Example: ATP calculation,ATP Rules Period ATP Cumulative Period ATP Forward Consumption Backward Consumption Backward - Forward,訂單答交 - 允交量,Final Price,Att

9、ributes,Qualifiers,PRICING ENGINE,INPUT,OUTPUT,Select Price List,Select Modifiers,彈性計價公式 (Advanced Pricing),Enter,Back Order,Pick Release,Complete,Ship Confirm,Receivables,Inventory,Entered,Booked,Backordered,Confirmed,And,Invoiced,Partial,Partial,Released,Interfaced,Credit Check Point : Booking Shi

10、pping,應收帳款餘額 (Open Receivables Balance) 未開發票訂單 (Uninvoiced Order) 現行保留訂單 (Order Currently On Hold),Credit Check Point,Credit Check Point,信用額度檢查-訂單輸入,信用額度包含 :,Vendor,Company,Customer,Purchase Order,ASN,Invoice,Purchase Order,Invoice,Ship to,訂單出貨 (Multiple Fulfillment),Manufacturing Plant,Work Order,S

11、hip to,彙總預測(Aggregate Forecasting),Training Computer,Workplace Computer,Class room Computer,Research Computer,Workplace Computer,Monitor,EGA Monitor,VGA Monitor,VGA Manual,VGA Stand,VGA-S,VGA-X,50%,35%,25%,100%,40%,70%,100%,50%,50%,100%,Planning Bill,Model Bill,生產排程與物料需求計劃,半成品 / 成品,原料,Consumed,MDS R

12、elief,訂單出貨確認Order Ship Confirmed,MPS Relief,需求計劃比較表 Comparison,客戶訂單 SO,途程 Routing,資源表 Bill of resource,核准廠商名錄,採購分配規則,Oracle 请购至付款,Self Service,Design & Engineering,Maintenance Requests,Planning & Scheduling,- 基本资料管理,生產發料控管,Raw & Subassembly Inventory 原料倉 半成品倉,Jobs 工單,Schedules 排程,Work In Process 生產線

13、,Floor Stock Account 在製科目,Vendor 供應商,Miscellaneous Issue 雜項發料,Push Issue 工單領料,Floor Stock Inventory 生產線邊倉 Backflush,Finished Goods Inventory 成品倉,Replenish 庫存補充,完工入庫,(批量品),Bulk,Vendor 外包商代購料,Operation Pull 作業回溯扣帳,Assembly Pull 工單回溯扣帳,缺料警示- Material Shortage Message,缺料警示 !,結合Workflow可提供下列通知方式 : - 螢幕即時

14、顯現 - 查看工作通知 - 電子郵件傳遞 - 傳呼器,外包管理(Outside processing),作業20 (外包) 鑄造/壓鑄/翻砂,外包加工商,作業10 開工及備料,作業30 (外包) 機械加工,將半成品及原料 送到外包加工廠商,半成品回廠檢驗 或單據回廠過帳,請購單,收料作業,採購單,半成品自動移轉到 作業30 Queue,半成品由10站移轉到 作業20 Queue,作業50 組合,外包驗收,Receive Assemblies,Ship Assemblies,Purchasing Receipts Returns Adjustments,WIP / Inventory Moves

15、 Resource charges Material transactions Completion transactions,Order Entry Shipments (final inspection),Order Entry RMAs Receive returns,Integrated Enterprise Wide Quality Data Repository,供應商,生產,出貨,客戶,全面品管系統整合,自定的各階段品質檢驗計劃,即時的品質分析圖表,品質分析報表 支援批號及序號Test/Failure分析 帕列托分析圖表 (80/20分析) 依部門別, 產品別, 工程別, 廠商別

16、, . . . 趨勢圖 控制圖提供品質資料轉出功能,PC Statistical Analysis,即時的品質分析圖表-轉出資料,即時轉出資料到外部如 EXCEL,Cost elements,Metal,Issue,Quality,Maint.,All other,Move,Equip.deprec.,Cost sub elements,成本結構 (Subelements),彈性的畫面欄位擴充能力,Maximum number of segments: 30,You define each fields name,Maximum width is 25 characters,Allows yo

17、u to add any number of fields to any screen,Cross Validation on fields attribute and relationship,Flex field,Requisition Approval Process,Notify Approver,Work Flow,User define the process then can link to the system function,可以由PC上載到系統附上任何的檔案 :文字/圖檔/影像/聲音/URL.,Enabling the Paperless Office,多媒體技術支援,O

18、racle Applications Standard (Fixed Format) Standard (Variable Format) Financial Statements (FSGs),Excel,Webpage,Text,Discoverer,PC 應用軟體整合,Request Center,import,export,開放的應用系統架構(API),Oracle Cooperative Applications,Financials,HumanResources,ProjectControl,Distribution,Cooperative Development Environm

19、ent,Oracle8i DatabaseNetworkingGateways,Manufacturing,API,API,API,API,API,Cooperative Applications Providers,PlantMaintenance,FieldService,ProcessManufacturing,Logistics,OtherVerticalMarkets,Open Integration Technology,Configured Items Inventory Transactions Demand Returned Material (RMAs) On-Hand Balance