Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Monday, December 28, 2009

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.

No comments: