My Oracle Support Banner

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

Last updated on MARCH 21, 2018

Applies to:

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

Symptoms

On : 12.2.5 version, Work Order Definition

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.


Changes

 

Cause

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

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


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