Difference between revisions of "SOP-42Q-MES0011 Part Number Maintenance"

From 42Q
Jump to navigation Jump to search
(Created page with "130px <center>'''SFDC Configuration''' </center> <center>'''Part Maintenance''' </center> <center>'''Version MDS Portal 1.0''' </center> <center>''...")
 
Line 20: Line 20:
  
 
''This edition applies to MDS Portal 1.0 Application and all subsequent releases and modifications until otherwise indicated in new revisions.''
 
''This edition applies to MDS Portal 1.0 Application and all subsequent releases and modifications until otherwise indicated in new revisions.''
 +
 +
 +
1. <font size = "4">'''SFDC Configuration Setup'''</font>
 +
 +
''This edition applies to MDS14-4 Application and all subsequent releases and modifications until otherwise indicated in new revisions.''
 +
 +
The Shop Floor Data Collection System (SFDC) communicates interactively with the Customer Order Processing System (COPS), and Statistical Process Control/Statistical Quality Control (SPC/SQC). The Manufacturing Data System (MDS) makes the communication between these systems possible.
 +
 +
SFDC provides real-time information used by SPC/SQC and MESWeb to create quality control reports. The data configuration for SFDC PC is handled within the Manufacturing Data System (MDS), which is a complete factory automation system. The SFDC System uses barcode scanning, both manual and automated, to monitor and control a single product line or an entire plant. SFDC Configuration collects data, provides analysis, maintains unit histories, and controls product movement on the manufacturing floor.
 +
 +
===Part Maintenance===
 +
The Part Maintenance module defines part numbers and descriptions for products found in the SFDC System. A part number refers to the product ID of a top assembly, a base, or any component or sub-component making up a unit.  A unit is an individual serial number assigned through SFDC. Scanning a serial number allows the system to track the unit from creation of a printed Traveler and/or serial number, through manufacturing, to shipping.
 +
 +
The Part Maintenance module provides the capability to '''Add,''' '''Delete''', '''View''' and '''Update''' Part Numbers.
 +
 +
====Part Numbers List====
 +
This functionality enables the user to list available part numbers in the database. The list results include the Part Number, Part Description, Part Type, Print Sequence and Part Family.
 +
 +
To access the part numbers list, click '''Part Maintenance''' from the SFDC Configuration Maintenance module.
 +
 +
The Part Number List window is displayed:
 +
 +
'''Figure 1: Part Number List'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_01.png|thumb|none|623px]]
 +
 +
Perform the desired filtering by populating the fields Part Number, Part Type, Part Status and/or Part Family.
 +
 +
* Click '''Filter''' to view filter results
 +
* Click '''Clear''' to clear the fields and start a new search.
 +
 +
The user is able to execute the following actions:''' Add, Edit''', '''Copy''', '''Delete, Import, Obsolete Part Numbers '''and''' Print/Export, Print/Export Filtered Part Numbers''' and '''Export Filtered Part Numbers.'''
 +
 +
====Add Part Numbers====
 +
This functionality enables the user to add part numbers to the database.
 +
 +
1. To add a Part Number, click the '''Add Part Number''' icon in the Tasks window.
 +
 +
'''Figure 2: Add part number screen'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_02.png|thumb|none|624px]]
 +
 +
The Part Number Form is displayed:
 +
 +
'''Figure 3: Part Number Form'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_03.png|thumb|none|624px]]
 +
 +
2. Populate the <font color="#0000FF">'''Part Number''' </font>field. Other mandatory fields in <font color="#FF0000">red </font>are auto-populated by default but may be modified as necessary.
 +
 +
3. Populate remaining fields as required.
 +
 +
Common Part Number field descriptions:
 +
 +
<u>'''PART'''</u>: This section defines the part number
 +
 +
'''Figure 4: Part Section'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_04.png|thumb|none|624px]]
 +
 +
* <font color="#0000FF">'''Part Number'''</font>: The unit part number. (50 Character limit)
 +
As a general rule, the part number should match the Oracle part number.
 +
 +
* '''Description''': The default description for the part number (150 Character limit).
 +
As a general rule, the part description should match the Oracle part description.
 +
 +
* '''Part Type''': Defines the part type.
 +
* Base: Base Part (top level assembly) This is the default when creating a part number.
 +
