Inventory Adjustment USER_ID Length Issue (Doc ID 3047915.1)

Last updated on SEPTEMBER 19, 2024

Applies to:

Symptoms

When attempting to create Inventory adjustment with USER_ID of length more than 30 char it fails in RIHA,the following error occurs.

javax.ejb.EJBException: Error while calling Injector Service.: Exception calling plsql inject. Error from {call RMSSUB_INVADJUST.CONSUME(?,?,?,?)}: [setInParms] Inserted value too large for column: "2021072234|vraitestingthelengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlength1"
ExceptionVo{statusCode=500, status=Internal Server Error, message=Exception calling plsql inject. Error from {call RMSSUB_INVADJUST.CONSUME(?,?,?,?)}: [setInParms] Inserted value too large for column: "2021072234|vraitestingthelengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlength1", stackTrace=java.lang.RuntimeException: Exception calling plsql inject. Error from {call RMSSUB_INVADJUST.CONSUME(?,?,?,?)}: [setInParms] Inserted value too large for column: "2021072234|vraitestingthelengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlengthlength1"
at com.retek.rib.binding.subscriber.slave.PlsqlApplicationMessageInjectorServiceBean.invokeInjectForMessageType(PlsqlApplicationMessageInjectorServiceBean.java:178)
at com.retek.rib.binding.subscriber.slave.PlsqlApplicationMessageInjectorServiceBean.inject(PlsqlApplicationMessageInjectorServiceBean.java:69)
at com.oracle.retail.rib.integration.services.slave.subscriber.RemotePlsqlApplicationMessageInjectorResource.inject(RemotePlsqlApplicationMessageInjectorResource.java:50)
at sun.reflect.GeneratedMethodAccessor676.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.