How To Change The Standard Oracle Logo in R12 Forms?

1.- Open the file $INST_TOP/ora/10.1.2/forms/server/appsweb.cfg

2.- Check the baseHTML and baseHTMLJInitiator variables inside the file. They point to theappsbase.htm file used in the forms (ussually is the same file for both)

3.- Open the file(s) pointed by those variables

4.- Go to the "// Forms Applet Parameters" section related to the client browser you use

5.- Check if there's a line that references to "PARAM name=logo". An example of how that line mustbe for Internet Explorer is:

IEhtml += '<' + 'PARAM name=logo value="' + xlogo + '">';
add or change that line according to what you have and what you want.

6.- Go to the "// Oracle Applications default Parameters" section in the same file

7.- Add or edit the definition of xlogo variable. It must be:var xlogo = "%logo%"

8.- Save the file(s)

9.- Locate the variable "logo" in $INST_TOP/ora/10.1.2/forms/server/appsweb.cfg file at the ";Forms Server Information: servlet, port, machine name and domain" section. If it's not there thenyou can create the line. The variable must point to the .gif file you want to add on the forms.You must put the .gif file in
$OA_JAVA/oracle/apps/media
and $OA_JAVA paths and point the "logo"variable to your file with:logo=

10.- Bounce Forms and Apache servers for the changes to take effect11.- Open a new browser window on your client desktop and test the forms.

3 ways to change sysadmin password

Use the following methods to change the sysadmin password is the password is forgotten

- select APPS.fnd_web_sec.change_password('SYSADMIN','CLONE') "RES" from dual;

- FNDCPASS apps/apps 0 Y system/clone sysadmin sysadmin

- fnd_user_pkg.UPDATEUSER('SYSADMIN',CLONE,'SYSADMIN');

How to change the Corporate Branding Image System Wide in the E-business Suite (R12)

Solution 1:

1.Make a backup of the following files under $OA_MEDIA,

FNDSSCORP.gif (Oracle image)

PERBRAND.gif (Human Resources image)

2. Change the required logo with the above names and place it in the OA_MEDIA folder

3. Bounce the Apache and the changes can be observed when we login.

Ref # Oracle® Self-Service Human Resources Deploy Self-Service Capability Guide (Part No. B31648-04)

Solution 2:

1. View the file name of your image. Pay special attention to case sensitivity.
e.g. file name IMAGE.gif

2. Copy the image to the $OA_MEDIA directory on ALL middle tiers

3. Edit profile option "Corporate Branding Image for Oracle Applications" at the site level.
Assign the value of your image file
e.g. IMAGE.gif

Make sure the case is exactly as the file is named. If the file name is not entered exactly as it is named the image will be broken and will not appear.

4. Stop / Start Apache to see the change

Can the hostname and IP address for the database tier be changed?

For the database, you need to look at the tnsnames.ora, listener.ora and sqlnet.ora files, and make changes as needed (IP, Hostname, etc.). DBConsole uses a WEB URL that also includes either the hostname or IP address. Other than that, nothing else is be needed for the database. As with any change like this, it is recommended you make a good back up and then test it on another server before putting it into production.

How to change the standard Oracle logo in R12 Forms ?

To change the logo of Oracle applications perform the following steps:

1.- Open the file $INST_TOP/ora/10.1.2/forms/server/appsweb.cfg
2.- Check the baseHTML and baseHTMLJInitiator variables inside the file. They point to the appsbase.htm file used in the forms (ussually is the same file for both)
3.- Open the file(s) pointed by those variables
4.- Go to the "// Forms Applet Parameters" section related to the client browser you use
5.- Check if there's a line that references to "PARAM name=logo". An example of how that line mustbe for Internet Explorer is:IEhtml += '<' + 'PARAM name=logo value="' + xlogo + '">';
add or change that line according to what you have and what you want.

6.- Go to the "// Oracle Applications default Parameters" section in the same file

7.- Add or edit the definition of xlogo variable. It must be:var xlogo = "%logo%"

8.- Save the file(s)

