APP-BOM-28282 - Error

APP-BOM-28282: You do not have access to any of the item types. Bills of Material definition form can be accessed only if you have at least one of the Model, Standard, Planing or Option Class item type 

You may get the above error because of the improper values set for related profile options.

1. Go into the responsibility: System Administrator

2. Navigate to Profiles => System.

3. Set the following profiles to YES either at site, application or user level

BOM: Model Item Access = YES
BOM: Planning Item Access = YES
BOM: Standard Item Access = YES

Thanks & Regards,
S.Grace Paul Regan.

Simple Query To Fetch Bill Of Material (BOM) Information

SELECT

     substr(iasy.segment1,1,20) "Assembly",

                 substr(icmp.segment1,1,20) "Component",

                 substr(comp.component_quantity,1,8) "Quantity",

                 substr(comp.effectivity_date,1,8) "From",

                 substr(comp.disable_date,1,8) "To Date"

FROM

                 mtl_system_items_B iasy,

                 bom_bill_of_materials bom,

                 bom_inventory_components comp,

                 mtl_system_items_B icmp

WHERE

                 iasy.segment1 LIKE '&Item%' AND

                 iasy.organization_id = 207 AND

                 iasy.inventory_item_id = bom.assembly_item_id AND

                 iasy.organization_id = bom.organization_id AND

                 bom.bill_sequence_id = comp.bill_sequence_id AND

                 comp.component_item_id = icmp.inventory_item_id AND

                 icmp.organization_id = 207

Thanks & Regards,

S.Grace Paul Regan

Simple Query To Fetch Implemented Engineering Change Order Information

SELECT

     substr(iasy.segment1,1,20) "Assembly",

     substr(icmp.segment1,1,20) "Component",

     substr(comp.component_quantity,1,8) "Quantity",

     substr(comp.effectivity_date,1,8) "From",

     substr(comp.disable_date,1,8) "To Date"

FROM

     mtl_system_items_B iasy,

     bom_bill_of_materials bom,

     bom_inventory_components comp,

     mtl_system_items_B icmp

WHERE

     iasy.segment1 LIKE '&Assembly%' AND

     iasy.organization_id   = 207 AND

     iasy.inventory_item_id   = bom.assembly_item_id AND

     iasy.organization_id   = bom.organization_id AND

     bom.bill_sequence_id   = comp.bill_sequence_id  AND

     comp.component_item_id   = icmp.inventory_item_id AND

     icmp.organization_id   = 207

Thanks & Regards,

S.Grace Paul Regan

Implementing Engineering Change Order (ECO)

Responsibility = Manufacturing and Distribution Manager

1.    Navigate to the Engineering Change Orders window.

·         (N) Engineering > ECOs > ECOs

2.    Use F11 to start a query.

3.    Enter the following data:

-        ECO Number = "enter the ECO number you wish to query"

4.    Use Ctrl F11 to run the query.

5.    (M) Tools > Implement (B) Yes

6.    Ensure that the request is Compeleted.

·         (M) View > Requests

View the components on the primary Bill of Material

7.    Navigate to the Bills of Material window.

·         (N) Bills of Materials > Bills > Bills

8.    Use F11 to start a query

9.    Enter the following data:

-        Item = "(XX 1000-User Defined Item Number)"

10.  Use Ctrl F11 to run the query.

11.  Select the ECO tab to view the change order.

12.  Close the window.

Thanks & Regards,

S.Grace Paul Regan