How to add back the deleted codes in a Code Group.

[Former Member]

Hi all,

I deleted a few codes from a Code Group. When I deleted them, they disappeared from the config, but they still exist in the table QPCD with the "Record Inactive (INAKTIV)" flag as checked.

(After deletion, I saved the config, logged out and logged back in).

Now I am trying to add the same codes back into config, but the system says "An entry already exists with the same key".

1. Can i delete the entries/codes completely so that they don't show up in the table QPCD?

2. How can I add back those same codes/entries into the code group?

Note: I made sure these codes are not assigned to any of the objects.

Any help is greatly appreciated.

[former_member735520]

I am also facing same issue. Please share the solution.

[peter_atkin · Accepted solution]

Shashikanth Nallu

I seem to remember an OSS Note on this issue. Have a look there..

PeteA

[former_member735520 · Accepted solution]

can you please share the OSS Note number.

[Former Member]

Shashikanth Nallu,

This probably because of the way you have configured the catalog category(Define catalog).You have probably selected "De-activate" check box for this category.When this is selected, whenever you delete a catalog group or catalog code assigned to this category, the system will not delete this from the database and set the de-active flag for this object.This is to prevent reusing this value again.

You probably will not be able to recreate value this even if you reset this check box for the catalog category.

Regards

Narasimhan

[Former Member]

Thanks Narsimhan, I was not able to re-create the values, but I now know the reason - the values were not being deleted from the database tables as I had the "DEACTIVATE" button checked for that Catalog.