Oracle电子商务套件解决方案ppt课件

1、Oracle CorporationOracle 電子商務解決方案藍圖買端 Buy side賣端 Sell side內部 Inside企業資源規劃ERP商業智慧系統BI供應鏈管理APS電子統購IPOracle9i/Enterprise ManagerOracle exchange電子市集MarketplaceeCommercegateway訊息交換Message exchange無線傳送WirelessPTG(Portal To Go)客戶入口網站Customer Portal網際網路Internet供應商入口網站Supplier Portal战略性企業管理SEM生產控制管理OSFM(MES)

2、電子商店iStoreOracle Portal客戶關係管理CRMORACLE ERP 全方位解決方案表示圖總 帳 系 統客戶訂單主生產排程MPS要徑產能模擬RCCP物料需求計劃MRP請購作業採購作業收料作業生產指示DiscreteRepetitiveFlowProjectProcess生產發料生產控制製程移轉生產入庫出貨作業細部產能模擬CRP應付帳款立帳付款作業票據管理本钱管理主需求排程MDS固定資產管理料品管理, 產品結構, 生產製程 ,客戶 ,供應商供應鍊管理最正确化排程APS銷售預測FCST彈性企業組織架構 - 彈性管理法則- 管理決策援助BI- 任务流程- 開放界面統一發票管理 收款作

3、業應收帳款立帳Local, RegionalGlobalInternal FocusInternetValue ChainAdministrativeSelf-ServiceTransactionsBusinessIntelligenceThe Internet DrivesNew Ways of Doing BusinessToFrom彈性管理規則定義 客戶授信額度定義 業務訂單流程 線上簽核 收料流程 供應商控管 可承諾量ATP定義 ABC分析 倉庫設定 .彈性訂單流程設計範例OrderFulfillmentOrderMake to OrderCreate Work OrderDrop S

4、hipCreate POYourCustomersStandard OrderApprove?Create Pick Slip Create RMAReturnEDIWarehouseSupplierPlant依規則為基準的採購範例ApprovedSuppliersRequisitionPurchase AgreementCreate ReleaseCurrent Pricing CreateApproved POYourEnterpriseNo PricingNo Approved SupplierRequest Pricing Create RFQCUSTOMERSSUPPLIERSARP

5、lanningAPGLReceivingShippingInventoryARPlanningAPGLReceivingShippingInventory製造工廠大陸,泰國,.配銷中心美國,日本,OrderEntryPurchasing WIP/ SFCOrderEntryPurchasingGL總公司 BOM全球運籌管理CEODirectorManagerRequisitioner核准層級Approval workflow : 1. By USER 2. By AMOUNT 3.By Job內部公司往來Intercompany Order Fulfillment (1)InventoryCh

6、inaUSCustomerCustomer ServiceTaipeiFinancialsTaipeiFinancialsChinaTaipei Set of Book(NTD)China Set of Book(RMB)FF. Selling Site issues I/C PayableEE. Shipping Site issues I/C ReceivableDD. Selling Site issues invoice to CustomerCC. Products to CustomerBB. Order is scheduled to ship in China “Shippin

7、g SiteAA. Customer places order to Taipei “Selling SiteMfg & InventoryChinaUSCustomerFinancialsFinancialsTaiwanChinaGG. Issues I/C Payable For Internal RequisitionD & ED & E . Products to HubBB. Place Internal RequisitionAA. Customer places order to TaipeiHubF. Issue I/C Receivable For Internal Sale

8、s OrderFCC. Internal Sales Order By system II. Issue AR for CustomerHCustomer ServiceTaiwanH. Products to Customer內部公司往來Intercompany Order Fulfillment (2) HUB新產品開發量試-量產作業研發試作量產製造Define Item料品定義(Engineering)Define BOM產品結構(Engineering)Define Routing 生產製程(Engineer) Item Control料品控制Define Item料品管理 Item料

