Material Plan View

The Material Plan is a predefined table in Supply Chain Planning. The Material Plan table is a time-phased view of the demands, supplies, and daily balances across the plan horizon for any item and organization combination.

The item, organization, and measures are displayed for the row headings, while the time periods are displayed for the column headings. Access the Material Plan table from the Planning Central or Supply Planning work area.

Caution: If you open the predefined Material Plan table without using any filters, it can take a long time to display the results. Oracle recommends that you create a copy of the Material Plan and add filters to reduce the item count and horizon of the material plan.

You can edit the measures at aggregate levels and allocate the measures to lower levels. For example, you can edit the manual demand measure by organization, item, and period, and then allocate that measure down to the day.

You can edit a measure's value inline by clicking in a cell and changing the value. Or, you can use mass editing capabilities that are available to adjust several cells at the same time. For example, you can increase the forecast of item X for the next three months by 30 percent.

You can also display the material plan as a graph. Each measure is plotted along the x-axis, which is the time dimension.

From the Material Plan table, you can drill down to the following tables:

  • Item Exceptions

  • Items

  • Supplies and Demands

  • Supply Chain Bill

Although you cannot modify the layout of the material plan, you can copy the material plan and configure the new layout in the following ways:

  • Add or remove members and measures

  • Filter members, such as items or categories

  • Add conditional formatting, such as font, background color, and status icons

  • Add user-defined drill-to actions