Method and system for product configuration management in a computer based manufacturing system

Description Submit all comments and votes

CROSS REFERENCE TO RELATED APPLICATION

This application is related to U.S. Pat. No. 5,307,261, filed of even date herewith, entitled Method and System for Automated Generation of Product Configurations in a Computer Based Manufacturing System, by one of the inventors hereof and assigned to the assignee herein.

BACKGROUND OF THE INVENTION

1. Technical Field

The present invention relates in general to computer based systems for product configuration management in the manufacture of complex products and in particular to methods and systems for defining a product or End Item Configuration for complex end items which involve special engineering design to modify a basic end item to meet specific customer requirements. Still more particularly, the present invention relates to a method and system for tracking multiple as designed end item configurations and their resultant effects on the basic end item.

2. Description of the Related Art

Computer based manufacturing systems are well known in the art. One function such systems typically provide is the tracking of engineering changes which may affect various end item configurations. For example, permanent changes to a basic end item which reduce cost or improve the basic end item are generally tracked in a time oriented manner. Additionally, changes to routings for basic items may occur as permanent changes which may or may not be caused by changes to the basic end item. Additionally, selected end item configurations may be especially created for specific customer contracts and may include changes which are considered as "transient" changes which are made to a basic End Item Configuration for one contract and may or may not be applicable to other contracts. Finally, routings for contracted end item configurations which are considered "transient" changes to the routings specifically for a particular configuration as modified for a customer contract.

Changes to a basic end item are generally incorporated in all Contract End Item configurations when the Contract End Item configurations are initially created. Subsequent changes to a basic end item are not automatically incorporated in the Contract End Item configurations. For example, for repeat orders, a customer may request certain changes to the previously contracted configuration. Appropriate version control techniques are needed to keep track of all changes to a contract End Item Configuration. The term "parallel version control" is generally used in the computer based manufacturing environment to describe this requirement. Parallel versions of an item are independent and concurrently active versions of different configurations of an item. These parallel versions are utilized to maintain a chronological history of all revisions made to each configuration of the same item.

In prior art systems the tracking of "as built" configurations has been accomplished and automated to some degree by a technique of "pegging" parts requirements to specific customer contracts. The recording of actual parts which were used to build a specific end item for a specific customer contract is known as "as built" configuration of the end item. Proper recording and management of "as designed" end item configurations continues to be a complex manual process.

Most existing bill of material systems require different product configurations to be redefined in separate hierarchies from the end item down through all non-standard components. More advanced bill of material systems often provide a multi-level end item effectivity which requires that non-standard items and/or components be relabeled for each new configuration.

Traditionally, most commercially available software in computer based manufacturing systems utilizes "date effectivity" for tracking engineering changes which modify product configurations over time. One such example is the COPICS (Communications Oriented Product Information and Control System) family of products and the MAPICS (Manufacturing Accounting and Production Information Control System) family of products both manufactured by International Business Corporation /f Armonk, N.Y. Version control of product configurations by "effective date" is suitable for tracking improvements or other "permanent" changes made to mass produced standard products but is generally unsuitable for tracking custom built product configurations.

More recently, some of the commercially available products utilized in computer based manufacturing systems have been modified for "serial number effectivity" in order to track "as built" product configurations, primarily to satisfy statutory accounting requirements. One example of such a product is the COPICS Defense product manufactured by International Business Machines Corporation. Such modified software products replace "from/to" dates by "from/to" serial numbers and use "pegged requirements" to connect detail component requirements to serially numbered end products. The "pegging" technique provides an upward traceability from components to assemblies, all the way up to the end product requirements stated in the master production schedule. However, none of the commercially available software products can distinguish between "permanent" changes made to a basic product and "transient" changes made to the basic product to satisfy specific customer requirements.

Thus, it should be apparent that a need exists for a method and system which permits product configuration management in a computer based manufacturing system which can maintain bills of material for item variations independently of the configurations which utilize those materials.

SUMMARY OF THE INVENTION

It is therefore one object of the present invention to provide an improved computer based system for product configuration management in the manufacture of complex products.

