SOP-42Q-MES0037 Traceability Administrator

From 42Q
Revision as of 00:55, 18 October 2022 by Helena wang (talk | contribs)
Jump to navigation Jump to search

42Q Home > Administration > Traceability Administrator

 

 

 

Administration
Traceability Administrator
Version MES 15.75
Revision I1
 

 

 

 

Administration

Administrative privileges in 42Q are located in the Administration menu heading. 

With the portal, Administrators are able to access privileges from one convenient location.

Privileges include:

  • User Maintenance
  • Plant Maintenance
  • Site Maintenance
  • Profile Maintenance
  • Generic Attribute Maintenance

Also located in the Administration menu heading are Shop Floor Control Administrator, Document Control, Traceability Administrator, Notification & Escalation, Meas Instance Admin, and Label Engine Admin.
To access any of the Administration Portlet, the user must sign to 42Q and then select the Administration expandable heading located in the menu on the left of the screen. 

Figure 1: User Sign-In

ADC User SignIn.png

 

 

 

Traceability Administration

This Work Instruction is a basic navigation-training guide and is not meant to teach the process flow for individual department functionality. Individual 42Q sites may have minor or specific process changes that will be documented at the site level. Work Instruction alteration suggestions must be reviewed and approved by the site Documentation Manager prior to sending an alteration request to 42Q Corporate.  This Work Instruction is a basic administration guide to support local Traceability WEB plant only. Please contact a  Traceability Regional Technologist for Traceability database and server administration.

1. To access the Traceability Administrator page, navigate to Administration>Traceability Administrator.


Figure 2: Traceability Administrator

03 Traceability Administrator.png

 

 

System Settings

This function is used to configure system parameters. Based on plant requirements, systems can be customized by changing system parameters. When Traceability needs to set up or upgrade, the administrator should make sure the parameters are configured correctly. Once changes are submitted, they are effective immediately, so the administrator should take caution when changing system settings.

1. To access the System Settings page, navigate to Administration>Traceability Administrator>System Settings.


Figure 3: System Settings

03 System Settings.png

 

 

Plant Information

  • Plant Code: such as E81
  • Plant Name: name of the plant
  • Admin Email: defines administrator e-mail.
  • PTS Portal URL: sets Traceability login address. This field is optional.
  • Plant Location City: The city where the plant is located.

 

 

Material and Labeling

  • Material Runout Percent: shows material in warning color according to remaining board quantity.
  • Material Label Prefix: prefix for material barcode generated by the system. (such as E81-)
  • Material Label Digit: the digit after the label prefix.
  • Material Show Recent: To show the material report that was printed inside the ‘Material Labeling’ page.

[Yes]: shows recent printing report at Traceability Web – Material Labeling page.

[No]: does not show the recent printing report at Traceability Web – Material Labeling page.

  • Show Extra MPN Info: at ‘Material Labeling’ page whether to show the information which is already defined at the ‘Manufacture Information’ module. (Such as package/orientation, etc).

[Yes]: needs to show the information on the Material Labeling page.

[No]: does not need to show the information on the Material Labeling page.

  • Next Inspection Date: Allow the user to define whether or not to display the Next Inspection Date option on the Material Labeling page.

[Yes]: displays the option on the Material Labeling page.

[No]: does not need to display at the Material Labeling page.

Note: If "Next Inspection Date =Yes", the date which the user set at the Material Labeling page must be greater than "Receiving day + Material Expire Day". Otherwise, the date in which the user set will be useless.

  • MFG Length: used to define how many letters of manufacture P/N can be displayed on the material label (e.g., for manufacturing P/N "SIM-012STT87F": if the setting is '3', it will only show 'SIM' SIMthe first three letters of manufacture P/N on the material label).
  • Material Expire Day defines when the material will expire.

Note: This parameter only works on 'Material Due Date' and must be set to Yes.

  • Material Show Inventory: select to show inventory and locator information at the 'Material Labeling' page.

[Yes]: shows inventory and locator information at the 'Material Labeling' page.

[No]: does not show inventory and locator at the 'Material Labeling' page.

  • Material Run Out: to control whether to allow loading material, preparing material, or scanning board while material quantity is zero. (It's a master switch.)

[Yes]: all workstations are not allowed to load material, prepare material, or scan board while material quantity is zero.

[No]: do not control when material quantity is zero.

  • Non-RoHS Alternative: if the part number is the same whether to use 'WL' material to replace normal material when normal material is short of.

[Yes]: allows using 'WL' to replace normal material.

[No]: does not allow using 'WL' to replace normal material.

Caution:

1) This function is only available for normal material.

2) This function is only available for those plants already implementing the RoHS prefix standard.

