Planning Example (Oracle Inventory Help)


	Previous	Next		Contents	Index	Glossary	Library

Planning Example

The planning department might want to group items according to product and product line. You can define a two segment structure for the item categories flexfield with the first segment representing the product and the second segment representing product line. You can use the two segment flexfield structure to define a category set called Planner's Set with categories like assembly-prod1, subassembly-prod2 and raw material-prod3. You can designate Planner's Set to be the default (mandatory) category set of the planning functional area.

In the bills of material shown in the Examples Overview, the top level items might be MPS planned items and the rest MRP planned items since this is a manufacturing company. When you define each item you can set the item defining attribute MRP Planning Method to be either MRP Planning or MPS Planning. Oracle Inventory automatically assigns the Planner's Set category set and the associated default category assembly-prod1 to each of these items. The following table shows category assignments within the Planning default category set.

Item Item Description Planning Default (Mandatory) Category Set Category

CM2345 Laptop Computer Planner's Set assembly-prod1

CM2346 Keyboard Planner's Set subassembly-prod2

CM2347 486 Processor Planner's Set subassembly-prod2

CM2348 Active Matrix Screen Planner's Set subassembly-prod2

CM2349 Monitor Manual Planner's Set subassembly-prod2

CM2350 DOS Operating System Planner's Set subassembly-prod2

CM2351 Desktop Computer Planner's Set assembly-prod1

CM2352 Desktop Keyboard Planner's Set subassembly-prod2

CM2353 Pentium Processor Planner's Set subassembly-prod2

CM2354 VGA Monitor Planner's Set subassembly-prod2

CM2355 Monitor Manual Planner's Set subassembly-prod2

CM2356 UNIX Operating System Planner's Set subassembly-prod2

In Oracle Master Scheduling/MRP and Oracle Supply Chain Planning you can compile a forecast for a range of categories within a category set. In addition you can use categories in the following reports:

Item	Item Description	Planning Default (Mandatory) Category Set	Category
CM2345	Laptop Computer	Planner's Set	assembly-prod1
CM2346	Keyboard	Planner's Set	subassembly-prod2
CM2347	486 Processor	Planner's Set	subassembly-prod2
CM2348	Active Matrix Screen	Planner's Set	subassembly-prod2
CM2349	Monitor Manual	Planner's Set	subassembly-prod2
CM2350	DOS Operating System	Planner's Set	subassembly-prod2
CM2351	Desktop Computer	Planner's Set	assembly-prod1
CM2352	Desktop Keyboard	Planner's Set	subassembly-prod2
CM2353	Pentium Processor	Planner's Set	subassembly-prod2
CM2354	VGA Monitor	Planner's Set	subassembly-prod2
CM2355	Monitor Manual	Planner's Set	subassembly-prod2
CM2356	UNIX Operating System	Planner's Set	subassembly-prod2

Planning Example

See Also