It is another object of the present invention to provide an improved method and system for product configuration management which permits the definition of product or end item configurations for complex end items which require special engineering design to modify a basic end item to meet specific customer requirements.

It is yet another object of the present invention to provide an improved method and system for product configuration management in a computer based manufacturing system which permits the tracking of multiple as designed end item configurations and their effects on the basic end item.

The foregoing objects are achieved as is now described. The method and system of the present invention is utilized to create a number of End Item Configuration lists, each End Item Configuration list including a listing of those custom components and variations of standard components which are utilized for a selected configuration of a complex product. A basic bill of materials is also created including a listing of those standard components utilized for all configurations of the complex product. Thereafter, a relationship is established between a particular End Item Configuration list and a customer contract for the manufacture of a selected configuration of a complex product. Based upon the established relationship, a selected one of the End Item Configuration lists is retrieved and combined with a basic bill of materials to create a complete bill of material utilizing both the End Item Configuration list and the basic bill of materials, which may then be utilized in the manufacture of a particular configuration of a complex product. A unique End Item Configuration identifier is established for each configuration of the complex product and is then utilized to maintain an engineering change history associated with each unique End Item Configuration, independent of engineering change histories associated with other configurations for the complex product. Additionally, the configuration data utilized to create a bill of material explosion may be stored in a nonredundant manner independently of the configuration which utilizes that data. In this manner, the End Item Configuration list feature may be added to existing bill of material systems without requiring a redesign of such systems.

BRIEF DESCRIPTION OF THE DRAWING

The novel features believed characteristic of the invention are set forth in the appended claims. The invention itself however, as well as a preferred mode of use, further objects and advantages thereof, will best be understood by reference to the following detailed description of an illustrative embodiment when read in conjunction with the accompanying drawings, wherein:

FIG. 1 is a block diagram depicting an example of the business processes which are related to configuration management which may utilize the method and system of the present invention;

FIG. 2 is a block diagram depicting the computer system components which may be utilized for configuration definition utilizing relational databases in accordance with the method and system of the present invention;

FIG. 3 illustrates a sample coding scheme for effectivity type codes which may be utilized with the method and system of the present invention;

FIG. 4 depicts the business process and data flow for recording a quoted End Item Configuration utilizing the method and system of the present invention;

FIG. 5 illustrates the business process and data flow utilized to convert a quotation to an order in accordance with the method and system of the present invention;

FIG. 6 depicts the relationships between different objects containing effectivity related data for configuration effectivity in accordance with the method and system of the present invention;

FIG. 7 depicts the manner of defining a specific End Item Configuration from a basic item which includes engineer-to-order components in accordance with the method and system of the present invention;

FIG. 8 depicts an Engineering Change Notice which may be utilized to define an initial bill of material for an assembly to be utilized in a basic end item in accordance with the method and system of the present invention;

FIG. 9 depicts an Engineering Change Notice which modifies the bill of material for an assembly in accordance with customer contract specifications for an End Item Configuration in accordance with the method and system of the present invention;

FIG. 10 is an illustration of the technique of pegging detail component requirements to customer contracts in accordance with the method and system of the present invention;

FIG. 11 illustrates an Engineering Change Notice which modifies the bill of material for an assembly utilized in a basic end item in accordance with the method and system of the present invention; and

FIG. 12 illustrates an Engineering Change Notice which depicts a repeated customer order for an existing End Item Configuration after the basic end item has been changed during the intervening period in accordance with the method and system of the present invention.

DETAILED DESCRIPTION OF PREFERRED EMBODIMENT

With reference now to the figures and in particular with reference to FIG. 1, there is depicted a block diagram which illustrates an example of the business processes which are related to configuration management which may utilize the method and system of the present invention. These business processes involve the integration of the engineering change release function 10 and the material requirements planning and inventory management function 12. Within engineering change release function 10, design engineering functions 14 are utilized to create engineering change notices 16 for any new and/or changed End Item Configuration.

As utilized herein an End Item Configuration shall be stored as a bill of material of a generic end item which consists of a basic end item and all engineer-to-order and make-to-order components and a specific combination of engineer-to-order and make-to-order components which are /rdered by a customer. A unique End Item Configuration identifier is utilized herein to identify each unique combination of items, at all levels of the product structure, that may be utilized in a specific configuration of an end item. This includes selected custom variations of items as described herein. Engineering changes made to a specific End Item Configuration are tracked by conventional time oriented version control methods. Each unique End Item Configuration is thus independently version controlled.

"As designed" end item configurations are then defined, within process 20 and consist of item and bills of material data 18. The engineering change release process 22 then releases the change information to the manufacturing function 26 which may now restructure the data which represents the "as planned" End Item Configuration. Based upon customer orders, as depicted at reference numeral 30 and forecast demands, as depicted at reference numeral 28, the materials requirements planning and inventory management functions 32 can then be utilized to prepare planned orders 34 which are then utilized for tracking "as built" configurations 36. Those skilled in the art will appreciate, as and when necessary, the "as built" configurations 36 may be compared with "as designed" configurations set forth at reference numeral 18 to locate any discrepancies which may exist.

Referring now to FIG. 2, there is depicted a block diagram which illustrates computer system components which may be utilized for configuration definition utilizing relational databases in accordance with the method and system of the present invention. As illustrated, a design engineer may utilize an engineer work station 50 to interact with application processor 52 which accesses relational databases to store and retrieve configuration information. Application processor 52 and work station 50 may be implemented utilizing an IBM System/370 and an IBM System/390, or any other suitable processor and work station unit. System database 54 preferably includes each relational database necessary for configuration definition. Thus, Master Item data, as depicted at reference numeral 56, defines all items including end items, assemblies, and detail parts. Each end item defined within Master Item data 56 has assemblies and components which are recorded in the Bill of Material (BOM) component data at reference numeral 58, which may be utilized to define the "basic" configuration of individual assemblies, as well as specially engineered assemblies for customers. Customer contract information is set forth within database 60 and 62 and ordered configurations are recorded in End Item Configuration header 64. An Engineering Change/Manufacturing Engineering Change headers are created when a customer contracted configuration has specially engineered assemblies and parts and this information is set forth at reference numeral 66. Engineering change affected items are listed at reference numeral 68 and location effected items are listed at reference numeral 70.

A listing of various locations is stored as depicted at reference numeral 70 and item routing and End Item Configuration custom items are set forth at reference numerals 74 and 76 respectively. Finally, customer End Item Configuration data is stored at reference numeral 78 and customer end item effectivity is stored at reference numeral 80. Customer end item effectivity is utilized to set forth noncontiguous ranges of end item serial numbers which are recorded therein. This object contains the most recent and currently active effectivity information.

With reference now to FIG. 3 there is illustrated a sample coding scheme for effectivity type codes which may be utilized with the method and system of the present invention. Sample effectivity codes are listed within a table 90 which includes a first character column 92 and a second character column 94. For convenience in remembering effectivity type codes in English, a customizable two character code is used. Alphabetic codes are assigned to each of these two characters as depicted within FIG. 3. Each character must have valid codes and a combination of two codes identifying the effectivity type for an item. All combinations of the two character code are valid codes within the presently depicted embodiment of the present invention with the exception of the DC code. This is because contract End Item Configuration effectivity may not be utilized with date effectivity.

Phase-in and phase-out effectivity codes may also be recorded in a separate data element to further qualify the effectivity type code. This data may be recorded as an attribute of the following data objects: the Engineering Change Affected Item and the Location Affected Item. Phase-In effectivity code is also preferably recorded in the bill of material component to facilitate retrieval of components which are to be phased in at the time the replace component runs out of stock.

Referring now to FIG. 4, there is depicted the business process and data flow for recording a quoted End Item Configuration utilizing the method and system of the present invention. The process steps depicted within FIG. 4 need not be executed in strict sequence. The block labeled Create Customer Contract depicts the recording of customer project and contract information for a particular quotation. A contract type indicator within this object may be utilized to indicate which attributes of the object are relevant for the contract. For example, the contract may be part of a larger project or the customer may be an external or internal user. This process takes into account company information from data stored at reference numeral 102 and creates a customer contract which may be stored as indicated at reference numeral 104.

