Contents of the Error Processing and Input Files
Use the fields and options to configure the Error Processing and Input Files.
Process Validation (for All BOM Types)
| Field | Error Message | Error Condition | Error Type |
|---|---|---|---|
| All Required Fields | This field must be entered. | Not supplied in input file. | E |
| Record Type | This is not a valid record type. | Not A (Add), C (Change), or D (Delete). | E |
| BOM Type | This is not a valid BOM Type. | Not M (MBOM), E (EBOM), or P (PBOM). | |
| Assembly Part | This is not a valid part number. | Part is not in Item master, and BOM Type is M. If ITEM_SETTINGS_CORP. ITEMS_BY_COMP_FL is set to Y, part must also be for user’s company. | E |
| Assembly Part | Only parts can be used in Bills of Material. | Item type is not P (Part). | E |
| Assembly Part | This part is inactive. | Inactive. | E |
| Assembly Part | This part's status is "Phase-Out." | Part status is Phase-Out. | W |
| Assembly Part | This part's status is "Obsolete." | Part status is Obsolete. | W |
| Assembly Part | One or more open ECNs exists for this assembly part. | ECN Original Part matches the BOM Assembly Part, and corresponding ECN Status Code is P (Pending), A (Approved), D (Documents Updated), or I (In Approval). | W |
| Assembly Part | Warning: This part/rev's status is MPS Planning-Only. | Mult Revs = N and Part Type = MPS Planning-Only (PART. S_PART_TYPE = L for user’s company if ITEM_SETTINGS_CORP. ITEMS_BY_COMP_FL = Y) | W |
| Line No | Line No must be greater than zero. | Line No is less than zero. | E |
| Component Part | This is not a valid part number. | Part is not in Item master, and BOM Type is M. | E |
| Component Part | Only parts can be used in Bills of Material. | Item type is not P (Part). | E |
| Component Part | This part is inactive. | Inactive. | E |
| Component Part | This part's status is phase-out. | Part Status is Phase-Out. | W |
| Component Part | This part's status is obsolete. | Part Status is Obsolete. | W |
| Component Part | One or more open ECNs exists for this component part. | ECN Original Part is equal to the BOM Component Part, and corresponding ECN Status Code is P (Pending), A (Approved), D (Documents Updated), or I (In Approval). | W |
| Component Type | Component Type must equal S, B, P, R, T, or D. | Component Type is not B (Buy w/Comp), S (Standard), P (Phantom), R (Reference), T (Tool), or D (Deleted). | E |
| Quantity Type | Quantity Type must equal A, O or R. | Quantity Type is not A (Per Assembly), O (Per Order), or R (As required). | E |
| Quantity | Quantity cannot be less than zero. | Quantity is less than zero. | E |
| Quantity | Fractional amounts will be rounded up when exploding BOM Requirements. | Component Default U/M is EA, and quantity is not a whole number. | W |
| Quantity | Warning: Fractional amounts will be rounded up when exploding BOM Requirements. | Component Default UM is EA and quantity is not a whole number, and Assembly Part/Rev is NOT a MPS Planning-Only type of part (PART. S_PART_TYPE = L for user’s company if ITEM_SETTINGS_CORP. ITEMS_BY_COMP_FL = Y). | W |
| Invalid Make/Buy | Make/Buy Code must be M or B. | Make/Buy code is not M (Make) or B (Buy). | E |
| Effectivity End Date | This part is currently out of effectivity. | Effectivity end date is earlier than or the same as the current date, and the BOM Type is M or E. | W |
| Scrap | This number cannot be less than zero. | Scrap is less than zero. | E |
| Stop Explosion Flag | Stop Explosion Flag must equal Y or N. | Stop Explosion Flag is not Y or N. | E |
| Omit Requirement Flag | Omit Requirement Flag must equal Y or N. | Omit Requirement Flag is not Y or N. | E |
| Comp Release Flag | Valid Comp Release Flag codes are 'Y' for released or 'N' for unreleased. | Invalid Comp Release Flag. | E |
| Assembly Part | This part number does not exist. A provisional part will be created. | Invalid - Not in ITEM or PROV_PART, and BOM Type is E or P. Create New Provisional Parts check box is selected on preprocessor screen. | W |
| Assembly Part | This part number does not exist. The record will not be processed. | Invalid - Not in ITEM or PROV_PART, and BOM Type is E or P. Create New Provisional Parts check box is not selected on preprocessor screen. | E |
| Component Part | This part number does not exist. A provisional part will be created. | Invalid - Not in ITEM or PROV_PART, and BOM Type is E or P. Create New Provisional Parts check box is selected on preprocessor screen. | W |
| Component Part | This part number does not exist. The record will not be processed. | Invalid - Not in ITEM or PROV_PART, and BOM Type is E or P. Create New Provisional Parts check box is not selected on preprocessor screen. | E |
| Assembly Part/Component Part | MPS planned parts can only be components of other MPS planned parts. | Component Part’s Planning Type is MPS and assembly part’s planning type is not MPS. For validation purposes, do not include BOM lines where the component type is D or the out effectivity date is not null and less than or equal to the current date. | E |
| BOM Type | The system is not set up to use Engineering Bills of Materials. Records with BOM Type = E will not be processed. | BOM Type is E, and BOM_SETTINGS_CORP. USE_EBOM_FL = N. | E |
| Proposal | Bills of Material for this Proposal have been frozen. This record will not be processed. | PROP_HDR. FREEZE_PBOM_FL = Y. | E |
| Proposal | This Proposal/Rev combination does not exist. | Proposal/Rev combination not found in PROP_HDR. | E |
| The quantity must equal zero for a quantity type of As-Required | Qty Type is R, Qty is not "0." | E |
Process Validation - Manufacturing BOM (BOM Type = M)
| Field | Error Message | Error Condition | Error Type |
|---|---|---|---|
| Record Type | This Manufacturing BOM line cannot be found. | Record Type is C (Change) or D (Delete), and no MBOM line match can be found using the assembly part, component line number, or configuration ID. | E |
| Assembly BOM Status | Released MBOMs cannot be changed or deleted. | Record Type is C (Change) or D (Delete), the Allow Released MBOM/EBOM Lines to be Changed/Deleted check box is not selected, and the Assembly Part Release Status is R (Released). | E |
| Assembly BOM Status | Assemblies must have a BOM status of "R" (Released), "U" (Unreleased) or "P" (Partially Released). | Assembly Part Release Status is not R (Released), U (Unreleased), or P (Partially Released). | E |
| Assembly BOM Status | Input file records with the same assembly must also have the same Assembly BOM Status value. No input records for this assembly will be processed. | Assembly Part ID and Assembly Part Revision combination exists on multiple input file records, and they have different Assembly BOM Status values. | E |
| Assembly BOM Status | The assembly part has a status of Estimating and is not a Planning Only part. It cannot have a BOM release status of Released or Partially Released. | ASY_REL_CD = R or P, Assembly Part status is E (Estimating), Assembly Part/Rev is not a Planning Only part type (PART. S_PART_TYPE is not L, for user’s company if ITEM_SETTINGS_CORP. ITEMS_BY_COMP_FL = Y) | E |
| Assembly BOM Status | The assembly part has a status of pre-release. | Assembly BOM Status is R; Assembly Part Status is Pre-Release. | E |
| Assembly BOM Status | MBOMs cannot be released with this process. | Record Type is A (Add), the Allow New MBOM/EBOM Lines to be Released check box is not selected, and the input file's Assembly BOM Status is R. | E |
| Assembly BOM Status | MBOMs cannot be released with this process. | Record Type is C (Change), the Allow New MBOM/EBOM Lines to be Released check box is not selected, the input file's Assembly BOM Status is R, and assembly part's release status is P (Partially Released) or U (Unreleased). | E |
| Assembly BOM Status | This assembly has a subassembly with an unreleased MBOM. | Input file's Assembly BOM Status is R, the Allow New MBOM/EBOM Lines to be Released check box is selected, and one or more existing MBOM lines exist for this assembly with the component part's release status of P (Partially Released) or U (Unreleased). | E |
| Assembly BOM Status | Unreleased MBOM components will be released, unless the component type is 'D'eleted. | Input file's Assembly BOM Status is R, the Allow New MBOM/EBOM Lines to be Released check box is selected, and one or more existing MBOM lines exist for this assembly with the Component Release Flag of N. | W |
| BOM Configuration | This BOM Configuration is not valid. | BOM Configuration ID is not in the Configuration ID table. If ITEM_SETTINGS_CORP. ITEMS_BY_COMP_FL is set to Y, check for user company. | E |
| BOM Configuration | BOM Configuration IDs are not used. The value will not be loaded | BOM Configuration ID is entered, and the Use Configuration IDs check box is cleared on the BOM Corporate Settings block of the Configure Bills of Material Settings screen. | W |
| Component Release Flag | Valid component status codes are Y for released or N for unreleased. | Component Release Flag is not Y or N. | E |
| Component Release Flag | The part has a status of estimating-only. You must release the part on the part master before it can be released in a BOM. | Component Release Flag is Y, and part status is Estimating. | E |
| Component Release Flag | The part has a status of pre-release. You must release the part on the part master before it can be released in a BOM. | Component Release Flag is Y, and part status is Pre-Release. | E |
| Component Release Flag | A released assembly cannot have unreleased components. | Assembly BOM Status is R, Component Release Flag is N, and COMP_TYPE is not D. | E |
| Component Release Flag | A released assembly cannot have unreleased components. | Record Type is C (Change), input file Assembly BOM Status is null, Component Release Flag is N, and Assembly Part's Release Status is R and either the COMP_TYPE not is D (if in input file), or MFG_BOM.S_COMP_TYP_CD is not D (if not in input file). | E |
| Component Release Flag | This Component line cannot be released. | Record Type is A (Add), Component Release Flag is Y, but the Allow New MBOM/EBOM Lines to be Released check box is not selected. | W |
| Component Release Flag | This Component line cannot be released. | Record Type is C, MBOM Component Release Flag is N, and input file's Component Release Flag is Y, but the Allow New MBOM/EBOM Lines to be Released check box is not selected. | W |
| Component Release Flag | This released component line cannot be changed or deleted. | Record Type is C or D, and the existing MBOM Component Release Flag is Y, but the Allow Released MBOM/EBOM Lines to be Changed/Deleted check box is not selected. | E |
| Component Release Flag | A component subassembly cannot have a release flag set to 'Y' when its BOM status is not released. | Component Part's BOM Release Status is Unreleased or Partially Released, and Component Release Flag is Y. | E |
| Warehouse | The Warehouse ID is not valid. Warehouse will not be loaded. | Warehouse ID is not in Warehouse table, for user’s company. | W |
| Warehouse | This component is not set up as a backflush part. Warehouse will not be loaded. | Warehouse is not null, and part Backflush flag is N. | W |
| Location | This component is not set up as a backflush part. Location will not be loaded. | Location is not null, and part Backflush flag is N. | W |
| Warehouse/ Location | The warehouse/location is not valid. Warehouse/location will not be loaded. | Warehouse/Location combination is not in Warehouse table or Locations table. | W |
| Warehouse/ Location | The location does not have a type of on-hand. Warehouse/ Location will not be loaded. | Location Type is not in Locations table. | W |
| Work center | The work center is not valid. The Work Center will not be loaded | Work Center is not in Work Centers table. | W |
| Product Option | This product option ID is invalid. Product Option will not be loaded. | Product Option ID is not in Product Options table. | W |
| Product Option | This part/product option combination does not exist in the Product Options table. | Product Option ID and Part combination does not exist in the Product Options table or Part table | W |
| This line already exists. | Record Type is A, and an MBOM line exists with the same Assembly Part Key, Line Number, Configuration, Effective Start Date, and Effective Ending Date between the MBOM row and input file record.* | E | |
| This line's date range overlap's another line's date range having the same line number. | Record Type is A, and an MBOM line exists with the same Assembly Part Key, Line Number, and Configuration; Effective Start Date and Effective Ending Date overlap.* | E | |
| A part cannot be a component to itself. | Component Part/Rev matches Assembly Part/Rev. | E | |
| All component subassemblies must have BOM release status' of Released in order to release the parent assembly's BOM. | Assembly BOM Status is Released, but component subassembly has a status of Unreleased or Partially Released. | E | |
| The quantity must equal zero for a quantity type of As-Required. | Quantity Type is R, and quantity is not equal to zero. | E | |
| The effective start date cannot be later than the effective end date. | Effective Starting Date is later than or the same as the Effective Ending Date. | E | |
| Assembly Part | This assembly part exists as a released component in one or more Manufacturing BOMs. | Assembly BOM Status is Unreleased or Partially Released, but the assembly part exists in another MBOM as a component part where the COMP_REL_FL = Y. | E |
| Assy BOM Status | Manufacturing Bills of Material must be released through the ECN process. | EC_SETTINGS_CORP. ECN_MBOM_REL_FL = Y and Assembly BOM Status is set to Released (previously null, Partially released or Unreleased). | E |
| A Manufacturing Bill of Material already exists with the assembly part as the component of this subassembly. This would create a looping bill of material. | If component is a subassembly (BOM_EXIST_FL = Y), and that subassembly has the current assembly as a component, a looping condition exists. | E | |
| Assembly Part/Rev | Warning: this assembly is a MPS Planning-Only type of part. | Assembly Part/Rev is a MPS Planning-Only type of part (PART. S_PART_TYPE = L for user’s company if ITEM_SETTINGS_CORP. ITEMS_BY_COMP_FL = Y). | W |
* You must click the arrow next to
and select
Import Bills of Material or
Import and Print Bills of Material for this validation to take place. This validation does not occur when you click
or
.
Process Validation - Engineering BOM (BOM Type = E)
| Field | Error Message | Error Condition | Error Type |
|---|---|---|---|
| Record Type | This Engineering BOM line cannot be found. | Record Type is C (Change) or D (Delete), and no EBOM line match can be found using the assembly part, component line number, or configuration ID. | E |
| Assembly BOM Status | Released EBOMs cannot be changed or deleted. | Record Type is C (Change) or D (Delete), the Allow Released EBOM Lines to be Changed or Deleted check box is not selected, and the Assembly Part Release Status is R (Released). | E |
| Assembly BOM Status | Engineering Bills of Material must be released through the ECN process. | EC_SETTINGS_CORP. ECN_EBOM_REL_FL = Y, and Assembly BOM Status is set to R (Released) (previously null or Unreleased). | E |
| Assembly BOM Status | Released Engineering Bills of Material must be modified through the ECN process. | EC_SETTINGS_CORP. ECN_EBOM_REL_FL = Y, and Record Type is C or D. | E |
| Assembly BOM Status | EBOM assemblies must have a BOM status of "R" (Released) or "U" (Unreleased). | Assembly Part Release Status is not R (Released) or U (Unreleased). | E |
| Assembly BOM Status | Input file records with the same assembly must also have the same Assembly BOM Status value. No input records for this assembly will be processed. | Assembly Part ID and Assembly Part Revision combination exists on multiple input file records, and they have different Assembly BOM Status values | E |
| Assembly BOM Status | The assembly part has a status of Estimating and is not a Planning Only part. It cannot have a BOM release status of Released. | ASY_REL_CD = R, Assembly Part Status is E (Estimating), Assembly Part/Rev is not a Planning Only part type (PART. S_PART_TYPE is not L for user’s company, if ITEM_SETTINGS_CORP. ITEMS_BY_COMP_FL = Y) | E |
| Assembly BOM Status | The assembly part has a status of pre-release. | Assembly BOM Status is R, and Assembly Part Status is Pre-Release. | E |
| Assembly BOM Status | EBOMs cannot be released with this process. | Record Type is A (Add), the Allow New MBOM/EBOM Lines to be Released check box is not selected, and the input file's Assembly BOM Status is R. | E |
| Assembly BOM Status | EBOMs cannot be released with this process. | Record Type is C (Change), the Allow New MBOM/EBOM Lines to be Released check box is not selected, input file's Assembly BOM Status is R, and assembly part's Release Status is U (Unreleased). | E |
| Assembly BOM Status | This assembly has a subassembly with an unreleased EBOM. | Input file's Assembly BOM Status is R, the Allow New MBOM/EBOM Lines to be Released check box is selected, and one or more existing EBOM lines exist for this assembly with the component part's Release Status of P (Partially Released) or U (Unreleased). | E |
| Assembly BOM Status | Warning: Unreleased EBOM components will be released, except if component type is 'D'eleted. | Input file's Assembly BOM Status is R, the Allow New MBOM/EBOM Lines to be Released check box is selected, and one or more existing EBOM lines exist for this assembly with the Component Release Flag of N. | W |
| BOM Configuration | This BOM Configuration is not valid. | BOM Configuration ID is not in the Configuration ID table | E |
| BOM Configuration | BOM Configuration IDs are not used. The value will not be loaded | BOM Configuration ID is entered, and the Use Configuration IDs check box is cleared on the BOM Corporate Settings block of the Configure Bills of Material Settings screen. | W |
| Component Release Flag | Valid component status codes are Y for released or N for unreleased. | Component Release Flag is not Y or N. | E |
| Component Release Flag | The part has a status of estimating-only. You must release the part on the part master before it can be released in a BOM. | Component Release Flag is Y, part Status is Estimating. | E |
| Component Release Flag | The part has a status of pre-release. You must release the part on the part master before it can be released in a BOM. | Component Release Flag is Y, and part Status is Pre-Release. | E |
| Component Release Flag | A released assembly cannot have unreleased components. | Assembly BOM Status is R, Component Release Flag is N, and COMP_TYPE not = D. | E |
| Component Release Flag | A released EBOM assembly cannot have unreleased components. | Record Type is C (Change), input file Assembly BOM Status is null, Component Release Flag is N, and Assembly Part's Release Status is R, and either the COMP_TYPE is not D (if in input file) or the ENG_BOM.S_COMP_TYP_CD is not D (if not in input file). | E |
| Component Release Flag | This Component line cannot be released. | Record Type is A (Add), Component Release Flag is Y, but the Allow New MBOM/EBOM Lines to be Released check box is not selected. | E |
| Component Release Flag | This Component line cannot be released. | Record Type is C, MBOM Component Release Flag is N, and input file's Component Release Flag is Y, but the Allow New MBOM/EBOM Lines to be Released check box is not selected. | E |
| Component Release Flag | This released component line cannot be changed or deleted. | Record Type is C or D, and the existing EBOM Component Release Flag is Y, but the Allow Released MBOM/EBOM Lines to be Changed/Deleted check box is not selected. | E |
| Component Release Flag | A component subassembly cannot have a release flag set to 'Y' when its EBOM status is not released. | Component Part's BOM Release Status is Unreleased or Partially Released, and Component Release Flag is Y. | E |
| This line already exists. | Record Type is A, and an EBOM line exists with the same Assembly Part Key, Line Number, Configuration, Effective Start Date, and Effective Ending Date between the EBOM row and input file record.* | E | |
| This line's date range overlap's another line's date range having the same line number. | Record Type is A, and an EBOM line exists with the same Assembly Part Key, Line Number, and Configuration; Effective Start Date and Effective Ending Date overlap.* | E | |
| Component | A part cannot be a component to itself. | Component Part/Rev matches Assembly Part/Rev. | E |
| Component | All component subassemblies must have BOM release status of Released in order to release the parent assembly's BOM. | Assembly BOM Status is Released, but component subassembly has a Status of Unreleased. | E |
| Component | The quantity must equal zero for a quantity type of As-Required. | Quantity Type is R, and quantity is not zero. | E |
| Component | The effective start date cannot be later than the effective end date. | Effective Starting Date is later than or the same as the Effective Ending Date. | E |
| Assembly BOM Status | The assembly EBOM Status cannot be Released if there are component lines with provisional parts. | EBOM Status is Released, and component lines with provisional parts exist. | E |
| Assembly BOM Status | EBOM Status cannot be Released if assembly is a provisional part. | EBOM Status is Released, and assembly is a provisional part. | E |
| Assembly Part | This assembly part exists as a released component in one or more Engineering BOMs. | Assembly BOM Status is Unreleased, but the assembly part exists in another EBOM as a component part where the COMP_REL_FL = Y. | E |
| New Provisional Part | Provisional Parts should not begin with a space character. | Begins with a space. | E |
| Component | An Engineering Bill of Material already exists with the assembly part as the component of this subassembly. This would create a looping bill of material. | If component is a subassembly (EBOM_EXIST_FL = Y), and that subassembly has the current assembly as a component, a looping condition exists. | E |
| Assembly Part/Rev | Warning: this assembly is a MPS Planning-Only type of part. | Assembly Part/Rev is a MPS Planning-Only type of part (PART. S_PART_TYPE = L for user’s company if ITEM_SETTINGS_CORP. ITEMS_BY_COMP_FL = Y). | W |
* You must click the arrow next to
and select
Import Bills of Material or
Import and Print Bills of Material for this validation to take place. This validation does not occur when you click
or
.
Process Validation - Proposal BOM (BOM Type = P)
| Field | Error Message | Error Condition | Error Type |
|---|---|---|---|
| Proposal | Bills of Material for this Proposal have been frozen. This record will not be processed. | Proposal Header's Freeze PBOM flag is Y (Yes). | E |
| Component Line | This Proposal BOM line cannot be found. | Record Type is C (Change) or D (Delete), and no PBOM line match can be found using the proposal key, assembly part key, and component line number. | E |
| Record Type | This update results in no more component lines for the Proposal Bill of Material, and so it will be deleted. | Record Type is D (Delete), resulting in no more PBOM lines for the PBOM header Proposal/Assembly combination. | W |
| Component line | Proposal bill of material line numbers must be unique. | Two lines have the same line number | E |
| Component Release Flag | This assembly exists as a firmed component in another PBOM for this proposal. You must either firm this PBOM or change the component firmed flag to N in the other PBOM(s). | PBOM Status is Unfirm, but assembly exists as a component in another PBOM line for that proposal and component's Firm Flag is set to Y. | E |
| Component Release Flag | The Proposal bill of material cannot be set to firmed if one of more components are unfirmed. | PBOM Status is Firm, but one or more component's Firm Flag is set to N. | E |
| Assembly BOM Status | PBOM assemblies must have a BOM status of 'U'nfirmed or 'F'irmed. | BOM Type is P, and Assembly Release Code (ASY_REL_CD) is not U (Unreleased) or F (Firmed). | E |
| Assembly BOM Status | Input file records with the same assembly must also have the same Assembly BOM Status value. | Assembly Part ID and Assembly Part Revision combination exists on multiple input file records, and they do not have the same, non-null Assembly Release Code (ASY_REL_CD) value. | E |
| Component Release Flag | Valid component status codes are 'Y' for firmed or 'N' for unfirmed. | Component Firmed flag is not Y or N. | E |
| Do Not Perform this validation During Trial Run | This line already exists. | Record Type is A (Add), and a PBOM line exists with the same Proposal Key, Assy Part Key, and Line Number between the PBOM_LN row and input file record. | E |
| Component | A part cannot be a component to itself. | Component Part/Rev matches Assembly Part/Rev. | E |
| Component | The quantity must equal zero for a quantity type of As-Required | Qty Type is R, and Qty is not 0. | E |
| Component | A Proposal Bill of Material already exists for this proposal with the assembly part as the component of this subassembly. This would create a looping bill of material. | If component is a subassembly within the same proposal (if Component Part Key is in PBOM_HDR table for selected PROP_KEY), and that subassembly has the current assembly as a component, a looping condition exists. | E |
| Assembly Part/Rev | Warning: this assembly is a MPS Planning-Only type of part. | Assembly Part/Rev is a MPS Planning-Only type of part (PART. S_PART_TYPE = L for user’s company if ITEM_SETTINGS_CORP. ITEMS_BY_COMP_FL = Y). | W |
* You must click the arrow next to
and select
Import Bills of Material or
Import and Print Bills of Material for this validation to take place. This validation does not occur when you click
or
.