oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PoSystemParameterEO.ACCRUED_CODE_COMBINATION_ID, PoSystemParameterEO.ORG_ID, PoSystemParameterEO.PRICE_CHANGE_ALLOWANCE, PoSystemParameterEO.REQ_CAN_AUTHORIZE, PoSystemParameterEO.INSPECTION_REQUIRED_FLAG, PoSystemParameterEO.ENFORCE_PRICE_CHANGE_ALLOWANCE, PoSystemParameterEO.DEFAULT_RATE_TYPE, PoSystemParameterEO.USER_DEFINED_RECEIPT_NUM_CODE, PoSystemParameterEO.MANUAL_RECEIPT_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_QUOTE_NUM_CODE, PoSystemParameterEO.MANUAL_QUOTE_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_RFQ_NUM_CODE, PoSystemParameterEO.MANUAL_RFQ_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_PO_NUM_CODE, PoSystemParameterEO.MANUAL_PO_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_REQ_NUM_CODE, PoSystemParameterEO.MANUAL_REQ_NUM_TYPE, PoSystemParameterEO.DEFAULT_QUOTE_WARNING_DELAY, PoSystemParameterEO.ENFORCE_BUYER_AUTHORITY_FLAG, PoSystemParameterEO.ENFORCE_BUYER_NAME_FLAG, PoSystemParameterEO.ENFORCE_VENDOR_HOLD_FLAG, PoSystemParameterEO.NOTIFY_IF_BLANKET_FLAG, PoSystemParameterEO.RFQ_REQUIRED_FLAG, PoSystemParameterEO.PO_DOCUMENT_REPORT_ID, PoSystemParameterEO.PO_DOCUMENT_PRINT_FLAG, PoSystemParameterEO.RFQ_DOCUMENT_REPORT_ID, PoSystemParameterEO.RFQ_DOCUMENT_PRINT_FLAG, PoSystemParameterEO.LINE_TYPE_ID, PoSystemParameterEO.RECEIVING_FLAG, PoSystemParameterEO.ALLOW_ITEM_DESC_UPDATE_FLAG, PoSystemParameterEO.DISPOSITION_WARNING_FLAG, PoSystemParameterEO.ENFORCE_FULL_LOT_QUANTITIES, PoSystemParameterEO.SECURITY_POSITION_STRUCTURE_ID, PoSystemParameterEO.MIN_RELEASE_AMOUNT, PoSystemParameterEO.PRICE_TYPE_LOOKUP_CODE, PoSystemParameterEO.NOTIFICATION_WARNING_DELAY, PoSystemParameterEO.PRICE_BREAK_LOOKUP_CODE, PoSystemParameterEO.INVOICE_CLOSE_CODE, PoSystemParameterEO.RECEIVE_CLOSE_CODE, PoSystemParameterEO.INVOICE_CLOSE_TOLERANCE, PoSystemParameterEO.RECEIVE_CLOSE_TOLERANCE, PoSystemParameterEO.CANCEL_REQS_ON_PO_CANCEL_FLAG, PoSystemParameterEO.REQIMPORT_GROUP_BY_CODE, PoSystemParameterEO.EXPENSE_ACCRUAL_CODE, PoSystemParameterEO.INVENTORY_ACCRUAL_CODE, PoSystemParameterEO.ORDER_TYPE_ID, PoSystemParameterEO.ORDER_SOURCE_ID, PoSystemParameterEO.SALESREP_ID, PoSystemParameterEO.TERM_ID, PoSystemParameterEO.NEXT_APPROVER_LOOKUP_CODE, PoSystemParameterEO.GLOBAL_ATTRIBUTE1, PoSystemParameterEO.GLOBAL_ATTRIBUTE2, PoSystemParameterEO.GLOBAL_ATTRIBUTE3, PoSystemParameterEO.GLOBAL_ATTRIBUTE4, PoSystemParameterEO.GLOBAL_ATTRIBUTE5, PoSystemParameterEO.GLOBAL_ATTRIBUTE6, PoSystemParameterEO.GLOBAL_ATTRIBUTE7, PoSystemParameterEO.GLOBAL_ATTRIBUTE8, PoSystemParameterEO.GLOBAL_ATTRIBUTE9, PoSystemParameterEO.GLOBAL_ATTRIBUTE10, PoSystemParameterEO.GLOBAL_ATTRIBUTE11, PoSystemParameterEO.GLOBAL_ATTRIBUTE12, PoSystemParameterEO.GLOBAL_ATTRIBUTE13, PoSystemParameterEO.GLOBAL_ATTRIBUTE14, PoSystemParameterEO.GLOBAL_ATTRIBUTE15, PoSystemParameterEO.GLOBAL_ATTRIBUTE16, PoSystemParameterEO.GLOBAL_ATTRIBUTE17, PoSystemParameterEO.GLOBAL_ATTRIBUTE18, PoSystemParameterEO.GLOBAL_ATTRIBUTE19, PoSystemParameterEO.GLOBAL_ATTRIBUTE20, PoSystemParameterEO.GLOBAL_ATTRIBUTE_CATEGORY, PoSystemParameterEO.ENFORCE_PRICE_CHANGE_AMOUNT, PoSystemParameterEO.PRICE_CHANGE_AMOUNT, PoSystemParameterEO.AUTO_OFFSET_METHOD, PoSystemParameterEO.PO_OUTPUT_FORMAT, PoSystemParameterEO.BUYING_COMPANY_IDENTIFIER, PoSystemParameterEO.GAPLESS_INV_NUM_FLAG, PoSystemParameterEO.MAX_ATTACHMENT_SIZE, PoSystemParameterEO.EMAIL_ATTACHMENT_FILENAME, PoSystemParameterEO.ACCEPTANCE_REQUIRED_FLAG, ot.name as order_type, pltv.line_type, pps.name as position_structure_name FROM PO_SYSTEM_PARAMETERS_ALL PoSystemParameterEO, oe_transaction_types ot, po_line_types_val_v pltv, per_position_structures pps where PoSystemParameterEO.org_id = :1 and PoSystemParameterEO.ORDER_TYPE_ID = ot.transaction_type_id (+) and nvl(ot.po_required_flag, 'N') = 'N' and nvl(ot.agreement_required_flag, 'N') = 'N' and PoSystemParameterEO.LINE_TYPE_ID = pltv.line_type_id (+) and PoSystemParameterEO.SECURITY_POSITION_STRUCTURE_ID = pps.position_structure_id (+)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Oracle Community by fred.jiang, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PoSystemParameterEO.ACCRUED_CODE_COMBINATION_ID, PoSystemParameterEO.ORG_ID, PoSystemParameterEO.PRICE_CHANGE_ALLOWANCE
via Oracle Community by 1498181, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PoSystemParameterEO.ACCRUED_CODE_COMBINATION_ID, PoSystemParameterEO.ORG_ID, PoSystemParameterEO.PRICE_CHANGE_ALLOWANCE
via Oracle Community by 878608, 1 year ago
oracle.jbo.NoDefException: JBO-25002: Definition santos.oracle.apps.icx.icatalog.shopping.server.SantosAllSourcesVO of type View Definition not found
via Oracle Community by user5425941, 1 year ago
oracle.jbo.NoDefException: JBO-25002: Definition xxsan.oracle.apps.icx.icatalog.shopping.server.xxSanAllSourcesVO of type View Definition not found
via Oracle Community by Dan..., 1 year ago
oracle.jbo.NameClashException: JBO-25001: Le nom linelocationsMergeVOIter de type d'objet Itérateur de rowset de vue existe déjà
via Oracle Community by user12003600, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT REQUISITION_LINE_ID, REQUISITION_HEADER_ID, LINE_NUM, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PoSystemParameterEO.ACCRUED_CODE_COMBINATION_ID, PoSystemParameterEO.ORG_ID, PoSystemParameterEO.PRICE_CHANGE_ALLOWANCE, PoSystemParameterEO.REQ_CAN_AUTHORIZE, PoSystemParameterEO.INSPECTION_REQUIRED_FLAG, PoSystemParameterEO.ENFORCE_PRICE_CHANGE_ALLOWANCE, PoSystemParameterEO.DEFAULT_RATE_TYPE, PoSystemParameterEO.USER_DEFINED_RECEIPT_NUM_CODE, PoSystemParameterEO.MANUAL_RECEIPT_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_QUOTE_NUM_CODE, PoSystemParameterEO.MANUAL_QUOTE_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_RFQ_NUM_CODE, PoSystemParameterEO.MANUAL_RFQ_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_PO_NUM_CODE, PoSystemParameterEO.MANUAL_PO_NUM_TYPE, PoSystemParameterEO.USER_DEFINED_REQ_NUM_CODE, PoSystemParameterEO.MANUAL_REQ_NUM_TYPE, PoSystemParameterEO.DEFAULT_QUOTE_WARNING_DELAY, PoSystemParameterEO.ENFORCE_BUYER_AUTHORITY_FLAG, PoSystemParameterEO.ENFORCE_BUYER_NAME_FLAG, PoSystemParameterEO.ENFORCE_VENDOR_HOLD_FLAG, PoSystemParameterEO.NOTIFY_IF_BLANKET_FLAG, PoSystemParameterEO.RFQ_REQUIRED_FLAG, PoSystemParameterEO.PO_DOCUMENT_REPORT_ID, PoSystemParameterEO.PO_DOCUMENT_PRINT_FLAG, PoSystemParameterEO.RFQ_DOCUMENT_REPORT_ID, PoSystemParameterEO.RFQ_DOCUMENT_PRINT_FLAG, PoSystemParameterEO.LINE_TYPE_ID, PoSystemParameterEO.RECEIVING_FLAG, PoSystemParameterEO.ALLOW_ITEM_DESC_UPDATE_FLAG, PoSystemParameterEO.DISPOSITION_WARNING_FLAG, PoSystemParameterEO.ENFORCE_FULL_LOT_QUANTITIES, PoSystemParameterEO.SECURITY_POSITION_STRUCTURE_ID, PoSystemParameterEO.MIN_RELEASE_AMOUNT, PoSystemParameterEO.PRICE_TYPE_LOOKUP_CODE, PoSystemParameterEO.NOTIFICATION_WARNING_DELAY, PoSystemParameterEO.PRICE_BREAK_LOOKUP_CODE, PoSystemParameterEO.INVOICE_CLOSE_CODE, PoSystemParameterEO.RECEIVE_CLOSE_CODE, PoSystemParameterEO.INVOICE_CLOSE_TOLERANCE, PoSystemParameterEO.RECEIVE_CLOSE_TOLERANCE, PoSystemParameterEO.CANCEL_REQS_ON_PO_CANCEL_FLAG, PoSystemParameterEO.REQIMPORT_GROUP_BY_CODE, PoSystemParameterEO.EXPENSE_ACCRUAL_CODE, PoSystemParameterEO.INVENTORY_ACCRUAL_CODE, PoSystemParameterEO.ORDER_TYPE_ID, PoSystemParameterEO.ORDER_SOURCE_ID, PoSystemParameterEO.SALESREP_ID, PoSystemParameterEO.TERM_ID, PoSystemParameterEO.NEXT_APPROVER_LOOKUP_CODE, PoSystemParameterEO.GLOBAL_ATTRIBUTE1, PoSystemParameterEO.GLOBAL_ATTRIBUTE2, PoSystemParameterEO.GLOBAL_ATTRIBUTE3, PoSystemParameterEO.GLOBAL_ATTRIBUTE4, PoSystemParameterEO.GLOBAL_ATTRIBUTE5, PoSystemParameterEO.GLOBAL_ATTRIBUTE6, PoSystemParameterEO.GLOBAL_ATTRIBUTE7, PoSystemParameterEO.GLOBAL_ATTRIBUTE8, PoSystemParameterEO.GLOBAL_ATTRIBUTE9, PoSystemParameterEO.GLOBAL_ATTRIBUTE10, PoSystemParameterEO.GLOBAL_ATTRIBUTE11, PoSystemParameterEO.GLOBAL_ATTRIBUTE12, PoSystemParameterEO.GLOBAL_ATTRIBUTE13, PoSystemParameterEO.GLOBAL_ATTRIBUTE14, PoSystemParameterEO.GLOBAL_ATTRIBUTE15, PoSystemParameterEO.GLOBAL_ATTRIBUTE16, PoSystemParameterEO.GLOBAL_ATTRIBUTE17, PoSystemParameterEO.GLOBAL_ATTRIBUTE18, PoSystemParameterEO.GLOBAL_ATTRIBUTE19, PoSystemParameterEO.GLOBAL_ATTRIBUTE20, PoSystemParameterEO.GLOBAL_ATTRIBUTE_CATEGORY, PoSystemParameterEO.ENFORCE_PRICE_CHANGE_AMOUNT, PoSystemParameterEO.PRICE_CHANGE_AMOUNT, PoSystemParameterEO.AUTO_OFFSET_METHOD, PoSystemParameterEO.PO_OUTPUT_FORMAT, PoSystemParameterEO.BUYING_COMPANY_IDENTIFIER, PoSystemParameterEO.GAPLESS_INV_NUM_FLAG, PoSystemParameterEO.MAX_ATTACHMENT_SIZE, PoSystemParameterEO.EMAIL_ATTACHMENT_FILENAME, PoSystemParameterEO.ACCEPTANCE_REQUIRED_FLAG, ot.name as order_type, pltv.line_type, pps.name as position_structure_name FROM PO_SYSTEM_PARAMETERS_ALL PoSystemParameterEO, oe_transaction_types ot, po_line_types_val_v pltv, per_position_structures pps where PoSystemParameterEO.org_id = :1 and PoSystemParameterEO.ORDER_TYPE_ID = ot.transaction_type_id (+) and nvl(ot.po_required_flag, 'N') = 'N' and nvl(ot.agreement_required_flag, 'N') = 'N' and PoSystemParameterEO.LINE_TYPE_ID = pltv.line_type_id (+) and PoSystemParameterEO.SECURITY_POSITION_STRUCTURE_ID = pps.position_structure_id (+)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:980)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)
at oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:152)
at oracle.apps.po.setup.webui.PurchasingOptionsCO.processRequest(PurchasingOptionsCO.java:141)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:596)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1166)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2513)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1894)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:538)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:426)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.