Next, as indicated at block 106 the process creates a Contract End Item configuration. A Contract End Item configuration represents each line item in a contract, in either quotation or order status, with an End Item Configuration identification which is assigned to that line item. Each line item in the contract is preferably for a product model (end item) that is being proposed for sale. The end item identifier (product model) must exist as an item identifier in the master item object. The quantity of the end item for which the quotation is being made is also preferably recorded. A single quotation may contain more than one line item where each line item is for a certain quantity of an end item.

If the line item is for a new End Item Configuration then a new and unique End Item Configuration identifier is assigned to the line item. The End Item Configuration identifier is system generated and is not externalized. The same End Item Configuration identifier is repeated for other line items which have identical end item configurations, possibly with different delivery dates. A previously utilized End Item Configuration identifier may also be reused, for example, when a repeat order for an existing End Item Configuration is received. Thereafter, the Contract End Item configuration is stored as indicated at reference numeral 108.

Next, the process illustrates the creation of an End Item Configuration header, as depicted at block 110. An End Item Configuration header is identified by the end item identifier and the End Item Configuration identifier found within the Contract End Item configuration object. The End Item Configuration header preferably contains header type information such as information about configuration, status and effectivity type. Those skilled in the art will appreciate that various types of end item configurations may be supported, such as "make-to-order" and "engineer-to-order".

The End Item Configuration header object is under engineering change control but may contain headers for non-engineering change controlled end item configurations. For example, new End Item Configuration identifiers generated by a Contract End Item configuration which is in quotation status is not under engineering change control. An End Item Configuration which is not under engineering change control may be promoted to the engineering control status, as needed. It is also possible that at different engineering change levels for an End Item Configuration different routings for the final assembly of the end item may be required. For this purpose, the routing information may also be recorded for an End Item Configuration. The End Item Configuration header is then stored, as indicated at reference numeral 112.

Next, as indicated at reference numeral 114, the process creates new engineer-to-order components. Each End Item Configuration may need to add new components at any level in the bill of material to satisfy unique customer requirements. These components are added by the conventional procedures for adding components to an existing bill of material and when this information is stored within the master item list at reference numeral 116 the item feature code attribute of the bill of material component is set to optional for such components.

Next, the process creates a new item custom variation, as set forth at reference numeral 118. A new item custom variation may be needed to add custom variations to a basic item. These variations to items may be created by utilizing a new item identifier. Thereafter, this item will be treated as a new engineer-to-order component. Additionally, a custom variation of an existing item may be utilized to create a new item identifier. A custom variation of an item is identified by an item custom variation identifier which qualifies the item identifier. The process of creating a new custom variation of an existing item is similar to the conventional process for copying a bill of material to create another bill of material. The main difference are that the from and to item identifiers are for the same item but the item custom variation identifiers are different.

Although the same item identifier may continue to be used the custom variation of an item may or may not be "form, fit and function" compatible with the basic item. These components are added by the normal procedures for creating new items, except that the item custom variation identifier attribute is also specified while creating a variation of an existing item. Thereafter, the bill of material for the engineer-to-order and custom variation components is created and stored at reference numeral 120. Thus, the bill of material created by listing the engineer-to-order components and the custom variation of existing components which is stored as set forth at reference numeral 120 contains those specialized components which are associated with a particular configuration. This information is stored independent of the basic bill of material item and exists in a relationship with a specific configuration so that engineering changes for specific configurations may be tracked and supported independently so that construction of an identified configuration may be achieved more effectively without the requirement of tracking specific configurations by serial numbers as in previously known systems.

Next, the process creates an End Item Configuration detail object. This object contains basic End Item Configuration details which are available from the bill of material header and the bill of material component objects. Bill of material components that have optinal indication in the item feature code attribute are not considered to be part of the basic End Item Configuration. Only those variations to the basic End Item Configuration which are needed to construct a unique Contract End Item configuration are recorded in the End Item Configuration custom items object, as depicted at reference numeral 124.

With reference now to FIG. 5, there is depicted the business process and data flow utilized to convert a quotation to an order in accordance with the method and system of the present invention. Those data elements of FIG. 5 which are identical to those within FIG. 4 are referred to herein utilizing the same reference numerals for ease in explanation. As above, the process steps discussed below need not be executed strictly in the sequence described. The process begins at block 130 which illustrates the promotion of the customer contract to an order status. This process changes the contract status code in the customer contract object to indicate conversion from quotation to order status. It should be noted that the quotation and order may not be identical and the contract identifier itself may have been changed. Thus, a user of the present method and system will have the choice of either changing the status code of an existing contract or copying an existing contract in quotation status to create a new contract in /rder status. When copied, the original quotation identification is recorded in the related contract identifier attribute to provide traceability of conversion of a quotation to an order. The contract is then stored as a customer contract, as depicted at reference numeral 104. Additionally, End Item Configuration header information is stored at reference numeral 112.

Next, the process passes to block 132, which indicates the updating, if necessary, of existing End Item Configuration information. This updating may need to occur when a customer contract is converted from quotation status to order status. Updating functions may also be required at other times. End item configuration custom items object instances pertaining to a specific End Item Configuration may also be updated as required. Those skilled in the art will appreciate that during updating bill of material retrievals may be performed for viewing end item configurations.

Bill of material net difference method may be utilized to find the "delta" changes between the basic End Item Configuration and Contract End Item configurations. Bill of material retrievals will retrieve all components used in a Contract End Item configuration. This will include basic components and custom variation of components. The basic components for an item are first retrieved, unless a custom variation of the item is used in the End Item Configuration in which case the components of the custom variation of the item are retrieved. Normal retrival principles for engineering change version controlled objects are followed while retrieving End Item Configuration header and its associated detail.

Next, as illustrated in block 134 the new engineer-to-order items are promoted to engineering change controlled status. This is required due to the fact that a new engineer-to-order item to be manufactured may be either a proposed new item which will be used in a bill of material or a proposed new custom variation of an existing item. Only those new items which will be used in bills of material will require promotion from not under engineering change control status to engineering change controlled status so that engineering changes to those items may be supported and tracked. This information is then coupled to the master item database, as depicted at block 116.

Next, an engineering change is created for the End Item Configuration. An engineering change is typically needed for an End Item Configuration header of the type "engineer-to-order" or "make-to-order" when a customer contract for an End Item Configuration is converted from a quotation to an order status. The normal engineering change approval process should be followed before authorizing manufacture of such an End Item Configuration. This engineering change information is then stored within the engineering change notice data, as depicted at block 138.

Next, the process creates an engineering change affected item list for the configuration, as depicted at block 140. The engineering change affected item list is created by a process which is identical to that utilized to create any other affected item object instance in a prerelease status, except that a non-null End Item C/nfiguration identifier is entered into the engineering change affected item. The design sequence number for the affected end item is incremented normally as with any other engineering change for an end item. Thus, the design sequence numbers for all end item configurations and the basic end item are intermixed. This process improves visibility of changes made to the basic end item with respect to any End Item Configuration. It also implements parallel versions since the design sequences for each End Item Configuration will be maintained, except that these numbers are not contiguous for each configuration. This information is then stored as data within the engineering change affected item list, as depicted at block 142.

Next, the process creates an engineering change affected item list for new engineer-to-order items, as depicted in block 144. Utilizing the same engineering change which was utilized for End Item Configuration or a different engineering changes, affected item objects are created for all new engineer-to-order items. A new engineer-to-order item may be either a proposed new item which will be used in a bill of material or a proposed new custom variation of an existing item. As above, a conventional engineering change affected item is created for the engineer-to-order variation of an item, except that a non-null item custom variation identifier is entered in the engineering change affected item. The design sequence number for the affected end item is incremented normally, as with any other engineering change for an end item. Thus, as above, the design sequence numbers for all custom variations of the item and the basic item are intermixed.

Block 146 illustrates the assigning of configuration effectivity. Configuration effectivity is the point at which an engineering change becomes effective for the serial number of a marketable end item containing functional valid combinations of engineer-to-order and/or make-to-order items. A serial number is a unique identification number used by manufacturers to track items individually. Of course, those skilled in the art will appreciate that for producers of chemicals or foods, batch number and lot number are synonymous terms.

