ERROR PROCESSING AND INPUT FILES

If you preview or print a test copy before clicking , the errors that prevent an input file record from processing are reported in an error report. The application makes no changes to the input and error files, and the error line number is not printed. Error line numbers print only if you click first.

An error occurs because a condition is not met for a field that is being processed in an input file record. Any input file records with one or more E (Error) type errors are removed from the input file and moved to an error file. The error file has the same format as the input file with an error file number added to it for reference. If the input file record contains one or more W (Warning) type errors (which serve as a notification that the input file record may contain an error) and the Prevent Insert/Update if Warning Conditions Exist check box is selected, the input file record moves to the top of the error file and a number is assigned to it. Conversely, if the input file record has one or more W (Warning) type errors and the Prevent Insert/Update if Warning Conditions Exist check box is not selected, the input file record is not moved to the error file.

The error file's file path is the same as the input file's file path, and named BMMMDDYY.ERR, where MMDDYY is the date on which the process is being run. If the error file already exists, new errors are appended to the file.

If a record with one or more warnings, but no errors, is processed when the Prevent Insert/Update if Warning Condition Exists check box is cleared, that record is excluded from the count for Total Bad Records.

If you click or , and the File Format is Delimited, and the delimiter does not exist in Line 1 of the input file, the following error message displays: "Line 1 does not contain the correct field delimiter."

The application checks for error conditions in the applicable tables, as outlined in the Error Condition column in the following table. The following Error Values apply to each error condition and message indicated in the following tables:

Record Type (REC_TYPE).
Assembly Part ID (ASY_PART_ID), Assembly Part Revision (ASY_PART_RVSN_ID).
Component Line Number (COMP_LN_NO).
BOM Configuration ID (BOM_CONFIG_ID).
Part and Provisional Part (PART and PROV_PART) error if you selected the Create New Provisional Parts check box.
Proposal ID (PROP_ID) and Proposal Revision (PROP_RVSN_ID) (applies to Proposal BOMs only).

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 chec kbox 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 .