3) Before activating this function, a plant must make sure all material PN didn't start with WL or LF for normal material.

4) RoHS material could not be replaced with other materials.

  • MFG Date: used to control whether to show MFG date on the label.

[Yes]: shows MFG date on the label.

[No]: does not show MFG date on the label.

  • Request Material: send the request material information to IRMS.

[Yes]: shows Request Material option at Load Material page.

[No]:(default value) does not show the Request Material option.

  • The following two values are used by the plant administrator to pre-define the tolerance range for confirmation material qty in order to prevent inputting the wrong qty. They will influence on Pocket PC and Traceability Web – Confirm High-Value Qty module and Load Material module.

 » High-Value Tolerance >(%): remaining qty minus input qty < remaining qty multiplied by (%). The lower limit for the high value remaining qty.
 » High-Value Tolerance>(%): input qty minus remaining qty < remaining qty multiplied by (%). The upper limitation for the high value remaining qty.

  • Track all Components: whether to track all components.

[Yes]:(default value) tracks all components.

[No]: tracks selected components as user set in the PN Extra Info module.

[Yes]:(default value) the label is not printed over the defined quantity.

[No]: the system does not limit printed quantity.

  • Lead-Free Transfer Control: used to define whether can transfer lead-free material to leaded material at Split /Transfer Material module.

[Yes]:(default value) system does not allow transferring.

[No]: lead-free material can transfer to leaded material.

  • Show Vendor Code: used to control the display of "Vendor Code" in Traceability material label printing modules:

[Yes]: displays Vendor Code in the material label printing module. [No]:(default value) system does not display Vendor Code in the material label printing module.

  • Material Extra Option: used to set the values (drop-down list ) for the field ACCEPT PROPERTY at the page Material labeling. The default value is ""ACCEPT PROPERTY:", "ACCEPTED", "REJECTED", "UAI", "STS"".
  • Allow Material Queue: allows material queue when the material is running out or is empty. This parameter will affect SMT and AI workstations when loading material. (For additional information, please review the Load Material page.)

[Yes]:(default value) allows material queue for SMT and AI workstation. The two options Material Queue Max Reels and Material Queue Max will work only when Allow Material Queue is Yes.

[No]: does not allow to Material queue function

  • Material Queue Max Reels: Sets the max reels (material lists) that can be joined for the material queue function.
  • Material Queue Max Boards: Sets the max boards that can be scanned using the jointed material (material lists) for the material queue function.
  • Show Bin Code: Show Bin Code at the materials label or not.
  • This parameter will affect whether the material label has a Bin code or not when printing/reprint/split/sub material.
  • [Yes]: Allow material label show Bin Code.
  • [No]: it’s the default value, do not show Bin Code on the Material label.
  • Oracle Obsoleted AML Control: This parameter is the switch to control the oracle obsoleted AML or not.

Use Case:

If the AML is obsoleted, the AML status will change release to Obsoleted, and the Part Number of the AML will change, too(For Example prefix with OBS).

The Traceability system will pop up the AML alarm at the production line because the customer's AML status changed from the release to OBS state, which means it is not allowed to buy the customer’s materials anymore, but the inventory customer material in the factory is allowed to use it. In this way, we will modify the AML of the agile system to Prefix OBS, Such as LFNK4210250 original AML: PSMN015-100B.118, now modified to OBS-PSMN015-100B.118, but in fact, it has already been labeled on the material tray in the factory. The information on the label is PSMN015-100B.118, but the information on the system is OBS-PSMN015-100B.118, which causes the actual materials and that in the system not to match, thus the Traceability system will pop up the AML alarm.

[Yes]: To control the oracle obsoleted AML.The system will general/add a new AML MPN :  AML MPN Prefix + original AML MPN.  If one of the new AML MPN and the original AML MPN matched, the system would not pop up the AML alarm.

[No]: Do not control the oracle obsoleted AML. The system will only check the original AML MPN.  If the original AML MPN is not matched, the system would pop up the AML alarm.

  • Obsoleted AML MPN Prefix: This parameter to define the prefix of the original AML MPN, obsoleted AML MPN Prefix + Original AML MPN is the obsolete AML MPN.

MSD Control

  • Plant Humidity: calculates the MSD material floor life. Can define the humidity default value for the Customize Bake Time module.
  • Plant Temperature: calculates the MSD material floor life. Can define the temperature default value for the Customize Bake Time module.
  • MSD Expire Stop: select to prepare/load material or scan board for expired MSD material.

[Yes]: will not prepare/load material or scan board when MSD material has expired.

[No]: prepare/load material or scan board normally.

  • Bake Time Control selects to load material when the material is in baking.

