oracle.apps.fnd.framework.OAException

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select T.territory_short_name display_nls_territory, nls_territory from fnd_territories_vl T, v$nls_valid_values V where T.nls_territory = V.value and V.parameter = 'TERRITORY') QRSLT WHERE (nls_territory = :1)

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 web1033

  • via Oracle Community by 447577, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select T.territory_short_name display_nls_territory, nls_territory from fnd_territories_vl T, v$nls_valid_values V where T.nls_territory = V.value and V.parameter = 'TERRITORY') QRSLT WHERE (nls_territory = :1)
  • oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select T.territory_short_name display_nls_territory, nls_territory from fnd_territories_vl T, v$nls_valid_values V where T.nls_territory = V.value and V.parameter = 'TERRITORY') QRSLT WHERE (nls_territory = :1)
  • via Oracle Community by e630688d-de97-43ea-9d13-8a33fc0641df, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select ename from scott.emp) QRSLT WHERE (DEPTNO=:1)
  • Stack trace

    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select T.territory_short_name display_nls_territory, nls_territory from fnd_territories_vl T, v$nls_valid_values V where T.nls_territory = V.value and V.parameter = 'TERRITORY') QRSLT WHERE (nls_territory = :1) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)

    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, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    9 more bugmates