JBO-27122: SQL Error - While Searching For Category Code In Products And Services Page
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)))
STEPS TO REPRODUCE
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