* Base/FIO: Base Part with Factory Installed Option
 +
* FIO: Factory Installed Option
 +
* FIO Kit: Factory Installed Option Kit
 +
* ICP:
 +
* Internal Make Assembly:
 +
* Kit:
 +
* Make Buy Base/FIO:
 +
* Product Family: Defines a part number for use as a "Part Family" to associate other part numbers to. The user must first create a Part Family before adding parts to it.
 +
* Spare:
 +
* Sub-Assembly: Sub-Assembly part that is merged to Base part type.
 +
* Undefined:
 +
* '''Obsolete''': Check-box to indicate obsolete part number.
 +
* '''Serial Algorithm''': this field will be able to maintenance if the chosen algorithm is "part based";
 +
* '''User Defined''': A user defined field.
 +
* '''S/N Algorithm''': Select the desired Serial Number Algorithm used during Release process. If the selected Algorithm is a Part Based Algorithm, the maintenance button is enabled for managing the appropriate fields.
 +
 +
<u>'''BOM'''</u>: This section defines Bill of Materials requirements of the part number.
 +
 +
'''Figure 5: BOM'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_05.png|thumb|none|624px]]
 +
 +
* '''Traveler Type''':
 +
* '''Unit Id''':
 +
* '''Quantity''': The quantity of units to appear on the traveler, as well as the quantity per unit serial number
 +
 +
<u>'''Label'''</u>: This section defines additional part fields used for label printing.
 +
 +
'''Figure 6: LABEL Section'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_06.png|thumb|none|624px]]
 +
 +
* All field data can be retrieved in label printing process.
 +
 +
<u>'''Manufacturing'''</u>: This section defines manufacturing requirements of part number.
 +
 +
'''Figure 7: MANUFACTURING Section'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_07.png|thumb|none|624px]]
 +
 +
* '''Part Family''': Select the desired Part Family. Only parts defined as a "Product Family" Part Type are available for selection.
 +
 +
<u>'''Shipping'''</u>: This section defines dimensions of shipment requirements used in Containerization.
 +
 +
'''Figure 8: SHIPPING Section'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_08.png|thumb|none|624px]]
 +
 +
* All field data used do define packing material dimensions, weight, skid and box quantities.
 +
 +
4. Click''' Save''' to create the Part Number, or click '''Cancel''' to cancel Part Number creation. To clear all filled fields, click on '''Reset'''.
 +
 +
5. The Part Number is created and available for tracking in the system.
 +
 +
====Edit Part Number====
 +
This functionality enables the user to edit an existing Part Number. The Part Number field itself is unavailable for editing.
 +
 +
1. Select desired Part Number and click the '''Edit''' icon.
 +
 +
2. The Part Number Form is displayed:
 +
 +
'''Figure 9: Part Number Form'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_09.png|thumb|none|624px]]
 +
 +
3. Perform desired Part Number modifications. Reference section '''''1.1.2 Add Part Number''''' for additional information on Part Number fields.
 +
 +
4. Click '''Save '''to confirm the update, or click '''Cancel''' to ignore updates.
 +
 +
5. The Part Number is updated.
 +
 +
====Revision Maint.====
 +
This functionality enables Revision Control for the selected Part Number. When releasing a Shop Order, or performing revision changes, the revision is limited to the values contained in this section. Using revision control will lessen the risk of tracking units using an improper revision.
 +
 +
1. To Add/Delete a Part Number Revision, click the '''Revision Maint.'''
 +
 +
'''Figure 10: Revision Maint'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_10.png|thumb|none|623px]]
 +
 +
The Part Revision Maintenance window is displayed:
 +
 +
