My Oracle Support Banner

E1: 30: Stocking Types (UDC 41/I) for Manufacturing Applications (Doc ID 650015.1)

Last updated on APRIL 07, 2020

Applies to:

JD Edwards EnterpriseOne Shop Floor Control - Version XE and later
JD Edwards EnterpriseOne Capital Asset Management - Version XE and later
JD Edwards EnterpriseOne Requirements Planning - Version XE and later
JD Edwards EnterpriseOne Engineer to Order - Version 8.9 and later
JD Edwards EnterpriseOne Product Data Management - Version XE and later
Information in this document applies to any platform.



EnterpriseOne defines stocking types in the Item Master, and Item Branch/Plant. They indicate how items are stocked (i.e. raw material or finished goods). Stocking types are defined in the 41/I UDC table, and applied to each item entered in the Item Master (P4101), and updated in the Item Branch/Plant (P41026).

The main trigger for stocking types is the first character value in the Description 2 field. The first character of Description 2 in the UDC table indicates whether the item is purchased (P) or manufactured (M). This impacts both Product Costing and Requirements Planning (MRP).

If Description 2 contains a 'P' as the first character, costing programs will use the Cost Method in P4105 value. MRP will recognize the 'P' and only generate Purchase Order message types (OP), and will not explode down any bill of material (BOM). A BOM may exist for a 'P' item as information only. When suppliers are not able to provide a complete order, a work order may be created using the BOM; however all costs will become variances to the frozen standard cost from the Cost Components (P30026).

If an 'M' is in the second description field, costing reads and uses the BOM/Routing information to determine an item's cost. MRP (R3482) explodes the demand down, creating component messages, and 'M' will generate only work order type messages (WO).


This document provides details on the Stocking Types in Manufacturing.


 All areas of manufacturing, Capital Asset Management, or Service and Warranty, that use work orders or inventory will be provided with a better understanding of what each stocking type is designed to do. 


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Stocking Types
 Changing Stocking Types
 Changing an End Item from a Manufactured Stocking Type to a Purchased Stocking Type ('M' to 'P')
 Changing an End Item from a Purchased Stocking Type to a Manufactured Stocking Type ('P' to 'M')

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.