[Yes]: loads material after baking time ends.

[No]: loads material within baking time.

  • Thaw Time: defines solder paste thaw time.
  • Max Open Times defines solder paste max open times.
  • Solder On Board Time: define solder paste onboard time. (Unit is second.)
  • Solder On Board: selects to control solder paste onboard time.

[Yes]: controls solder paste onboard time. [No]: does not control solder paste onboard time.

  • High-Value Level: used to customize whether MSD is high-value material (e.g., if inputting "4" in this field, MSD material will be regarded as high-value material when MSD material level is or greater than 4).

Note:

  • 1) High-value material can be defined on the System Setting page or manually set at ezPicklist.
  • 2) System - Defines MSD level at the system setting page, the system will automatically recognize that MSD level or higher as high-value material.
  • 3) Manual - manually defines high-value material in the Picklist whether the material is MSD or not.

 

Email information

  • Send Email From: sender's email address.
  • Email SMTP: email server, every plant has its own email server
  • Send Email To: send an e-mail to a primary recipient.
  • Send Email CC: send e-mail to a secondary recipient.

Note: These email settings only have an effect on load material error. Max 200 characters per field.

 

Orientation and Thickness Control

  • Loading not permitted when fail: select to control material loading when orientation and thickness are unmatched.

[Yes]: does not allow loading material.

[No]: allows loading material.

  • Thickness Upper Error: maximum acceptable limit if the thickness value of the target material is larger than the one in ezPicklist.
  • Thickness Lower Error: maximum acceptable limit if the thickness value of the target material is smaller than the one in ezPicklist.
  • Ori Pic & Check (Pre/Cur Comp): select to show the orientation picture for the required material when loading material.

[No]:(default value) does not show the orientation pictures.

[Yes]: shows the orientation picture if the picture is already been saved into a specified folder.

  • Orientation Check selects to check the component’s orientation with that in ezPicklist.

[Yes]: needs to verify orientation.

[No]: does not need to verify orientation.

  • Thickness Check: whether to check the component's thickness with that in ezPicklist.

[Yes]: needs to verify thickness.

[No]: does not need to verify thickness.

  • Auto Rotate Picture: allows to rotate pictures with component's Orientation in Manufacture information.

[Yes]: allows auto-rotation of the picture to the orientation defined in Manufacture information.

[No]: does not allow auto-rotation of the picture.

Note: The default orientation of the uploaded picture is 0.

 

Workstation WIP Control

  • Workstation WIP: select to calculate all loading materials' quantity by scanning board.

[True]: calculates the remaining quantity of loading material.

[False]: does not calculate the remaining quantity of loading material.

 

 

Deviation Note

  • Deviation Note Control: select to allow modifying DN in online status.

[True]: does not allow DN modification while production line has online status.

[False]: allows modifying DN while production line has online status.

 

RTV Control

  • RTV Control: select to start RTV control.

[True]: RTV.connects

[False]: no need to control.

  • RTV Connect Timeout: timeout for RTV connecting RTV service.
  • RTV Connect Port: RTV service port.

 

IC Marking

  • IC Marking Setup: select to load material when IC Marking is unmatched. This parameter will influence on Pocket PC and Traceability Web – Prepare or Load Material module

[Yes]: IC Marking must be right when loading material.

[No]: IC Marking will not be verified when loading material.

 

Machine Models

  • Machine Models: defines the machine types in SMT Machine module supported by ezPicklist.
  • Combine XML and PGO: select to get data from XML and PGO files.

[Yes]: acquires data from XML and PGO file to compose ezPicklist

[No]: does not use this function.

Note: The plant should have XML and PGO file formats.

 

 

Others

  • Workstation Setup Reset: select to reset "Check P/N in Picklist" value to Yes for all workstations when the production line turning off.

[Yes]: resets the value to yes when the production line turns off.

[No]: does not make any change.

  • Jig Control: select the Jig Barcode system verification for required workstation/product.

[No]: (default option) Jig Barcode will not be verified when the system scans the board.

[Yes]: required workstations will be verified by the Jig Barcode when the system scans the board. This parameter will affect the Scan Board Barcode module.

  • Check P/N In Picklist: used to check P/N consistency between Picklist and BOM for all workstations when system compares Picklist with BOM.

[Yes]:(default value) checks consistency between Picklist P/N and BOM P/N.

[No]: no need to check Picklist P/N and BOM P/N consistency.

  • Show Picklist Period: used to define how many picklists are displayed under Production Setup ---

Defines the Picklist page as per time duration (in days). The default value is 30 days, which means the system will only display picklists of the last 30 days. This ensures that the end-users are always presented with the latest picklists and reduces the potential of using outdated picklists.

  • Compare Shop Order with WO: Compares the SFDC Shop Order with the Traceability Work Order for the SFDC-Traceability integration scanning.

