JBO-27122: SQL Error - While Searching For Category Code In Products And Services Page

(Doc ID 2092972.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Supplier Lifecycle Management - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Registration and Onboarding

While defining Products and Services Category below error occurs upon searching for Category Code from Category LOV.


oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT 'PS:' || code ps_code, code, meaning
FROM table(pos_product_service_utl_pkg.product_service_ocv)) QRSLT
WHERE (( UPPER(CODE) like UPPER(:1) AND (CODE like :2 OR CODE like :3 OR CODE like :4 OR CODE like :5)))


The issue can be reproduced at will with the following steps:
1. Navigate to Supplier Management Administrator Responsibility -> Supplier Home Page
2. Click on Administrator -> Products and Services Category Category
3. Search for any Category Code from Category LOV
4. Shows the error mentioned.


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 hundreds of Community platforms