JBO-27040 Value Category Name Error On Task: Manage Requisition Approvals (Doc ID 2160732.1)

Last updated on AUGUST 22, 2016

Applies to:

Oracle Fusion Self Service Procurement Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Self Service Procurement - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

After upgrade to Rel 11, users encounter error when go to Task: Manage Requisition Approvals.

Due to this issue, users cannot even open the screen to setup/maintain Requisition Approvals.
 

Error

Application

Value Category Name Is in (560.78 Trucks, Pallet, Hand Operated and Powered, 560.75 Trucks, Lift, Powered: Fork Lifts, etc., 560.72 Trucks, Lift,
Hand Operated, 560.69 Trucks, Hand, Two-Wheeled, 560.66 Trucks, Hand, Shelf, 559.94 Windshield Wipers, Parts and Accessor
...
...
and Tubes, Motorcycle, 863.05 Tires and Tubes, Passenger Vehicles, 863.03 Tires and Tubes, Aircraft, 560.84 Wheels, Industrial, Steel,
Pneumatic, and Rubber T, 560.81 Trucks, Platform) for field ConditionString exceeds the maximum length allowed.

 

Log files show the above error as:

[2016-05-31T14:57:04.125+00:00] [ProcurementServer_1] [ERROR] [] [oracle.adf.controller.internal.binding.TaskFlowRegionModelViewPort] [tid: [ACTIVE].ExecuteThread: '25' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: WILLISL28515] [ecid: 005D2ILJbn43z0Q5ubg8yX0002Or002YqC,0:1:2:40:2] [APP: ProcurementApp#V2.0] [DSID: 0000LK7JHGj6QPQ5ub_AiX1ND3^1004OCc] [[
oracle.jbo.PrecisionScaleValidationException: JBO-27040: Value Category Name Is in (560.78 Trucks, Pallet, Hand Operated and Powered,
...
...
Steel, Pneumatic, and Rubber T, 560.81 Trucks, Platform) for field ConditionString exceeds the maximum length allowed.
at oracle.jbo.rules.JboPrecisionScaleValidator.createAttributeException(JboPrecisionScaleValidator.java:373)
at oracle.jbo.rules.JboPrecisionScaleValidator.createAttributeException(JboPrecisionScaleValidator.java:36)
at oracle.jbo.rules.RulesBeanUtils.createException(RulesBeanUtils.java:399)
at oracle.jbo.rules.RulesBeanUtils.createException(RulesBeanUtils.java:367)
at oracle.jbo.rules.AbstractValidator.createException(AbstractValidator.java:1410)
at oracle.jbo.rules.JboAbstractValidator.createException(JboAbstractValidator.java:449)
at oracle.jbo.rules.AbstractValidator.doRaiseException(AbstractValidator.java:1453)
at oracle.jbo.rules.JboAbstractValidator.doRaiseException(JboAbstractValidator.java:443)
at oracle.jbo.rules.AbstractValidator.raiseException(AbstractValidator.java:1442)
at oracle.jbo.rules.JboAbstractValidator.raiseException(JboAbstractValidator.java:435)
at oracle.jbo.rules.AbstractValidator.raiseException(AbstractValidator.java:1429)
at oracle.jbo.rules.JboAbstractValidator.callValidateValueWithContext(JboAbstractValidator.java:279)
at oracle.jbo.rules.JboAbstractValidator.validate(JboAbstractValidator.java:412)
at oracle.jbo.rules.RulesBeanUtils.validateObject(RulesBeanUtils.java:749)
at oracle.jbo.rules.RulesBeanUtils.validate(RulesBeanUtils.java:720)
at oracle.jbo.server.AttributeDefImpl.validate(AttributeDefImpl.java:3849)
at oracle.jbo.server.AttributeDefImpl.set(AttributeDefImpl.java:3745)
at oracle.jbo.server.EntityImpl.setAttributeInternal(EntityImpl.java:2348)
at oracle.apps.fnd.applcore.oaext.model.OAEntityImpl.setAttribute(OAEntityImpl.java:3061)
at oracle.apps.fnd.applcore.oaext.model.OAEntityImpl.setAttributeInternal(OAEntityImpl.java:3097)
at oracle.jbo.server.AttributeDefImpl.resolveSet(AttributeDefImpl.java:4038)
at oracle.jbo.server.EntityImpl.setAttrInvokeAccessor(EntityImpl.java:2329)
at oracle.jbo.server.EntityImpl.setAttribute(EntityImpl.java:2256)
at oracle.jbo.server.ViewRowStorage.setAttributeValue(ViewRowStorage.java:2589)
at oracle.jbo.server.ViewRowStorage.setAttributeInternal(ViewRowStorage.java:2390)
at oracle.jbo.server.ViewRowImpl.setAttributeInternal(ViewRowImpl.java:1684)
at oracle.apps.fnd.applcore.oaext.model.OAViewRowImpl.setAttributeInternal(OAViewRowImpl.java:254)
at oracle.apps.prc.por.manageApprovalRules.uiModel.view.BasicConditionVORowImpl.setConditionString(BasicConditionVORowImpl.java:290)
at oracle.apps.prc.por.manageApprovalRules.uiModel.applicationModule.ManageApprovalRuleAMImpl.deriveAndSetConditionStringForDBCondition(ManageApprovalRuleAMImpl.java:8626)
at oracle.apps.prc.por.manageApprovalRules.uiModel.applicationModule.ManageApprovalRuleAMImpl.deriveConditionsStringForNestedDBCondition(ManageApprovalRuleAMImpl.java:8291)
at oracle.apps.prc.por.manageApprovalRules.uiModel.applicationModule.ManageApprovalRuleAMImpl.deriveConditionsStringForDBRule(ManageApprovalRuleAMImpl.java:8240)
at oracle.apps.prc.por.manageApprovalRules.uiModel.applicationModule.ManageApprovalRuleAMImpl.deriveConditionsStringsForTaskRules(ManageApprovalRuleAMImpl.java:8194)
at oracle.apps.prc.por.manageApprovalRules.uiModel.applicationModule.ManageApprovalRuleAMImpl.startRuleUpgrade(ManageApprovalRuleAMImpl.java:13255)
...
...

 

Steps To Reproduce
1. Navigator: Setup and Maintenance
2. Search and select task: Manage Requisition Approvals
3. After a short delay, application throws error.



Changes

Upgrade to Release 11.

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