An end item that has configuration effectivity may have any number of components that have time oriented effectivity. Serial numbers assigned to end item configurations are recorded in the following objects: engineering change affected item; location affected item; and, Contract End Item configuration effectivity, as illustrated at reference numerals 142 and 148. Contract End Item Configuration is stored in a database as indicated at reference numeral 150.

Referring now to FIG. 6 there is depicted the relationship between different objects containing effectivity related data for configuration effectivity in accordance with the method and system of the present invention. This diagram indicates data relationships between various data objects and depicts objects which are generally available in existing bill of material systems which may be utilized without modification, objects which may be available within existing bill of material systems which are enhanced by the utilization of additional attributes and new objects which are defined for implementing Contract End Item configuration effectivity in accordance with the method and system of the present invention.

Blocks 182 and 184 depict identification of the manufacturing locations and customer for a particular end item and are generally available in existing bill of material systems. The remaining existing, enhanced and/or new objects depicted within FIG. 6 are set forth in detail within the tables below. Each table sets forth whether the object is an existing object, an enhanced object or a new data object and lists the various attributes associated with the particular object and the usage of that attribute for configuration effectivity in accordance with the method and system of the present invention. Each table number corresponds to the number of the object depicted within FIG. 6, for ease of explanation.

TABLE 160 ______________________________________ MASTER ITEM (Existing Object) Attribute Attribute Usage for Configuration Effectivity Notes ______________________________________ Item Iden- It uniquely identifies an item or an end item. tifier Item It indicates whether a new engineer-to-order Change item is EC controlled. Type Other Other existing attributes of this object are existing not used for configuration effectivity attributes implementation. ______________________________________

TABLE 162 ______________________________________ AFFECTED ITEM (Enhanced Existing Object) Attribute Attribute Usage for Configuration Effectivity Notes ______________________________________ EC Identi- It identifies the EC for end item config- fier urations and custom (engineer-to- order) variations of items. This is a part of the unique logical key. Item Iden- It identifies end items that have CEI tifier configurations effectivity. It also identifies custom (engineer-to-order) variations of items. This is a part of the unique logical key. End Item It identifies an end item configuration. A new data Configura- For CEI configurations, the end item element is tion Identi- configuration identifier must exist in used. fier the CEI configuration object. For the "basic" end item configuration, a null (blanks) configuration identifier is used. (Note that for engineer-to-order items other than end items, the item custom variation identifier is used instead of the end item configuration identifier.) Item Custom variations of an item are inde- A new data Custom pendent and concurrently active element is Variation versions of different custom built used. Identifier (engineer-to-order) variations of an item. The EC version control tech- niques maintain chronological history of all revisions made to each such custom variation of the same item. Custom variations of an item may or may not have the same form, fit and function. All components used in one such custom variation of an item has the same item custom variation identifier. Item Status Prerelease Status Code The affected CEI configuration is in prerelease status before it is released to different manufacturing locations. Effectivity data is not required to be entered in the CEI configuration effectivity object at this time. Released Status The affected CEI configuration is in released status after it is released to different manufacturing locations. Effectivity data must be entered in the CEI configuration effectivity object prior to release. Subsequent promotion of affected CEI configurations to accept and effective status are recorded in the Location Affected Item. Planned It indicates the type of effectivity for New Effectivity an affected CEI configuration or a effectivity Type Code custom (engineer-to-order) variation type codes of an item. For CEI configurations, are used. this code must match with the planned effectivity type code in the end item configuration header object. Suggested values: SC - CEI serial number BC - CEI batch number LC - CEI lot number Planned This represents the date when an Effectivity affected item is planned to be made Start Date effective at all manufacturing views (locations) supported by a computing system location. For CEI config- uration effectivity type codes SC, BC and LC, and for custom variations of items with end item serial number effectivity type codes ST, BT and LT, the planned start dates must be in ascending sequence matching with sequence of planned effectivity start numbers in this object. Planned This represents the end item serial or Effectivity batch or lot number at which an Start affected item is planned to be made Number effective in all manufacturing views (locations) supported by a single com- puting system location. It is required for affected items in accept status with effectivity type code other than DT. It represents serial or batch or lot number as indicated by the planned effectivity type code. The effectivity start number for a later EC/MEC level im