Skip to main content
D
DK_103042223-Newcomer
3-Newcomer
August 13, 2024
Solved

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

  • August 13, 2024
  • 2 replies
  • 2222 views

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.

Best answer by HelesicPetr

So you did something wrong.

Check your condition.

PetrH

2 replies

H
Hari_Vara16-Pearl
16-Pearl
August 13, 2024

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

 

HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire II
22-Sapphire II
August 20, 2024

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

 

HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire IIAnswer
22-Sapphire II
August 27, 2024

So you did something wrong.

Check your condition.

PetrH

V
vnamboodheriCommunity Manager
Community Moderator
August 20, 2024

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.

Terms & ConditionsCookie settingsAccessibility statement