oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT qfapa.list_line_id, qfapa.pricing_attribute_context, qfapa.pricing_attribute, qfapa.pricing_attr_value_from, qfapa.pricing_attr_value_to, qfapa.factor_list_id, qfapa.comparison_operator_code, qfapa.pricing_attribute_id, qfapa.creation_date, qfapa.created_by, qfapa.last_update_date, qfapa.last_updated_by, qfapa.orig_sys_header_ref, qfapa.orig_sys_line_ref, qfapa.orig_sys_pricing_attr_ref FROM qpfv_factor_asso_pricing_attrs qfapa WHERE qfapa.pricing_attribute = NVL (:2, qfapa.pricing_attribute) AND qfapa.comparison_operator_code = NVL (:3, qfapa.comparison_operator_code) AND NVL (qfapa.pricing_attr_value_from, 'xxxxx') = NVL (:4, NVL (qfapa.pricing_attr_value_from, 'xxxxx')) AND NVL (qfapa.pricing_attr_value_to, 'xxxxx') = NVL (:5, NVL (qfapa.pricing_attr_value_to, 'xxxxx'))) QRSLT WHERE (LIST_LINE_ID = :1)

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 755555, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT qfapa.list_line_id, qfapa.pricing_attribute_context, qfapa.pricing_attribute, qfapa.pricing_attr_value_from, qfapa.pricing_attr_value_to
via Oracle Community by amit.kochar-Oracle, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT csm.ship_method_code, csm.enabled_flag, fl.enabled_flag lookup_Enabled_Flag, fl.meaning FROM wsh_carrier_ship_methods csm
via Oracle Community by Siva Prasad Nidimamidi, 1 year ago
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
via Oracle Community by 452203, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: Select Header_id,Line_id from oe_order_lines_all where header_id = NVL(:1,1134)
via Oracle Community by 712742, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = :1 AND VIEW_APPLICATION_ID = :2 AND LANGUAGE = USERENV('LANG') AND ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE - 1) AND NVL(END_DATE_ACTIVE, SYSDATE + 1) AND SECURITY_GROUP_ID = 0
via Oracle Community by 1008289, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: Select template_name, template_code,application_short_name, template_type_code from xdo_templates_vl where ds_app_short_name = :1 and data_source_code = :2 and template_status= 'E' and sysdate between start_date and nvl(end_date,sysdate)
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT qfapa.list_line_id, qfapa.pricing_attribute_context, qfapa.pricing_attribute, qfapa.pricing_attr_value_from, qfapa.pricing_attr_value_to, qfapa.factor_list_id, qfapa.comparison_operator_code, qfapa.pricing_attribute_id, qfapa.creation_date, qfapa.created_by, qfapa.last_update_date, qfapa.last_updated_by, qfapa.orig_sys_header_ref, qfapa.orig_sys_line_ref, qfapa.orig_sys_pricing_attr_ref FROM qpfv_factor_asso_pricing_attrs qfapa WHERE qfapa.pricing_attribute = NVL (:2, qfapa.pricing_attribute) AND qfapa.comparison_operator_code = NVL (:3, qfapa.comparison_operator_code) AND NVL (qfapa.pricing_attr_value_from, 'xxxxx') = NVL (:4, NVL (qfapa.pricing_attr_value_from, 'xxxxx')) AND NVL (qfapa.pricing_attr_value_to, 'xxxxx') = NVL (:5, NVL (qfapa.pricing_attr_value_to, 'xxxxx'))) QRSLT WHERE (LIST_LINE_ID = :1)
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:2970)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2767)

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.