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

Solutions on the web

via Oracle Community by Harrrry, 1 year ago
po.po_approved_supplier_list psl WHERE psl.item_id=msix.inventory_item_id AND psl.using_organization_id=msix.organization_id AND EXISTS (SELECT 1 FROM po.po_asl_documents psd, po.po_headers_all pha, po.po_lines_all pla WHERE psd.asl_id=psl.asl_id
via Oracle Community by Asmirnov-Oracle, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT FTHeaderEO.HEADER_ID, FTHeaderEO.SUPPLIER, ………………………………… and NVL(op.operation_seq_num,'-99') = NVL(FTHeaderEO.operation_seq_num,'-99
via Oracle Community by Dharma_, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT ibyprvl.PAYMENT_REASON_CODE, ibyprvl.MEANING, ibyprvl.DESCRIPTION, ibyprvl.territory_code, countries.territory_short_name FROM IBY_PAYMENT_REASONS_VL
via Oracle Community by 882688, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT /* $Header: KeyFlexfield.java 120.8.12010000.3 2008/11/14 21:37:18 hgeorgi ship $ */ OTA_RESOURCE_DEFINITIONS.RESOURCE_DEFINITION_ID FLEX_CCID
via Oracle Community by Bipin Behari Sethy, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT NVL(PAA.DATE_START, PAA.DATE_PROJECTED_START) START_DATE, NVL(PAA.DATE_END, PAA.DATE_PROJECTED_END) END_DATE, PAATTL.NAME ABSENCE_TYPE
via Oracle Community by 814480, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT pc.competence_id ,pc.name ,pc.competence_alias as short_name ,pc.unit_standard_id ,qual_ctype.meaning credit_type ,pc.credits ,qual_level_type.meaning
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT
msix.item_name,
msix.description,
msix.organization_id,
msix.primary_uom_code,
msix.inventory_item_id,
msix.category_name,
msix.category_description,
msix.category_id,
msix.list_price,
msix.inv_direct_item_type,
msix.item_cost,
msix.cross_reference_type,
msix.cross_reference,
msix.description2,
mfnum.manufacturer_name,
mfnum.mfg_part_num,
(SELECT NVL((SELECT 'Item is on Blanket'
FROM po.po_approved_supplier_list psl
WHERE psl.item_id=msix.inventory_item_id
AND psl.using_organization_id=msix.organization_id
AND EXISTS (SELECT 1
FROM po.po_asl_documents psd,
po.po_headers_all pha,
po.po_lines_all pla
WHERE psd.asl_id=psl.asl_id
AND psd.document_type_code='BLANKET'
AND pha.po_header_id=psd.document_header_id
AND pha.authorization_status = 'APPROVED'
AND NVL(pha.closed_code, 'OPEN') = 'OPEN'
AND pla.po_line_id=psd.document_line_id
AND pla.item_id=psl.item_id
AND NVL(pla.closed_code, 'OPEN') = 'OPEN')
AND rownum=1),'Not on Blanket')FROM dual) Blanket
FROM
(
SELECT msik.concatenated_segments AS
item_name,
msik.description,
msik.organization_id,
msik.primary_uom_code,
msik.inventory_item_id,
mcg.category_name,
mcg.category_description,
mcg.category_id,
msik.list_price_per_unit AS
list_price,
DECODE(stock_enabled_flag, 'N', 2, 1) AS
inv_direct_item_type,
(SELECT NVL(ccicv.item_cost, 0)
FROM mtl_parameters mp,
cst_cg_item_costs_view ccicv
WHERE ccicv.organization_id = mp.organization_id
AND ccicv.organization_id = msik.organization_id
AND ccicv.inventory_item_id = msik.inventory_item_id
AND ccicv.cost_group_id = DECODE(mp.primary_cost_method, 1, 1, NVL(mp.default_cost_group_id, -1))
AND rownum <= 1)
AS
item_cost,
xref.cross_reference,
xref.cross_reference_type,
xref.description as description2
FROM mtl_system_items_vl msik LEFT OUTER JOIN
(SELECT mc.concatenated_segments AS
category_name,
mc.description AS category_description,
mc.category_id,
mic.inventory_item_id,
mic.organization_id
FROM mtl_item_categories mic,
mtl_categories_kfv mc,
mtl_category_sets mcs,
mtl_default_category_sets mdcs
WHERE mcs.category_set_id = mdcs.category_set_id
AND mdcs.functional_area_id = 2
AND mcs.structure_id = mc.structure_id
AND mic.category_set_id = mdcs.category_set_id
AND mc.category_id = mic.category_id
)
mcg ON (mcg.organization_id = msik.organization_id AND mcg.inventory_item_id = msik.inventory_item_id)
LEFT OUTER JOIN mtl_cross_references xref ON (xref.inventory_item_id = msik.inventory_item_id)
WHERE msik.bom_item_type = 4
AND(msik.eam_item_type IS NULL OR msik.eam_item_type IN(1, 3))
AND((stock_enabled_flag = 'N'
AND msik.purchasing_item_flag = 'Y'
AND msik.purchasing_enabled_flag = 'Y') OR(stock_enabled_flag = 'Y'))
AND (xref.organization_id = msik.organization_id OR xref.organization_id IS NULL)
) msix
LEFT OUTER JOIN
(SELECT mcr.cross_reference as cref, mcr.description as desc1, msi.inventory_item_id as inv1, msi.organization_id as org1,
mpn.mfg_part_num, mfg.manufacturer_name
FROM
MTL_MFG_PART_NUMBERS MPN,
MTL_MANUFACTURERS MFG,
mtl_parameters mp,
mtl_system_items_vl msi LEFT OUTER JOIN MTL_CROSS_REFERENCES mcr
ON (mcr.inventory_item_id = msi.inventory_item_id)
WHERE (mcr.description = (SELECT xref.description
FROM mtl_system_items_vl msi
LEFT OUTER JOIN MTL_CROSS_REFERENCES xref ON (msi.inventory_item_id = xref.inventory_item_id)
WHERE msi.inventory_item_id = mcr.inventory_item_id
AND ROWNUM <=1
) OR mcr.description IS NULL)
AND (mcr.organization_id = (SELECT xref.organization_id
FROM mtl_system_items_vl msi
LEFT OUTER JOIN MTL_CROSS_REFERENCES xref ON (msi.inventory_item_id = xref.inventory_item_id)
WHERE msi.inventory_item_id = mcr.inventory_item_id
AND ROWNUM <=1
) or (mcr.organization_id is NULL))
AND (mcr.cross_reference = (SELECT cross_reference
FROM mtl_system_items_vl msi
LEFT OUTER JOIN MTL_CROSS_REFERENCES xref ON (msi.inventory_item_id = xref.inventory_item_id)
WHERE msi.inventory_item_id = mcr.inventory_item_id
AND ROWNUM <=1
) OR mcr.description IS NULL)
AND MPN.MANUFACTURER_ID = MFG.MANUFACTURER_ID
AND mpn.organization_id = mp.master_organization_id
AND msi.inventory_item_id = mpn.inventory_item_id
AND mp.organization_id = msi.organization_id) mfnum
ON (((mfnum.cref = msix.cross_reference) OR (mfnum.cref IS NULL AND msix.cross_reference IS NULL))
AND ((mfnum.desc1 = msix.description2) OR (mfnum.cref IS NULL AND msix.cross_reference IS NULL))
AND mfnum.inv1 = msix.inventory_item_id
AND mfnum.org1 = msix.organization_id)) QRSLT WHERE (organization_id = :1 and inv_direct_item_type = :2 AND ( UPPER(ITEM_NAME) like UPPER(:3) AND (ITEM_NAME like :4 OR ITEM_NAME like :5 OR ITEM_NAME like :6 OR ITEM_NAME like :7)))	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.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)	at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2972)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1852)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)