Skip to main content
1-Visitor
May 18, 2017
Question

Where are the change objects that are associated with a change notice located in ORACLE?

  • May 18, 2017
  • 1 reply
  • 1248 views

I am trying to find the WT parts associated with a change notice in the Oracle database.

I created a change notice and 1 task (1 record each in WTChangeOrder/Master and WTChangeActivity/Master). There are 2 WTPart records that are linked to this task. In what table(s) are these stored? I have looked in STRUCTUREDANNOTATIONSET and SUPPORTINGDATAFOR but the records are not there. (one table has no records whatsoever; the other has none modified in the last 2 months.)

1 reply

2-Explorer
May 19, 2017

AFFECTEDACTIVITYDATA is the table you are looking for.