This report lists item costs by level, detailiing assembly costs by subelement to the lowest level of your bill. Each item is detailed regardless of the number of levels it appears at on the bill. You can report item costs across multiple organizations, costing methods, and currencies - connected to sourcing rules.

The report contains a Basis/Yield type column for displaying the component type as Lot or Item.

   Report submission:

You can submit this report as part of the cost rollup process, or when reporting item costs. Only an historical report is printed when reporting item costs. A cost rollup is not performed. It uses costs stored as the result of a prior cost rollup. Oracle recommends you run this report using a past rollup to ensure that the appropriate information is available for the report.

Use the Indented Bills of Material Cost Report form and enter Indented Bills of Material Cost Report in the Name field to submit the Indented Bills of Material Cost Report.

   To enter report parameters:

1. Enter a Description. Optionally enter any descriptive text referencing this request.

2. Select a value in the Cost Type field.

   Cost type determines how the rollup is performed. If an item does not already have cost information in this cost type, costs from the organization default cost type are used. If costs do not exist in the default cost type, then costs from the current organization's valuation cost type are used.

   Note: Every time the Supply Chain Cost Rollup program is generated, costs are overwritten from previous rollups for the cost type specified.

   See: Defining Cost Types.

3. Enter an Organization. You can use the default current organization, or leave this field blank. The Organization and Range fields are used together to specify the list of the top level assemblies to roll up.

   • If you select the current organization, then the top level assembly items are rolled up from this organization.

   • If the field is blank, then the top level assembly items are from all organizations are rolled up.

4. Optionally, select a value for Assignment Set. Once you have defined your sourcing rules and bills of distribution, assign them to particular items and/or organizations. These groupings are called assignment sets. This is where sourcing strategies are defined for a particular supply chain network. See: Setting up the Supply Chain, Oracle Advanced Planning Implementation and User's Guide.

5. If you selected an Assignment Set, select a Buy Cost Type.

   If you specified a sourcing rule, all the costs defined in Buy Cost Type are summed in the material cost. For example:

   • If both the destination and buy cost types are set up as Pending, the process searches for pending costs.

   • If there are no pending costs, the process then searches for default cost type.

   • If there are no default costs in the current organization, the process then searches for the current organization's valuation cost type. See: Defining Costing Information.

     For configure to order items, select the value for the CTO Cost Type defined in the profile option, BOM:Buy Cost Type for Configurations. See: Configuration Item Cost Rollup, Oracle Configure to Order Implementation Manual.

     See: Defining Costing Information.

6. Select a Conversion Type from the list of values. This is the currency conversion type used if currency values need to be converted across organizations.

7. Select the Range of items to roll up.

   Your choices are: All items, Category, Range of items, Specific item, or Zero cost items.

   If you select Zero cost items, then the rollup includes zero cost items in the current and the default cost types that have the attribute, Based on Rollup, enabled.

   Note: Inactive items are not rolled up unless you select a Specific Item that is inactive.

8. Select a Rollup Option. Your choices are:

   • Full cost rollup: Performs a bill of material explosion for assemblies, and then builds the cost of assemblies starting with the lowest level, and works up the structure to top level assemblies.

   • Single-level cost rollup: Assigns new standard costs to the top assembly, but not to the lower-level assemblies.

9. If you selected a request type that prints a report, then select a Report Type. Your choices are:

   • Consolidated: Prints the Supply Chain Consolidated Bill of Material Cost report, which lists total quantities of each component used in the parent assembly regardless of level.

   • Detail Indented: Prints the Indented Supply Chain Bill of Material Cost report, which lists detailed cost structure by level.

     See: Supply Chain Consolidated Bills of Material Cost Report, and Supply Chain Indented Bills of Material Cost Report

10. If you selected a request type that prints a report, in the Material Detail, Material Overhead Detail, and Routing Detail fields, indicate if you want these fields to display on the report. Your choices are Yes or No.

    If you select Yes, then Material, Material Overhead, and Routing detail subelements display on the report.

    Note: If you select No, then you limit the amount of subelement detail and reduce the size of the report.

11. Report Number of Levels. Select the number of levels to display on the report. For example, if your assembly had 20 levels and you enter 10 in this field, then the costs for levels 1 to 10 would be detailed. The costs for levels 11 to 20 would be summarized as previous level costs.

12. Enter the Effective Date to determine the structure of the bill of material to use in the cost rollup. You can use this to roll up historical and future bill structures using current rates and component costs.

13. Include Unimplemented ECOs. Select Yes or No to indicate whether to include unimplemented ECOs in the bill structure.

14. Select an Alternate Bill to copy the structure of the bill. Otherwise, the primary bill structures are used. By selecting an alternate bill, you can get an indented bill of material cost report that reflects the frozen cost, even if the bill structures have changed. Set the cost type to snapshot the bill structure. When you run this report, specify the same alternate bill that you set up in the cost type.

15. Optionally, enter an Alternate Routing for the assembly to roll up, if applicable, for the Range that you selected.

    For example, if an alternate routing is specified, all items specified in the range are still rolled up:

    • The items that do have an associated routing with that name are rolled up using that routing.

    • The items that do not have an associated routing with that name will continue to be rolled up using the primary routing.

      See: Primary and Alternate Routings.

16. Engineering Bill. Select Yes or No to indicate whether to report engineering bills.

17. Optionally, enter a Specific Item to roll up:

    • If you selected Specific Item in the Range field, then select an item.

    • If you selected Category in the Range field, then select either a category set or a specific category.

      If you select a category set, then item costs are rolled up for items associated with this category set. The default is the category set defined for your costing functional area.

    • If you selected Range of items, then enter From and To values to specify the range of items for which to roll up costs.

18. Select a Category Set. Indented bill cost information is reported for items associated with this category set. The default is the category set you defined for your functional area.

19. Specific Category. Select a specific category to restrict the report to a range of categories. Indented bill cost information is reported for items associated with these category sets.

20. Item From/To. Select a beginning and an ending item to restrict the report to a range of assembly items.