'''Figure 11: Part Revision Maintenance'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_11.png|thumb|none|301px]]
 +
<br>
 +
2. Check the '''Revision Controlled Part''' to enable revision control.
 +
 +
Operators and users are only capable of releasing and/or changing unit revisions to those listed here.
 +
 +
3. Click on '''Add Revision''' to add a revision to the selected Part. Enter desired Revision (double click) and click on '''Update'''. To add another Revision, follow the same process.
 +
 +
4. Click '''Save''' to confirm, or '''Cancel''' to ignore.
 +
 +
5. To remove a revision from Part, select desired Revision and click the '''Remove Revision'''.
 +
 +
6. A confirmation is displayed. Click on '''Ok''' to remove.
 +
 +
7. Click on '''Save''' to confirm.
 +
 +
====Load BOM====
 +
This functionality is part of DPMO (Defect per Million of Opportunities). It involves three modules: Defect Code, Generic attribute and Part Number Maintenance. Generic attribute module should be configured with the following options:
 +
 +
<font color="#274E13">Generic attribute required:</font>
 +
 +
* part_opportunities_reference_designator_column
 +
* part_opportunities_process_column
 +
* part_opportunities_joint_errors_column
 +
* part_bom_revision_column
 +
* part_bom_reference_designator_column
 +
* part_bom_quantity_column
 +
* part_bom_part_number_column
 +
* part_bom_description_column
 +
 +
Sample of .csv file to be loaded:
 +
 +
'''Figure 12: Sample of BOM file'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_12.png|thumb|none|623px]]
 +
 +
To load the BOM file, select the file and click on '''OK'''.
 +
 +
'''Figure 13: Load BOM'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_13.png|thumb|none|623px]]
 +
 +
A message telling all BOM was uploaded successfully is displayed and Load Defect Opportunities button becomes available.
 +
 +
The following information is displayed:
 +
 +
<nowiki>*</nowiki>* BOM items information:
 +
 +
Part Number
 +
 +
Quantity
 +
 +
Revision
 +
 +
<nowiki>*</nowiki>** These information will be displayed for each record filled in the spreadsheet.
 +
 +
See bellow some rules to ensure that the calculations are correct:
 +
 +
To ensure that the calculations are correct, the following rules must be validated:
 +
 +
'''1º rule:'''
 +
 +
This rule checks the total of opportunities. After all the calculations this rule is displayed.
 +
 +
There will be 1 record for the Total number of opportunities for a part number, which will have "Total" as the process name.
 +
 +
The total number of component opportunities will be the count of the components (the sum of the quantity field in the BOM that was imported).
 +
 +
The total number of placement opportunities will be the count of the components (the sum of the quantity field in the BOM that was imported).
 +
 +
The total number of termination opportunities will be the sum of the termination counts (Column H, "JointErrors", in the above sample. The total number of assembly opportunities is 1.
 +
 +
'''2º rule:'''
 +
 +
This rule is executed to check if there is a mechanical process or not. Mechanical processes are considered when missing process information, process filled as Mechanical, No Ref. Designator or quantity information <nowiki>></nowiki> than Qty. Ref Designator.
 +
 +
Create a record to hold the data with the partkey and process name populated.
 +
 +
The number of component opportunities will be the count of reference designators that are added at that process.
 +
 +
The number of placement opportunities will be the count of reference designators that are added at that process.
 +
 +
The number of termination opportunities will be the sum of the termination opportunities for the reference designators at that process. The number of assembly opportunities is 0.
 +
 +
'''3º rule:'''
 +
 +
This is to check if the mechanical calculation is correct. The number of component opportunities will be the number of total component opportunities minus the sum of the component opportunities in the other process records.
 +
 +
The number of placement opportunities will be the total placement opportunities minus the sum of the placement opportunities in the other process records.
 +
 +
The number of termination opportunities will be the number of total component opportunities minus the sum of the component opportunities in the other process records. The number of assembly opportunities will be 1.
 +
 +
====Load Defect Opportunities====
 +
This functionality is part of DPMO (Defect per Million of Opportunities). The Load Defect Opportunities button will be available after import a BOM file.
 +
 +
Generic attribute should be configured to the following options:
 +
 +
* part_opportunities_reference_designator_column
 +
* part_opportunities_process_column
 +
* part_opportunities_joint_errors_column
 +
* part_bom_revision_column
 +
* part_bom_reference_designator_column
 +
* part_bom_quantity_column
 +
* part_bom_part_number_column
 +
* part_bom_description_column
 +
 +
'''Figure 14: Load Defect Opportunities'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_14.png|thumb|none|624px]]
 +
 +
Sample of .csv file to be loaded:
 +
 +
