Steve – Would you be able to post the SQL query for date-specific BOM ? I can try and tweak it for my current requirements. 

Thanks,

Shan Maran.

Patrick – Thanks for your response. For us Agile is the System of Record and the Manufacturing BOM is maintained in Agile. It gets transmitted to ERP Systems based on the release event of the ECO via ACS. The challenge we are trying to address is building the DMR based on the effectively date.(In essence its basically a multi-level BOM explosion report along with any attributes updates for the given effectively date).

Thanks,

Shan Maran.

Arif – Appreciate your time and support. I was thinking along the same lines as the dB approach but solved it by getting the Change object and getting the cell value of the CA/Owner since its an IAgileList value and casting it as an IDataObject. Finally I get the email from :

ICell cell = doc.getCell(sowner);
ownerEmail=value1.getValue(UserConstants.ATT_GENERAL_INFO_EMAIL).toString();

This is how we have it:
/usr/java/jdk1.7.0_45/bin/java -classpath /u01/Oracle/Middleware/wlserver_12.1/server/lib/weblogic.jar:MissingFilesLocator.jar com.agile.webfs.tools.upgrade.MissingFilesLocator -dburl edinburgh:1521:agile9 -dbuserid agile -dbpassword {DBUSERID}-ifsuser ifsuser -ifspassword {iFSPASSWORD}

Praveen – Can you please expand on “auto population of certain attribute values”. If you solve it using Out of the Box solution using Agile config, that would be a preferred option. Customization can be looked into if config does not meet the requirements.

Thanks Danny. My configuration is set up correctly, however once you enter user-id/password, the screen keeps looping/throwing a JavaNull error. Planning to bounce my app servers now.
Thanks for your recommendation.