Fusion PIM: Item Import Using Import Map Fails With Error FND_VS_VAL_MAX_LEN_EXCEEDED (Doc ID 1622692.1)

Last updated on JANUARY 19, 2016

Applies to:

Oracle Fusion Product Hub Cloud Service - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

The program Item Import Child failed because of an internal error.

Steps

  1. Create new import map at Root Item Class level
  2. Upload data file for Sub-Item Classes that you have created.



Error Message:
FAILURE
oracle.jbo.AttrSetValException: JBO-FND:::FND_VS_VAL_MAX_LEN_EXCEEDED: FND-3109The value Sequence generated 100000000267012.IP cannot contain more characters than the maximum allowable length 20.
oracle.jbo.rules.AbstractValidator.createAttributeException(AbstractValidator.java:1689)
oracle.jbo.rules.RulesBeanUtils.createException(RulesBeanUtils.java:393)
oracle.jbo.rules.AbstractValidator.createException(AbstractValidator.java:1068)
oracle.jbo.rules.JboAbstractValidator.createException(JboAbstractValidator.java:439)
oracle.jbo.rules.AbstractValidator.doRaiseException(AbstractValidator.java:1123)
oracle.jbo.rules.JboAbstractValidator.doRaiseException(JboAbstractValidator.java:433)
oracle.jbo.rules.AbstractValidator.raiseException(AbstractValidator.java:1112)
oracle.jbo.rules.JboAbstractValidator.raiseException(JboAbstractValidator.java:425)
oracle.jbo.rules.AbstractValidator.raiseException(AbstractValidator.java:1099)
oracle.jbo.rules.JboAbstractValidator.callValidateValueWithContext(JboAbstractValidator.java:251)
oracle.jbo.rules.JboAbstractValidator.validate(JboAbstractValidator.java:402)
oracle.jbo.rules.JboExpressionValidator.validate(JboExpressionValidator.java:181)
oracle.jbo.rules.RulesBeanUtils.validateObject(RulesBeanUtils.java:734)
oracle.jbo.rules.RulesBeanUtils.validate(RulesBeanUtils.java:714)
oracle.jbo.server.AttributeDefImpl.validate(AttributeDefImpl.java:3705)
oracle.jbo.server.AttributeDefImpl.set(AttributeDefImpl.java:3585)
oracle.jbo.server.EntityImpl.setAttributeInternal(EntityImpl.java:2241)
oracle.apps.fnd.applcore.oaext.model.OAEntityImpl.setAttribute(OAEntityImpl.java:2811)
oracle.apps.fnd.applcore.oaext.model.OAEntityImpl.setAttributeInternal(OAEntityImpl.java:2830)
oracle.apps.scm.productCatalogManagement.versions.protectedModel.entity.ChangeVersionEntityImpl.setAttributeInternalSuper(ChangeVersionEntityImpl.java:280)
oracle.apps.scm.productCatalogManagement.advancedItems.protectedModel.entity.ItemEffBaseEOImpl.setAttributeInternalSuper(ItemEffBaseEOImpl.java:599)
oracle.apps.scm.productCatalogManagement.versions.protectedModel.entity.ChangeVersionEntityImpl.setAttributeInternal(ChangeVersionEntityImpl.java:620)
oracle.apps.scm.productCatalogManagement.advancedItems.protectedModel.entity.ItemEffBaseEOImpl.setAttributeInternal(ItemEffBaseEOImpl.java:464)
oracle.jbo.server.AttributeDefImpl.resolveSet(AttributeDefImpl.java:3885)

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