Create Smart Form Gets Exception at oracle.apps.icx.por.common.server.ErrorUtil.handleFatalException After Changing the Line Type Value from Goods Billed by Quantity to Services Billed by Quantity (Doc ID 1633789.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle iProcurement - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In Release 12.1.3 iProcurement

Create Smart Form gets exception at oracle.apps.icx.por.common.server.ErrorUtil.handleFatalException after changing the line type value from Goods Billed by quantity to Services Billed by Quantity.

ERROR: Error Page
Exception Details. oracle.apps.fnd.framework.OAException: java.sql.SQLException: Initialization failed at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.icx.por.common.server.ErrorUtil.handleFatalException(ErrorUtil.java:667)
at oracle.apps.icx.por.schema.server.LineTypeHelper.getRateLineTypeId(LineTypeHelper.java:574)
at oracle.apps.icx.icatalog.common.webui.CatalogCO.getLineTypeFromItemType(CatalogCO.java:290)
at oracle.apps.icx.icatalog.authoring.webui.EditSmartFormCO.setLineTypeFVFromItemType(EditSmartFormCO.java:807)
...
## Detail 0 ## java.sql.SQLException: Initialization failed at oracle.sql.NUMBER.(NUMBER.java:298) at oracle.jbo.domain.Number.(Number.java:289)
at oracle.apps.icx.por.schema.server.LineTypeHelper.getRateLineTypeId(LineTypeHelper.java:570)
at oracle.apps.icx.icatalog.common.webui.CatalogCO.getLineTypeFromItemType(CatalogCO.java:290)
at oracle.apps.icx.icatalog.authoring.webui.EditSmartFormCO.setLineTypeFVFromItemType(EditSmartFormCO.java:807)
at oracle.apps.icx.icatalog.authoring.webui.EditSmartFormCO.handleItemTypePPR(EditSmartFormCO.java:528)
at oracle.apps.icx.icatalog.authoring.webui.EditSmartFormCO.processFormRequest(EditSmartFormCO.java:250)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:819)


STEPS TO REPRODUCE
1. Navigate to iProcurement Catalog Administration
2. Go to Stores
3. Smart Forms - Click on Create Smart Forms, Before typing anything see the page displayed
4. Change the line type / item type from Goods Billed by quantity to Services Billed by Quantity - exception occurs

BUSINESS IMPACT
Users are not able to create Smart Form for other line types than Goods Billed by Quantity.

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