Forecast Comparison Report
The Forecast Comparison Report displays a comparison of forecast quantities and costs or quantities only. You can choose the number of periods and weeks for which to run the report. You can report all items or a range of items associated with the forecast name. You can also compare the costs of the forecast quantities.
Report Submission
In the Submit Requests window, enter Forecast Comparison Report in the Name field.
Report Parameters
Forecast Name
Select a forecast name to compare its forecast to the forecast quantities of the second forecast name.
First Quantities
Select one of the following options:
| Current
| Print forecast comparison information using current forecast quantities.
|
| Original
| Print forecast comparison information using original forecast quantities.
|
Second Organization
Select the organization of the second forecast to compare to the forecast from your current organization.
Second Forecast Name
Select a forecast name to compare its forecast to the first forecast name.
Second Quantities
Select one of the following options:
| Current
| Print forecast comparison information using current forecast quantities.
|
| Original
| Print forecast comparison information using original forecast quantities.
|
Report Start Date
Enter a report start date from which to print the forecast comparison.
Periods
Select one of the following time periods:
| 12
| Report the forecast for 12 periods.
|
| 24
| Report the forecast for 24 periods.
|
| 36
| Report the forecast for 36 periods.
|
| 48
| Report the forecast for 48 periods.
|
Weeks
Enter the number of weeks. The number of Weeks you choose, together with the number of Periods you choose, determines how many weeks and how many months that display in the horizontal time-phased plan.
For example, if you choose 24 as the time Period and 10 as the number of Weeks, 10 of these periods display as weeks, the remaining 14 as months.
Note: The number of weeks that displays in the QuickPick is based on the workday calendar and corresponds to the end of the working periods. For example, if you choose 12 as the time Period and it is the third week of a four week period calendar, Oracle Master Scheduling/MRP and Oracle Supply Chain Planning calculates the number of weeks to the end of each period and displays the valid QuickPick options as 1, 5, and 9 weeks.
Include Costs
Select one of the following options:
| No
| Report the comparison information by units rather than value (standard cost times units).
|
| Yes
| Report the comparison information by value (standard cost times units) in addition to units.
|
Include Before Start Date
Select one of the following options:
| No
| Do not display forecast entries, bucketed in the first bucket, before the start date you enter.
|
| Yes
| Display forecast entries, bucketed in the first bucket, before the start date you enter.
|
First Sort
Select one of the following options. The report sorts items first in this order, then in the order you specify for the second and third sort.
| ABC class
| Sort items first by ABC class.
|
| Buyer
| Sort first by buyer.
|
| Category
| Sort first by material category.
|
| Inventory item
| Sort first by inventory item.
|
| No sort
| Do not employ a first sort for the report.
|
| Planner
| Sort first by planner.
|
Second Sort
Select the second sort type for the item. Items are sorted by the First Sort type and then by this sort type within the first type.
For example, if you choose Planner as the first sort type and Category as the second sort type. Oracle Master Scheduling/MRP and Oracle Supply Chain Planning sorts the report by planner, and then by material category within planner.
Note: If you choose No sort here, the report is sorted using just the First Sort type.
If you choose No sort, the report is sorted by using just the First Sort type.
Third Sort
Select the third sort type for the item. Oracle Master Scheduling/MRP and Oracle Supply Chain Planning sorts the items by the first sort type, then by the second sort type within the first type, and finally by this sort type within the second type.
For example, if you choose Planner as the first sort type, Category as the second sort type, and Inventory item as the third sort type, the report is sorted by planner, then by material category within planner, and finally by Inventory item within material category.
If you choose No sort, the report is sorted by using just the first and second sort types.
Planner
Select a planner to report items planned by this planner.
Buyer
Select a buyer to report items planned by this buyer.
Items From/To
To restrict the report to a range of items, select the beginning and ending item numbers.
Category Set
Select a category set. Oracle Master Scheduling/MRP and Oracle Supply Chain Planning reports forecast entries associated with this category set.
Categories From/To
To restrict the report to a range of categories, enter the beginning and ending category names.
ABC Assignment Group
Select an ABC assignment group. Oracle Master Scheduling/MRP and Oracle Supply Chain Planning reports forecast entries associated with this ABC assignment group.
ABC Class
Select an ABC class associated with the ABC assignment group.
See Also
Submitting a Request
