Skip to main content
3-Newcomer
Aug 13, 2024 6:22 AM UTC
Solved

We are trying to extract Windchill As-stored BOM Information from Windchill DB

Version: Windchill 11.1

 

Use Case: We are trying to Extract Windchill As-stored BOM Information from Windchill DB and Staging DB, We are not finding the BOM Child As-stored Revision in the both database.


Description:

We are trying to Extract Windchill As-stored BOM Information from Windchill DB and Staging DB, We are not finding the BOM Child As-stored Revision in the both database.
From the Windchill Database we are not able to find Child Relation between EPMASSTOREDMEMBER and EPMMEMBERLINK.

HelesicPetr
22-Sapphire II
Aug 27, 2024 6:33 AM UTC

So you did something wrong.

Check your condition.

PetrH

11 replies

16-Pearl
Aug 13, 2024 6:28 AM UTC

Hi,

As far as I know, only EPMDocument structure is by default always have a "As Stored" configuration. For BOM, there must a Baseline defined, or a Promotion Request snap shot or "As Matured" configuration (In case of Release by ECN), only if any of the 3 are there in the system , you can extract the BOM configuration as per your intent.

We can wait for other experts reply on this.

There may be some workaround through the CAD-Part link somehow.

 

Cheers

Hari

 

Translate
HelesicPetr
22-Sapphire II
Aug 20, 2024 8:20 AM UTC

Hi @Hari_Vara 

@DK_10304222 talking about the CAD BOM Structure not about the WTPart structure. 

So the CAD Structure have the as stored definition. 

@DK_10304222 

It is really not good practice to collect information directly from DB. 

If the information is not in the database then the as stored configuration does not exists.

PetrH

 

Translate
3-Newcomer
Aug 20, 2024 10:13 AM UTC

Thank you!!

 

I need a relation between EPMASSTOREDMEMBER and EPMMEMBERLINK in database.

 

Thanks

Deepa

Translate
Emeritus
Aug 20, 2024 10:02 AM UTC

Hello @DK_10304222, 

 

It looks like you have some responses from some community members. If any of these replies helped you solve your question please mark the appropriate reply as the Accepted Solution. 

Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.

Thanks,
Vivek N.
Community Moderation Team.

Translate