9.- Locate the variable "logo" in $INST_TOP/ora/10.1.2/forms/server/appsweb.cfg file at the ";
Forms Server Information: servlet, port, machine name and domain" section. If it's not there thenyou can create the line. The variable must point to the .gif file you want to add on the forms.You must put the .gif file in $OA_JAVA/oracle/apps/media and $OA_JAVA paths and point the "logo"variable to your file with:logo=logo_file

10.- Bounce Forms and Apache servers for the changes to take effect11.- Open a new browser window on your client desktop and test the forms.

How to change Application port using autoconfig

Open the context file ($INST_TOP/apps/$CONTEXT_NAME/appl/admin/$CONTEXT_NAME.xml) and change the old port to the new port in the following seven context variables. Search for the following variables and replace the old port with the new port between their tags.

- chronosURL oa_var

- EndUserMonitoringURL

- externURL oa_var

- login_page oa_var

- httplistenparameter oa_var

- web_port oa_var

- activewebport oa_var


Now run autoconfig. You can access the Application with the new port number, next time you log in.

Change the hostname of an Applications Tier using AutoConfig

The following method can be used to change an Applications Tier hostname using AutoConfig.

- Deregister the current Applications server

as the owner of the Oracle Applications file system and current database instance runt eh following command:

perl $AD_TOP/bin/adgentns.pl appspass= \
contextfile= path-to-context-file -removeserver

If you already changed the information of your existing AutoConfig Context file and have not done the above step, then you can manually update the Net Services Topology Model using the following syntax:

Locate the System Name:
The System name is the database name
Verify with sql query:

select DB_NAME from FND_DATABASES;

Locate the server name corresponding to the tier in question:

Query on the Applications tier:

select NAME, SERVER_TYPE from FND_APP_SERVERS, FND_NODES
where FND_APP_SERVERS.NODE_ID = FND_NODES.NODE_ID and
SERVER_TYPE='APPS' and FND_NODES.NODE_NAME=upper('hostname');

Run the following PL/SQL block:

begin
FND_NET_SERVICES.remove_server(', '');
end;
/
commit;
/

- Create a new context file using the following syntax (skip this step if you have changrd the context file previously and had manually removed the tier server):

cd $APPL_TOP/admin
perl $AD_TOP/bin/adclonectx.pl contextfile=$CONTEXT_FILE

This will create a new Context file of the format _.xml in the current working directory

- Shutdown all Application services

- Reseed the Net Services Topology Model.

The Net Services Topology Model is automatically updated by running AutoConfig.

cd /bin
./adconfig.sh contextfile= path-to-context-file appspass=apps-password

- Change the machine hostname

Change the hostname at O/S level at this stage
If you use /etc/hosts ensure you remember to update the entries.

Linux Red Hat Platforms Only:

Verify that the /etc/hosts file contains entries that are similar to the following:

127.0.0.1 localhost.localdomain
ip_address node_name.domain_name

Verify that the /etc/sysconfig/network file contains an entry that is similar to the following:

HOSTNAME=node_name.domain_name

Check to see if the /etc/sysconfig/networking/profiles/default/network file exists. If it does, remove it.

If you changed any files in the previous steps, reboot the system.


- Start the Applications Tier Services

Rerun APPSORA.env and start the Applications Tier Services using the script from the new directory:

$COMMON_TOP/admin/scripts/SID_newhostname/adstrtal.sh apps

Changing the OC4J administrator account password

To change your OC4J administrator account:

1. Log in to the Application Server Control Console using your OC4Jadmin username and password.
2. Navigate to the Application Server home page and select Setup at the top of the page.

Application Server Control Console displays the Password page. Note that the User field on this page identifies which account you are modifying.

3. Enter your current OC4J password, the new password, and the new password again for confirmation.

To provide additional security, the new password:
* Must contain at least five characters, but not more than 30 characters.
* Must begin with an alphabetic character. It cannot begin with a number, the underscore (_), the dollar sign ($), or the number sign (#).
* At least one of the characters must be a number.
* Can contain only numbers, letters, and the following special characters: US dollar sign ($), number sign (#), or underscore (_).
* Cannot contain any Oracle reserved words, such as VARCHAR.

Note that these restrictions are enforced by Application Server Control and Oracle Universal Installer; they are not enforced by the OC4J system-jazn.xml or application-based security configuration files.

4. Click OK to reset the password.

The next time you log in, you must use the new password.