Customer Form, Account Profile Issue: Profile Class Always uses DEFAULT Profile Class

(Doc ID 1083484.1)

Last updated on AUGUST 02, 2016

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to edit the Account Profile associated to a customer, to change the Profile Class, upon saving the Profile Class resets to DEFAULT. Also the log report shows the following errors:

java.sql.SQLException: Initialization failed
at oracle.sql.NUMBER.<init>(NUMBER.java:283)
at oracle.jbo.domain.Number.<init>(Number.java:316)
at oracle.apps.ar.hz.components.account.customer.server.HzPuiCustAccountEOImpl.getProfileClassId(HzPuiCustAccountEOImpl.java:4337)
at oracle.apps.ar.hz.components.account.customer.server.HzPuiCustAccountEOImpl.getAttrInvokeAccessor(HzPuiCustAccountEOImpl.java:3005)
at oracle.jbo.server.EntityImpl.getAttribute(EntityImpl.java:791)
at oracle.jbo.server.ViewRowStorage.getAttributeInternal(ViewRowStorage.java:1133)
at oracle.jbo.server.ViewRowImpl.getAttributeInternal(ViewRowImpl.java:648)
at oracle.jbo.server.ViewRowServiceImpl.getAttributeInternal(Unknown Source)
at oracle.jbo.server.ViewRowServiceImpl.getAttributeInternal(Unknown Source)
at oracle.jbo.server.OAJboViewRowImpl.getAttributeInternal(Unknown Source)
at oracle.apps.ar.hz.components.account.customer.server.HzPuiCrUpCustActVORowImpl.getProfileClassId(HzPuiCrUpCustActVORowImpl.java:1795)
at oracle.apps.ar.hz.components.account.customer.server.HzPuiCrUpCustActVORowImpl.getAttrInvokeAccessor(HzPuiCrUpCustActVORowImpl.java:2188)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:695)
at oracle.jbo.server.ViewRowImpl.getAttribute(ViewRowImpl.java:760)
at oracle.apps.fnd.framework.webui.OAWebBeanDataAttributeHelper.getValueWithoutDataTypeConversion(OAWebBeanDataAttributeHelper.java:345)

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