My Oracle Support Banner

R12: Supplier Tax Registration Num >20 Characters on Organization Link Causes Issues - You Have Encountered An Unexpected Error (Doc ID 2262263.1)

Last updated on SEPTEMBER 28, 2018

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle iSupplier Portal - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When entering a Tax Registration Number longer than 20 Characters, when navigating to the Tax and Reporting link and trying to make any change, i.e. update any value in the Reporting Name and save, the following error id displayed:

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

 

Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-12899: value too large for column "AP"."AP_SUPPLIERS"."VAT_REGISTRATION_NUM" (actual: 32, maximum: 20)
ORA-06512: at "APPS.ZX_TCM_BES_REGISTRATION_PVT", line 19
ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:783)
at oracle.apps.pos.supplier.webui.ByrTaxRptCO.processFormRequest(ByrTaxRptCO.java:201)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:909)
.
.
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1499)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
## Detail 0 ##
java.sql.SQLException: ORA-12899: value too large for column "AP"."AP_SUPPLIERS"."VAT_REGISTRATION_NUM" (actual: 32, maximum: 20)
ORA-06512: at "APPS.ZX_TCM_BES_REGISTRATION_PVT", line 19
ORA-06512: at line 1

 

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.