9、品(Manufacturing BOM產品結構(Manufacturing)Define Routing 生產製程(Manufacturing)ECN(mfg)ImplementECN(Eng)ImplementBOMITEMBOMITEMPDMAPITransferFlexible definition of ATP rules(Available to Promise ) Periods F 1 2 3Opening on hand qty 0 10 0Supply 50 50 50Demand 40 70 50Period ATP 10 - 10 0Cum ATP 10 0 0Examp

10、le: ATP calculationATP RulesPeriod ATPCumulative Period ATPForward ConsumptionBackward ConsumptionBackward - Forward訂單答交 - 允交量Final PriceAttributesQualifiersPRICING ENGINEINPUTOUTPUTSelectPrice ListSelectModifiers彈性計價公式 (Advanced Pricing) EnterBack OrderPick ReleaseCompleteShip ConfirmReceivablesInv

11、entoryEnteredBookedBackorderedConfirmedAndInvoicedPartialPartialReleasedInterfacedCredit Check Point :BookingShipping應收帳款餘額 (Open Receivables Balance)未開發票訂單 (Uninvoiced Order)現行保管訂單 (Order Currently On Hold)Credit Check PointCredit Check Point信誉額度檢查-訂單輸入 信誉額度包含 :VendorCompanyCustomerPurchase OrderAS

12、NInvoicePurchase OrderInvoiceShip to訂單出貨 (Multiple Fulfillment) Manufacturing PlantWork OrderShip to彙總預測(Aggregate Forecasting)TrainingComputerWorkplaceComputerClass roomComputerResearchComputerWorkplaceComputerMonitorEGAMonitorVGAMonitorVGA ManualVGA StandVGA-SVGA-X50%35%25%100%40%70%100%50%50%100%

13、Planning BillModel Bill生產排程與物料需求計劃主生產排程MPS主需求計劃MDS物料需求計劃MRP請購單PR採購單PO工單Job order半废品 / 废品原料瓶頸產能規劃RCPP詳細產能計劃CRP淨變式物料需求計劃Net Change MRP需求建議與例外表Execption需求模擬Simulation銷售預測FCSTConsumedMDS Relief訂單出貨確認Order Ship ConfirmedMPS Relief需求計劃比較表Comparison客戶訂單SO路程Routing資源表Bill of resource核准廠商名錄採購分配規則主生產排程比較表Comp

14、arisonOracle 请购至付款Self ServiceDesign & EngineeringMaintenanceRequestsPlanning & Scheduling集成商业智慧Spend AnalysisProcurement ProductivitySupplier Performance供应商协同协作PortalMessaging:XML / EDIOrdersChangesShip NoticesInvoicesEFT/CheckStatement供应商Banks核准厂商名录合约/电子目录Sourcing 询价 (RFQ)招标 (Auction) 报价(Quotes) 竞

15、标 (Bids) 请购单收货付款Demand请购单根本资料管理供应商管理料品管理员工主档核准厂商名录 /采购分配规那么签核签核签核管理- 根本资料管理生產發料控管 Raw &Subassembly Inventory原料倉半废品倉Jobs 工單Schedules 排程Work In Process 生產線Floor StockAccount在製科目Vendor供應商Miscellaneous Issue雜項發料Push Issue工單領料Floor Stock Inventory 生產線邊倉 BackflushFinished GoodsInventory废品倉Replenish庫存補充完工入

16、庫(批量品)BulkVendor外包商代購料Operation Pull作業回溯扣帳Assembly Pull工單回溯扣帳缺料警示- Material Shortage Message採購單收料缺料工單缺料警示 !生產線直接纳料待驗暫存區收料入待驗暫存區庫結合Workflow可提供以下通知方式 :- 螢幕即時顯現- 查看任务通知- 電子郵件傳遞- 傳呼器外包管理(Outside processing) 作業20 (外包)鑄造/壓鑄/翻砂外包加工商作業10開工及備料作業30 (外包)機械加工將半废品及原料送到外包加工廠商半废品回廠檢驗或單據回廠過帳請購單收料作業採購單半废品自動移轉到作業30 Q

17、ueue半废品由10站移轉到作業20 Queue由請購單轉採購單實物流程系統流程圖示說明作業50組合系統自動產生已核准請購單外包驗收ReceiveAssembliesShipAssembliesPurchasing Receipts Returns AdjustmentsWIP / Inventory Moves Resource charges Material transactions Completion transactionsOrder Entry Shipments (final inspection)Order Entry RMAs Receive returnsIntegrat

18、ed Enterprise Wide Quality Data Repository供應商生產出貨客戶全面品管系統整合自定的各階段品質檢驗計劃即時的品質分析圖表品質分析報表援助批號及序號Test/Failure分析帕列托分析圖表 (80/20分析)依部門別, 產品別, 工程別, 廠商別, . . .趨勢圖控制圖提供品質資料轉出功能PC Statistical Analysis即時的品質分析圖表-轉出資料即時轉出資料到外部如EXCELCost elementsMaterialMaterialoverheadResourceResource overheadOSPPlasticsReceiptDi

19、rectlaborBenefitsOSPMetalIssueQualityMaint.All otherMoveEquip.deprec.Cost sub elements 本钱結構 (Subelements)彈性的畫面欄位擴充才干Reason CodeToleranceInspectorAcct. CodeFailure AnalysisDispositionMaximumnumber ofsegments: 30You defineeach fieldsnameMaximum width is 25charactersAllows you to add any number of fiel

20、ds to any screenCross Validationon fields attributeand relationshipFlex fieldRequisition Approval ProcessNotify Approver Work Flow User define the process then can link to the system function可以由PC上載到系統附上任何的檔案 :文字/圖檔/影像/聲音/URL.Enabling the Paperless Office Sound O/S FilesDocumentsImagesElectronic Mai

21、lVideo 多媒體技術援助 Oracle Applications Standard (Fixed Format) Standard (Variable Format) Financial Statements (FSGs)ExcelWebpageTextDiscovererPC 應用軟體整合 RequestCenterimportexport開放的應用系統架構(API)Oracle Cooperative Applications FinancialsHumanResourcesProjectControlDistributionCooperative Development EnvironmentOracle8i DatabaseNetworkingGatewaysManufacturingAPIAPIAPIAPIAPICooperative Applications ProvidersPlantMaintenanceFieldServiceProcessManufacturingLogisticsOtherVert