Oracle Inventory MinMax Planning Guide.docx
- 文档编号:18182565
- 上传时间:2023-04-24
- 格式:DOCX
- 页数:12
- 大小:299.66KB
Oracle Inventory MinMax Planning Guide.docx
《Oracle Inventory MinMax Planning Guide.docx》由会员分享,可在线阅读,更多相关《Oracle Inventory MinMax Planning Guide.docx(12页珍藏版)》请在冰豆网上搜索。
OracleInventoryMinMaxPlanningGuide
InventoryMin-MaxPlanningGuide
TestInstance
Testby
StartTime
EndTime
CRP1
JeffWei
5/9/20121:
35PM
5/12/201211:
45:
19PM
Contents
Overview2
ItemAttributes3
RunMin-MaxPlanning(PreviewModel)5
RunMin-MaxPlanning(RestockModel)9
RequisitionImport10
Troubleshooting&FAQ14
Overview
Scope:
Thelowvalueitems(ClassC),suchasSCREW,NUTS
AS-IS
TO-BE
NowAMAstilluseMRPplanningforthelowvalueitems(ClassC),suchasSCREW,NUTS
UseMin-MaxPlanningforthelowvalueitems(ClassC),suchasSCREW,NUTS
WastetimetocreatetoomanysmallvaluePR/PO
ReducethePR/PO,don’twastetime
AutoReleasePRfromMin-MaxPlanning
Needcleanupallthepastdueunnecessaryorders
ImportantNotice:
●Min-Maxplanningwillignorethesafetystocksetup,becausesafetystockalreadybeenincludedintheMinvalue.
●SafetystockonlyuseforReorderPointplanningandMRPplanning
ItemAttributes
Re-OrderPointandMin-Maxplanisaninventoryplanningmethod,notMRPplan.
Whichuseforlowvalueitems(ClassC),suchasSCREW,NUTS…
OrganizationItems>ItemAttributes>MPS/MRPPlanningmethodshouldbe‘NotPlanned’
ShoulduseInventoryPlanningmethod=Min-Max,SourceType=Supplier
SampleData
Item
Min
Max
MOQ
Price
021-0007
9500
55000
100
0.2
021-0008
300
1600
N/A
0.28
BusinessRules:
●MinValueshouldbe5daysaverageusage(sameasvendor’spurchasingleadtime)
●MaxValueshouldbe30daysaverageusage(ThismeanswillonlyonePOpermonth)
●MOQ(MinimumOrderQty),shoulddefineifvendorhaveit
●SafetyStock:
None(becauseMinvaluealreadycoverit)
RunMin-MaxPlanning(PreviewModel)
021-0007OnhandQty=49178.22998
Item
OnHandQty
Min
Max
021-0007
49178.22998
9500
55000
021-0008
-1962
300
1600
OracleMenuInventory>Planning>Min-MaxPlanning
PlannershouldrunMin-MaxPlanning(weekly)
Selectallitems,selectdemandcutoffdays(should>vendor’spurchaseleadtime)
Firsttimerun,selectRestock=No,itmeanspreviewofthereplenishmentreportfirst
FindRequest
ViewOutput:
Thisisjustpreview,notrealreplenishment.
Forbelowscreenshot,OraclewillcreatePRwithqty=1628forthisitem
ReadtheattachedExcelfile(ExcelFormula)tobetterunderstandthelogic.
ImportantNotice:
●Oraclewillnotcomparethesystemcurrenton-handqty(-1962)withMinvalue,becausetherearesomeIntransitorders.
●Oraclewillusethecurrentdate’splanningQty(considertheIntransitorders)=-28,ifthisqty RunMin-MaxPlanning(RestockModel) Ifthepreviewdataisok,re-runMin-MaxplanningandsetRestock=Yes ViewOutput RequisitionImport SubmitNewRequest: RequisitionImport SelectImportSource=INV(HeremeansInventoryPlanning,notMRPplanning) ViewRequestoutput Output ContactITiffounderrorinterfacelinesinproduction. FindautocreatedPurchasingRequisition: ImportSource=INV CreateDatesettoday YouwillfindtheMin-MaxplanningPurchasingRequisition: ThePRStatus=Approved,becauseautocreatedbyMin-Maxplanning.Noneedadditionalapprovalprocess TheImportSource=INV,meansthisPRimportedfromtheInventoryPlanning,notMRPworkbench ThePRNeedbyDate=04-JUN-2012 PRLineNeedbydate=Today+VendorLeadTime(Pre+Process+Post) PRLineNeedbydate=12-MAY-2012+17workingdays=04-JUL-2012 Troubleshooting&FAQ Min/MaxPlanningMessage: "UnabletoGenerateRequisition" Pleasecheck: ●Doessourcingrulemaintained? Itmeanstheitemsourcefromwhichvendor. ●Doesquotationmaintainedandapproved? Itmeanstheitemprice. ●OrganizationItem>GeneralPlanning>Mustsetupasourcetype(normallyshouldbeSupplier) ITTroubleshootingreferencedocument: ●FAQ: Min-MaxPlanningReport[ID66712.1] ●GettingMessage"Unabletogeneraterequisition"intheOutputoftheMin-MaxPlanningReport(INVISMMX)[ID1265297.1] ●Min/MaxPlanningMessage: "UnabletoGenerateRequisition"[ID113224.1] ●PRinterfacetable: po_requisitions_interface_all
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oracle Inventory MinMax Planning Guide