Based on a script I created years ago to correct sequence values after cloning from a production environment to a dev or test environment, numerous tables use the same sequence named AGILEOBJECTIDSEQUENCE. This includes ITEM_HISTORY.

We may not share the same version of Agile, because I cannot find “Complaints” as a class. If indeed Complaints is a class, then you will narrow it down to the subclass in order to get to the Page three attributes. In general however, multitext values are stored in the AGILE.AGILE_FLEX table. They must be referenced by the object’s ID and the attributes base ID. Here’s an example of a sub-query:

(Select Text From Agile.Agile_Flex Where Id = I.Id And Attid = 1568)

Where I.ID is the object’s ID and 1568 can be replaced with the base ID that you’re interested in.

Hope that helps a little. By the way, I doubt that Affected Items will be found in a multitext field unless that is just a term you’re using for this Complaints class. Typically Affected Items are found in the REV table on Change orders or Change Requests.  Attachments are also not in multitext attributes, but again… I’m not familiar with that class.

Svevis,

I’m not certain I can help or not, but to even start I have some questions. What is the input to this query? Are you starting with an item as the parent and providing a specific rev number? Then you want to see all its components at the time and what their rev values were?  Or are you wanting to just provide the parent number, and show ALL revs in one query result? Is this an exploded BOM you’re looking for or just top level under the parent item?

Steve

Clint, I see there’s still no answers on this. Did you find a way to do this? If not, I have questions. First, are you looking to just do a one-time operation of many parts, or are you looking to make a special version of Save-As to do this as needed, part by part? If you are looking to just recreate new versions of the parts, but with a prefix, you might just try exporting all the parts of interest, with all the applicable attributes, then update their part numbers in the excel file to include the prefix, then import them as new parts. Only you might lose is the info in the item’s history that indicates they were saved from another part.

Sabarish, If you’re using Microsoft Edge, this article info from Oracle Support may help.

CAUSE

Microsoft Edge is still not supported with Autovue for Agile PLM 21.0.1

SOLUTION

To implement the solution, please execute the following steps:

1. Upgrade to AutoVue for Agile PLM 21.0.2 or above.
   Refer to below Note to find the latest RUP available for AutoVue for Agile PLM 21.0.2:
   AutoVue 21.0.2 and AutoVue for Agile 21.0.2 RUP Releases (Doc ID 2507858.1)
   It is recommended to upgrade to the latest version of AutoVue for Agile
2. Apply the latest RUP to Agile 9.3.6.
   You may find the patch # of the latest 9.3.6 RUP from below Note:
   Note:2247729.1 ANNOUNCEMENT: Availability of Agile Release Update Packs (RUP)
3. Retest the case, and confirm you can view file using Microsoft Edge browser now

Yes and no… There are a couple of ways in the web client, but neither are all that much better than doing them individually, and the output format is pretty useless.  The best way would be to query the database directly. If you have access to do that let me know and I’ll see if I can provide a query for you.

Steve L.

I may not be the right person to answer this, but since no one else has tried…

Based on your error message (and the code in your loop), it looks like you are attempting to obsolete a value and then add a value at the very same parent index.  Actually, it looks like you’re obsoleting the parent and then trying to add a value to that parent.  If you’ve obsoleted it, the object is likely no longer valid.  You may have to do separate loops… one to obsolete,  then get the objects fresh and loop through to add what you need to.  This is not my area of expertise, but clearly you’ve altered an object and then attempting to do something with that object afterward. Is there some “refresh” command that you can instantiate somewhere within there?

Steve L.

Dear mfr5043,

To me this depends on what you’re defining as a work order.  If you’re looking to have Agile be an entry point, but have that integrated to some other system, such as Oracle EBS, then it seems to me that managing it directly in Oracle EBS may be better. If on the other hand, what you’re defining as a work order is solely entered into and managed within Agile, then that indeed does seem “easy enough”.  You could certain create custom Document objects to represent your Work orders. They could have all of the Page 3 attributes needed.  You could manage them on ECOs, create workflows for others to review or sign off, etc.  I’m not saying that integrating with other systems is impossible, but would certainly be more complex.  These are just my opinions 🙂

Regards,

Steve L.

Dear Srilatha,

You may have to be more specific with your question.  There are many tables in Agile’s database… ITEM, SITES, ITEM_SITES, BOM, REV, AGILEUSER, NODETABLE, just to name a few. What information are you looking for?  If you are looking for Items, a simple query might be as follows:

SELECT * FROM AGILE.ITEM;

There are different types of items (Documents and Parts). Each of those have their own subclasses.  The Class/Subclass names are stored within the NODETABLE. The ITEM table only carries the IDs for Class and Subclass.  That said, the subclass IDs will all be unique. If you had a subclass of parts called “Design Parts”, and you wanted to get a list of all Design Parts, your query might look like this:

SELECT I.ITEM_NUMBER FROM AGILE.ITEM I
INNER JOIN AGILE.NODETABLE N ON I.SUBCLASS = N.ID
WHERE N.DESCRIPTION = ‘Design Part’;

I hope that helps a little, but without knowing exactly what info you need, that’s about all I can give you.

Regards,

Steve L.

Dear Madhu,

I do not see the attachment that you mention. You may need to try to attach it again.  When you say that you  “want to get the current Redline BOM details”… get them where?  Do you want to see more details about the items in the redline BOM view?  Do you want to query them from the database? Are you writing some application or report that you are trying to extract them into?  Where or how exactly do you expect to see the info?

Steve