Hi,

I just developed below query which works for me.Please try below query.

SELECT DISTINCT c.change_number change_number
, i.item_number Parent_Item
,(SELECT n.description
FROM agile.nodetable@ebstoagile n
WHERE 1 = 1
AND n.id = r.release_type)parent_lifecycle
, r.rev_number Parent_rev
, r.old_revnumber Parent_old_rev
, s.name org
, b.item_number Child_Item
,(SELECT MAX(rev_number)
FROM agile.rev@ebstoagile rc
WHERE 1 = 1
AND rc.site = s.id
AND rc.item = b.component)child_rev
,(SELECT MAX(rc.old_revnumber)
FROM agile.rev@ebstoagile rc
WHERE 1 = 1
AND rc.site = s.id
AND rc.item = b.component)Child_old_rev
, b.quantity
, b.find_number
,(SELECT n.description
FROM agile.rev@ebstoagile r
, agile.nodetable@ebstoagile n
WHERE 1 = 1
AND r.latest_flag = ‘1’
AND r.item = b.component
AND r.site = s.id
AND n.id = r.release_type)Child_lifecycle
FROM agile.bom@ebstoagile b
, agile.item_sites@ebstoagile si
, agile.item_p2@ebstoagile i
, agile.sites@ebstoagile s
, inv.mtl_parameters mp
, agile.rev@ebstoagile r
, agile.change@ebstoagile c
, agile.item_p2@ebstoagile ip2
WHERE 1 = 1
AND ip2.item_number = b.item_number
AND c.id = r.change
AND r.site = s.id
AND((b.change_out = c.id
AND b.change_in <> c.id
AND substr(b.flags, 5, 1) = ‘0’)
OR substr(b.flags, 5, 1) = ‘1’
OR(b.change_in = c.id
AND b.change_out <> c.id
AND c.statustype IN(3, 4)
AND substr(b.flags, 5, 1) = ‘1’)
OR(b.change_in = c.id
AND b.change_out <> c.id
AND c.statustype != 3))
AND r.item = b.item
AND b.item(+) = si.item
AND si.site = s.id
AND s.name = mp.organization_code
AND si.item = i.id
AND c.change_number = :change_number
AND i.item_number = nvl(:item_number, i.item_number)
AND s.name = nvl(:site_name, s.name)
ORDER BY i.item_number
, s.name
, to_number(nvl(find_number, 0))

Thanks,

Vaibhav

Hi Ron,

Please find detail navigation below. Depending upon the class for which you want to see the attributes and get its relaterd table name and column name please follow the steps below.

Go to Java Client for your instance
>>Admin Tab
>> Classes
>>Go to the class for which you want to see attributes (e.g. File Folders >> File folders)
>> Go to User Interface Tabs
>> select the tab for which you want to see the attributes (e.g. Page Two)
>> Go to tab Attributes:Page Two
>> You can see the name of attribute same as what we have on web client (i.e. Agile front end)
>> Select the row for which attribute you want to see the table and got to Attribute column . Here you will see Table Name.Column Name where this attribute actually stored to

Thanks
Vaibhav

Finally after all the research I got the answer for my question.

We have to use INode to get the part sub class node then get it child nodes. One of child node is LifeCycle Phases, for this node you can get the child nodes which are our lifecylce associated with the part sub class.

Steps to achieve it:
1. Get part sub classs using IAgileClass
2. Get level 1 node for part sub class
3. Get all childs for level1 node in Collection object
4. Iterate through it to look for LCP
5. Get Child Nodes of  LCP in another Colleciton object and here you go

I am fairly new to Agile PLM SDK developement but I think for all configuration related data we need to refer using INode which is also stored in nodetable in database.

Thanks,
Vaibhav

Thanks Keith. Ignore warning works.

Hi , Please find below query which can be useful ( I am breaking this in seperate updates as I am not able to upload complete query at once). I just developed this query which can be executed by assembly item and give you latest released rev and lifecycle. 

Thanks
Vaibhav

HI Raju,

Please elaborate your question. Do you want changes with conflicting part for particular parts? just all conflicting changes which are not yet released ? Or do you want the parts for which there are conflicting changes in the system?

Thanks,
Vaibhav

Hi Laura,

I don’t think its possible to add pending changes for components on BOM tab. 

But report could be a good idea for this kind of requirement.

I created a query which will help you to get the pending changes related to all the components in the BOM. Pass the BOM (Assembly Item Number) and get the pending changes (if any) related to all the components at all levels (i.e. even subassemblies). Create a PX which use this query and populate result either in html, excel. and you can add this px on action menu for user to use.

WITH x AS(SELECT DISTINCT a.item parent_item_id
, a.item_number child_item
, level bom_level
, a.find_number
FROM agile.bom a START WITH(a.item =(SELECT DISTINCT i.id
FROM agile.item i
, agile.bom b
WHERE i.id = b.item
AND i.item_number = :assembly_item
)
AND nvl(a.change_out, 0)= 0
AND(substr(a.flags, 5, 1)= 1)
AND a.id NOT IN(SELECT c.prior_bom
FROM agile.bom c
WHERE c.item = a.item
))CONNECT BY PRIOR a.component = a.item
AND nvl(a.change_out, 0)= 0
AND(substr(a.flags, 5, 1)= 1)
AND a.id NOT IN(SELECT b.prior_bom
FROM agile.bom b
WHERE b.item = a.item
)
)
SELECT DISTINCT i.item_number
, c.change_number
, n.description
, r.released
FROM agile.rev r
, agile.item i
, agile.change c
, agile.nodetable n
, x
WHERE 1 = 1
AND r.released = 0
AND n.id = c.status
AND c.id = r.change
AND r.item = i.id
AND i.item_number = x.child_item;

Thanks,
Vaibhav

I am facing the same issue and planning to implement counter method as suggested by Arif to handle it. But while investigating this error found metalink which suggest this issue has been taken care in version 9.3.6 URL:Someone is working on this object. Please try again later .

I am getting the same error and I know why its causing. In my case I have Event Px which works on Update Of Cover Page for Change Order and I have another PX which create ECO update descriptipn, updatede reason, add items, redlines etc… So whenver there is update for ECO cover page other px runs simultaneously and resulting in the error.

I was just curious if this issue is really fixed in 9.3.6. Please let me know whoever is working on 9.3.6

CAUSE

CMSessionBean.logUserDefinedActionWOVersionChange(…) was locking the object and the event was not recorded correctly.
 
This is explained on the following bug：
BUG:24293677 – EVENT:UPDATE TABLE BOM/MANUFACTURERS/ATTACHMENT NOT WORKING ON IEVENTDIRTYROW
 

SOLUTION

This issue is resolved in Agile PLM 9.3.6. Upgrade to Agile PLM 9.3.6 or above.