My Oracle Support Banner

Unexpected Error JBO-27122 and ORA-00907 On iSupplier Products And Services When Attempting To Add a Product or Service (Doc ID 1102975.1)

Last updated on MARCH 15, 2022

Applies to:

Oracle iSupplier Portal - Version 11.5.1 and later
Information in this document applies to any platform.


On 11.5.10, when attempting to add products and services for a supplier, the Products and Services in iSupplier Portal gives error JBO-27122 and ORA-00907


oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select distinct mcb.SEGMENT1 value, x.description description, psps.classification_id supplier_selection from mtl_categories_b mcb, mtl_category_set_valid_cats mcsvc, (select null description, segment1 value from MTL_CATEGORIES_B null ) x , pos_sup_products_services psps where mcb.SEGMENT1 is not null and (mcb.supplier_enabled_flag is null or mcb.supplier_enabled_flag = 'Y' or mcb.supplier_enabled_flag = 'y') and mcb.category_id = mcsvc.category_id and mcsvc.category_set_id = 2 and x.value = mcb.SEGMENT1 and mcb.SEGMENT1 = psps.SEGMENT1 (+) and psps.vendor_id (+) = :1 and psps.status (+) <> 'X'
at oracle.apps.fnd.framework.OAException.wrapperException(
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(
## Detail 0 ##
java.sql.SQLException: ORA-00907: missing right parenthesis
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.ttc7.TTIoer.processError(
at oracle.jdbc.ttc7.Oall7.receive(
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(


1. Navigate to Supplier Profile Administrator / Manage Supplier Profile
2. Query for Supplier = XXXXXXXXX
3. Click the Products and Services link
4. Click Add
5. Get the error




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

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