oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT pl.requisition_header_id AS HeaderId, pl.requisition_line_id AS LineId, pl.item_description AS ItemDescription, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', pl.quantity, to_number(null)) AS Quantity, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', to_number(null), 'AMOUNT', pl.quantity, 'FIXED PRICE', decode(pl.currency_amount, null, pl.amount, pl.currency_amount)) AS Amount, decode(upper(po_line_types.order_type_lookup_code), 'AMOUNT', null, pl.currency_code) AS Currency, mtl_units_of_measure_tl.unit_of_measure_tl AS UomMeaning, po_line_types.purchase_basis AS PurchaseBasis, po_line_types.order_type_lookup_code AS ValueBasis, ph.contractor_requisition_flag AS ContractorFlag, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 1, 0) AS IsQuantityRendered, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 0, 1) AS IsAmountRendered, decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 1, 'AMOUNT', 1, 0) AS IsCurrencyRendered, decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 0, 'AMOUNT', 0, 1) AS IsUomRendered FROM po_requisition_headers_all ph, po_requisition_lines_all pl, po_line_types, mtl_units_of_measure_tl ............ ........... at RF. jspService(_RF.java:225)

Oracle Community | kkrm333 | 5 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Unable to logon to iProcurement

    Oracle Community | 5 years ago | kkrm333
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT pl.requisition_header_id AS HeaderId, pl.requisition_line_id AS LineId, pl.item_description AS ItemDescription, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', pl.quantity, to_number(null)) AS Quantity, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', to_number(null), 'AMOUNT', pl.quantity, 'FIXED PRICE', decode(pl.currency_amount, null, pl.amount, pl.currency_amount)) AS Amount, decode(upper(po_line_types.order_type_lookup_code), 'AMOUNT', null, pl.currency_code) AS Currency, mtl_units_of_measure_tl.unit_of_measure_tl AS UomMeaning, po_line_types.purchase_basis AS PurchaseBasis, po_line_types.order_type_lookup_code AS ValueBasis, ph.contractor_requisition_flag AS ContractorFlag, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 1, 0) AS IsQuantityRendered, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 0, 1) AS IsAmountRendered, decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 1, 'AMOUNT', 1, 0) AS IsCurrencyRendered, decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 0, 'AMOUNT', 0, 1) AS IsUomRendered FROM po_requisition_headers_all ph, po_requisition_lines_all pl, po_line_types, mtl_units_of_measure_tl ............ ........... at RF. jspService(_RF.java:225)
  2. 0

    JBO-26041 DMLException    - Invalid Column

    Oracle Community | 1 decade ago | 544280
    oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "BEGIN INSERT INTO SAN_SUPP_INV_HOLD_COMMENTS(IP_AUTO_LINE_ID,USER_ID,BUYERS_COMMENTS,LAST_UPDATE_LOGIN,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,USER_NAME) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9) RETURNING ROWID INTO :10; END;". . . . .
  3. 0

    JBO-25002: Definition of type ApplicationModule not found

    Oracle Community | 8 years ago | 598438
    oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25002: Definition company.oracle.apps.xxscp.lov.server.BufferStockLovAM of type ApplicationModule not found after deploying to a Quality instance. 1. Class files & XML files have been deployed . 2. I have Bounced the server as well as the oc4j container after the installation. 3. The file permissions are good . All files as well as directories have 755 . The same files work in jdeveloper and in other instances. This happens for files in a particular directory. $JAVA_TOP/<company>/oracle/apps/xxscp/lov/server All files in other directories like $JAVA_TOP/<company>/oracle/apps/xxscp/<module>/server $JAVA_TOP/<company>/oracle/apps/xxscp/<module>/webui are getting picked up. the only difference (in comparison to other instances) I found was in server.xml , which did not have the Files as entries. But then I thought server.xml is only used when you want to extend any objects. However I deleted the server.xml (bounced webserver &oc4j) and tried , still the same error. Any idea what could be wrong or Am I missing something. Thanks and Regards Hari ERROR STACK ------------
  4. Speed up your debug routine!

    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 pl.requisition_header_id AS HeaderId, pl.requisition_line_id AS LineId, pl.item_description AS ItemDescription, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', pl.quantity, to_number(null)) AS Quantity, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', to_number(null), 'AMOUNT', pl.quantity, 'FIXED PRICE', decode(pl.currency_amount, null, pl.amount, pl.currency_amount)) AS Amount, decode(upper(po_line_types.order_type_lookup_code), 'AMOUNT', null, pl.currency_code) AS Currency, mtl_units_of_measure_tl.unit_of_measure_tl AS UomMeaning, po_line_types.purchase_basis AS PurchaseBasis, po_line_types.order_type_lookup_code AS ValueBasis, ph.contractor_requisition_flag AS ContractorFlag, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 1, 0) AS IsQuantityRendered, decode(upper(po_line_types.order_type_lookup_code), 'QUANTITY', 0, 1) AS IsAmountRendered, decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 1, 'AMOUNT', 1, 0) AS IsCurrencyRendered, decode(upper(po_line_types.order_type_lookup_code), 'FIXED PRICE', 0, 'AMOUNT', 0, 1) AS IsUomRendered FROM po_requisition_headers_all ph, po_requisition_lines_all pl, po_line_types, mtl_units_of_measure_tl ............ ........... at RF. jspService(_RF.java:225)

      at com.orionserver.http.OrionHttpJspPage.service()
    2. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    3. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    4. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    5. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      1 frame
    6. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      1 frame
    7. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      1 frame
    8. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
      1 frame
    9. com.evermind.server
      AJPRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
      5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
      6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
      6 frames
    10. oracle.oc4j.network
      ServerSocketReadHandler$SafeRunnable.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      1 frame
    11. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    12. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame