Mass Changing Bills of Material
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.
Prerequisites
To mass change bills of material:
The change order type describes your changes and determines the type of bills to modify.
3. Enter the effective date for the change (for engineering bills only).
6. 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.
Enter an item type for the parent items.
7. Choose the Changes button to enter component changes.
8. 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.
Caution: You cannot undo a mass change. However, you can create another mass change to reverse the effects of a previous mass change.
9. Choose the Submit button to launch the selected actions.
To enter component changes:
1. Choose the Changes button on the Mass Change Bills window.
2. 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.
3. In the Main alternative region, enter the item sequence, operation sequence, the quantity, and the inactive date for each component. See: Item and Operation Sequence.
4. Open the Component Detail alternative region and enter the planning percent. See: Planning Percent.
Enter the yield and indicate whether the component should be quantity related and included in cost rollups. See: Yield
5. Open the Material Control alternative region and enter the supply type. See: Supply Types.
6. For model, option class, and kit bills, open the Order Entry alternative region and enter the minimum and maximum sales order quantities. See: Minimum and Maximum Quantity.
Indicate whether to check ATP. See: Check ATP.
7. Open the Shipping alternative region, and choose whether the component should be listed on shipping documents, required to ship, or required for revenue. See: Shipping Details.
To set Engineering Change Order (ECO) options:
For Oracle Engineering only.
1. From the Mass Change Bills window, choose the Special menu item and choose Set ECO Options.
3. 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.
Oracle Alert automatically notifies the planner for the revised item if the use-up date changes based on information from a new MRP plan.
See Also
Bill / Component Validation Rules
Engineering Change Order Schedule Report
Overview of Engineering Change Orders