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

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 ) )).