'''Figure 15: Sample of .csv file'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_15.png|thumb|none|623px]]
 +
 +
The file is loaded and a success message is displayed informing all Defect Opportunities were loaded.
 +
 +
The following information is displayed:
 +
 +
<nowiki>*</nowiki>* BOM items information:
 +
 +
Part Number
 +
 +
Quantity
 +
 +
Revision
 +
 +
<nowiki>*</nowiki>* Defect Opportunities information:
 +
 +
Process Name
 +
 +
Ref Des
 +
 +
Terminal
 +
 +
<nowiki>*</nowiki>** These information will be displayed for each record filled in the spreadsheet.
 +
 +
====Delete Part Number====
 +
This functionality enables the user to delete an existing part number.
 +
 +
Note: ''It is not possible to delete an existing Part Number if activity records have been recorded for it.''
 +
 +
1. Select the Part Number record to be deleted and click on '''Delete'''. A confirmation message is displayed.
 +
 +
'''Figure 16: Delete Part Number'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_16.png|thumb|none|623px]]
 +
 +
2. Click '''Yes''' to confirm, or '''No''' to cancel deletion operation.
 +
 +
3. The Part Number is deleted from the database, ''provided no activity records had been recorded for it''.
 +
 +
====Print/Export Part Number====
 +
This functionality enables the user to print/export an existing part number. The report results include the Part Number, Description, Part Type, Print Sequence, Part Family, Product Number, Product Internal, Model Number, Model Description, Product Option, Graphic, Length, Width, Height, Weight and the External Part Number.
 +
 +
1. Select the desired Part Number and click the '''Print/Export''' button.
 +
 +
A report is generated and the user is able to save the file or print it:
 +
 +
'''Figure 17: Part Report'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_17.png|thumb|none|623px]]
 +
 +
====Copy Part Number====
 +
This functionality enables the user to copy existing Part Number information to a new Part Number.
 +
 +
1. To copy an existing Part Number, select the desired Part Number; click the '''Copy''' button.
 +
 +
The Copy Part page is displayed:
 +
 +
'''Figure 18: Copy Part dialog'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_18.png|thumb|none|623px]]
 +
 +
2. Enter the new part number.
 +
 +
3. Select the desired check boxes to choose other assignments to copy to the new part number.
 +
 +
* Algorithm Assignment
 +
* Assembly Assignment
 +
* Route Assignment
 +
* Attribute Assignment
 +
 +
4. Click '''Ok''' to confirm, or '''Close''' to cancel copy.
 +
 +
5. The new Part Number is created and added to the part table.
 +
 +
====Obsolete Part Number====
 +
This functionality enables the user to set a Part Number as obsolete.
 +
 +
Note: There are situations that the part number can not be set to obsolete:
 +
 +
* It is not possible to set a Part Number as obsolete when assigned to a pending Shop Order (SO status different other than "R"). If an attempt is made, an error message is displayed: "The Part Number cannot be set as "Obsolete". There is at least one pending Shop Order assigned to it."
 +
* It is not possible to set a Part Number as obsolete when assigned to a test configuration. If an attempt is made, an error message is displayed: "The Part Number cannot be set as "Obsolete". There is at least one Test Configuration using it on Kit Verify."
 +
 +
1. To flag a Part Number as obsolete, select the desired part number from the '''Active''' list and click the '''Obsolete Part Numbers''' button.
 +
 +
'''Figure 19: Obsolete Part Numbers'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_19.png|thumb|none|623px]]
 +
 +
2. The Part Number is set as obsolete.
 +
 +
====Import Part Numbers====
 +
This functionality allows the user to import some parts at the same time.
 +
 +
Click on Import button to choose the file to be imported.
 +
 +
'''Figure 20: Import Part Numbers'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_20.png|thumb|none|623px]]
 +
 +
Click on '''Get Template''' button to get the .csv file. Enter the data and save it locally. Select the saved file and click on '''Ok'''.
 +
 +
A successful message is displayed.
 +
 +
====Export Filtered Part Numbers (full)====
 +
This functionality generates a .csv output file all Part Number fields. No report is generated for this option.
 +
 +
1. To print/export filtered part numbers (Full), perform the filter and on '''Print/Export Filtered Part Numbers''' icon.
 +
 +
'''Figure 21: Export Filtered Part Numbers (Full)'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_21.png|thumb|none|624px]]
 +
 +
A report is generated and the user is able to save the file or print it.
 +
 +
'''Figure 22: Export Filtered /part Numbers  (Full) result'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_22.png|thumb|none|624px]]
 +
 +
