Oracle Articles: Four Technical Problems in List of Values || Oracle ADF

Saturday, September 14, 2013

Four Technical Problems in List of Values || Oracle ADF

Today i will go away from Oracle SOA to come Back to my favorite world Oracle ADF, but today i will speak about the famous bugs of list of values with input text with list of values component Exist in All Releases R2 - Oracle ADF 11.1.2.0.0,11.1.2.1.0 & 11.1.2.2.0 latest.

in Form : Auto Fire of Mandatory Validation Items in same table after Navigation out of input text with list of values.
in Form :List of values behavior in validating Entered value againest list values same as X like Y%, however i use X=Y in View Criteria.
in Table : Page Refresh after naivgation out of input text with list of values component in table mode.
in Table : Unusual behavior in Table validations while modifying old records or create insert new records.

First, i will build fast normal and small expample of list of values using latest ver 11.1.2.2.0 to show 4 main famous technical problems, some of them are bugs need work around solution to solve and others needs just few of improvements.
Resources : JDeveloper 11.1.2.2.0, Database XE, HR Schema ..

Build View Criteria under Departments View Object based on department id & name attributes.

Check Query Automatically & Give value for Display Width for the 2 attributes.

in employees View Object, create new attribute with department Name as a name.

insert the below sql statement to work in query mode and check Queryable check box & give Alias & type and finally make it Always updatable.

Create List of values under Department id under Employees View Object using new Accessor and using View Criteria created before under Departments View Object and finally choose the type to be input text with list of values.

drop Employees View object in first jsf page in view controller project as a form type.

in Department id , make auto submit = true.

in Department name , make Partial Triggers = Department id.

Drop Create insert operation of Employees View object to be used in Test operation.

always i prefere to use data source created before in integrated weblogic server & stopping Auto Syn of Jdbc/Datasource.

let us start check the form model, i pressed create insert , started to insert data of employee id, first name , …. etc , then i skipped Hire Date & job id and then tryed to enter correct value in department id and pressed tab to navigate, result below shows a bug in the release, Validation of other attributes done in unusual behavior, this type of validation expected under submit or commit process.

i made same previous step but i entered everything well and i entered in department id = 10, another strange behavior comes after LOV auto validation process to show 10 & 100 and i have to choose between them !!

Now i will make another page to test Table Model and drop same view object as a table

Now, Page Auto refresh execute once i navigate out of department id however i have ppr between department id & name !!

Now, i will try to make some changes in different rows then press create insert to show a new unusual behavior from table.

Solutions
Now, i will describe the 4 solutions until Oracle make it’s best to finish theses bugs.
1- for the First problem, you have to uncheck the mandatory check box in Employees Entity Object for attribute in same table and Enhance your page to customize Back Bean method to make the required validation in view controller layer before submit or commmit process.

2- for the second problem, i Enhanced a new work around to change department id from Number to Varchar2 Datatype and i created db trigger using lpad function (lpad(department_id,5,0)) to make all the entered values to be like 00010,00100,01000 & 10000 and then using same solution of lov will work as expected.
3- for Auto Page Refresh for Table, we have to change the Event policy in the Binding layer properites to be Non instead of ppr decided based on Partial Triggers.

4- for Table unusual behavior, i prefere to use theses 2 properites to enhance to give more control for table properites (Editing Mode = Click to Edit) & Immediate = true.