Item Assignments Fail With Rules Exception (Doc ID 1374147.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Product Hub - Version 12.1.1 and later
Information in this document applies to any platform.
ItemImportRulesUtil.getOriginalAttributeInternalValue(ItemImportRulesUtil.java:1933)


**Checked for Currency on 02-DEC-2014**

Symptoms

Item assignments fail with the following error.

Steps
1. Assign an item to an Organization
2. The system submits a concurrent program ICP (EGO Spreadsheet Java Concurrent Program).
3. The program completes with WARNING status and Errors are showing as RULES Exception.

Error

TESTVKN43 - 801 - RULES EXCEPTION : Oracle.apps.ego.item.itemimport.rules.util.ItemImportRulesUtil.getOriginalAttributeInternalValue(ItemImportRulesUtil.java:1933)
oracle.apps.ego.item.itemimport.rules.server.ImportRluesAMImpl.getOriginalAttributeInternalValue(ImportRulesAMImpl.java:465)
oracle.apps.ego.rules.runrule.EgoRunRules.evaluateAttributeRelationship(EgoRunRules.java:1659)
Revision 0 The revision entered is for an item that does not exist in MTL_SYSTEM_ITEMS nor MTL_SYSTEM_ITEM_INTERFACE


Workaround
Disable the Business Validation Rule.

Changes

The issue began after enabling a Business Validation Rule.

Example rule setup to check the list price:

Rule name : LIST_PRICE_CONTROL
Type: Validation
Attribute group: Purchasing
Business entities: Item-Organization
Severity: Needs Approval
If expression: True
Validation condition: !changed(Purchasing.LIST_PRICE_PER_UNIT)
Explanation message: List price can not be changed, please submit change order.

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