Consolidated BOM report summarizes component information at all levels.

Navigate to BOM responsibility -> Reports -> Bills -> Select Single Request -> Select name of the report as ‘Consolidated Bill Of Material Report GUI’.

Select necessary parameters like Items, categories, explosion quantity.

Click OK and submit. Navigate to View -> Requests -> View output

Sample output screenshot is provided.

Bill Of Material Structure Report GUI is a standard oracle report that can be run to view and print BOM structure. It lists out all component information in all levels after exploding.

Navigate to BOM responsibility -> Reports -> Bills -> Select Single Request -> Select name of the report as ‘Bill Of Material Structure Report GUI’.

Report Parameters:
1 ) All organizations:    Select YES or NO. if NO is selected then it will print BOM for current inventory organization only.
2 ) Organization Hierarchy: If your requirement is to display BOM for a specific organization hierarchy, then select the hierarchy. You must pre-define the organization hierarchies before you select.
3 ) Item selection: Select ‘Specific’ to run for an item.
4 ) Item: Select item or range of items
5 ) Alternate selection: Select ‘All’ to choose specific alternate type
6 ) Revision: Select BOM revision
7 ) Date: Choose the effective date of BOM for considering the BOM structure.
8 ) Item From and To: Select the range of items
9 ) Select category set
10 ) Select category from to
11) Select levels to explode if you want to restrict to certain levels.
12 ) Implemented only: Choose YES for implemented BOM only
13 ) Display Option: Choose All, Current, Future and Current
14 ) Explosion Quantity: If you want to see the component quantities required to manufacture more than one assembly then you can enter.
15 ) Component Item detail: Select YES or NO
16 ) Show Full description: Select YES or NO
17 ) Assembly detail: Select YES or NO
18 ) Order Entry detail: Select YES or NO
19)  Lead time details:    Select YES or NO
20 ) Reference Designators: Select YES or NO
21 ) Substitute Components: Select YES or NO
22) Order by: Select the sequence
23 ) Use planning percentage: Select YES or NO

Click ‘Submit’ to launch concurrent request.
Navigate to View -> request -> view output.

Sample screenshot of output is shown below.

Oracle BOM is setup as single indented BOM with multiple level i.e. you can build one level at a time, each parent can be component for another assembly making it a multi-level structured BOM During this process some times circular loops can occur i.e. when you assign an assembly as component to itself, you can always assign any assembly as component to some other item but not to the same item. This kind of loops can cause issues while doing MRP planning.

Navigate to BOM responsibility -> Reports -> Bills -> Select Single Request -> Select name of the report as ‘Bill Of Material Loop Report GUI’.

This report have various parameters as shown in screenshot, it can be run for an item or for a range of items. It can be run for a category and for a range or categories or specific category.

Once you choose relevant parameters and click Submit. You can view the output once concurrent program is completed normal.

This report prints out BOMs that have any circular loops. You must fix them. If no data found the same is printed in the output.