Use the Mass Change Bills window to mass change your manufacturing or engineering bills of material. You can define a mass change to add, delete or replace a component, alter a component quantity or yield, or change other component information. You can mass change all using bills of material or choose a subset of bills by item range, item category, or item type. You can mass change primary and alternate bills of material for each using assembly. For engineering bills, you can schedule the mass change for a future effective date. For manufacturing bills, you can implement the changes immediately. You can also report effective changes for all using assemblies or components.
If you are using Oracle Engineering, you can create an engineering change order (ECO) from the mass change order that affects both engineering and manufacturing bills. You can then implement the ECO and report on any effected using assemblies.
Bills of Material or Engineering take into account all the actions you enter to determine if the change is applicable. For example, suppose you add component A and delete component B. This change is made only if component A does not exist and component B does exist on the selected bills. The change is applied only if both conditions are met. In this example, two records are affected.
You must create at least one bill of material. See: Creating Bills of Material.
You must create at least one change order type. See: Defining ECO Types, Oracle Engineering User's Guide.
Navigate to the Mass Change Bills window.
Enter a mass change order number and a change order type. If you have Engineering installed and have set up ECO Autonumbering, a default value will appear. See: Defining ECO Autonumbering, Oracle Engineering User's Guide.
The change order type describes your changes and determines the type of bills to modify.
Enter the effective date for the change (for engineering bills only).
Select a single item unit number.
Indicate whether to increment the parent item's revision by 1 (numeric based revisions only).
Note: Revisions are sorted as per ASCII rules. Each revised number must be greater than the previous revised number. Therefore, you cannot revise to 10 after revision 9 because according to ASCII sorting 10 precedes 9. If the current revision is 9 and increment revision check box is checked, then the mass change program will result in an error. To avoid this, set default revision as 001 instead of 1. Then the mass change increment revision functionality will not return an error until the revision reaches 999.
Indicate whether to update Work in Process material requirements of any unreleased discrete job, or any release or unreleased repetitive schedule associated with the parent items.
Specify the parent items to change.
You can use a category set, a category range, or an item range. Alternatively, indicate whether to change all primary bills, all primary and alternate bills, or a specific alternate bill.
Optionally, enter a base model to mass change configuration items related to this model that meets your other selection criteria.
If the mass change involves editable common BOM assemblies, then the mass change ignores the editable common bills when you update the non-material control attributes.
Enter an item type for the parent items.
Choose the Changes button to enter component changes.
Caution: If you do not wish to replace the values for the Supply Type, Supply Subinventory, and Supply Locator fields, you must enter the current value when executing a mass change. If you leave the Supply Type, Supply Subinventory, and Supply Locator fields blank when entering component changes, their values will be replaced by the blank (null) value when the mass change is executed.
When finished, select the action(s) to take.
For Bills of Material, select Report (to see affected bills), Implement (to perform the mass change), both, or neither.
For Engineering, select Report, Create ECO, both, or neither.
If you make no selection, the mass change order is saved for you to work on later.
Note: You cannot undo a mass change. However, you can create another mass change to reverse the effects of a previous mass change.
Choose the Submit button to launch the selected actions.
Choose the Changes button on the Mass Change Bills window.
For each component item to change, indicate the action to perform. You can add or delete components to or from a parent item.
Or, you can update existing information about the component on the parent item. With this option a new row is created that you enter new information into.
In the Main tabbed region, enter the item sequence, operation sequence, the quantity, and the inactive date for each component. See: Item and Operation Sequence Fields.
Open the Component Detail tabbed region and enter the planning percent. See: Planning Percent Field.
Enter the yield and indicate whether the component should be quantity related and included in cost rollups. See: Yield Field.
Open the Material Control tabbed region and enter the supply type. See: Supply Types.
Enter the supply subinventory and locator identifiers. See: Supply Subinventory and Locator Fields.
For model, option class, and kit bills, open the Order Entry tabbed region and enter the minimum and maximum sales order quantities. See: Minimum and Maximum Quantity Fields.
Indicate whether to check ATP. See: Check ATP (Available to Promise) Field.
Indicate whether the component is optional and mutually exclusive. See: Mutually Exclusive and Optional Fields.
Open the Shipping tabbed region, and choose whether the component should be listed on shipping documents, required to ship, or required for revenue. See: Shipping Details Fields.
For Oracle Engineering only.
From the Mass Change Bills window, choose the Tools menu item and choose Set ECO Options.
Use the Plan check box to indicate whether you want Oracle Master Scheduling/MRP to include the revised item in the planning process.
Indicate whether each revised item's effective date is based upon the planned item's use-up date. If so, check the Use Up check box.
Enter an item whose use-up date is tied to each revised item effective date. The default is the use-up item associated with the plan name. This can be the revised item or a component of the revised item.
Oracle Alert automatically notifies the planner for the revised item if the use-up date changes based on information from a new MRP plan.
Engineering Change Order Schedule Report, Oracle Engineering User's Guide
Overview of Engineering Change Orders, Oracle Engineering User's Guide