[Yes]: compares the Shop Order with the WO.

[No]: does not compare the Shop Order with the WO.

  • MES Shop Floor: sets the MES Shop Floor that will use the function location mapping for workstation setup.
  • FUJI VERIFY CONNECTION STRING: defines the connection string for FUJI Verify application.
  • FUJI TRAX CONNECTION STRING: defines the connection string for FUJI TRAX application.
  • FUJI PROFILER CONNECTION STRING: defines the connection string for FUJI Profiler application.
  • Feeder Full Maintenance Period: defines the period to rework/maintain all feeders.
  • Allow Leak Scanning Board: This option allows users whether to leak the scan board or not at the production scanning process.

[Yes]: Allows users to leak the scan board.

[No]: Do not allow users to leak the scan board.

Please see how to Leak scan board for detailed information.

  • Loading List Nozzle Template: define the EZpicklist Loading list template file with Nozzle or not.

[Yes]:  EZpicklist Loading list template file with Nozzle
[No]:  EZpicklist Loading list template file doesn’t with Nozzle

  • Lead Free PN Prefix: define the Prefix of the part number, that the EZpicklist application will auto check the materials be Lead-Free. 

For example, if users change its value to ‘LF, PF’ then those part numbers starting with 'LF' or ‘PF’ will be identified to ‘Lead-Free’ at the EZplicklist function automatically, so users don’t need to check and add manually.

 

  • WO BOM PPN: The default value will be empty, meaning  the MES-Interface will sync all the MESR WO BOM to the PTS database. If users add a specific product PN at the WO BOM PPN field, then the MES-Interface will only sync those predefined WO BOM PRODUCT PN data to the PTS. Users will be able to set more than one product PN at the WO BOM PPN field.

 

  • WO BOM PPN Prefix: Users have to configure the Product PN Prefix for the specific customer, and sync those customers WO BOM from Oracle to the PTS database.

 

Note: If the users do not enter any data in the WO BOM PPN or WO BOM PPN Prefix, the system will sync all the MESR WO BOM data to the PTS database.


Note: WO BOM PPN:Work Order Bill of Materials Product Part Number.

 

  • Max BOM Export Variant:  this option fo defines the max BOM variant for the BOM Export function. It allows numbers.

 

Regulation Control

Material Barcode Regulation: defines a regular expression for load material.
Note: regulation must be right when the user loads material if the user defines the material regulation.

Prefix Regulation: Define the prefix regulation of the material barcode.

 

Email Address about Support Team

This is to configure the email addresses of the support team so they are well informed of Traceability exceptions to perform immediate recovery.

  • Field IT Email: input the email address of the person in the field IT team who is responsible for Traceability.
  • Regional IT Email: input the email address of the person in the regional IT team who is responsible for Traceability.
  • Corporate IT Email: input the email address of the person in the corporate IT team who is responsible for Traceability.

 

 

Fujitral Control

  • MSD to Fuji Verifier: To define whether to verify the MSD material or not at the Fuji site.
  • MSD Level Update Rule: This option defines the rule on how to set the MSD level of the materials when syn Traceability material information into Fuji Database. Users can input 1,2 or 3 for this field, default by 1.

         “MSD Level Update Rule”,  with options 1,2,3

1: High overwrite Low

2: Low overwrite High

3: Only Update NA MSD Level

Option 1:

If the Traceability real MSD level is higher than the Fuji PN MSD level, then overwrite the Fuji PN MSL value.

If the Traceability real MSD level is lower than the Fuji PN MSD level, then do not overwrite the Fuji PN MSL value.

Option 2:

If the Traceability reel MSD level is higher than the Fuji PN MSD Level, then do not overwrite the Fuji PN MSL value.

If the Traceability reel MSD Level is lower than the Fuji PN MSD Level, then overwrite the Fuji PN MSL value.

Option 3:

If the Fuji PN MSL value is none, then insert the Traceability reel MSL value into the Fuji PN MSL field.

If the Fuji PN MSL value is none, then do not overwrite the Fuji PN MSL value.

Note: When the option is changed, only affect the sync data of next time. The data in processing will use the previous option. If the option is wrong, but some data has already been updated, we can't revert the database. If the plant doesn't want to use option 1 as default, need to add a record at the Traceability database first and change the option before deploying the new version.

RTENOTITLE

  • 42Q-Fuji Material Remaining QTY Sync: To define whether to sync the material remaining QTY to the PTS system for the different SMT machines, such as Siemens, Panasonic etc. The default option is set as No. The users could change the option to Yes. If it is set to YES, the system will sync the Fuji material unload remaining qty into the PTS system, if it is set to No, then it won’t need to sync the Fuji material unload remaining qty into the PTS system.

 

