Applications System appears as Production SID after clone

Sandeep Nagpal called today. He told me that after a clone, in OAM Workflow manager screen it showed Applications System name and Workflow System name as Production SID.

I asked him to run these queries and check the values:

select applications_system_name from apps.fnd_product_groups;

select name from apps.wf_systems;

These two had production sid instead of the cloned sid.

I told Sandeep to:

1. Update the two tables with correct values

2. Stop Apache

3. rm $COMMON_TOP/_pages

4. Restart Apache.

Once he did the above 4 steps, OAM started showing the cloned system SID.