OracleCorporationOracle電子商務解決方案藍圖買端Buyside賣端Sellside內部Inside企業資源規劃ERP商業智慧系統BI供應鏈管理APS電子統購IPOracle9i/EnterpriseManagerOracleexchange電子市集MarketplaceeCommercegateway訊息交換Messageexchange無線傳送WirelessPTG(PortalToGo)客戶入口網站CustomerPortal網際網路Internet供應商入口網站SupplierPortal策略性企業管理SEM生產控制管理OSFM(MES)電子商店iStoreOraclePortal客戶關係管理CRMORACLEERP全方位解決方案示意圖總帳系統客戶訂單主生產排程MPS要徑產能模擬RCCP物料需求計劃MRP請購作業採購作業收料作業生產指示DiscreteRepetitiveFlowProjectProcess生產發料生產控制製程移轉生產入庫出貨作業細部產能模擬CRP應付帳款立帳付款作業票據管理成本管理主需求排程MDS固定資產管理料品管理,產品結構,生產製程,客戶,供應商供應鍊管理最佳化排程APS銷售預測FCST彈性企業組織架構-彈性管理法則-管理決策支援BI-工作流程-開放界面統一發票管理收款作業應收帳款立帳彈性管理規則定義•客戶授信額度定義•業務訂單流程•線上簽核•收料流程•供應商控管•可承諾量ATP定義•ABC分析•倉庫設定•………..彈性訂單流程設計範例OrderFulfillmentOrderMaketoOrderCreateWorkOrderDropShipCreatePOYourCustomersStandardOrderApprove?CreatePickSlipCreateRMAReturnEDIWarehouseSupplierPlant依規則為基準的採購範例ApprovedSuppliersRequisitionPurchaseAgreementCreateReleaseCurrentPricingCreateApprovedPOYourEnterpriseNoPricingNoApprovedSupplierRequestPricingCreateRFQCUSTOMERSSUPPLIERSARPlanningAPGLReceivingShippingInventoryARPlanningAPGLReceivingShippingInventory製造工廠大陸,泰國,...配銷中心美國,日本,....OrderEntryPurchasingWIP/SFCOrderEntryPurchasingGL總公司BOM全球運籌管理CEODirectorManagerRequisitioner核准層級Approvalworkflow:1.ByUSER2.ByAMOUNT3.ByJob內部公司往來IntercompanyOrderFulfillment(1)InventoryChinaUSCustomerCustomerServiceTaipeiFinancialsTaipeiFinancialsChinaTaipeiSetofBook(NTD)ChinaSetofBook(RMB)FF.SellingSiteissuesI/CPayableEE.ShippingSiteissuesI/CReceivableDD.SellingSiteissuesinvoicetoCustomerCC.ProductstoCustomerBB.OrderisscheduledtoshipinChina“ShippingSite”AA.CustomerplacesordertoTaipei“SellingSite”Mfg&InventoryChinaUSCustomerFinancialsFinancialsTaiwanChinaGG.IssuesI/CPayableForInternalRequisitionD&ED&E.ProductstoHubBB.PlaceInternalRequisitionAA.CustomerplacesordertoTaipeiHubF.IssueI/CReceivableForInternalSalesOrderFCC.InternalSalesOrderBysystemII.IssueARforCustomerHCustomerServiceTaiwanH.ProductstoCustomer內部公司往來IntercompanyOrderFulfillment(2)HUB新產品開發量試-量產作業研發試作量產製造DefineItem料品定義(Engineering)DefineBOM產品結構(Engineering)DefineRouting生產製程(Engineer)ItemControl料品控制DefineItem料品管理Item料品(ManufacturingBOM產品結構(Manufacturing)DefineRouting生產製程(Manufacturing)ECN(mfg)ImplementECN(Eng)ImplementBOMITEMBOMITEMPDMTransferFlexibledefinitionofATPrules(AvailabletoPromise)PeriodsF123Openingonhandqty0100Supply505050Demand407050PeriodATP10-100CumATP1000Example:ATPcalculationATPRulesPeriodATPCumulativePeriodATPForwardConsumptionBackwardConsumptionBackward-Forward訂單答交-允交量FinalPriceAttributesQualifiersPRICINGENGINEINPUTOUTPUTSelectPriceListSelectModifiers彈性計價公式(AdvancedPricing)EnterBackOrderPickReleaseCompleteShipConfirmReceivablesInventoryEnteredBookedBackorderedConfirmedAndInvoicedPartialPartialReleasedInterfacedCreditCheckPoint:•Booking•Shipping應收帳款餘額(OpenReceivablesBalance)•未開發票訂單(UninvoicedOrder)•現行保留訂單(OrderCurrentlyOnHold)CreditCheckPointCreditCheckPoint信用額度檢查-訂單輸入信用額度包含:VendorCompanyCustomerShipto訂單出貨(MultipleFulfillment)ManufacturingPlantWorkOrderShipto彙總預測(AggregateForecasting)TrainingComputerWorkplaceComputerClassroomComputerResearchComputerWorkplaceComputerMonitorEGAMonitorVGAMonitorVGAManualVGAStandVGA-SVGA-X50%35%25%100%40%70%100%50%50%100%PlanningBillModelBill生產排程與物料需求計劃主生產排程MPS主需求計劃MDS物料需求計劃MRP請購單PR採購單PO工單Joborder半成品/成品原料瓶頸產能規劃RCPP詳細產能計劃CRP淨變式物料需求計劃NetChangeMRP需求建議與例外表Execption需求模擬Simulation銷售預測FCSTConsumedMDSRelief訂單出貨確認OrderShipConfirmedMPSRelief需求計劃比較表Comparison客戶訂單SO途程Routing資源表Billofresource核准廠商名錄採購分配規則主生產排程比較表ComparisonOracle请购至付款SelfServiceDesign&EngineeringMaintenanceRequestsPlanning&Scheduling集成商业智慧SpendAnalysisProcurementProductivitySupplierPerformance供应商协同合作PortalMessaging:XML/EDIOrdersChangesShipNoticesInvoicesEFT/CheckStatement供应商Banks核准厂商名录合约/电子目录Sourcing询价(RFQ)招标(Auction)报价(Quotes)竞标(Bids)请购单收货付款Demand请购单基本资料管理供应商管理料品管理员工主档核准厂商名录/采购分配规则签核签核签核管理-基本资料管理生產發料控管Raw&SubassemblyInventory原料倉半成品倉Jobs工單Schedules排程WorkInProcess生產線FloorStockAccount在製科目Vendor供應商MiscellaneousIssue雜項發料PushIssue工單領料FloorStockInventory生產線邊倉BackflushFinishedGoodsInventory成品倉Replenish庫存補充完工入庫(批量品)BulkVendor外包商代購料OperationPull作業回溯扣帳AssemblyPull工單回溯扣帳缺料警示-MaterialShortageMessage採購單收料缺料工單缺料警示!生產線直接收料待驗暫存區收料入待驗暫存區庫結合Workflow可提供下列通知方式:-螢幕即時顯現-查看工作通知-電子郵件傳遞-傳呼器外包管理(Outsideprocessing)作業20(外包)鑄造/壓鑄/翻砂外包加工商作業10開工及備料作業30(外包)機械加工將半成品及原料送到外包加工廠商半成品回廠檢驗或單據回廠過帳請購單收料作業採購單半成品自動移轉到作業30Queue半成品由10站移轉到作業20Queue由請購單轉採購單實物流程系統流程圖示說明作業50組合系統自動產生已核准請購單外包驗收ReceiveAssembliesShipAssembliesPurchasingReceiptsReturnsAdjustmentsWIP/InventoryMovesResourcechargesMaterialtransactionsCompletiontransactionsOrderEntryShipments(finalinspection)OrderEntryRMA'sReceivereturnsIntegratedEnterpriseWideQualityDataRepository供應商生產出貨客戶全面品管系統整合自定的各階段品質檢驗計劃即時的品質分析圖表•品質分析報表•支援批號及序號Test/Failure分析•帕列托分析圖表(80/20分析)依部門別,產品別,工程別,廠商別,...•趨勢圖•控制圖提供品質資料轉出功能PCStatisticalAnalysis即時的品質分析圖表-轉出資料即時轉出資料到外部如EXCELCostelementsMaterialMaterialoverheadResourceResourceoverheadOSPPlasticsReceiptDirectlaborBenefitsOSPMetalIssueQualityMaint.AllotherMoveEquip.deprec.Costsubelements成本結構(Subelements)彈性的畫面欄位擴充能力ReasonCodeToleranceInspectorAcct.C