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

Last updated on JUNE 28, 2023

Applies to:

Symptoms

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

ERROR

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


STEPS

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.

Cause

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