Try the Rev table.  I haven’t dived too deeply into this, but it should just be as easy as this (though I’m not sure this is pulling items that have a pending change or not):

SELECT item_number 
FROM   item i, 
       rev r 
WHERE  i.id = r.item 
       AND ( rev_number IS NULL 
              OR rev_number LIKE ‘Introductory’ ) 
       AND r.CHANGE = i.latest_released_eco

I would definitely check the Database it see if there’s anything wrong with either the ECR affected items tab or that item itself. 

Oracle Doc ID 1668825.1 might help you a bit here but the Oracle support website indicates that it could be a bunch of different issues. Try looking up the error message on the Oracle Support site and you’ll see what I’m talking about.

This can be done via groovy script though too.  

The simplified script outline would be something like:

void invokeScript(IBaseScriptObj obj) {
IAgileSession session = obj.getAgileSDKSession()

def change_list = [“ECO1234”, “ECO1235”, “ECO1236”]

change_list.each { change_number ->     //start looping through all of the change_list list of ECOs, defining each value as <change_number>
IChange change = session.getObject(IChange.OBJECT_TYPE, change_number)  //get the Change dataobject
change.approve(“mypassword”, “I’m approving this via automatic script”)    //approve it via the IRoutable Interface 
} //done looping through all of the defined ECO numbers 
}

I just tested this and it works just fine. 

There’s other ways to do this and even get your workflow routing list dynamically, but I find that if you’re doing something on such a one-off script like this, just export your list of ECOs and other Changes to Excel, use this formula to get it into the right template ( =””””&A1&”””,”) and copy the results into an arraylist like above.  

(you can use DataLoad tool with Agile?  Cool, I could never get that to work before.)

I had this issue before but I’m sure that it can be caused by a bunch of things.

In my case, we were trying to rev an item that had something like 20, 30, 40, 50+ child levels on its BOM.  Even though there weren’t any redlines on the ECO (or even MCO), the Agile-Oracle database still updates that BOM with a new Change Id.  So as Agile was trying to update the part BOM with the most recent ECO number, our DBA watched as Agile kept trying to get a BOM explosion report via SQL from the database to update.  Therefore we eventually fixed it by simplifying the BOM.  You may be having something similar due to either the large number of affected items or something weird with one or more of those affected items.  Do also run averify just in case there’s any data corruption issues that’s causing issue.

Please also see Doc ID 2214465.1 and Doc ID 2321864.1 on the Oracle website. 

Try that.  The lovely “the operation did not complete within a stipulated time” is set for 15 minutes in our system.  So if something takes longer than 15 minutes to do, Weblogic kills it and rolls the process back.

My company uses an MES that has its own bill of processes and my last company housed that information in Oracle ERP.  Agile doesn’t specifically have bills of process as a separate function though in my experience you can tinker with that idea by putting documents on a bills of material (thus for each process document/work instructions, the where used tab shows the applicable parts its used on).  I almost did something similar by creating a Process as a Document subtype to put on the part BOM or even in the relationship tab. 
I’d argue that Agile doesn’t specifically have a BOP because, in some respects, Agile is your as-planned baseline for how a product is configured, while it leaves other systems to house your as-built baseline (i.e., execution).  Hope that makes sense.

Hi Kulbhushan,

You’d want to iterate through an item’s (i.e., IItem object’s) BOM table via groovy script or convert into Java as a Java process extension.

Something like this:
IItem item = session.getObject(IItem.OBJECT_TYPE, “Part1234”)
ITable BOMtable = item.getTable(ItemConstants.TABLE_BOM)
Iterator iter = BOMtable.iterator()
while (iter.hasNext()) {
         IRow row = iter.next()
        String number = row.getValue(ItemConstants.ATT_BOM_ITEM_NUMBER)
        println number
}  //done iterating through item BOM

See the Agile 9.3.X SDK Developer Guides for more info.

Simple.  From one of my groovy scripts:

change.setValue(2002, null); //Set the Date field, in this case Base ID 2002, to null.
//you could have also written it like <change.setValue(ChangeConstants.ATT_PAGE_TWO_DATE01, null);>

Let us know if you need more help.

Try this.  I can’t take credit for this since our DBA found it after picking up this SQL query being passed from the Agile application to Oracle database (as we were diagnosing an earlier issue).  I later figured out that this is a BOM explosion report.  Use the current change ID or most recently released Change ID for the ? variable.  

SELECT DISTINCT a.id, 
                item_number, 
                find_number, 
                change_in, 
                change_out 
FROM   bom a 
START WITH ( a.item IN (SELECT DISTINCT item 
                        FROM   rev 
                        WHERE  CHANGE = ? 
                               AND item > 0) 
             AND Nvl (a.change_out, 0) = 0 
             AND ( Substr (a.flags, 5, 1) = 1 
                    OR a.change_in = ? ) 
             AND a.id NOT IN (SELECT c.prior_bom 
                              FROM   bom c 
                              WHERE  c.change_in = ?) ) 
CONNECT BY PRIOR a.component = a.item 
                 AND Nvl (a.change_out, 0) = 0 
                 AND ( Substr (a.flags, 5, 1) = 1 
                        OR a.change_in = ? ) 
ORDER  BY To_number(find_number)

I barely remember having a similar issue in the past once.  The answer has to do with the download settings in the browser settings.  That is, Chrome is probably downloading the file but you may have hidden the download bar through Chrome settings.  Check your download folder to see if that’s true and then check the browser settings.