Add Deviation Note

This module is designed to change/update BOM material in case an alternative part is needed. To distinguish the original BOM from the updated one, thus a deviation note is added.

1. To access the Add Deviation Note page, navigate to Administration>Traceability Administrator>Add Deviation Note.


Figure 4: Add Deviation Note

04 Add Deviation Note.png

 

1. Under Add Deviation Note: Enter a reference number to identify such deviation. Example: (Modify/Temporally) Customer Change Notification (CCN) number or Engineering Change Notification (ECN). Please discuss with your Plant Quality Manager to confirm what deviation note format to be used if required.

2. Under BOM P/N: Enter the BOM Part Number, which requires updating the material part number and/or reference designator.

3. Under BOM ECN: Enter the existing BOM ECN in Traceability for this deviation change. When entering BOM P/N, the BOM ECN will show automatically. If there is no BOM ECN, an alert message will display.

4. Under Due Date: Select the expiry date of this deviation BOM ECN.

5. Select Create after finishing all the above steps.

 

Search Deviation Note

Figure 5: Search Deviation Note

04 Admin DN search.png

 

1. Select Search By: BOM P/N or Deviation Note, input the P/N, then click Search. The result is displayed.

2. At the report list, if the BOM ECN is online, only it displays. Otherwise, the font will be blue and it cannot be edited.

3. Click on the Bom Part Number (not online, in blue font) which is required to change the alternative 42Q Part Number material part number and/or associated reference designator. Open the sub-page.


Figure 6: Show BOM Item

05 Admin DN update sub-page.png

 

Add P/N

Figure 7: Add BOM Item

06 Admin DN-add bom item.png

 

1. Select Add P/N button to open the Add BOM Item page.

2. Input the Usage, Level,Sequence,Part Number, and Designator; then select Add.

Substitute P/N

1. Select the left checkbox at the show BOM item page, and then select Substitute P/N.

2. Select Substitute P/N to open the Substitute Part Number page.

3. Input the Part Number, New Usage, and select Substitute.


Figure 8: Substitute P/N

07 Admin DN-substitute pn.png

 

Delete Designator

1. Select the left checkbox at the show BOM item page, and then select Del Designator.

2. Select Del Designator to open the Delete BOM Item page.

3. Select the checkbox, then click the button Del Designator to delete a designator.


Figure 9: Delete Designator

08 Admin DN-delete bom item.png

 

Remove Deviation Note

Figure 10: Remove Deviation Note

09 Admin DN-remove DN.png

 

1. Select the desired Deviation Note (Not online, in blue font) to be deleted. Open the sub-page.

2. Confirm the deletion by selecting Delete.

 

Error message Maintenance

Error Message Maintenance is a module under the Traceability web where users can customize the error content for different platforms, display color, and define whether or not an alert email should be triggered when such an error occurs.

1. To access the Error Message Maintenance page, navigate to Administration>Traceability Administrator>Error Message Maintenance.


Figure 11: Error Message Maintenance

10 Admin error message maintenance.png

 

A list of all Traceability error messages will display. The user can scroll down to view or input keywords in the Error Content textbox to search error messages. Select one error message and click on the Error Description column.

The following screen will display:


Figure 12: Update Error Message Detail

11 Admin error message detail.png

  • Error Code: The code of the selected error. Display only.
  • Error Description: The default error Description of selected error. Display only.
  • Web Message: The error description is to be displayed on the Traceability Web when the selected error occurs as per whatever user input in this textbox.
  • PPC Message: The error description is to be displayed in PPC when the selected error occurs as per whatever user input in this textbox.
  • NetDC Message: The error description is to be displayed on NetDC when the selected error occurs as per whatever user input in this textbox.
  • Display Color: Allow the user to define the font color of the error message displayed when the error occurs. Select from the drop-down list. Default is red.
  • Send Alert Mail: Defines whether or not for the system to send alert emails when the selected error occurs. Select Yes or No.
  • Stop Machine: Defines whether or not for the machine to stop when the selected error occurs. Select Yes or No.
  • Send: Saves the configuration.
  • Cancel: Goes back to the previous window without saving the configuration.

 

Note: The error message can be customized to both English and Chinese.

 

Upload Picture

Upload Picture is a module that allows the user to upload pictures about the orientation named by the Part Number. The images must be in JPG format.

