oracle.apps.fnd.framework.OAException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • JBO-27122: SQL error during statement preparation
    via by Bharat_Hegde,
  • VO Extension giving JBO-27122 error
    via by Rvzz,
  • Getting error in i-procurement checkout page
    via by User338888,
  • db:: 5.87::oracle.jbo.NoDefException JBO-25058 1k
    via by Unknown author,
  • "Unknown Source" Errors
    via by Unknown author,
  • Getting error while extending Region
    via by 833116,
    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select lookup_code, meaning from fnd_lookup_values where lookup_type = :1 and language = :2 and (lookup_code = 'EXPENSE' OR (lookup_code = 'INVENTORY' AND :3 = 'Y') OR (lookup_code = 'SHOP FLOOR' AND :4 = 'Y')) order by meaning asc 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)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    9 more bugmates