Dear “NewUser”, While I do not have experience with these extended attributes, I did find this documentation. I assume you’ve already found this, but thought I would provide the link just in case.

Oracle Agile Product Lifecycle Management for Process Extended Attribute Calculation Guide

Steve L.

Dear tsatz,

Not sure about roles specifically. I see that there is a USER_ROLE table, but when I query mine I get nothing. I don’t know if that’s an access issue for me, or if our Agile instance simply does not use this table. That said, roles are typically assigned to groups and users also assigned to groups. With that I can help. The following query shows how the users and user groups are associated via the USER_ASSIGNMENT table, just as Swagoto mentions above.

SELECT UG.NAME GROUP_NAME,AU.LOGINID USERNAME, AU.EMAIL, AU.TITLE
,UA.CREATED
FROM AGILE.USER_GROUP UG
INNER JOIN AGILE.USER_ASSIGNMENT UA ON UG.ID = UA.OBJECTID
INNER JOIN AGILE.AGILEUSER AU ON UA.USER_ID = AU.ID
ORDER BY UA.CREATED DESC;

Steve L.

If, as Raj suggested, this is more of a one-time case, or occasional data updates (meaning you not making a PX for someone to do this by simply clicking a button), here’s how I would deal with it. I would query the database for the items I needed to update, then either export that to excel, such that it could be imported into Agile (after manipulating data in Excel or via the query).  In many cases, I have coded my SQL query such that it also outputs the string for a SOAP Request, which can be pasted into SOAP UI to run the updates. This works real well if the attributes you’re updating are not change controlled. If they are, you’re better off importing the items onto Change orders.

Here is a made up example: Let’s say you have parts that are painted, but you have to update all the yellow parts to now be green.  Lets say the paint is stored in PAGE_THREE.LIST31. For simplicity, let’s assume I’ve looked up the list ID for yellow and it is 123456. Let’s further assume that subclass is called ‘Design Part’, and its ID is 222123

SELECT I.ITEM_NUMBER
,’Design Part’ AS SUBCLASS
,’Green’ AS COLOR
FROM AGILE.ITEM I
INNER JOIN AGILE.PAGE_THREE P3 ON I.ID = P3.ID
WHERE I.SUBCLASS = 222123
AND P3.LIST31 = 123456;

Hope this helps,

Steven

I believe that appropriate criteria could be made. The criteria itself would be set for Object Type “Change Orders”. The Attribute would be “Affected Items.Item Number” and Match If set to “Is Not Null”. Set this as required criteria in your workflow from  Pending to Submitted. The workflow status change should be allowed as long as there are affected items.  Full disclosure: I have not actually tried this.

Here’s the catch… the standard Agile functionality will not tell you anything meaningful when the criteria is not met. It will simply tell you the criteria is not met… that’s it.  It is not a true validation.

That is why, where I work, we implemented a validation PX, which checks all sorts of things like affected items are present, new revs are entered properly, items on BOMs are not obsolete, etc. It is not a small thing though. It involves a database package, a Groovy script PX, and configured objects that serve as Validation Collections and Validation Rules.  But now that it is in place we can add all the validations we need. I don’t if the source code is something I can share or not, but may be able to provide guidance if it’s something you would like to put the effort into.

Steven

Clint,

You didn’t mention if you have subclass in your import file.  As a minimum, when doing imports, you must include part number AND subclass.

Hope that helps,

Steve

I see you never got a response to this. We moved to a product called DocState by ZeroWaitState.  They had to make a customized solution for us, but by now they should have plenty of practice getting it right.

Steve L.

Here’s something else that may interest you.  While I’m not sure about your particular version of Agile, you should be able to configure such that common files open in their native apps (xlsx in Excel, docx in Word, etc.  In the Java client Admin screen, navigate to System Settings | Viewers and File. Then click on the File Association tab.  For each file type that you want the user to open in the native desktop app, simply uncheck the 2 boxes.  You can actually delete the file type entry if you wish.

Clicking on the attachment link on an object will now force a copy of the file to be downloaded to the user’s PC and open in an app they have associated with that file type.

Hope that helps,

Steve

See Oracle’s article on this topic:
AutoVue for Agile 21.0.1 (JNLP) Not Working Behind Proxy Server Using SSL (Doc ID 2262454.1)

I’m not sure what your end goal is, but if you use Sites, rather than just one Common BOM, then an item can have multiple BOMs. Within our company we have multiple organizations. Each is represented by a site.  Typically, we keep the BOMs in sync between the orgs, but that is not to say that they couldn’t be different.  Do you already take advantage of site-specific BOMs?

Sabarish,

If you want the user experience to feel more automatic, you might try trigger on status change, such as Pending to Submitted. It would likely have to be a “Pre” event rather than “Post”, depending on what types of redline changes are allowed in Submitted. If it had to be Post, you may have to give the PX permissions to make the changes.

Steve