My Oracle Support Banner

Item Export To Excel : Error JBO-27122: SQL Error During Statement Preparation. (Doc ID 2485532.1)

Last updated on MARCH 22, 2021

Applies to:

Oracle Fusion Product Hub Cloud Service - Version 11.13.18.10.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.18.10.0 version, Item Management

Unable to export item to excel.

Error :

Export is incomplete due to error JBO-27122: SQL error during statement preparation. Statement: SELECT /*+ LEADING(ItemTextPEO) FIRST_ROWS(10) */ ItemAllPEO.ITEM_NUMBER, ItemAllPEO.APPROVAL_STATUS, ItemAllPEO.NEGATIVE_MEASUREMENT_ERROR, ItemAllPEO.ORGANIZATION_ID, ItemAllPEO.INVENTORY_ITEM_ID, ItemAllPEO.LAST_SUBMITTED_NIR_ID, ItemAllPEO.HTML_LONG_DESCRIPTION, ItemRevisionPEO.REVISION_ID, ItemClassPEO.ITEM_CLASS_CODE AS CategoryCode, ItemClassPEO.ITEM_CLASS_ID, ItemClassPEO.VERSION_ENABLED_FLAG, ItemAllPEO.ORGANIZATION_ID AS ORGANIZATION_ID5, ItemAllPEO.ORGANIZATION_ID AS ORGANIZATION_ID6, (null) AS LAST_SUBMITTED_NIR_NAME, ItemAllPEO.ATTRIBUTE_CATEGORY, ('ITEM_ENTITY') AS AttachmentEntityName, ItemAllPEO.BACK_TO_BACK_ENABLED, ItemAllPEO.CONTRACT_MANUFACTURING, ItemAllPEO.DAYS_OF_COVER, ItemAllPEO.DEMAND_PERIOD, ItemAllPEO.SAFETY_STOCK_PLANNING_METHOD, ItemAllPEO.ITEM_DEFINITION_ORG_ID, ItemAllPEO.OUTSIDE_PROCESS_SERVICE_FLAG, ItemAllPEO.ALLOW_MAINTENANCE_ASSET_FLAG, ItemAllPEO.ENABLE_GENEALOGY_TRACKING_FLAG, ItemAllPEO.COMPLETENESS_SCORE, ItemAllPEO.CSS_ENABLED_FLAG, ItemAllPEO.ENGINEERED_ITEM_FLAG, (SELECT GL.CURRENCY_CODE FROM INV_ORG_PARAMETERS IOP,FUN_ALL_BUSINESS_UNITS_V BU,GL_LEDGERS GL WHERE IOP.BUSINESS_UNIT_ID = BU.BU_ID AND BU.PRIMARY_LEDGER_ID =GL.LEDGER_ID AND IOP.ORGANIZATION_ID= ItemAllPEO.ORGANIZATION_ID) AS Currency, ItemRevisionPEO.ORGANIZATION_ID AS ORGANIZATION_ID11, ItemAllPEO.FORCE_PURCHASE_LEAD_TIME_FLAG, ItemAllPEO.REPLACEMENT_TYPE FROM EGP_SYSTEM_ITEMS_ALL_V ItemAllPEO, EGP_ITEM_REVISIONS_VL ItemRevisionPEO, EGP_ITEM_CLASSES_VL ItemClassPEO WHERE ItemAllPEO.INVENTORY_ITEM_ID = ItemRevisionPEO.INVENTORY_ITEM_ID AND ItemAllPEO.ITEM_DEFINITION_ORG_ID = ItemRevisionPEO.ORGANIZATION_ID AND ItemAllPEO.ITEM_CATALOG_GROUP_ID = ItemClassPEO.ITEM_CLASS_ID AND (( ( (UPPER(ItemAllPEO.ITEM_NUMBER) LIKE UPPER( :vc_temp_1 || '%') ) AND ( 1 = 1 ) AND (:VarOrgId1 = :VarOrgId1) AND EXISTS (SELECT /*+ PUSH_SUBQ */ 1 FROM EGP_ITEM_CLASSES_B classes WHERE classes.item_Class_id = ItemAllPEO.ITEM_CATALOG_GROUP_ID CONNECT BY PRIOR classes.ITEM_CLASS_ID = classes.PARENT_ITEM_CLASS_ID START WITH classes.ITEM_CLASS_ID = :VarItemClassId ) AND ( ( ItemAllPEO.VERSION_ID = -1 AND ItemAllPEO.ACD_TYPE = 'PROD' AND :VarRevision1 = :VarRevision1 ) AND sysdate between ItemRevisionPEO.EFFECTIVITY_DATE and NVL(ItemRevisionPEO.END_EFFECTIVITY_DATE,sysdate+1) AND ItemRevisionPEO.IMPLEMENTATION_DATE IS NOT NULL AND ItemAllPEO.TEMPLATE_ITEM_FLAG = 'N' AND NVL(ItemAllPEO.MASTER_ITEM_VERSION_ID,-1) = -1 ) AND 1=1 AND 1=1 AND (ItemOrganizationParameterPEO.ORGANIZATION_CODE = :vc_temp_2 ) AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 ) ) AND ( ( 1 = 1 ) )).

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. go to Product Information Management UI
2. Task : Manage Items
3. search Items using specific criteria
4. export to excel (error when opening excel sheet)

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!


In this Document
Symptoms
Cause
Solution
References


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