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.

How to license a new product through OAM?

Here's how you can license a new product through OAM:

1. Login to OAM
2. Click on Site Map (The link near Applications Dashboard link)
3. Click on License Manager
4. Under License heading, click Products
5. Click on blue plus icon of More options
6. Click on the radio button: License Applications Product
7. Click on continue button
8. You'll get a list of all the individual products
9. Check the box on the left of the product you want to license
10. Click on Next button
11. Click on Submit button
12. You'll get a message: Sucessfully licensed the selected product(s). Click OK

That's it you are done. You may regenerate all the forms of the newly licensed product just to make sure.