Monday, February 14, 2011

Dependent LOV in table shows invalid values

Dependent LOV in table sometimes show invalid values.
This is reproduced in Jdeveloper 11.1.1.3 and 11.1.1.4
For example lets say that there is a business rule that ‘The manager of an Employee must be from the same Department.’

To implement this we usually have a list of value for departments and a list of values for Managers that is depended from the department field. Also added dependency on ManagerId attribute to DepartmentId attribute.

I have created an updatable table with the above fields and added auto-submit and partial trigger properties

So for example (testTable.jspx)
When Department is Administration there are 2 selectable employees (189,200) for manager Id
When Department is Marketing there are 3 different selectable employees (190,201,202) for manager Id

It works correctly as long as there is no validation error in manager id field.


To reproduce the problem, do the following:

1. Select row for employee 190 that has department Marketing and type in ManagerId field the value 200.
2. Select an other row. A validation error shows for Manager Id.
3. Select again the same row and change Department to Administration. (Validation error continue to show)
4. open ManagerId LOV. The values shown are wrong (190,201,202). The ManagerId LOV is not refreshed according to Department.
5. Select or Type a value in field (i.e. 201 that is invalid) and press commit. The invalid value cleared. The row is saved to database with null value for manager id.


This issue does not reproduce in form layout (testForm.jspx) since Manager Lov always becomes null when department is changed.

It is quite confusing for the users.

Test Case:
http://adfbugs.googlecode.com/files/DependentLOVtest.zip

Still reproduce in jdeveloper 11.1.2
The workaround we found for this is in managed bean to resetValue of the LOV component in the value change listener of choise list

Friday, February 11, 2011

Jdeveloper is Ready

On the first release of jdeveloper 11, I had made a post that jdeveloper is not ready.
http://forums.oracle.com/forums/thread.jspa?messageID=2836045&#2836045

After 4 patches I feel now that jdeveloper 11.1.1.4 and ADF is ready to use for development of large scale enterprise applications.

The basic bugs have been minimized and the IDE have been stabilized.

We migrated the 46000 files (1GB) adf application to 11.1.1.4 without any serious issue apart from fixing the jazn-data.xml according to note 1288757.1 - Policy Migration of the "jazn-data.xml" File Fails Silently in JDeveloper 11.1.1.4.0.

We are also working now with java 64 bit on windows and set the following configuration :

Set in jdev.conf file (in $Middleware_Home$\jdeveloper\jdev\bin) depending on java installation path:
SetJavaHome D:\Java64\jdk1.6.0_23
AddVMOption -XX:MaxPermSize=1024M

Set in ide.conf file (in $Middleware_Home$\jdeveloper\ide\bin) depending on the available memory:

AddVMOption -Xmx2048M

AddVMOption -Xms512M

The low memory messages have been minimized.

I would like to congratulate the jdeveloper team for their work and wish the best for the future.