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 laterInformation 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 |