Following is the sample to show/control the Orientation picture in production:

  • User needs to configure the Orientation setting (Orientation And Thickness Control) at the Traceability System Setting.
  • Upload the component image via the Upload Picture GUI.
  • The system will display the pre-defined component picture at the load material or PPC GUI during the load material process so that the operator will refer to the pre-defined component picture to place the component at the SMT with the proper direction. 

Important Note: The picture must be named in this format: XXX.jpg (XXX=Part Number, which matched with the Part Number in the production picklist). 

1. To access the Upload Picture page, navigate to Administration>Traceability Administration>Upload Picture.

 

Figure 13: Upload Image

13 Upload Image.png

 

  • Select Upload to open the upload sub-page.
  • Click the Select button to open the resource folder to select the picture file, and then click the Upload button.
  • Select Delete to delete the picture.

Note:

  • The uploaded picture file name cannot contain Chinese.
  • The picture file size cannot be over 3M.

 

Upload BOM

This function is used to upload BOM into the system. The user can download the template file and edit the BOM file with the template fileBefore uploading the BOM, the system reads the BOM information from the BOM file(.csv) and shows the detailed BOM items on the list. After the check, the items will be uploaded along with the BOM into the system.

  1.  To access the Upload Bom, navigate to Administration > Traceability Administrator > Upload BOM.

 

Figure 14: Upload BOM Main Page

14 Upload BOM main page.png

 

  1. Click the Download button, save the BOM template file to local.

 

Figure 15: BOM Template File

Figure 16- Bom Template.png

  1.  Edit the template file with the production BOM data.

 

Figure 16: Prepared BOM File

Figure 17- Prepared bom file.png

 

  1. Click the … ICON to select and open the Bom file, the file name will show in the text field.
  2. Click the Import button to show the detailed BOM items on the list.
  3. Click the Upload button to save the BOM to the system.
  4. The BOM was uploaded successfully.
  5. Or the error message will show if the PN does not exist in the database.

 

Figure 17: BOM Upload

Figure 18- Upload bom succeed.png

 

Users can check the uploaded BOM from the Show BOM module.

 

Figure 18: Show BOM

Figure 19- Show Bom.png

 

Note: Only the .csv file format is supported. Cannot upload the BOM when it is in use.

 

Upload AML

Upload AML module allows users to upload the AML information from CSV file, also provides the template download function to let users to download the csv file template.

Navigator to Administrator > Traceability Administrator > Upload AML.

Figure 19: Upload AML main page

19 Upload AML main page.png

 Download the AML template file

  1. Select the Download at the top menu, to open the AML Template.csv file.

Figure 20: Download  AML template csv file.

Down AML Template csv.png

The detailed description of the columns for the AML template file is as following:

  • Part Number: This is the Part Number of material to identify the material. This column is mandatory.
  • Item Description: The description of the Part Number to make clear to the user. This column is mandatory.
  • Manufacture Name: This is the name of the Manufacturer. This column is mandatory.
  • Manufacturer PN: The Part Number of the manufacturer. This column is mandatory.
  • Receipt Traveler: The receipt traveler number for the received materials provided by the warehouse staff. This column is mandatory.
  • Qty: The quantity of received material.
  • Expiry Days: The days of how soon the manufacture will expire. If the user leaves this column empty, it will be treated as this manufacture will never expire.
  • Locator: The address of the material's manufacturer.
  • Status: This column is used to verify the status of the status of the manufacturer, the value is Active/Inactive. if the user leaves the status column as empty, it will be treated as the Active by default.
  1. Click Download to download the AML template CSV file to local disk, or click Share to save as google sheet.

Figure 21: Save AML template file to local

Save AML template file to local.png

 

Figure 22 : Save the AML template file into Google Drive

Save AML template file to Google Driver.png


Upload AML

  1. Select the Icon at the man page to open the prepared AML information csv file.

 

Figure 23: Select AML file

23 Select AML file.png

  1. Click the Import button, then the detailed AML information display in the list.

Figure 24: Import AML file

Import AML file.png

  1. Click the Upload button, all the AML information will upload into the Traceability portal DB successfully.

Note: If the AML already exists, the system will overwrite the old data with the new AML information in the CSV file.

 

Figure 25: Upload AML Succeed

25 Upload AML Succeed.png

  1. Users can check the upload results at the Approved Manufacturer list module(This step is optional).

Figure 26: Upload AML results

Upload AML results.png

 

 

 

Accept Prompt Settings

Users can set the Accept Prompt Settings(for example: Reject, Accepted) for the material.

This Setting is used at the Incoming > material labeling module for Accept Property drop-down list (see figure below).

Figure 27: Accept Property Drop-down list

Accept Property.png

 

  1. Navigator to Administrator > Traceability Administrator > Accept Prompt Settings.

Figure 28: Accept Prompt Setting Main page

