Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OAF dependant LOV

Shikhar VermaMar 19 2026 — edited Mar 19 2026

I am trying to enhance an existing visa lov by using country lov , Country is lov is passing the country code vlaue in form value Country1, and when I am trying to create a bind variable in sql and VO like this: SELECT
flv.meaning AS visatypevalue,
flv.description AS visatypedesc,
flv.attribute1 AS issuingcountrycode1
FROM
fnd_lookup_values flv
WHERE
flv.lookup_type = 'ELC_GLB_VISA_TYPES'
AND flv.language = 'US'
AND flv.enabled_flag = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(flv.start_date_active, TRUNC(SYSDATE))
AND NVL(flv.end_date_active, TRUNC(SYSDATE))
AND INSTR(
'|' || flv.attribute1 || '|',
'|' || :Country1 || '|'
) > 0

And also creating a bind variable (Country1)but still.

Second approach I am following is, I am using dyanamic where clause:

// if ("visatype".equals(lovInputSourceId))

// { String country = pageContext.getParameter("Country1");

pageContext.writeDiagnostics(this, "[TaleoCO] Country = " + country, 1);

if (country != null) {

pageContext.writeDiagnostics(this, "[ERROR] EmployeeAM fetch start", 1);

    OAApplicationModule rootAM = pageContext.getApplicationModule(webBean);

pageContext.writeDiagnostics(this, "[ERROR] EmployeeAM fetch completed", 1);

 OAApplicationModule lovAM = (OAApplicationModule)rootAM.findApplicationModule("EmployeeLovAM1");

pageContext.writeDiagnostics(this, "[ERROR] EmployeeLovAM fetch failed" + lovAM, 1);

  if (lovAM != null)

  {          OAViewObject vo = (OAViewObject)lovAM.findViewObject("VisatypeLovVO1");

   if (vo != null)          {

         String whereClause =    "INSTR('|' || attribute1 || '|','|" + country + "|') > 0";

  pageContext.writeDiagnostics(this, "\[TaleoCO\] WHERE = " + whereClause, 1);

   vo.setWhereClause(whereClause);

       pageContext.writeDiagnostics(this, "\[TaleoCO\] Query = " + vo.getQuery(), 1);

        vo.executeQuery();       }      else       {

   pageContext.writeDiagnostics(this, "\[ERROR\] VO NOT FOUND", 1);

} else { pageContext.writeDiagnostics(this, "[ERROR] LOV AM NOT FOUND", 1);

} } }

But in this approach lovam value is coming null:

Means EmployeeLovAM is not passing employeeAM.

Can suggest on this?

Comments
Post Details
Added on Mar 19 2026
13 comments
228 views