====Export Filtered Part Numbers====
 +
This functionality generates an output file with the current filtered part numbers. The report results include the Part Number, Quantity, Description, Status, Part Type and Print Sequence.
 +
 +
To export filtered part numbers, click the '''Export Filtered Part Numbers '''button.
 +
 +
'''Figure 23: Export Filtered Part Numbers'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_23.png|thumb|none|624px]]
 +
 +
'''Figure 24: Print/Expot Filtered Part Numbers'''
 +
 +
[[Image:SOP-5-I-MDS0039-C_RA1_MDS_Part_Maintenance_24.png|thumb|none|623px]]
 +
 +
----
 +
 +
 +
 +
----
 +
 +
 +
 +
----
 +
 +
 +
 +
----
 +
 +
 +
 +
----
 +
 +
 +
 +
==Appendix A==
 +
 +
'''Glossary'''
 +
 +
'''''Access Control'''''
 +
 +
it is a module that will set the permissions for users and external customers of Sanmina-SCI
 +
 +
'''''administrator'''''
 +
 +
the System Administration has full access - all plants, all reports, all users.
 +
 +
'''''component'''''
 +
 +
A component is a specific piece of data that appears on a label, for example: bar code, part numbers, graphic images, line or text.  Hence, label components are broken down into several different types: text, graphic images, MDS database values, or a combination of text and database values.
 +
 +
'''''framework'''''
 +
 +
In software development, a framework is a defined support structure in which another software project can be organized and developed. A framework may include support programs, code libraries, a scripting language, or other software to help develop and glue together the different components of a software project.
 +
 +
'''''SFDC Configuration'''''
 +
 +
The rules used to define how SFDC collects data, provides analysis, controls processing and maintains unit histories
 +
 +
'''''Site Minder'''''
 +
 +
''Universal login of Sanmina-SCI''
 +
 +
'''''username'''''
 +
 +
the username is the siteminder username (or a partial string)
 +
 +
==Document Revision History==
 +
 +
{|border="2" cellspacing="0" cellpadding="4" width="100%"
 +
|align = "center" bgcolor = "#00FFFF"|<font color="#FFFFFF">Date</font>
 +
|align = "center" bgcolor = "#00FFFF"|<font color="#FFFFFF">Author</font>
 +
|align = "center" bgcolor = "#00FFFF"|<font color="#FFFFFF">Title</font>
 +
|align = "center" bgcolor = "#00FFFF"|<font color="#FFFFFF">Version</font>
 +
|align = "center" bgcolor = "#00FFFF"|<font color="#FFFFFF">Change Reference</font>
 +
 +
|-
 +
|08/20/13
 +
|Elaine Fonaro
 +
|Technical Writer
 +
|v 1.0
 +
|This is the first revision of MDS User<nowiki>’</nowiki>s Guide
 +
 +
|}

Revision as of 20:25, 20 August 2013

Sanmina logo.png


SFDC Configuration
Part Maintenance
Version MDS Portal 1.0
Work Instruction


This Work Instruction is Sanmina's corporate standard.
This document is under revision control. The latest revision is located on SanminaNet.
Once printed it is an uncontrolled copy. All alterations to this work instruction require approval.
Contact the IT Global Education and Training Department to submit suggested alterations and or updates.

This edition applies to MDS Portal 1.0 Application and all subsequent releases and modifications until otherwise indicated in new revisions.


1. SFDC Configuration Setup

This edition applies to MDS14-4 Application and all subsequent releases and modifications until otherwise indicated in new revisions.

The Shop Floor Data Collection System (SFDC) communicates interactively with the Customer Order Processing System (COPS), and Statistical Process Control/Statistical Quality Control (SPC/SQC). The Manufacturing Data System (MDS) makes the communication between these systems possible.

SFDC provides real-time information used by SPC/SQC and MESWeb to create quality control reports. The data configuration for SFDC PC is handled within the Manufacturing Data System (MDS), which is a complete factory automation system. The SFDC System uses barcode scanning, both manual and automated, to monitor and control a single product line or an entire plant. SFDC Configuration collects data, provides analysis, maintains unit histories, and controls product movement on the manufacturing floor.

Part Maintenance

The Part Maintenance module defines part numbers and descriptions for products found in the SFDC System. A part number refers to the product ID of a top assembly, a base, or any component or sub-component making up a unit. A unit is an individual serial number assigned through SFDC. Scanning a serial number allows the system to track the unit from creation of a printed Traveler and/or serial number, through manufacturing, to shipping.

The Part Maintenance module provides the capability to Add, Delete, View and Update Part Numbers.

Part Numbers List

This functionality enables the user to list available part numbers in the database. The list results include the Part Number, Part Description, Part Type, Print Sequence and Part Family.

To access the part numbers list, click Part Maintenance from the SFDC Configuration Maintenance module.

The Part Number List window is displayed:

Figure 1: Part Number List

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 01.png

Perform the desired filtering by populating the fields Part Number, Part Type, Part Status and/or Part Family.

  • Click Filter to view filter results
  • Click Clear to clear the fields and start a new search.

The user is able to execute the following actions: Add, Edit, Copy, Delete, Import, Obsolete Part Numbers and Print/Export, Print/Export Filtered Part Numbers and Export Filtered Part Numbers.

Add Part Numbers

This functionality enables the user to add part numbers to the database.

1. To add a Part Number, click the Add Part Number icon in the Tasks window.

Figure 2: Add part number screen

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 02.png

The Part Number Form is displayed:

Figure 3: Part Number Form

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 03.png

2. Populate the Part Number field. Other mandatory fields in red are auto-populated by default but may be modified as necessary.

3. Populate remaining fields as required.

Common Part Number field descriptions:

PART: This section defines the part number

Figure 4: Part Section

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 04.png
  • Part Number: The unit part number. (50 Character limit)

As a general rule, the part number should match the Oracle part number.

  • Description: The default description for the part number (150 Character limit).

As a general rule, the part description should match the Oracle part description.

  • Part Type: Defines the part type.
  • Base: Base Part (top level assembly) This is the default when creating a part number.
  • Base/FIO: Base Part with Factory Installed Option
  • FIO: Factory Installed Option
  • FIO Kit: Factory Installed Option Kit
  • ICP:
  • Internal Make Assembly:
  • Kit:
  • Make Buy Base/FIO:
  • Product Family: Defines a part number for use as a "Part Family" to associate other part numbers to. The user must first create a Part Family before adding parts to it.
  • Spare:
  • Sub-Assembly: Sub-Assembly part that is merged to Base part type.
  • Undefined:
  • Obsolete: Check-box to indicate obsolete part number.
  • Serial Algorithm: this field will be able to maintenance if the chosen algorithm is "part based";
  • User Defined: A user defined field.
  • S/N Algorithm: Select the desired Serial Number Algorithm used during Release process. If the selected Algorithm is a Part Based Algorithm, the maintenance button is enabled for managing the appropriate fields.

BOM: This section defines Bill of Materials requirements of the part number.

Figure 5: BOM

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 05.png
  • Traveler Type:
  • Unit Id:
  • Quantity: The quantity of units to appear on the traveler, as well as the quantity per unit serial number

Label: This section defines additional part fields used for label printing.

Figure 6: LABEL Section

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 06.png
  • All field data can be retrieved in label printing process.

Manufacturing: This section defines manufacturing requirements of part number.

Figure 7: MANUFACTURING Section

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 07.png
  • Part Family: Select the desired Part Family. Only parts defined as a "Product Family" Part Type are available for selection.

Shipping: This section defines dimensions of shipment requirements used in Containerization.

Figure 8: SHIPPING Section

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 08.png
  • All field data used do define packing material dimensions, weight, skid and box quantities.

4. Click Save to create the Part Number, or click Cancel to cancel Part Number creation. To clear all filled fields, click on Reset.

5. The Part Number is created and available for tracking in the system.

Edit Part Number

This functionality enables the user to edit an existing Part Number. The Part Number field itself is unavailable for editing.

1. Select desired Part Number and click the Edit icon.

2. The Part Number Form is displayed:

Figure 9: Part Number Form

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 09.png

3. Perform desired Part Number modifications. Reference section 1.1.2 Add Part Number for additional information on Part Number fields.

4. Click Save to confirm the update, or click Cancel to ignore updates.

5. The Part Number is updated.

Revision Maint.

This functionality enables Revision Control for the selected Part Number. When releasing a Shop Order, or performing revision changes, the revision is limited to the values contained in this section. Using revision control will lessen the risk of tracking units using an improper revision.

1. To Add/Delete a Part Number Revision, click the Revision Maint.

Figure 10: Revision Maint

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 10.png

The Part Revision Maintenance window is displayed:

Figure 11: Part Revision Maintenance

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 11.png


2. Check the Revision Controlled Part to enable revision control.

Operators and users are only capable of releasing and/or changing unit revisions to those listed here.

3. Click on Add Revision to add a revision to the selected Part. Enter desired Revision (double click) and click on Update. To add another Revision, follow the same process.

4. Click Save to confirm, or Cancel to ignore.

5. To remove a revision from Part, select desired Revision and click the Remove Revision.

6. A confirmation is displayed. Click on Ok to remove.

7. Click on Save to confirm.

Load BOM

This functionality is part of DPMO (Defect per Million of Opportunities). It involves three modules: Defect Code, Generic attribute and Part Number Maintenance. Generic attribute module should be configured with the following options:

Generic attribute required:

  • part_opportunities_reference_designator_column
  • part_opportunities_process_column
  • part_opportunities_joint_errors_column
  • part_bom_revision_column
  • part_bom_reference_designator_column
  • part_bom_quantity_column
  • part_bom_part_number_column
  • part_bom_description_column

Sample of .csv file to be loaded:

Figure 12: Sample of BOM file

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 12.png

To load the BOM file, select the file and click on OK.

Figure 13: Load BOM

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 13.png

A message telling all BOM was uploaded successfully is displayed and Load Defect Opportunities button becomes available.

The following information is displayed:

** BOM items information:

Part Number

Quantity

Revision

*** These information will be displayed for each record filled in the spreadsheet.

See bellow some rules to ensure that the calculations are correct:

To ensure that the calculations are correct, the following rules must be validated:

1º rule:

This rule checks the total of opportunities. After all the calculations this rule is displayed.

There will be 1 record for the Total number of opportunities for a part number, which will have "Total" as the process name.

The total number of component opportunities will be the count of the components (the sum of the quantity field in the BOM that was imported).

The total number of placement opportunities will be the count of the components (the sum of the quantity field in the BOM that was imported).

The total number of termination opportunities will be the sum of the termination counts (Column H, "JointErrors", in the above sample. The total number of assembly opportunities is 1.

2º rule:

This rule is executed to check if there is a mechanical process or not. Mechanical processes are considered when missing process information, process filled as Mechanical, No Ref. Designator or quantity information > than Qty. Ref Designator.

Create a record to hold the data with the partkey and process name populated.

The number of component opportunities will be the count of reference designators that are added at that process.

The number of placement opportunities will be the count of reference designators that are added at that process.

The number of termination opportunities will be the sum of the termination opportunities for the reference designators at that process. The number of assembly opportunities is 0.

3º rule:

This is to check if the mechanical calculation is correct. The number of component opportunities will be the number of total component opportunities minus the sum of the component opportunities in the other process records.

The number of placement opportunities will be the total placement opportunities minus the sum of the placement opportunities in the other process records.

The number of termination opportunities will be the number of total component opportunities minus the sum of the component opportunities in the other process records. The number of assembly opportunities will be 1.

Load Defect Opportunities

This functionality is part of DPMO (Defect per Million of Opportunities). The Load Defect Opportunities button will be available after import a BOM file.

Generic attribute should be configured to the following options:

  • part_opportunities_reference_designator_column
  • part_opportunities_process_column
  • part_opportunities_joint_errors_column
  • part_bom_revision_column
  • part_bom_reference_designator_column
  • part_bom_quantity_column
  • part_bom_part_number_column
  • part_bom_description_column

Figure 14: Load Defect Opportunities

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 14.png

Sample of .csv file to be loaded:

Figure 15: Sample of .csv file

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 15.png

The file is loaded and a success message is displayed informing all Defect Opportunities were loaded.

The following information is displayed:

** BOM items information:

Part Number

Quantity

Revision

** Defect Opportunities information:

Process Name

Ref Des

Terminal

*** These information will be displayed for each record filled in the spreadsheet.

Delete Part Number

This functionality enables the user to delete an existing part number.

Note: It is not possible to delete an existing Part Number if activity records have been recorded for it.

1. Select the Part Number record to be deleted and click on Delete. A confirmation message is displayed.

Figure 16: Delete Part Number

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 16.png

2. Click Yes to confirm, or No to cancel deletion operation.

3. The Part Number is deleted from the database, provided no activity records had been recorded for it.

Print/Export Part Number

This functionality enables the user to print/export an existing part number. The report results include the Part Number, Description, Part Type, Print Sequence, Part Family, Product Number, Product Internal, Model Number, Model Description, Product Option, Graphic, Length, Width, Height, Weight and the External Part Number.

1. Select the desired Part Number and click the Print/Export button.

A report is generated and the user is able to save the file or print it:

Figure 17: Part Report

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 17.png

Copy Part Number

This functionality enables the user to copy existing Part Number information to a new Part Number.

1. To copy an existing Part Number, select the desired Part Number; click the Copy button.

The Copy Part page is displayed:

Figure 18: Copy Part dialog

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 18.png

2. Enter the new part number.

3. Select the desired check boxes to choose other assignments to copy to the new part number.

  • Algorithm Assignment
  • Assembly Assignment
  • Route Assignment
  • Attribute Assignment

4. Click Ok to confirm, or Close to cancel copy.

5. The new Part Number is created and added to the part table.

Obsolete Part Number

This functionality enables the user to set a Part Number as obsolete.

Note: There are situations that the part number can not be set to obsolete:

  • It is not possible to set a Part Number as obsolete when assigned to a pending Shop Order (SO status different other than "R"). If an attempt is made, an error message is displayed: "The Part Number cannot be set as "Obsolete". There is at least one pending Shop Order assigned to it."
  • It is not possible to set a Part Number as obsolete when assigned to a test configuration. If an attempt is made, an error message is displayed: "The Part Number cannot be set as "Obsolete". There is at least one Test Configuration using it on Kit Verify."

1. To flag a Part Number as obsolete, select the desired part number from the Active list and click the Obsolete Part Numbers button.

Figure 19: Obsolete Part Numbers

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 19.png

2. The Part Number is set as obsolete.

Import Part Numbers

This functionality allows the user to import some parts at the same time.

Click on Import button to choose the file to be imported.

Figure 20: Import Part Numbers

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 20.png

Click on Get Template button to get the .csv file. Enter the data and save it locally. Select the saved file and click on Ok.

A successful message is displayed.

Export Filtered Part Numbers (full)

This functionality generates a .csv output file all Part Number fields. No report is generated for this option.

1. To print/export filtered part numbers (Full), perform the filter and on Print/Export Filtered Part Numbers icon.

Figure 21: Export Filtered Part Numbers (Full)

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 21.png

A report is generated and the user is able to save the file or print it.

Figure 22: Export Filtered /part Numbers (Full) result

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 22.png

Export Filtered Part Numbers

This functionality generates an output file with the current filtered part numbers. The report results include the Part Number, Quantity, Description, Status, Part Type and Print Sequence.

To export filtered part numbers, click the Export Filtered Part Numbers button.

Figure 23: Export Filtered Part Numbers

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 23.png

Figure 24: Print/Expot Filtered Part Numbers

SOP-5-I-MDS0039-C RA1 MDS Part Maintenance 24.png






Appendix A

Glossary

Access Control

it is a module that will set the permissions for users and external customers of Sanmina-SCI

administrator

the System Administration has full access - all plants, all reports, all users.

component

A component is a specific piece of data that appears on a label, for example: bar code, part numbers, graphic images, line or text. Hence, label components are broken down into several different types: text, graphic images, MDS database values, or a combination of text and database values.

framework

In software development, a framework is a defined support structure in which another software project can be organized and developed. A framework may include support programs, code libraries, a scripting language, or other software to help develop and glue together the different components of a software project.

SFDC Configuration

The rules used to define how SFDC collects data, provides analysis, controls processing and maintains unit histories

Site Minder

Universal login of Sanmina-SCI

username

the username is the siteminder username (or a partial string)

Document Revision History

Date Author Title Version Change Reference
08/20/13 Elaine Fonaro Technical Writer v 1.0 This is the first revision of MDS User’s Guide
Retrieved from "https://42qrpt1.42-q.com/mes_wiki/index.php?title=SOP-42Q-MES0011_Part_Number_Maintenance&oldid=13373"