Accept Property Setting main page.png

  1. Select Add

Figure 29: Add a new Accept Property Setting

Add new Accept Propert setting.png

  1. Enter the Accept Property Name, Allow Load Component, Status
  • Accept Property Name: The name of the accept property, this name will show at the Accept Property drop-down list for material labeling page.
  • Allow Load Component: To define the system allow to load the material or not at the load material module if the material is set this Accept property.

Yes: Allow loading this material.

No: Not allowed to load this material.

For example, some plants set the Accept property name to Rejected, set the Allow Load Component to Yes, print one label: E76-M001 selecting the Accept Property drop-down list to Rejected, material barcode: E76-M001 can be loaded at the load material module.

For some reason, One plant set the Accept property Rejected(Name), Allow Load Component to No, then print another label: E76-M002. material barcode: E76-M002 can not be loaded at the load material module.

 

  • Status: To set the status(Enabled/disabled) of the Accept property setting. If this setting is enabled, it will show at the Accept Property drop-down list, if is disabled, will not show at the Accept Property drop-down list.
  1. Select Save to create a new Accept Property for the material.
  2. Or double click on the selected Accept Property name, change the fields, select Save to edit the Accept Property setting.

 

 

BOM Export

Users can export a special  BOM to target PC and folder with this function BOM Export.

On the main page, users select the TargetBOM P/NRevision, Variant, and levels; click Sent to export the BOM to the target.

 

Figure 30: BOM Export Main Page

Bom Export main page.png
 

Target: Select the target where to export the BOM. Target is defined at the BOM Export Configuration function.

BOM P/N: Input the BOM P/N. The P/N at the BOM.

Revision: Select the revision of the BOM, when users input the BOM P/N, the revision will display automatically.

Variant: The range of the variant is defined at the system setting.

Levels: Input the levels of the BOM P/N.

 

Figure 31: Preview BOM Export

BOM export preview.png

ClickPreview/Save, users can preview the exported BOM, see Figure below.

 

Figure 32: BOM Export Preview File

RTENOTITLE

Click Send to export the BOM file to the target( IP: port/folder).

 

BOM Export Configuration

Users can set the configurations for BOM exporting at the BOM Export Configuration function.

 

Figure 33: BOM Export Configuration Main page

Bom Export config main page.png

Create Target 

      Click Create, input the data at the text fields accordingly, then click Save to create a new target list.      

       Default Filter P/N: 

       Default Level:

      Target Name: The only 

       IP:

       Port:

       Folder:

       Login Name:

       Password:

 

Copy Target 

  Users can create a new target fast with the copy target function.

Select one existing target, then click Copy, one copied target will appear on the list. Change some fields accordingly, click Save. One new target was created successfully.

 

Delete Target 

  Users can delete a target list. 

  Select one target from the list, click Delete, select Yes at the pop-up message box to delete the target. 

 

Figure 34: Delete Target List

RTENOTITLE

 

Indirect Material Control

Background

 

In certain plants, indirect material is not managed in Oracle BOM. In order to track indirect material, engineers must add those indirect materials into the BOM through Deviation Note in the Traceability. This procedure is repeated after publishing each new version of BOM ECN. The plants believe this process is not convenient and too time-consuming.

 

Design Proposal

 

Indirect material config modules allow users to add/delete the indirect material information with an effective date and expiration date. The system will check if the indirect material is active or not, then add or remove the indirect material information into/from the BOM automatically, eliminating the need to create one BOM ECN. After the indirect materials are added into Traceability BOM, they can be tracked by the Traceability system as direct materials.

 

Figure 35: Solution for Indirect material

Solution for Indirect material.png

 

 

 Indirect Material Control

 

  1. Go to: Traceability Administration > Indirect Material Configuration.

 

Figure 36: Indirect Material Config list main page

36 Indirect Material Config list main page.png

 

In Indirect Material Config portlet , users may create a new indirect material config and delete an existing indirect material config.

 

  1. Select Create to open the Create Indirect Material Config page.

 

Figure 37: Create Indirect Material Config.

Create Indirect Material Config.png

 

  • Model P/N: Production Part Number. The Model P/N cannot be blank and must be preconfigured in the Traceability System.
  • Designator: Define the Designator/station where the indirect material will be loaded.
  • Material P/N: The material Part Number for the indirect material.
  • Quantity: The quantity of the received indirect material, the default value is 1.
  • Effective Date: The effective date that to Syn this indirect material to Traceability BOM, Default is the current date.
  • Expire Date: The expiration date of the indirect material. If the expiration date is earlier than the Date that PrintQ to Syn Bom into Traceability process, the indirect material cannot be added to the BOM.
  1. Reset: To clear the fields to blank.
  2. Save: Fill in all the requested values, Click the Save button to submit the indirect material information to the Traceability system. The Create Indirect Material Config page will close.
  3. Save & More: Fill in all the requested values, Click the Save button to submit the first set of indirect material information to the Traceability system. The page remains open and all fields in the page will be cleared to blank. Users may now add another indirect material config.

