When Attempting to Use an Extended Attribute with Qualitative Type, Receive Error, "Executing SQL Command 'insert into ExtAttrQualitativeLookup" (Doc ID 2102584.1)

Last updated on FEBRUARY 03, 2016

Applies to:

Oracle Agile Product Lifecycle Management for Process - Version 6.1.1.6 and later
Information in this document applies to any platform.

Symptoms

When attempting to use an Extended Attribute with Qualitative Type in PLM for Process, receive error: 

ERROR

Stack-Trace:

Exception: System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> Xeno.Data.DataObjectException: Error executing sql command 'insert into ExtAttrQualitativeLookup ( pkid , Comments, fkExtendedAttributeType, fkOwner, fkOwnerAlt, fkRoot ) values ( 'EXAMPLE1', N'FindIt', '2281xxxxxxxxxxx', '1004xxxxxxxx', NULL, '1004xxxxxxxxxx' )'



STEPS TO REPRODUCE

1. View ExtData Tab on Material Spec.
2. Add Extended Attribute with Qualitative Lookup type and Simple selection.

Changes

 When running the PKID migration tool, not all fields are updated correctly.

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