Assigning User Defined Value to UDO

[Former Member]

I have created a UDO based on Master Data and Master Data Rows.  When I try to assign a query to one of the UDFs in the UDO via the User Defined Value I get the following error, "Exclusive code already exists, 'xx'"

The xx is because depending on when I've tried this I get a different two digit number every time.  I can't seem to get it to stop erroring on any of my databases. 

Any ideas?

[former_member197621]

Hi Elizabeth,

You getting this error for all the UDO's or particular UOD ??.

Are you getting the same error for any marketing UDF??

Post your error screen ?

Based on your reply I will try to solve your issue.

[Former Member]

Prasanna,

We are currently just working with this particular UDO.  We don't get this error for any other UDF.  They all seem to be working except for in relation to this UDO.  We have even tried deleting it and starting over and creating a different query and assigning that but we still get the following error:

Exclusive code already exists, '53' [Message 173-13]

[kothandaraman_nagarajan]

Hi,

Same problem reported in,

http://scn.sap.com/thread/2070093

http://scn.sap.com/thread/3305426

Better check with SAP support.

Thanks & Regards,

Nagarajan

[former_member197621]

Hi Elizabeth,

Do the following steps ,

1. Take one backup and restore as test
2. Then run the query "delete from cshs"
3. Now try to assign the FMS
4. If its works then we can come to the conclusion problem in DB level
5. Then raise ticket to SAP
6. Please don't try the above steps in LIVE DATABASE

[Former Member]

Prasanna,

Could you explain what you mean by run the query "delete from cshs"?  What would this query look like and would I have to run it from the SQL server and not just within Query Manager in SAP?

[former_member197621]

Hi Elizabeth,

Above query will delete all the values in the cshs table. This table will have the values of the FMS.

This you can run it in query generator or SQL server

Just try it wont affect you anything , (Take a backup and restore it in different name then try)

[Former Member]

Hi Elizabeth,

Please show where the query that is being used, it must be some problem in the query.

Regards,

Marcelo Silva Santos

[Former Member]

Marcelo,

I don't think it has anything to do with the query.  The query is quite simple and is simply looking up the Inventory Items List:

SELECT T0.[ItemCode], T0.[ItemName] FROM OITM T0