in the File Location field to select an alternate file location. If you choose the second option, leave the File Location field blank and use the File Upload Manager to upload the input file to the Costpoint database.Use this screen to add, modify, or delete Manufacturing Bills of Material (MBOM), Engineering Bills of Material (EBOM), and/or Proposal Bills of Material (PBOM) rows from a BOM record using a user-created input file, formatted as a delimited or fixed-length ASCII text file. You can specify the network location and name of the input file, and the application performs all necessary database and business rule validation. If the input file record is valid, the preprocessor modifies the proper database tables. If the input file record is invalid, the preprocessor creates an error record and saves it to an error file with the extension .ERR, which you can modify and resubmit.
After uploading the transactions, you can review and edit Manufacturing Bills of Material on the Manage Manufacturing Bills of Material screen, review and edit Engineering Bills on the Manage Engineering Bills of Material screen, and review and edit Proposal Bills on the Manage Proposal Bills of Material screen.
This preprocessor has Add functionality for EBOM and PBOM uploads. It can process Manufacturing, Engineering, and Proposal BOMs.
The user interface also includes a Provisional Parts group box.
The preprocessor checks the following settings on the BOM Corporate Settings block of the Configure Bills of Material Settings screen: Use Extended Length Reference Designators (USE_LVC_REFDES_FL), Use Configuration IDs (USE_CID_FL), and Use Engineering Bills of Material (USE_EBOM_FL). It also checks control flags on the Corporate Settings block of the Configure Materials Requirements Planning Settings screen and the ECN Corporate Settings block of the Configure Engineering Change Notice Settings screen.
in the File Location field to select an alternate file location. If you choose the second option, leave the File Location field blank and use the File Upload Manager to upload the input file to the Costpoint database.Validation of company tables is triggered by the company ID of the user executing the process. When looking up valid values, the preprocessor validates all company-related tables using the user's company ID. When a new BOM is saved, the preprocessor assigns it the user's company ID. filters on parameters by company. All new parameter rows are saved with the user's company ID. To separate items by company in Costpoint, select the Separate Items By Company check box on the Corporate Settings block of the Configure Product Definition Settings screen.
The following custom files and stored procedures files must be accessible to run the Bills of Material Preprocessor:
Click this link to open the Configuration subtask and view and/or edit the configuration identifiers the selected assembly part. Assembly Serial Numbers Click this link to open the Assembly Serial Numbers subtask and view the configuration serial numbers for the selected assembly part.
|
Filename |
Description |
|
AOPBOM.exe |
Import Bills of Material preprocessor application executable. |
|
AOPBOM.QRP |
Import Bills of Material preprocessor report file. |
Before running the preprocessor application, complete the following steps: On the Configure Bills of Material Settings screen, establish default values. In Product Definition, establish component and assembly parts. Make sure the Import Bills of Material preprocessor application executable (AOPBOM.EXE) and the report file (AOPBOM.QRP) are applied to the database. Make sure that all patches and service packs (if applicable) have been applied to the database.
Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.
Enter, or click 
to select, a parameter
ID of up to 15 alphanumeric characters. Choose characters for your parameter
ID that help identify the type of selections you made in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.
You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display in the screen, you can override the defaults.
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Enter, or click to select, the alternate file location where the input file is located. Alternate file locations are set up in the Manage Alternate File Locations screen.
Enter, or click to select, the name of the input file.
Use the drop-down list to select the format in which the file will be saved. Options are:
Delimited — Select this option to process files with fields separated by a pre-defined delimiter (either by commas or another specified character). Make your delimiter selection in the File Delimiter field.
Fixed Length — Select this option to process the file with no field delimiters. If you select this option, the values in the file are determined by their location. You must fill in every position in a fixed-length input file format with either an appropriate character or a space. It is not necessary to zero fill numbers; you can use spaces to maintain the proper format. Right-justify numeric fields; left-justify character fields. You do not need to fill the entire line with spaces. End every row with a carriage return and a line feed.
If you selected Delimited in the File Format field, use this drop-down list to select a file delimiter. Options are Comma and Other. If you select Other, you must enter a delimiter in the field to the right.
Please refer to the MBOM and EBOM Processing section for additional details regarding the processing of input files.
If you select this check box, the program does not update the input file record if warning messages are generated.
Select this check box to allow MBOMs to be set to a Released status. If you select this check box, the application uses the Component Release Flag (entered in Component Released column of the Manage Manufacturing Bills of Material/Manage Engineering Bills of Material or Release Manufacturing Bills of Material/Release Engineering Bills of Material screens) in the input file to determine the status of the BOM line. Proposal BOMs (PBOMs) have separate validation criteria, as outlined in the Detailed Table Specifications section.
If you select this check box and do not enter a Component Release Flag, the Component Release Flag (the Component Released column of the Manage Manufacturing Bills of Material/Manage Engineering Bills of Material screen) will be set to Y (Released) in the MBOM/EBOM table. However, if you do not select this check box, the Component Release Flag will be set to N (Unreleased) for all new lines. The application displays a warning message if you try to change the status to Y (Released) with this checkbox cleared. Similarly, the application displays a warning message if you try to change the status of an existing, unreleased MBOM/EBOM line to Y (Released).
Select this check box to allow updates to BOM lines that have been released. You can modify or delete an existing, released MBOM/EBOM line (the Component Released check box is selected in the Manage Manufacturing Bills of Material/Manage Engineering Bills of Material or Release Manufacturing Bills of Material/Release Engineering Bills of Material screens) only if you select this check box. If you do not select this check box, any input record that modifies or deletes a released MBOM/EBOM line will be in error and will not be processed.
Select this check box to load any of the component part's BOM text to the BOM line.
If you select this check box, the application checks each new MBOM/EBOM line that is added (not changed or deleted) for item text. Any BOM standard text that is linked to a component part is assigned to that component’s BOM line. Standard text codes are established on the Manage Standard Text screen in Costpoint Product Definition, and can be assigned to parts on the Assigned Standard Text subtask of the Manage Parts screen.
Use this drop-down list to select either of the options to delete active or inactive BOM lines. The deletion process is discussed in detail in the Changing and Deleting BOM Rows section of the MBOM and EBOM Processing topic.
Physically Delete MBOM/EBOM Lines — Select this option to physically delete any MBOM/EBOM lines flagged for deletion.
Make MBOM/EBOM Lines Out of Effectivity — Select this option to mark any MBOM/EBOM lines for deletion out of effectivity. The line is not physically deleted from the table, but the component effectivity end date is set to the current date (unless the end date is already earlier than the current date).
Select this check box to create new provisional parts during processing. The application displays a warning message if a component or assembly part/revision in the input file does not exist in the PART or PROV_PART tables. If you choose to process records that have warnings, the application creates a new provisional part.
Enter, or click to select, an existing provisional part type to be used as a default when creating new provisional parts. This field is enabled only if you select the Create New Provisional Parts check box. The field to the right displays the provisional part type description.
MBOM and EBOM Processing (including Input File Formats)
Error Processing and Input Files