Change a Post-Installation Job Parameter Value

To create an adapter, the post-installation job creates objects—including a Work Area and Program—inside an Adapter Area in an Adapter Domain, and installs the Work Area. These objects are created using the post-installation job parameters values that you entered when you ran the job.

Note:

If you change the values of some of these parameters after running the job, it may cause problems. The problems vary depending on which parameter you change, and are given for each parameter listed in this topic.

However, you can call the function FND_PROFILE.SAVE in SQL*Plus to change most parameters. This function takes the following parameters. You must enter single quotes around each value.

• x_name is the profile name

• x_value is the profile value that you want to set

• x_level_name is the name of the level at which the value should be set

Note:

You must set each value at the Site level. To do this, enter 'Site' for the function parameter x_level_name each time you call the function.

To call FND_PROFILE.SAVE:

1. Log in to SQL*Plus as apps.
2. At the SQL prompt, enter:

   begin
   FND_PROFILE.SAVE ('x_name''x_value' 'x_level_name');
   end;
   /

You need a line calling FND_PROFILE.SAVE for each post-installation job parameter you need to change. The function parameter values required to change each post-installation parameter are included below. When you are ready to commit the changes, enter:

commit;

The details for each post-installation job parameter are:

• Object ID Sequence. You cannot change this value.

• DB Host Name. If the Oracle LSH database moves to a different machine or the name of the current machine changes, you can call FND_PROFILE.SAVE to change the name. However, changing this value will result in subsequent adapter Work Area installations and upgrades failing when you upgrade to a new version of Oracle LSH. Provide the following function parameter values:

  FND_PROFILE.SAVE('CDR_DBHOST_NAME','New_Host_Name', 'SITE');
  

• DB Port Number. If the DB port number changes, you can call FND_PROFILE.SAVE to change it. However, changing this value will result in subsequent adapter Work Area installations and upgrades failing when you upgrade to a new version of Oracle LSH. Provide the following function parameter values:

  FND_PROFILE.SAVE('CDR_DBPORT_NUM','New_Port_Number', 'SITE');
  

• Owning Location. There are currently no restrictions in changing this parameter value. Provide the following function parameter values:

  FND_PROFILE.SAVE('OWNING_LOCATION','New_Owning_Location', 'SITE');
  

• Company ID. Never change the company ID. The company ID is part of the unique key for every object in Oracle LSH, including the adapter objects that were created by running the post-installation job. Changing this value could lead to the system not working in many places, including job execution, the user interface not listing submitted jobs, and more.