My Oracle Support Banner

JBO-27122: SQL Error During Statement Preparation (Doc ID 2376913.1)

Last updated on JUNE 28, 2023

Applies to:

Oracle Work in Process - Version 12.2.4 and later
Information in this document applies to any platform.


When attempting to query work orders with Operation Status, the following error occurs.


JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT Entity.PO_NUMBER, Entity.ITEM_NUMBER, Entity.ITEM_DESCRIPTION, Entity.ITEM_ID, Entity.NEED_BY_DATE, Entity.PROMISED_DATE, Entity.QUANTITY_ORDERED, Entity.QUANTITY_DELIVERED, Entity.UOM, Entity.COMPONENT, Entity.PO_LINE_ID, Entity.PO_DISTRIBUTION_ID, Entity.ORGANIZATION_ID, Entity.WIP_ENTITY_ID, Entity.WIP_ENTITY_NAME, Entity.WIP_ENTITY_TYPE, Entity.WIP_LINE_CODE, Entity.WIP_LINE_ID, Entity.WIP_OPERATION_SEQ_NUM, Entity.WIP_REPETITIVE_SCHEDULE_ID, Decode(Entity.Wip_entity_type,6,to_number(null),Entity.ASSEMBLY_ITEM_ID) as ASSEMBLY_ITEM_ID, Decode(Entity.Wip_entity_type,6,null,Entity.ASSEMBLY_ITEM_NUMBER) as ASSEMBLY_ITEM_NUMBER, Decode(Entity.Wip_Entity_Type, 6,null,Entity.ASSEMBLY_DESCRIPTION) as ASSEMBLY_DESCRIPTION, Entity.ASSEMBLY_PRIMARY_UOM, Entity.ASSEMBLY_QUANTITY_ORDERED, Entity.START_DATE, Entity.STATUS, Entity.PO_HEADER_ID, Entity.PO_RELEASE_ID, Entity.PO_RELEASE_NUMBER, Entity.SUPPLIER_ITEM_NUMBER, Entity.VENDOR_ID, Entity.VENDOR_SITE_ID, Entity.RESOURCE_SEQ_NUM, Entity.QA_PLAN, Entity.VENDOR_CONTACT_ID, Entity.BASE_PO_NUM, Entity.BUYER_ID, Entity.OPERATING_UNIT_CODE, Decode (Entity.Wip_entity_type, 6, '/oracle/apps/eam/osp/webui/EAM_OSP_DETAILS_PAGE', '/oracle/apps/wip/osp/webui/OSPDetailsPG') as WO_Details_Region, Decode (Entity.Wip_entity_type, 6,426,706) as Region_Appl_ID, Entity.Work_Order_Name as WorkOrderName, Entity.OperationCompleted as OperationCompleted, Entity.OperationStatus as OperationStatus, Entity.Operation_Status_Link as OperationStatusLink, Entity.OpSeqNum as OpSeqNum FROM WIP_ICX_OSP_WORKBENCH_V Entity) QRSLT WHERE (AND ( vendor_id = :1 )) ORDER BY NEED_BY_DATE, PROMISED_DATE, PO_NUMBER


The issue can be reproduced at will with the following steps:

1. Responsibility: iSupplier Portal

2. iSupplier Portal --> Orders --> Work Orders

3. Select Operation Status as 'All' and click Go

4. Get the aforementioned error message.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.