Sorry, but it is just not clear exactly what you have done and exactly what you are doing when you:

create new employee for XYZ department.It is assigned to the another department.

When you created the clone, what copy of your file did you clone? Are you sure that your clone is not also damaged? Ideally, you would check a back up copy by recovering it and if no problems are reported by the recover, you would then save a clone of that original back up copy. If you save a clone of the recovered file or the corrupted file, you have a greater chance that the clone is also damaged.

A screen shot of your relationships would help clarify what is linked to what.

And a step by step description of how you went about creating that new employee would also be very helpful as there are many different ways that you might have done that particular task.

When you created the clone, what copy of your file did you clone? Are you sure that your clone is not also damaged? Ideally, you would check a back up copy by recovering it and if no problems are reported by the recover, you would then save a clone of that original back up copy. If you save a clone of the recovered file or the corrupted file, you have a greater chance that the clone is also damaged.

And back to another question that I've already asked:

Now When I create status for the Job number

How, step by step, did you do that?

You can create a new record by going to a layout and selecting "new record". You can create a new record by entering data into a portal row. You can create a new record by running a script that creates the new record. Just to name a few possibilities.

So how, EXACTLY, did you do it?

What you describe could be as simple as an auto-entered serial number that has the wrong "next value setting" due to the import into clone or it could be something else.

1.I have created clone file of the original file. But this file was damaged . So I created clone file. I checked many back up files. They all are damaged. 2.I performed recovery on clone file and did not gave any errors 3.I also performed recovery on original file 4. I opened specify layout and then imported records from the recovered file manually(Use Import Record not using script). 5. After import , I have manually verified data in clone file and original file. They look fine. There is no issue with auto enter serial key. 6.I have created new record(on live environment) and it worked fine. Now some users complied that they have created new records in status database but there are not able to see it.