SOP-42Q-MES0051 Reporting Part Traceability
This edition applies to MES15 Portal 1.0 Application and all subsequent releases and modifications until otherwise indicated in new revisions.'
Reporting
MES can provide various traceability reports to meet the needs and documentation requirements of its users. Traceability reports provide users with information about the status of materials, production lines, and workstations.
Part Traceability
This section introduces the reports relating to part traceability. To access the pages for the various reports discussed herein, log on to the MES15 Portal and navigate to Reporting > Part Traceability. After expanding the Part Traceability menu, users can then select the pages for the various PTS reports.
NOTE: Online Help is available on PTS web.
Material Report
The Material Report is one of the most important and frequently used reports for incoming processes. The Material Report can be used to search and display a variety of information about certain materials.
1. To use the report, navigate to the Material report page: Reporting > Part Traceability > Material Report.
2. Specify the manner in which to search material by selecting an option from the Search by drop-down box. Options include Create Time, Material Barcode, Receipting Number, Part Number, Expired Material, and LPN.
3. Enter the corresponding information in the field of fields adjacent to the Search by drop-down box.
4. Alternatively, users may perform a search by entering a Lot Code or Date Code in the respective fields.
5. The report information displays.
Figure 1: Material Report
Figure 2: Material Report-Log Report
Figure 3: Material report-usage report
Log Report:
1. To use the log report portlet, check the box of an item from the Material Report list. The Log Report is now available for selection.
2. Select Log Report. The Component Log Report displays.
Usage Report:
1. To use the Usage Report portlet, check the box of an item from the Material Report list. The Usage Report is now available for selection.
2. Select Usage Report. The Usage Report displays.
Receipt Traveler Report
The Receipt Traveler report can be used to display all the receiving records processed in Oracle.
Figure 4: Receipt Traveler Report
1. To view the report, navigate to the Receipt Traveler report page: Reporting > Part Traceability > Receipt Traveler Report.
2. Select an option for displaying the search results from the Search by drop-down box. Options include Create Time and Receipting Number.
3. Enter the appropriate information in the fields adjacent to the Search by field and select the search icon to generate results.
4. Click the receipting number of a result in the list. The Material Report window displays.
Material On Hold
The Material On-Hold report can be used to display information about materials that are presently on-hold.
Figure 5: Material On Hold
1. To view the report, navigate to the Material On Hold report page: Reporting > Part Traceability > Material On Hold.
2. Select an option for displaying search results from the drop-down box. Options include Material Barcode, Receipting Number, and Part Number.
3. Enter the corresponding search information in the fields adjacent to the drop-down box, and select the search icon to generate results.
4. The search results are then displayed.
NOTE: The status of material that is on hold and cannot load is indicated by a red X.
Figure 6: Material On Hold (update status)
Update
Use the update portlet to update the material status of an item from on hold to active.
1. Check the box of an item from the search results and select Update.
NOTE: You can check multiple boxes and update them at the same time.
NOTE: Check boxes that are grayed cannot be put on hold, as this means the materials have been used in some product.
Board In Production
The Board in Production report can be used to display information about materials from scanned boards that are in production in a select line.
Figure 7: Board In Production
1. To view the report, navigate to the Board in Production report page: Reporting > Part Traceability > Board in Production.
2. Select a production line from the Production Line drop-down box. Alternatively, users may search be entering the barcode into the Search Barcode field.
3. Enter a date range by which to filter the search results, and select the search icon.
4. The report results are displayed.
NOTE: If required, define the Start Date and the Stop Date for limited production history boards.
Boards In Model
The Board in Model report can be used to display information about serials that have been scanned with a selected BOM P/N.
Figure 8: Boards In Model
1. To view the report, navigate to the Board in Model report page in the MES Portal: Reporting > Part Traceability > Board in Model.
2. To generate search results first select a BOM P/N from the BOM P/N drop-down box. Alternatively, users may enter the barcode of an item in the Search Barcode field.
3. Define the Start Date and the Stop Date box for limited production history boards.
4. Select the search icon. The results are displayed.
Boards In Work Order
The Board in Word Order report can be used to display information about board scanning times according to work order number.
Figure 9: Boards In Work Order
1. To view the report, navigate to the Board in Work Order report page: Reporting > Part Traceability > Board in Work Order.
2. Select a work order number from the Word Order down-down box. Alternatively, users can enter the barcode of the item they are searching for in the report.
3. Enter the Start Date and the End Date in the respective fields.
4. Click the search icons.
Board History Report
The Board History report can be used to view information regarding all the workstations that are associated with a given board barcode.
Figure 10: Board History Report
1. To view the report, navigate to the Board History Report main page: Reporting > Part Traceability > Board History Report.
2. Enter a board barcode into the Input Boar d Barcode field, and select the search icon.
3. The required information is displayed.
Break Panel Query
The Break Panel Query report can be used to view when a material or a component is consumed.
Figure 11: Break Panel Query
1. To view the report, navigate to the Break Panel Query report page: Reporting > Part Traceability > Break Panel Query.
2. Enter Panel Barcode, Work Order, Break Date Start, and Break Date End into the respective fields.
3. Select search. The results are displayed.
Load Material Report
The Load Material Report can be used to show which materials are loaded at a workstation’s production line.
Figure 12: Load Material Report
1. To view the report, navigate to the Load Material report page: Reporting > Part Traceability > Load Material Report.
2. Select a production line from the Production Available field, and select a workstation from the Workstation Available field.
3. The report information is displayed.
Replace Barcode Report
The Replace Barcode report can be used to view the replacement history of barcodes, including replace time, original barcode, new barcode, workstation, production line, and the position of the person who replaced the barcode.
Figure 13: Replace Barcode Report
1. To view the report, navigate to the Replace Barcode Report in the MES Portal: Reporting > Part Traceability > Replace Barcode Report.
2. Select an option for searching results using the Search by drop-down box. Options include Original Barcode and New Barcode.
3. Enter the corresponding barcode information into the field adjacent to the Search by drop-down box. Enter the Start Date and the Stop Date to further filter the search results.
4. Select the search icon. The search results are displayed.
5. View the Barcode History report for a given result, click on the name of the new barcode (in blue) for the respective result.
Prepare Material Report
The Prepare Material report can be used to see which materials are prepared for a given production line and workstation.
Figure 14: Prepare Material Report
1. To view the report, navigate to the Prepare Material Report in the MES Portal: Reporting > Part Traceability > Prepare Material Report.
2. In the Prepare Material Report page, select a production line from the Production Available drop-down box; then select a workstation from the Workstation Available drop-down box. The report information is displayed.
Further Information
This completes SOP-5-I-PTSxxxx Reporting Part Traceability information. For further information on a specific functional area refer to PTS Web.
Document Revision History
| Date | Author | Title | Version | Change Reference |
| 14/01/06 | Helena Wang | Tech Writer | 1.0 | Initial User’s Guide |
| 03/05/14 | Dane Parker | Tech Writer | 1.0 | General review and new screen capture |
| 03/05/14 | Elaine Fonaro | Tech Writer | 1.0 | Review and format for WIKI |
