Home

Is there any way to add the substances to a specification without removing the Parts and MPNs.

I have to add a few substances to a Specification without removing the Parts and MPNs used. I am trying to update it directly in DB, but not getting the proper table.

 

Thank You!!

Agile Talent Asked on August 28, 2019 in Product Governance and Compliance.
Add Comment
Cancel
2 Answer(s)

Anything linked to a Specification would be in the COMPLIANCE table. Specifications themselves are in the REGULATION table.

BE VERY CAREFUL in doing this. Use the AGILEOBJECTIDSEQUENCE to set your ID value in COMPLIANCE, and make sure you know the ID values of the specification and the substances you wish to add. Look at the other attributes in the table, and figure out what is needed to make it work. TEST it in your test environment first, and know the ID values of the records you added, so if needed, you can remove them later.

Cancel
Agile Angel Answered on August 28, 2019.

stortip

Is the AGILEOBJECTIDSEQUENCE revision specific?  Does each revision have a different AGILEOBJECTIDSEQUENCE?

on August 28, 2019.
Cancel
Add Comment
Cancel

Hi Kevin,

Thanks for your valuable response. Yes, I just updated the substance_map table and still checking if it needs to be updated anywhere else.

Thanks!!

 

Cancel
Agile Talent Answered on August 28, 2019.
Add Comment
Cancel

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.