Hi Nagma,

There are 9-10 OOTB Large text attributes available at Page-Two and Page-Three level with Maximum length of 60000. You can rename one/multiple fields based on user needs. 

Regards,
MAK

Hi Pradeep,

Can you try to Give ‘Enforce Field Level Read’ privilege to ACS subscriber and check

Regards,
Arif

Pradeep,

You need to enable global trust between domains as mentioned in the below link. You can check the following knowledge document. 

Agile Content Services (ACS) Does Not Transfer Data to the Application Integration Architecture (AIA) Queue (Doc ID 1327459.1) in support.oracle.

The error description of Knowledge doc. matches to the one you have mentioned here.

Regards,
Arif

You can put a check for soft-deleted items. Once you load the item you can set a check using isDeleted() method. 

if (!itemobj.isDeleted()) {
//Write you logic

}
else {
objLogger.info(“Item ” + itemobj.getName() + ” is already soft-deleted.”);
}

So for the connection_URL which one you are mentioning. The load balancer URL or individual node URL.

I too have configured batch-job in similar environment which runs on hourly basis. I am using AgileSessionFactory.refreshInstance(url) for accessing the URL and in finally block i am closing the session. 

Did you follow similar approach ? 

Hi Shane,

Thanks for the info. Yes, i see this a limitation.

As a work-around what i did is, i saved a search for the creation date. Then i have written an event and configured it as a batch job which runs on hourly basis and implements the batch job. 

I think we thought alike on the work-around. Thank u so much. 

Regards,
Arif

Hi Romano,

1. The screenshot and as per your description it looks  Agile PLM for Process aka Prodika. The highest available version for the same is 6.2.0.0. This suite is used for F&B Industry majorly.  A9 is for discrete industries and mainly for Manufacturing, Hi-Tech, Medical and Automobile industries. 

Note: The current view that you see here is loaded using Hierarchy-Navigator utility. You can download it from Extensibility pack. 

2. Coming to doing impact analysis i don’t think there is an inbuilt tool, however you can query table “formulationSpec” table do a join with IngrdientSpec  to find out all the formulas and drill down their BOM details and can see if this particular Ingredient is used. 

Regards,
Arif

Hi Sujit,

Sample code is available on below URL. 
http://www.oracle.com/technetwork/indexes/samplecode/agileplm-sample-520945.html

Regards,
Arif

Based on my experience Re-start is one of the critical and necessary evil for any Agile PLM Set up. Based on my interaction with analysts and project experience so far, once in a month rolling bounce should be done.  

Along with Re-start, clear cache should also be done. You can resolve multiple generic issues and introduce performance enhancement activities during the planned re-start. 

1. Object modification errors are seen on Import most of the time when there is Stuck-threads as user or kernel level. 
2. Someone working object on Executing PXes from Action menu. (Mostly on Save as on existing Items or creating a next item version) 
3. As pointed out by Kevin, if any of your custom code is using SQL queries,  at times you see Connection pool exhaustion or DB Cursor 
3. Null pointer exceptions on object ( At times have seen user opening multiple tabs at the same time and performing data-edits) 
4. Executing A-Verify once in a month post Shutting down services keeps a tab on data issues. 
5. Also, monthly you can plan for data-purging on select tables to improve system performance.