Note: The related field verification when submitting is similar to the previous functional interface. The default for Quantity is 1, for Effective Date the current system date, while the Expire Date may be left empty, i.e. processing is not controlled by Expire Date.

The Indirect material config can’t be duplicated.

 

Figure 38 : Indirect Material Config can’t be duplicated

38 Indirect Material Config can’t be duplicated.png

Following is the rules to verify if indirect material is active or inactive.

  • BOM without related Indirect Material Config, it shouldn't add any Indirect Material P/N to it;
  • BOM time < Indirect Material Config Effective time, it shouldn't add the Indirect Material P/N;
  • BOM time > Indirect Material Config Expire time, it shouldn't add the Indirect Material P/N;
  • BOM time >= Indirect Material Config Effective time & Expire Date is null, it should add the Indirect Material P/N to the Traceability BOM;
  • Indirect Material Config Effective time <= BOM time < Expire Date, it should add the Indirect Material P/N to Traceability BOM;

Note: BOM time= The time that PrintQ interfaces to Syn Bom information from ERP to Traceability database.

For example, The following indirect material information is already configured and active. Once approved, the information will be automatically added into BOM by Traceability system .

Users can then track the indirect material normally at the load material process.

The Model P/N: GRACIE-TEST5

Designator: V1,V2,V3,V4

Material P/N: DL22736

Quantity :1

 

Figure 39:  Indirect Material Example

Indirect Material Example1.png

 

Figure 40: Show BOM

40 Show BOM.png

 

Delete Indirect Material Config

  1. Tick the indirect material config you wish to delete from the list, then select Delete.
  2. System displays a confirmation message to confirm the deletion. Click Yes to delete the indirect material config or No to cancel the operation.

 

Figure 41:  Delete Material Config

Delete Indirect Material Config.png

 

IC Part Number Mapping

At some plants, a certain number of ICs require programming prior to surface mounting. For the same IC, some product models require the programming to be burned before mounting, while others require programming after mounting. The ICs have different Sanmina P/Ns before and after programming (Before programming - P/N:A, with IQC PASSED label; after programming - new P/N: B, without IQC, PASSED label as plant don't print new label after programmed the IC, the operator manually writes the new part number on the existing IQC label). This means that the same IC would exhibit two different statuses during WIP, while the IQC PASSED labels would remain the same. During SMT loading, Traceability cannot recognize whether or not the material has been programmed. In the case that the incorrect material is loaded (e.g. if unprogrammed material is loaded instead of the expected programmed material), it would cause a bulk rework. Therefore, Traceability must be equipped with setup recognition and binding functions (differing P/N pre- and post-programming), enabling Traceability to automatically report an error when a loading error occurs.

IC Part Number Mapping is used to make a connection for the Part Number between the Raw IC Part number(before programming) and the Programmed IC part number.

 

  1. Navigator to Administration > T'raceability Administration > IC Part Number Mapping'.

Figure 42: IC Part Number Mapping Main Page

42 IC Part Number Mapping Main Page.png

 

  1. Select Create to add a new mapping.

Figure 43: Create a New IC P/N mapping

RTENOTITLE

  • Model P/N: The Production Part Number.
  • Raw IC P/N: The Raw Part number for the IC, it’s always printed by the warehouse which save into the Oracle ERP system.
  • Programmed IC P/N: The Part Number after the programming process for the IC.
  • Effective Date: The effective date for the PrintQ to sync this Programmed IC P/N into the Traceability Database. Set the current date by default.
  • Expire Date: The expire date for the PrintQ to sync this Programmed IC P/N into the Traceability Database.
  • Input the fields, select Save to add a new mapping.
  • Or select Save & More to save the mapping and clear all fields to add more mappings.
  • Select one existing mapping and click Delete to remove the mapping.

Figure 44: Delete IC P/N Mapping

Delete IC PN mapping.png

 

 

Printer Setup

This Module is to manage the Printer, the user can add or delete the Printer.

 

  1. Navigator to Administration > Traceability Administration > Printer Setup.

Finger 45: Printer Setup Main page

Printer Setup Main page.png

 

  1. Select Add Printer to add a new printer.

Figure 46: Add Printer

Add Printer.png

 

  1. Select Delete Printer to delete an existing printer.

Figure 47: Delete Printer

RTENOTITLE