Automatically Generate Bills of Resources

You can generate bills of resources through an automated scheduled process that uses collected discrete work definitions and item and resource attributes.

Use the Create Bills of Resources scheduled process to create bills of resources for planning assembly items in a sales and operations plan.

Aggregate supply planning in sales and operations planning doesn't consider detailed bills of materials and routings. It uses bills of resources that collapse routing operations to focus on critical components and resources so that you can perform rough cut capacity planning at a strategic level. This process enables you to plan at an aggregate level and make strategic decisions in your sales and operations planning process.

The Create Bills of Resources scheduled process:

  • Uses collected discrete work definition data in the form of routings and item structures as the primary source of input data.

    Routings are required input data. You can't run the Create Bills of Resources process with only bills of materials.

  • Uses assignment set with Make at and Transfer from sourcing as input data. For example, the Create Bills of Resources scheduled process uses a sourcing assignment at an item or product category level with a Make at sourcing rule.

    Define sourcing assignments in an assignment set. An assignment set is required for aggregate supply planning in a sales and operations plan. To simplify data setup, Oracle recommends that you specify sourcing assignments at an aggregate level such as Category and Organization rather than at an item level. The planning process considers the Transfer from sourcing rule for subassemblies manufactured in upstream organizations.

  • Considers critical components and bottleneck resources to narrow down the scope of the work definitions and ensure that constrained supply can meet strategic needs.

  • Sends bills of resources data to the Aggregate Bill of Resources table in the output simulation set (not Plan Inputs) that you can associate with a sales and operations plan.

Note: You can also upload the bills of resources entity by using the file-based data import (FBDI) template, ScpBillOfResourcesImportTemplate.xlsm. To create bills of resources at the category level, you must use the FBDI import template.

You can schedule and automate the Create Bills of Resources process. For example, define a job set that automates a scheduled process in which the Create Bills of Resources scheduled process is followed immediately by a batch run plan.

After you submit the scheduled process, refer to the log file associated with the Create Bills of Resources Process ID in Search Results on the Scheduled Processes page.

When the scheduled process completes, you can open the Aggregate Bill of Resources table in the output simulation set to review and modify the process output.