Delimiter in Category Segment Causes Product and Services Setup Not Completed Error and Exception ORA-06512 at POS_PRODUCT_SERVICE_UTL_PKG line 588 and line 926 (Doc ID 2081319.1)

Last updated on JUNE 08, 2017

Applies to:

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

Symptoms

In 12.1.x and 12.2.x iSupplier Portal / Supplier Lifecycle Management

Adding Products and Services during review of New Supplier Registration Request gets Unexpected Error and ORA-06512 at APPS.POS_PRODUCT_SERVICE_UTL_PKG line 588 and line 926

ERROR

Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.

Exception Details.  
oracle.apps.fnd.framework.OAException: The required setup for Product and Services to work is not complete. Please contact your system administrator.
at oracle.apps.pos.request.server.ProdSvcRequestsVORowImpl.retrieveConcatenation(ProdSvcRequestsVORowImpl.java:898)
at oracle.apps.pos.request.server.ProdSvcRequestsVORowImpl.getConcatenation(ProdSvcRequestsVORowImpl.java:851)
at oracle.apps.pos.request.server.ProdSvcRequestsVORowImpl.getAttrInvokeAccessor(ProdSvcRequestsVORowImpl.java:716)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:695)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:760)
at oracle.apps.fnd.framework.webui.OADictionaryDataRow.selectGoodValue(OADictionaryDataRow.java:204)
at oracle.apps.fnd.framework.webui.OADictionaryData.selectValue(Unknown Source)
at oracle.apps.fnd.framework.webui.OADictionaryDataRow.selectValue(OADictionaryDataRow.java:78)
at oracle.apps.fnd.framework.webui.OADataBoundValue.selectValue(OADataBoundValue.java:278)
at oracle.apps.fnd.framework.webui.OADataBoundValue.getResultValueFromDataOjbect(OADataBoundValue.java:238)
at oracle.apps.fnd.framework.webui.OADataBoundValue.getValue(OADataBoundValue.java:158)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.getAttributeValueImpl(OAWebBeanHelper.java:1844)
at oracle.apps.fnd.framework.webui.beans.message.OAMessageStyledTextBean.getAttributeValueImpl(OAMessageStyledTextBean.java:238)
at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source)
at oracle.cabo.ui.collection.UINodeAttributeMap.getAttribute(Unknown Source)
at oracle.cabo.ui.collection.AttributeMapProxy.getAttribute(Unknown Source)
...
## Detail 0 ##
java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.POS_PRODUCT_SERVICE_UTL_PKG", line 588
ORA-06512: at "APPS.POS_PRODUCT_SERVICE_UTL_PKG", line 926
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
at oracle.apps.pos.request.server.ProdSvcRequestsVORowImpl.retrieveConcatenation(ProdSvcRequestsVORowImpl.java:893)
at oracle.apps.pos.request.server.ProdSvcRequestsVORowImpl.getConcatenation(ProdSvcRequestsVORowImpl.java:851)
at oracle.apps.pos.request.server.ProdSvcRequestsVORowImpl.getAttrInvokeAccessor(ProdSvcRequestsVORowImpl.java:716)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:695)
...

STEPS TO REPRODUCE

1. Navigate to Supplier / Profile Management as buyer user
2. Click the link for New Supplier Requests in the To Do List, to review supplier registration submitted by supplier
3. Click to review the first row where Registration Purpose is Sourcing Negotiation, Status = Supplier to Provide Details
4. In Products and Services region click Create, to add products and services for this supplier
- See rows listed
5. Select the Applicable checkbox for 2 rows (005…) and (010…)
Click Next 10
6. Select the Applicable checkbox for 2 more rows (016…) and (020…)
Click Apply
- The user is returned to the review supplier registration page and the error is displayed in the Products and Services column in the Products and Services table listing for this supplier registration:
- or sometimes the unexpected error is displayed on a blank page, where the url of the page is like host.domain:port/OA_HTML/OAErrorPage.jsp

As a result, the required products and services cannot be added to supplier registration.

Cause

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