My Oracle Support Banner

Creating Smart Forms For - Non Catalog - Good Or Services Billed By Amount Errors (Doc ID 2564191.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On :  12.2.7 version, Requisition

Creating Smart Forms for - Non Catalog - Good or Services Billed by Amount is throwing exceptions  
This issue is not happening when we select Item Type: Goods 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:718)
at oracle.apps.icx.por.schema.server.LineTypeHelper.getAmountLineTypeId(LineTypeHelper.java:606)
at oracle.apps.icx.icatalog.common.webui.CatalogCO.getLineTypeFromItemType(CatalogCO.java:296)
at oracle.apps.icx.icatalog.authoring.webui.EditSmartFormCO.setLineTypeFVFromItemType(EditSmartFormCO.java:852)
## Detail 0 ##
java.sql.SQLException: Initialization failed
at oracle.sql.NUMBER.(NUMBER.java:305)
at oracle.jbo.domain.Number.(Number.java:289)
at oracle.apps.icx.por.schema.server.LineTypeHelper.getAmountLineTypeId(LineTypeHelper.java:602)
at oracle.apps.icx.icatalog.common.webui.CatalogCO.getLineTypeFromItemType(CatalogCO.java:296)
at oracle.apps.icx.icatalog.authoring.webui.EditSmartFormCO.setLineTypeFVFromItemType(EditSmartFormCO.java:852)
at oracle.apps.icx.icatalog.authoring.webui.EditSmartFormCO.handleItemTypePPR(EditSmartFormCO.java:573)
at oracle.apps.icx.icatalog.authoring.webui.EditSmartFormCO.processFormRequest(EditSmartFormCO.java:275)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:924)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: iProcurement Catalog Administration --> iProcurement Administration: Home Page. --> Stores --> Smart Forms --> Create Smart Form
2. Enter Name for Smart Form
3. Choose: Item Type - (Goods or Services billed by Amount or Services billed by Quantity) is throwing exception

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.