oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select distinct ffvl.flex_value,ffvl.description, mcb.category_id from fnd_flex_value_sets ffvs ,fnd_flex_values_vl ffvl, mtl_categories_b mcb,fnd_id_flex_structures_vl fifsl where ffvs.flex_value_Set_name = 'XXLSC_DELIVERY_LOCATION_CODES' and ffvs.flex_value_set_id = ffvl.flex_value_set_id and ffvl.enabled_flag = 'Y' and nvl(ffvl.end_date_active,trunc(sysdate) + 1) >= trunc(sysdate) and nvl(ffvl.flex_value,'ABC') = nvl(mcb.segment5,'ABC') and mcb.segment1||'.'||mcb.segment2 = :1 and mcb.segment3 = :2 and to_date(:3,'YYYY-MM-DD') between trunc(to_date(mcb.attribute3,'RRRR/MM/DD HH24:MI:SS')) and nvl(mcb.disable_date,to_date('31/12/4712','DD/MM/RRRR')) and mcb.segment4 = :4 --and nvl(mcb.disable_date,trunc(sysdate)+1) >= trunc(sysdate) and mcb.enabled_flag = 'Y' and mcb.structure_id = fifsl.id_flex_num and fifsl.id_flex_structure_code = 'XXLSC_CAT_LOC_RELATIONS' and fifsl.application_id = 401 and fifsl.ID_FLEX_CODE = 'MCAT' order by ffvl.description

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by Siva Prasad Nidimamidi, 1 year ago
(ffvl.flex_value,'ABC') = nvl(mcb.segment5,'ABC') and mcb.segment1||'.'||mcb.segment2 = :1 and mcb.segment3 = :2 and to_date(:3,'YYYY-MM-DD') between trunc(to_date(mcb.attribute3,'RRRR/MM/DD HH24:MI:SS')) and nvl(mcb.disable_date,to_date('31/12/4712','DD/MM/RRRR
via Oracle Community by sseth29, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT lookup_code, meaning FROM fnd_lookup_values WHERE trunc(nvl(start_date_active, SYSDATE)) <= trunc(SYSDATE) AND trunc(nvl(end_date_active, SYSDATE
via Oracle Community by sseth29, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT lookup_code, meaning FROM fnd_lookup_values WHERE trunc(nvl(start_date_active, SYSDATE)) <= trunc(SYSDATE) AND trunc(nvl(end_date_active, SYSDATE
via Oracle Community by 775215, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select decode(fnd_profile.value('BEN_DISPLAY_EMPLOYEE_NAME'),'FN',ppf.full_name, ppf.first_name||' '|| ppf.last_name) full_name
via Oracle Community by user539616, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select decode(fnd_profile.value('BEN_DISPLAY_EMPLOYEE_NAME'),'FN',ppf.full_name, ppf.first_name||' '|| ppf.last_name) full_name
via Oracle Community by sreese, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select fdfc.descriptive_flex_context_code, ffvv.flex_value, ffvv.descriptionfrom fnd_flex_values_vl ffvv, fnd_descr_flex_col_usage_vl fdfc where
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select distinct ffvl.flex_value,ffvl.description, mcb.category_id from fnd_flex_value_sets ffvs ,fnd_flex_values_vl ffvl, mtl_categories_b mcb,fnd_id_flex_structures_vl fifsl where ffvs.flex_value_Set_name = 'XXLSC_DELIVERY_LOCATION_CODES' and ffvs.flex_value_set_id = ffvl.flex_value_set_id and ffvl.enabled_flag = 'Y' and nvl(ffvl.end_date_active,trunc(sysdate) + 1) >= trunc(sysdate) and nvl(ffvl.flex_value,'ABC') = nvl(mcb.segment5,'ABC') and mcb.segment1||'.'||mcb.segment2 = :1 and mcb.segment3 = :2 and to_date(:3,'YYYY-MM-DD') between trunc(to_date(mcb.attribute3,'RRRR/MM/DD HH24:MI:SS')) and nvl(mcb.disable_date,to_date('31/12/4712','DD/MM/RRRR')) and mcb.segment4 = :4 --and nvl(mcb.disable_date,trunc(sysdate)+1) >= trunc(sysdate) and mcb.enabled_flag = 'Y' and mcb.structure_id = fifsl.id_flex_num and fifsl.id_flex_structure_code = 'XXLSC_CAT_LOC_RELATIONS' and fifsl.application_id = 401 and fifsl.ID_FLEX_CODE = 'MCAT' order by ffvl.description
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2946)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2743)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
9 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.