Extract BOM for each revision of assembly – with revision specific component details
Hi All.,
We are working on extracting and migration the data from Agile PLM to a different PLM system.
For this, we need to extract the BOM details for all revisions of the parts (assemblies)- with the history revisions.
We are able to get a DB extract this information, however are missing one detail – the revision of the child component.
We are looking to get the below details :
1. Parent Item Number
2.Parent Revision
3.Child Item Number
4.Child Revision (the revision value when the parent was revised)
…other BOM attributes
Any suggestions on how we can achieve this would be really appreciated !
Thanks,
Deepak
This is a common misconception with and PDM (or PLM) system. The premise of these systems is purely for design whereas systems such as your ERP would have that information as they are date sensitive to know what the configuration is of the BoM at a certain date (revisions of all component parts included). So it is there that you must look.
You can derive the revision for the component item by taking the latest one previous to the release (or effective) date of the assembly.
To get full revision BOMs from Agile, you need to get the list of assembly revisions, and process them as follows :
select <whatever you need> from bom
where ITEM = <ITEM.ID of the assembly item number>
and CHANGE_IN in (0,<change IDs for current rev and all earlier ones>)
and (CHANGE_OUT = 0 or CHANGE_OUT not in (<change IDs for current rev and all earlier ones>) );
You can also link in data from ITEM, PAGE_TWO and PAGE_THREE for the component item number, if you want.
Thanks Kevin. We are using the same query snippet you suggested to get the revision specific BOM for the assemblies.
Could you please suggest if there is a way to fetch the specific revision of the component as well along with the BOM details.
Example :
——————————-
Assembly1
Assembly_revision = A
Component1
Component1_revision = B (revision of component1 in this particular BOM structure where rev of assembly1 = A)
Component2
Component2_revision = B
——————————
Assembly1
Assembly revision = B
Component1
Component1_revision = C(revision of component1 in this particular BOM structure where rev of assembly1 = B)
Component2
Component2_revision = B
—————————————-
Thanks,
Deepak
As I said, get the release/effective date of the assembly revision you are processing, and select the latest revision of the component that is at/before the assembly release/effective date (the component revision may have been released on the same ECO/MCO that the assembly was released). That will give you the correct revision of each component part.