oracle.apps.fnd.framework.OAException

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT asb.status_code, ast.meaning FROM apps.as_statuses_b asb, apps.as_statuses_tl ast WHERE asb.status_code=:1 AND ast.language= userenv('LANG') AND asb.enabled_flag = 'Y' AND asb.opp_flag = 'Y' AND asb.opp_open_status_flag = 'Y' and asb.status_code = ast.status_code

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1039

  • via Oracle Community by user10816003, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT asb.status_code, ast.meaning FROM apps.as_statuses_b asb, apps.as_statuses_tl ast WHERE asb.status_code=:1 AND ast.language= userenv('LANG') AND asb.enabled_flag = 'Y' AND asb.opp_flag = 'Y' AND asb.opp_open_status_flag = 'Y' and asb.status_code = ast.status_code
  • via Oracle Community by 533926, 1 year ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT OpportunityEO.lead_id , OpportunityEO.last_update_date , OpportunityEO.creation_date , OpportunityEO.lead_number, OpportunityEO.customer_id
  • via Oracle Community by 492297, 2 weeks 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)
  • Stack trace

    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT asb.status_code, ast.meaning FROM apps.as_statuses_b asb, apps.as_statuses_tl ast WHERE asb.status_code=:1 AND ast.language= userenv('LANG') AND asb.enabled_flag = 'Y' AND asb.opp_flag = 'Y' AND asb.opp_open_status_flag = 'Y' and asb.status_code = ast.status_code at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3247) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3042)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    9 more bugmates