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 laterInformation 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)
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 |