oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DISTINCT ship_uid, concat(concat(ship_uid,', '),ship_name) AS ship_name FROM APPS.XXFC_ASO_CNC_SHIPMENT_STAG WHERE quote_header_id =:1 ORDER BY ship_uid

Oracle Community | user11258661 | 5 years ago
  1. 0

    SQL error during statement preparation

    Oracle Community | 5 years ago | user11258661
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DISTINCT ship_uid, concat(concat(ship_uid,', '),ship_name) AS ship_name FROM APPS.XXFC_ASO_CNC_SHIPMENT_STAG WHERE quote_header_id =:1 ORDER BY ship_uid
  2. 0

    ORA-01722: INVALID NUMBER ERROR THROWN in suppliers accounting page

    cla5h.com | 7 months ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT CUSTVO.VALUE_CODE AS "ValueCode", LOVVO.NAME AS "ValueMeaning", CUSTVO.VALUE_DISPLAY_SEQUENCE AS "ValueDisplaySequence", CUSTVO.VALUE_SOURCE AS "ValueSource" FROM (SELECT FndLovChoiceValuesEO.VALUE_SOURCE, FndLovChoiceValuesEO.USER_ID, FndLovChoiceValuesEO.FULL_REF_NAME, FndLovChoiceValuesEO.VALUE_DISPLAY_SEQUENCE, FndLovChoiceValuesEO.VALUE_CODE, FndLovChoiceValuesEO.CREATED_BY, FndLovChoiceValuesEO.CREATION_DATE, FndLovChoiceValuesEO.LAST_UPDATED_BY, FndLovChoiceValuesEO.LAST_UPDATE_DATE, FndLovChoiceValuesEO.LAST_UPDATE_LOGIN FROM FND_LOV_CHOICE_VALUES FndLovChoiceValuesEO WHERE ((VALUE_SOURCE = 'USER' OR VALUE_SOURCE = 'SEEDCOPY') AND USER_ID = :1 AND FULL_REF_NAME = :2) OR (VALUE_SOURCE = 'SEED' AND FULL_REF_NAME = :3 AND NOT EXISTS(SELECT NULL FROM fnd_lov_choice_values WHERE (VALUE_SOURCE = 'USER' OR VALUE_SOURCE = 'SEEDCOPY') AND USER_ID = :4 AND FULL_REF_NAME = :5)) ORDER BY FndLovChoiceValuesEO.VALUE_DISPLAY_SEQUENCE ) CUSTVO, (select set_of_books_id, name, short_name, description, currency_code, period_set_name from gl_sets_of_books where set_of_books_id in (SELECT hou2.set_of_books_id FROM hr_operating_units hou2 WHERE mo_global.check_access(hou2.organization_id) = 'Y') ) LOVVO WHERE CUSTVO.VALUE_CODE = LOVVO.SET_OF_BOOKS_ID ORDER BY CUSTVO.VALUE_DISPLAY_SEQUENCE
  3. 0

    ORA-01722: INVALID NUMBER ERROR THROWN in suppliers accounting page

    Oracle Community | 4 years ago | user9534610
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT CUSTVO.VALUE_CODE AS "ValueCode", LOVVO.NAME AS "ValueMeaning", CUSTVO.VALUE_DISPLAY_SEQUENCE AS "ValueDisplaySequence", CUSTVO.VALUE_SOURCE AS "ValueSource" FROM (SELECT FndLovChoiceValuesEO.VALUE_SOURCE, FndLovChoiceValuesEO.USER_ID, FndLovChoiceValuesEO.FULL_REF_NAME, FndLovChoiceValuesEO.VALUE_DISPLAY_SEQUENCE, FndLovChoiceValuesEO.VALUE_CODE, FndLovChoiceValuesEO.CREATED_BY, FndLovChoiceValuesEO.CREATION_DATE, FndLovChoiceValuesEO.LAST_UPDATED_BY, FndLovChoiceValuesEO.LAST_UPDATE_DATE, FndLovChoiceValuesEO.LAST_UPDATE_LOGIN FROM FND_LOV_CHOICE_VALUES FndLovChoiceValuesEO WHERE ((VALUE_SOURCE = 'USER' OR VALUE_SOURCE = 'SEEDCOPY') AND USER_ID = :1 AND FULL_REF_NAME = :2) OR (VALUE_SOURCE = 'SEED' AND FULL_REF_NAME = :3 AND NOT EXISTS(SELECT NULL FROM fnd_lov_choice_values WHERE (VALUE_SOURCE = 'USER' OR VALUE_SOURCE = 'SEEDCOPY') AND USER_ID = :4 AND FULL_REF_NAME = :5)) ORDER BY FndLovChoiceValuesEO.VALUE_DISPLAY_SEQUENCE ) CUSTVO, (select set_of_books_id, name, short_name, description, currency_code, period_set_name from gl_sets_of_books where set_of_books_id in (SELECT hou2.set_of_books_id FROM hr_operating_units hou2 WHERE mo_global.check_access(hou2.organization_id) = 'Y') ) LOVVO WHERE CUSTVO.VALUE_CODE = LOVVO.SET_OF_BOOKS_ID ORDER BY CUSTVO.VALUE_DISPLAY_SEQUENCE
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Message Choice Error type View Definition is invalid - How to create a Picklist/Dropdownlist from scratch Using "Message Choice" type?

    Oracle Community | 2 years ago | 964919
    oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidDefNameException: JBO-25004: Definition name /xxxx/oracle/apps/ap/oie/xxchoicelist/server/xxdaicountrycityVO for type View Definition is invalid

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.apps.fnd.framework.OAException

      oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DISTINCT ship_uid, concat(concat(ship_uid,', '),ship_name) AS ship_name FROM APPS.XXFC_ASO_CNC_SHIPMENT_STAG WHERE quote_header_id =:1 ORDER BY ship_uid

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.renderDocument
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
      3. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3260)
      4. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3055)
      4 frames