JBO-27122 Error While Selecting Category From Non Catalog Request Page (Doc ID 2819846.1)

Last updated on JUNE 28, 2024

Applies to:

Symptoms

On : 12.2.10 version, Catalog Shopping

When attempting to choose category from Non Catalog Request Page
the following error occurs.

ERROR
-----------------------
JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT MtlCategoriesKfv.CATEGORY_ID,MtlCategoriesKfv.CONCATENATED_SEGMENTS AS CATEGORY_NAME,MtlCategoriesTl.DESCRIPTION AS CATEGORY_DESCRIPTION,PoCommoditiesVl.NAME AS COMMODITY_NAME,PoCommoditiesVl.COMMODITY_ID, (select threshold_amount from po_doc_type_categories pdcc where pdcc.category_id = MtlCategoriesKfv.category_id and pdcc.org_id = fnd_profile.value('ORG_ID') and pdcc.document_type_code= 'REQUISITION'and pdcc.document_subtype = 'PURCHASE' and rownum=1) category_limit FROM MTL_CATEGORIES_KFV MtlCategoriesKfv,MTL_CATEGORY_SETS MtlCategorySets,MTL_DEFAULT_CATEGORY_SETS MtlDefaultCategorySets,MTL_CATEGORIES_TL MtlCategoriesTl,PO_COMMODITIES_VL PoCommoditiesVl,PO_COMMODITY_CATEGORIES PoCommodityCategories WHERE MtlCategoriesKfv.ENABLED_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN NVL(MtlCategoriesKfv.START_DATE_ACTIVE, TRUNC(SYSDATE)) AND NVL(MtlCategoriesKfv.END_DATE_ACTIVE, TRUNC(SYSDATE)) AND MtlCategoriesTl.CATEGORY_ID = MtlCategoriesKfv.CATEGORY_ID AND MtlCategoriesTl.LANGUAGE = :1 AND MtlCategorySets.CATEGORY_SET_ID = MtlDefaultCategorySets.CATEGORY_SET_ID AND MtlDefaultCategorySets.FUNCTIONAL_AREA_ID = 2 AND MtlCategoriesKfv.STRUCTURE_ID =


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to iProcurement
2. Non Catalog Request Page
3. Choose Category LOV
4. Gets the above error 

Cause

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