0 Replies Latest reply: Jul 8, 2014 11:07 AM by mgereis RSS

    Error when using LOV wildcard(%) in custom web ADI

    mgereis

      Hello,

      I'm getting the following error on a custom Web ADI integrator.

      There are a number of LOVs on the form, and they're all working fine except one.

      The LOV is populated correctly, however, once the wildcard (%) search is used, the following error is shown:

       

      The following error has occurred

      Exception Name: oracle.apps.bne.exception.BneSQLException -

      Error occurred when setting bind value G% on SQL Statement at index 3.

      Cause: A low level API call failed.

      Action: Please note this error to your support

      representative.

      Statement: SELECT DISTINCT alias_value_name P_ALLOWANCE_NAME,

      alias_value_id, pel.element_type_id P_ELEMENT_TYPE_ID FROM apps.HXC_ALIAS_VALUES

      hav , apps.PAY_ELEMENT_LINKS_f pel , apps.per_all_assignments_f paaf ,

      apps.per_all_people_f ppf WHERE pel.ELEMENT_TYPE_ID = hav.attribute1 AND SYSDATE

      BETWEEN paaf.EFFECTIVE_START_DATE AND paaf.EFFECTIVE_END_DATE AND paaf.person_id

      = ppf.person_id AND ppf.employee_number = :1 AND ( (paaf.business_group_id =

      pel.business_group_id AND paaf.business_group_id =

      fnd_profile.value('PER_BUSINESS_GROUP_ID') AND LINK_TO_ALL_PAYROLLS_FLAG = 'Y')

      OR (pel.payroll_id = paaf.payroll_id ) ) AND hav.ENABLED_FLAG = 'Y' AND

      hav.ATTRIBUTE3 = 'PJ' AND HAV.ATTRIBUTE4 =

      DECODE(:2,'Quantity','Q','Amount','A','@') AND TRUNC(SYSDATE) BETWEEN

      HAV.DATE_FROM AND NVL(HAV.DATE_TO,HR_GENERAL.END_OF_TIME) AND TRUNC(SYSDATE)

      BETWEEN pel.effective_start_date AND

      NVL(pel.effective_end_date,HR_GENERAL.END_OF_TIME)

      Bind values used in SQL statement: G%

      Log File Bookmark: 964273

       

       

      Please help.

       

      Thanks,

      Mina