AutoConfig could not successfully instantiate the following files: igccmprf.sql

Issue: While running autoconfig after applying R12 RUP 4 patch, we encountered the following error:

AutoConfig could not successfully instantiate the following files:

Directory: /apps/local/INSTANCE_NAME/inst/apps/CONTEXT_NAME/admin/install

igccmprf.sql INSTE8

It was crucial to get past the above error as autoconfig was being run as part of the post patching steps to propagate the changes brought into the system via this patch. However, it was relatively simple to fix this issue. The autoconfig log had the following entries:

SP2-0310: unable to open file "/apps/INSTANCE_NAME/apps/apps_st/comn/admin/install/CONTEXT_NAME/igccmprf.sql"

Some investigation revealed that this file is generated from the template file with the same name i.e. igccmprf.sql and was missing from the appl top.

Fix: Copy the file igccmprf.sql from $PATCH_TOP/igc/admin/template to $IGC_TOP/admin/template and rerun autoconfig.

Although the bigger question that needs to be answered is "why did the file not get copied by the patch?", we are at the moment content with getting past this issue and later revisit the above question to find an answer.

- Aravind Kamath Posral