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 23, 2019

Applies to:

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

Symptoms


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

ERROR:

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(OAException.java:891)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:603)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1136)
...
## Detail 0 ##
java.sql.SQLException: ORA-00907: missing right parenthesis
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2566)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2963)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)



STEPS TO REPRODUCE

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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