My Oracle Support Banner

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 OCTOBER 10, 2022

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

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
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.