Dependent Picklist/Poplist OAF

Dependent Picklist

Testing VO at design time - OAF Jdev 10G feature

In Jdev 10.1.3 we have the option to test View Object at design time.

Step1: Find the Application Module that you want to test.

Step 2:  Right click on ApplicationModule and select Test.

Step3 : Select connection Name.

 Step 4 In the Oracle Business Component Browser window, double click the EmployeeFullVO1 node to show the employees details. Navigate between the records using the Next button . You can also add or remove record of View Object from this window only.

Thanks
--Anil

java.sql.SQLException: ORA-01008: not all variables bound

In case you are setting bind variables of VO associated with Poplist/MessageChoice .You may face this error.

Suppose you have a query like this in VO

select meaning, 
lookup_code
from fwk_tbx_lookup_codes_vl
where lookup_type = 'FWK_TBX_POSITIONS'
and meaning <> :1

Cause:  

• You have not binded the View Object Query properly in any of the BC4J components(i.e. AM,VO or CO).

• You have set View Defination property of messageChoiceBean.

Action: 

•   Ensure before executing the VO query you are setting the bind variables :-

//VOImpl Code

public void initQuery()
  {
        setWhereClause(null);
        setWhereClauseParams(null);
        setWhereClauseParam(0,"Buyer");
        executeQuery();
  }

• Instead of setting the View Definition property set the View Instance property of messageChoiceBean.

Thanks
AJ