Appears to be orphaned entries in PLMK

[Former Member]

Hi,

Even i have faced same kind of issue. Client was trying to create Inspection Plan with external number assignment. He used QP01 transaction to create Inspection Plan. He entered Material, Plant and Group. Then selected the usage and status and went to operations screen to define operation details. Then cliked on Inspection Charactersitics button to enter the MIC. In this it is MIC. Surprisingly, some characteristics already selected. Then he tried to save it. The transaction got terminated and issued message saying duplicated record exist. Material assignment was not done so no data apperaed MAPL but Orphaned entries exist in PLMK table.

I was just wondering how could without saving Inspection Plan system is issuing Duplicate record. Then i debugged the program and found PLFL table there is an entry.

I thought at least i could enter remaining details in the change mode of IP. Used QP02 transcation to enter the details. But Group is available.

Different tables i have checked and found enteries in PLPO, PLMK, PLAS, PFLF, and PLKZ, and last but not least PLZU.

Found enteries in all these tables. In PLMK, the characteristics are dispalyed, in rest of the tables only grop and group counter details exist.

I have tried to delete the Group and create a new one. Even that was also failed saying Group does not exist.

Has anyone come across this situation, If so, please share your experience how you had resolved this issue.

User had not created any Inspection Plan with this Group number. How come entries have come in the PLFL and in other tables

Is there any way we can resolve this issue

Regards,

Krishna mohan

[Former Member]

As per my knowledge once a group is created ,it remains in the database tables.Even if you delete the same it will remains there with deletion flag.So When you are creating something with same deleted group its only possible with new group counter number.

[Former Member]

Hi Sujit,

User has not created any Group number in Inspection Plan. He was trying to create it using QP01. Surprisingly MIC was existing for the new group. However, while he was trying to create to Group for a material system abruptly treminated and displayed message that duplicate record exist.

How is it possible? Without creating IP how could Group and group counter and MIC exist. In the investgation i found data is existing in the tables PLFL, PLPO and so on.

How can i clean up this data?