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)

blogspot.com | 7 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Oracle2Me: Submitting and Monitoring Concurrent Programs from Oracle Apps Self-Service Pages

    blogspot.com | 7 months ago
    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)
  2. 0

    Facing issue when Extending two VO's

    Oracle Community | 5 years ago | 910567
    oracle.apps.fnd.framework.OAException: java.lang.ClassCastException: xxx.oracle.apps.ap.oie.server.ExtReceiptBasedLinesVOImpl incompatible with oracle.apps.ap.oie.server.ReceiptBasedLinesVOImpl
  3. 0

    How to Open JSP Page from Oracle APPS.

    Oracle Community | 4 years ago | 995114
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.lang.NullPointerException;
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    submit request using oaf page

    Oracle Community | 9 years ago | user626324
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  6. 0

    java.sql.SQLException: Invalid column index error | Oracle Community

    oracle.com | 11 months ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 122 with java object of type java.lang.String due to java.sql.SQLException.

    5 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 * 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()
    2. oracle.apps.fnd
      OAException.wrapperException
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
      2 frames