Cannot Open Report or Form Within Reports or Forms Builder 10.1.2.3 (MS Windows Vista)

Developer Suite has been installed successfully on a MS Windows Vista system.To meet the MS Windows Vista certification this instructions were followed. On trying to open or to compile a reports module file (RDF) in Reports Builder, the Builder crashes.Opening a Forms module file (FMB) in the Forms Builder crashes the Builder.Error(s)Windows Vista complains there has been a problem in Reports Builder and is trying to work it out.But eventually, it states that Reports Builder is going to be closed.

This is because despite applying patchset 10.1.2.3 there are still issues in the 10.1.0.5 DB client causing the crashes.
Apply
Patch 7047034 ORACLE 10G 10.1.0.5 Patch 26 BUG FOR WINDOWS 32 BIT
to the ORACLE_HOME of the Developer Suite installation.

The patch can be downloaded from Metalink's PATCHES section doing a SIMPLE SEARCH for patch number 7047034 and platform MS Windows (32-bit).
Follow the instructions of the patch readme carefully.

Standard manager fails to start

A concurrent program that had its basepath defined wrong when it was registered was submitted. which caused the standard manager to crash. and since the concurrent program was in the standard manager queue, the manager would crash as soon as the concurrent managers are restarted since the program is executed as soon as the concurrent managers are online. None of the log files reported any error except in the manager log of the deactivated processes ( of the standard manager) in the front end. all of the deactivated processes log's contained the request ID of the concurrent program.

The solution was to remove the concurrent program from the queue and correct the basepath of the concurrent program under the system administrator -> applications -> register to the correct custom top path as in the OS level and restart the concurrent managers.

RMAN Restore and recovery scenarios

Test Case1:
1. Startup the database in nomount mode
sql> startup nomount
2. Restore the control file from the backup you want to restore
RMAN> set DBID=XXXXXXXXXX
RMAN> restore controlfile from '/backups/rman/ctlback'
3. Mount the database
SQL> startup mount;
4. Find out the max sequence of the archive file and restore max+1 as its an incomplete recovery,
You can find it either using RMAN or through SQL,
RMAN> list backup of archivelog all;
SQL> set serverout on;
SQL> set num 50;
SQL> select sequence#,NEXT_CHANGE# from v$archived_log order by next_change# desc;
5. Restore and recover the database upto the archive log we have,
RMAN>
run
{
set until sequence 2337;
restore database;
recover database;
sql 'alter database open resetlogs';
}

Test Case 2:
Move the datafile tx_data7.dbf to another name after shutting down the database
2. startup the database, you will get the following error
ORA-01113: file 33 needs media recovery
ORA-01110: data file 33: '/u01/oracle/visndata/tx_data7.dbf'
3. Offline the datafile and open the database
4. Restore it using RMAN as follows,
RMAN> restore datafile 44;
or
SQL> alter database datafile '/u01/oracle/visndata/tx_data7.dbf' online;
alter database datafile '/u01/oracle/visndata/tx_data7.dbf' online
*
ERROR at line 1:
ORA-01113: file 33 needs media recovery
ORA-01110: data file 33: '/u01/oracle/visndata/tx_data7.dbf'
SQL>
SQL> recover datafile '/u01/oracle/visndata/tx_data7.dbf';
Media recovery complete.
SQL> alter database datafile '/u01/oracle/visndata/tx_data7.dbf' online;
Database altered.

Test Case: 3
Restore of datafiles from a full hot backup and complete recovery
RMAN offline or online database backup
Target database mode: Archivelog

Loss: All current datafiles have been lost. Current controlfiles and redo logs are still available.
Requirement: Restore and complete recovery
This example simulates the loss of the current database datafiles.
The current controlfile and redo logs are still intact.
Target database mode: Database mounted
RMAN> run {
restore database;
recover database;
sql "alter database open";
}

Notes:
Archived logs will be restored automatically as required.It is possible, but not necessary, to manually restore from an archivelog backupset

Test Case: 4
Restore of datafiles from a full hot backup and complete recovery
RMAN offline or online database backup
Target database mode: Archivelog
Loss: All current datafiles have been lost, current and inactive redolog groups member has been lost, controlfiles are also lost
Requirement: Restore and complete recovery of control files and open the database with resetlogs
select FIRST_CHANGE#,sequence# from v$archived_log order by FIRST_CHANGE# desc;
In our example we restored the control file from an incremental backup, but the latest archive log sequence is 70 and which is available on the disk, so in order for a complete recovery we need
RMAN> catalog archivelog '/u01/arch/NGIND_arch_70_1_672703990.arc';
cataloged archive log
archive log filename=/u01/arch/NGIND_arch_70_1_672703990.arc recid=4 stamp=678426497
Target database mode: Database mounted
RMAN> list archivelog all;
RMAN> run {
restore database;
recover database;
sql "alter database open resetlogs";
}

Notes:
Archived logs will be restored automatically as required if they are cataloged.It is possible, but not necessary, to manually restore from an archivelog backupset

Test Case: 5
Restore of datafiles from a full hot backup and complete recovery
RMAN offline or online database backup
Target database mode: Archivelog
Loss: All current datafiles have been lost, inactive and one current redo log is lost, current file is still available
Requirement: Restore and complete recovery of control files and open the database with resetlogs
RMAN> run {
restore database;
recover database;
sql "alter database open resetlogs";
}
Notes:
Archived logs will be restored automatically as required if they are cataloged.It is possible, but not necessary, to manually restore from an archivelog backupset

How To Relink A Single Executable Via ADADMIN

How to regenerate a single executable using ADADMIN utility?

1. Run adadmin and answer the standard startup questions; see Oracle Applications Maintenance Utilities Release 11i 11.5.10 (Part No. B13586-01): "Running AD Utilities". At the AD Administration Main Menu select the option: Maintain Applications Files menu

2. At the Maintain Applications Files menu select the option: Relink Applications programs

3. At the prompt "Do you wish to proceed with the relink [Yes] ?" Hit return for the default option.

4. At the prompt "Enter the name of your Oracle Applications environment file below. File name [*.env] : " Hit return for the default option or correct the file if necessary.

5. At the prompt "Enter list of products to link ('all' for all products) [all] :" enter the product's short name associated with the target executable, such as "fnd".

6. At the prompt "Generate specific executables for each selected product [No] ?" enter Yes

7. At the prompt "Relink with debug information [No] ?" Hit return for the default option.

8. At the prompt "Enter executables to relink, or enter 'all' [all] :" the exact name of the executable to be relinked.

How to uninstall backout rollback an Oracle Applications 11i Patch

How to backout rollback an Oracle Applications 11i Patch

There is no automated method of backing out patches.
This can be a really complex operation which depends on the patch complexity and sometime the mostreasonable suggestion is to restore from a backup.

Main Advices :
- In all cases before applying a large number of patches, a series of mini-packs, family packs, ora maintenance pack, back up the Oracle Applications file system and database.

- You should always test the application of a patch several times on a test system, particularlyif the patch is a mini-pack, family pack, or maintenance pack. Once the test application issuccessful, apply the patch on the production system.

- Determine the cause of the failure.In many cases, the issue can be resolved and the patching process restarted at the point of failure.

If you are not able to solve the issue for the patch application, you have to consider 2 cases :
- Backing out the files from the APPL_TOP
- Backing out the Database actions

How to Remove an Oracle Applications 11i node

How to remove an Oracle E-Business suite Apps tier node.

T0 remove a node requires the node is deregistered from the Net Services Topology Data Model in one of the following cases:

* To delete an application tier
* The Database is upgraded/migrated resulting in a change in one of the following parameters:
o Database Host
o Database Port
o Database Name
o Database SID

The tier should be deregistered before the tier is decommissioned.

How to deregister an application tier from the Net Services Topology Data Model?
To deregister the current application tier from the Net Sevices Topology Data Model, invoke the following command:

perl /bin/adgentns.pl appspass= contextfile= -removeserver

How To Quick Solve This Post Clone Error : RC-50004, AC-00005: No write permissions for creating the Context file - /tmp/temp.xml ?

On R12 (or 11i) , while executing 'perl adcfgclone.pl', we are facing the error as following:

Target System Display [testerp:0.0] : RC-50004: Error occurred in CloneContext: AC-00005: No write permissions for creating the Context file - /tmp/temp.xml Raised by oracle.apps.ad.context.AppsContext Check Clone Context logfile /oracle/Test/Application/apps/apps_st/comn/clone/bin /CloneContext_06151127.log for details.

ERROR: Context creation not completed successfully. For additional details review the file /tmp/adcfgclone_4796.err if present.

Apps user does not have write permissions on /tmp directory.
1- Give write permission to apps user on "/tmp" directory.
Example :
As root:
# chmod 777 /tmp
# ls -al grep tmp
drwxrwxrwx 11 root root 4096 Jun 15 04:02 tmp
2- Re-run the Postclone.
perl adcfgclone.pl

Nb:
We could hit this Error too:
Following stacktrace produced when running adcfgclone.pl StackTrace: java.lang.Exception: AC-00005: No write permissions for creating the Context file - /u01/PROD/oracle/920/appsutil/temp.xml Raised by oracle.apps.ad.context.AppsContext at oracle.apps.ad.context.AppsContext. getOaEnabledValues(AppsContext.java:733) at oracle.apps.ad.context.CloneContext.doClone(CloneContext.java: 657) at oracle.apps.ad.context.CloneContext.main(CloneContext.java:6033) RC-50004: Error occurred in CloneContext: AC-00005: No write permissions for creating the Context file - /u01/PROD/oracle/920/appsutil/temp.xml Raised by oracle.apps.ad.context.AppsContext Context file creation not succesful

Analysis:

The error above is a bit misleading. adcfgclone.pl should not be creating a "temp.xml" file under appsutil, The context file created under "/u01/PROD/oracle/920/appsutil" should be _.xml.
Normally adcfgclone.pl is trying to do is, create files under /usr/tmp and/or /tmp.
Check if you have a temp.xml file or other RapidClone files under either of those directories owned by a different user? If so please delete them and retry adcfgclone.pl.

FNDLOAD Commands to Download Different Seed Data Types.

How to download different seed data types?

The Generic Loader (FNDLOAD) is a concurrent program that can transfer Oracle Application entity data between database and text file.The loader reads a configuration file to determine which entity to access.

1 - Printer Styles FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name"

2 - Lookups FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="FND" LOOKUP_TYPE="lookup name"

3 - Descriptive Flexfield with all of specific Contexts FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX P_LEVEL=’COL_ALL:REF_ALL:CTX_ONE:SEG_ALL’ APPLICATION_SHORT_NAME="FND" DESCRIPTIVE_FLEXFIELD_NAME="desc flex name" P_CONTEXT_CODE="context name"

4 - Key Flexfield Structures FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt KEY_FLEX P_LEVEL=’COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL’ APPLICATION_SHORT_NAME="FND" ID_FLEX_CODE="key flex code" P_STRUCTURE_CODE="structure name"

5 - Concurrent Programs FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME="FND" CONCURRENT_PROGRAM_NAME="concurrent name"

6 - Value Sets FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="value set name"

7 - Value Sets with values FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value set name"

8 - Profile Options FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME="profile option" APPLICATION_SHORT_NAME="FND"

9 - Request Groups FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME="request group" APPLICATION_SHORT_NAME="FND"

10 - Request Sets FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SETAPPLICATION_SHORT_NAME="FND" REQUEST_SET_NAME="request set"

11 - Responsibilities FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility"

12 - MenusFNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME="menu_name"

: Oracle Application System Administrator's Guide Appendix C has detail description on the usage of loaders.

Default temproary tablespace in Oracle

Use this query to find the default temproary tablespace in an Oracle database.

SELECT * FROM DATABASE_PROPERTIES where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';

Oracle instant client install procedure

1. Download the appropriate Instant Client packages for your platform. All installations REQUIRE the Basic or Basic Lite package.

2. Unzip the packages into a single directory such as "instantclient".

3. Set the library loading path in your environment to the directory in Step 2 ("instantclient"). On many UNIX platforms, LD_LIBRARY_PATH is the appropriate environment variable. On Windows, PATH should be used.

4. Copy a tnsnames.ora file and set the location of TNS_ADMIN.

5. Add the folder under which sqlplus executable is present to PATH variable.

6. Execute sqlplus from command prompt

Unbreakable Linux Enviroment check before R12 install

This script collects and shows the data that is required by the R12 Release Notes in 'Oracle Applications Installation and Upgrade Notes Release 12 (12.0) for Linux (32-bit)' without having to run RapidWizard.

#!/bin/bash
clear
echo "============================================"
echo "Script to check Unbreakable Linux enviroment"
echo "============================================"
echo
echo "---------------------------------------------------"
echo "From /etc/redhat-release:-"
echo "---------------------------------------------------"
cat /etc/redhat-release 2>&1
echo "---------------------------------------------------"
echo
echo "---------------------------------------------------"
echo "From /etc/hosts"
echo "---------------------------------------------------"
cat /etc/hosts 2>&1
echo "---------------------------------------------------"
echo
echo "From /etc/sysconfig/network"
echo "---------------------------------------------------"
cat /etc/sysconfig/network 2>&1
echo "---------------------------------------------------"
echo
echo "---------------------------------------------------"
echo "/etc/sysconfig/networking/profiles/default/network"
echo "THIS FILE SHOULD NOT EXIST"
echo "---------------------------------------------------"
cat /etc/sysconfig/networking/profiles/default/network 2>&1
echo "---------------------------------------------------"
echo
echo "---------------------------------------------------"
echo "uname -r"
echo "This must be greater than 2.6.9-42.0.0.0.1.EL"
echo "---------------------------------------------------"
uname -r
echo
echo "---------------------------------------------------"
echo "Check tools exist"
echo "---------------------------------------------------"
echo
which ar
which gcc
which g++
which ld
which ksh
which make
echo
echo "---------------------------------------------------"
echo "Query package version"
echo "---------------------------------------------------"
rpm -qa grep glibc
rpm -qa grep binutils
rpm -qa grep gcc
rpm -qa grep libgcc
rpm -qa grep libstdc
rpm -qa grep pdksh
rpm -qa grep make
rpm -qa grep gnome-libs
rpm -qa grep sysstat
rpm -qa grep compat-db
rpm -qa grep openmotif
rpm -qa grep setarch
rpm -qa grep control-center
rpm -qa grep xscreensaver
rpm -qa grep libaio
echo
echo "---------------------------------------------------"
echo " From /etc/sysctl.conf:- "
echo "---------------------------------------------------"
cat /etc/sysctl.conf 2>&1
echo
echo "---------------------------------------------------"
echo " From /etc/security/limits.conf"
echo "---------------------------------------------------"
echo
cat /etc/security/limits.conf 2>&1
echo
echo "---------------------------------------------------"
echo
echo "---------------------------------------------------"
echo "From /etc/resolv.conf"
echo "---------------------------------------------------"
cat /etc/resolv.conf 2>&1
echo
echo "---------------------------------------------------"
echo " THE END"
echo "---------------------------------------------------"

R12/11i Getting Aferror.log File Created On Client PC Desktop

A file named "aferror.log" appearing on their client pc desktops. The file has a size of 'zero bytes'.

Steps to reproduce:

1. Login to the 11i/R12 homepage
2. Launch a form
3. Press the x button in your browser on the page that states "Important: do not close this window"... this will kill the forms session
4. Select logout on the homepage
5. Login again to the 11i/R12 homepage
6. Launch a form the aferror.log will appear on your desktop

This is a known issue and is described in Bug 6825183 "R12 GETTING AFERROR FILE CREATED ON DESKTOP"

Solution:

To resolve the problem on Release 12 apply Patch 6866258

For 11i customers the fix will be included in 11.5.10.2 RUP7

500 Internal Server Error

In R12, when attempting to log in to EBS using HTTP://HOST.DOMAIN:PORT/
,the following error occurs.

ERROR500 Internal Server Errorjava.lang.NoClassDefFoundError atoracle.apps.fnd.sso.AppsLoginRedirect.AppsSetting(AppsLoginRedirect.java:126) atoracle.apps.fnd.sso.AppsLoginRedirect.init(AppsLoginRedirect.java:170) at com.evermind[OracleContainers for J2EE 10g (10.1.3.0.0)

The issue is caused by the following setup: Incorrect set-up of the Distributed Caching, port:12377 is not available.

To implement the solution, please execute the following steps:

Solution 1:
1. You can disable the use of "Distributed JVM cache" by disabling LONG_RUNNING_JVM- set oc4j.properties: ==> LONG_RUNNING_JVM= to "false"

Note: not usually recommended

Solution 2:

1. Assign an available port for "Distributed JVM cache" by using the following steps
a) Set the correct port in your Context File -> parameter "s_java_object_cache_port"
2. Run Autoconfig on all Middle Tiers
3. Make sure your System Profile "JTF_DIST_CACHE_PORT" has the same port specified
4. Retest the issue.

How to find the process using a specific port

1) use the following command on the linux shell:

netstat -lntp grep port_number

its output will be like:

tcp 0 0 :::8080 :::* LISTEN 4950/java

note the process id number given in bold and execute the following command

ps -ef | grep process_id

the output will be similar to

aacguser 4950 1 0 06:32 ? 00:00:09 /u01/jdk/jdk1.6.0_14/bin/java -Djava.util.logging.config.file=/u01/tomcat/apache-tomcat-5.5.27/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.security.auth.login.config=/u01/tomcat/apache-tomcat-5.5.27/webapps/ags/WEB-INF/jaas.config -Xss512k -Xms256M -Xmx2048M -XX:

This is the process that is using the port

Common reasons for OUI failures on the MS Windows platforms

Here are the most common reasons why the OUI will fail to run, on any Microsoft Windows Operating System:

1. Operating System Permissions: Oracle recommends running the OUI as an Administrator. However, sometimes using an account that belongs to the Administrator group is not enough. Thus, whenever there is a problem running the OUI, we will recommend using the Local Administrator account. There is a difference between the Local Administrator account and a user account that has Administrator privledges. To determine if the failure is related to OS Permissions, we always recommend you login as the Local Administrator of the machine. Then run the OUI. If the OUI runs correctly, then the problem is with your OS account.

2. Remote Connection Utilities: Trying to run the OUI over a remote connection (such as Terminal Services, Remote Desktop, etc..) can cause the OUI to not run. While it may work for some customers, if there is a problem when using any of these remote connection utilities, we will ask that you login to the server console directly, and try the install. If the install works on the server console, and not over your remote connection, then the problem is with the remote connection utility. A lot of times, the problem is due to the way the remote connection utility is setup / configured.

3. Software conflicts: There is a possibility of the OUI failing, due to conflicts with other software. Some things to check: Make sure there is not a newer version of Java installed. For example, the 10g OUI uses the JDK 1.4.2 (installed when Oracle is installed). If there is a newer version of the JDk installed on the system (for example, the 1.5 version), it can cause a problem with the OUI. Check your PATH. If you find a newer (or older) version of the JDK installed, remove it from the PATH (you do not have to remove the software, just from the PATH). NOTE: It is ok to have other JDKs installed from other Oracle Products. These normally do not cause a problem.

4. Services Running: There have been a few cases where having some services running (even if they are not being used) can cause a problem. For example, the Terminal Services service was running (the customer was not connected over a Terminal Services Session), and it caused a problem. Once the Service was stopped, the OUI ran fine. You can look at what services are running, and try stopping any service that is not needed by Windows.

5. Spaces in the directory names: Make sure you do not have any spaces in the directory name, where you are installing the software from. This includes new installs and patches. If a space exists in the directory name, you will need to remove it.Another place to check for spaces is in the TEMP and TMP variables. These are used for the initial installation, for a temporay location for the OUI. However, if a space exists in the TEMP and TMP variables, the OUI will fail. By Default, Windows sets the TEMP and TMP locations for a user, to: C:\Documents and Settings\%UserProfile%\Local Settings\Temp.Notice the spaces in the directory names.This should be changed to something like: C:\TEMP (NOTE: Make sure the directory exists).

Some other Metalink Notes that might be helpful are mentioned in the reference section below.

How to identify correct Oracle Database software to install on Linux platform

If you are planning to install Oracle Database on Linux platform, then you have to ensure that you are downloading/installing the correct software installation kit. Incorrect software installation for your linux platform will cause errors at relink phase of the installation. Correct Oracle Database Software installation kit can be identified based on Linux OS kernel architecture type (from OS command 'uname -a' output). Following are the different linux architectures along with examples that help to identify correct oracle database software.

Linux x86: (32-bit OS)

$ uname -a Linux celnx4 2.6.9-34.0.2.ELsmp #1 SMP Fri Jun 30 10:33:58 EDT 2006 i686 i686 i386 GNU/Linux

If Linux kernel architecture contains "i386 or i686 or x86", then this platform will be referred as "Linux x86". Please ensure that you are downloading/installing the Oracle Database software installation kit that is released for "Linux x86".

Linux x86_64: (64-bit OS)
$ uname -a Linux celnx7 2.6.9-55.ELsmp #1 SMP Fri Apr 20 16:36:54 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux

If linux kernel architecture is "x86_64", then your platform will be referred as "Linux x86_64" (or Linux AMD64 or Linux EM64T or Linux AMD64/EM64T or Linux x86_64(AMD64/EM64T) ). Please ensure that you are downloading/installing the Oracle Database software installation kit that is released for "Linux x86_64".

Linux Itanium: (64-bit OS)

$ uname -a Linux celia4 2.6.9-42.EL #1 SMP Wed Jul 12 23:25:09 EDT 2006 ia64 ia64 ia64 GNU/Linux

If linux kernel architecture is "ia64", then your platform will be referred as "Linux Itanium". Please ensure that you are downloading/installing the Oracle Database software installation kit that is released for "Linux Itanium".IBM Power Based Linux: (64-bit OS)

$ uname -a Linux stuze22 2.6.9-34.0.1.0.11.EL #1 SMP Mon Dec 4 16:10:42 PST 2006 ppc64 ppc64 ppc64 GNU/Linux

If linux kernel architecture is "ppc64", then your platform will be referred as " 'IBM Power Based Linux' or 'Linux on Power' ". Please ensure that you are downloading/installing the Oracle Database software installation kit that is released for "IBM Power Based Linux" or "Linux on Power".IBM zSeries Based Linux: (64-bit OS)

$ uname -a
Linux pazxxt12 2.6.16.46-0.12-default #1 SMP Thu May 17 14:00:09 UTC 2007 s390x s390x s390x GNU/Linux

If Linux kernel architecture is "s390x", then your platform will be referred as "IBM zSeries based Linux" or "zLinux". Please ensure that you are downloading/installing the Oracle Database software installation kit that is released for "IBM zSeries based Linux" or "zLinux".

IBM S/390 Based Linux (31-bit): (31-bit OS)

$ uname -a Linux pazxxt10 2.4.21-50.EL #1 SMP Tue May 8 17:10:38 EDT 2007 s390 s390 s390 GNU/Linux

If Linux kernel architecture is "s390" (but not s390x) , then your platform will be referred as "IBM S/390 based Linux (31-bit)". Please ensure that you are downloading/installing the Oracle Database software installation kit that is released for "IBM S/390 based Linux (31-bit)". 10gR1 (10.1.0.x) is the last/terminal Oracle Database release for this platform.

Is It Required to Recompile Forms/Reports When Connecting to a New Database Instance?

It is recommended to recompile all forms and reports when connecting to a new RDBMS.

1) This will act as a health-check to confirm that all dependent RDBMS objects are present andvalid. (Review the compile output for any errors)

2) Timestamps of RDBMS objects may be newer than the depending forms/reports objects.

3) If the new RDBMS uses a different schema to house database objects, the reference in thecompiled forms/reports will no longer be valid, and problems will occur.

4) The recompilation can be done using a batch script, so it is not required to spend timerecompiling each form/report manually

Unable to compile the forms.

While running the frmcmp_batch.sh shows the below error message.
FRM-91500:
Unable to start/complete the build when running ./frmcmp_batch.sh from 11g
Problem occurs when using VNC, putty, or ssh..
/u14/ora11g/middleware/asinst_1/bin/frmcmp_batch.sh,

Add the following to the actual frmcmp_batch.sh script to resolve this issue
TERM=vt220 export TERM
ORACLE_TERM=vt220 export ORACLE_TERM

You can add these after the portion of the script that says ->

#ORACLE_SID=<>; export ORACLE_SID

It is applicable for both 10g and 11g.

Moving Forms Applications From One Platform To Another

For this example the assumption is that the "development" machine is a MS Windows platform and the "deployment" machine is a Unix platform.
IMPORTANT: FMX, MMX, and PLX files are NOT portable between platforms. They are also not portable between major versions. For example, you cannot run a 9.0.4 FMX in a 10.1.2 environment. Source code (FMB, MMB, PLL) must be recompiled when moving from one platform and/or major version to another. This includes moving from one Unix platform to another (i.e. Sun Solaris to Linux) or one Windows platform version to another.
( FRM-40031: File xxxxx.fmx is not a Forms Runtime File.)
Failure to correctly compile source files on the machine where they are being deployed will cause instability or prevent the application from running or may cause trigger code to not fire.
Requirements for "deployment" machine:
Log-in access as the "oracle" user
X-session (GUI)
It is NOT supported to perform the following via a remote session.

1. Verify that the deployment environment has been correctly installed and configured as documented in the product Installation Guide.

2. Create a staging directory where the application source files (FMB, MMB, PLL, OLB) can be stored permanently or temporarily. This directory will also be where the compiled executables (FMX, MMX, PLX) will be created. For example:
mkdir /u02/oracle/ias904_mid/forms90/myApplication

3. Copy/transfer all of the Forms components which make up the application to the directory created in step 2. These will include FMB, MMB, PLL and OLB files.
IMPORTANT: Unix is a case sensitive operating system. Be sure that any references to files within your application have been corrected to match files on the new file system. This will usually impact references to image (icon) files, other forms, menus, and libraries.

4. Copy/transfer all other application files as needed. These files may include custom resource (.res), image or custom JARs files. These files will need to be placed in specific locations based on how you developed the application. Refer to the product documentation for more details.
IMPORTANT: If transferring using FTP, all files must be transferred in binary mode.
The following steps must be performed from the local "deployment" machine. Performing these steps remotely is not supported.

5. Open a shell session.

6. Set the ORACLE_HOME variable and point it to the Application Server installation. Be sure to use the appropriate syntax for the particular shell you are using. For example in csh the command would look something like this:
export ORACLE_HOME=/u02/oracle/ias904_mid

7. Set the FORMS90_PATH variable to the directory which was created in step 2. For example:
export FORMS90_PATH=/u02/oracle/ias904_mid/forms90/myApplication
Additional variables may be necessary or desired based on your needs and system configuration. Here are a few examples:
TNS_ADMIN
NLS_LANG
CLASSPATH
TERM
DISPLAY
In most cases, setting these will not be necessary if you use the provided script (.sh file) noted in the next step.
When compiling a Forms application it is important to understand the application. Most important is to understand the dependencies which may exist between components. In other words, for example you will not be able to compile an FMB if it has a dependant PLL which has not yet been compiled. In most cases the order in which compiling should occur is as follows:
1. PLL
2. MMB
3. FMB
There are exceptions, but this will work in most cases.

8. Using the compiler, generate "X" files for all of the application's binaries (PLL, MMB, FMB). The command will be something like the following:
f90genm.sh module=myForm module_type=form compile_all=yes userid=scott/tiger@orcl
Other possible module_type values:
library
menu
form
Addition compiler options can be found in the Forms Builder online help. For Forms 9.0.4, the Builder help is also available online at:
http://www.oracle.com/forms/10g/help/
Click on Reference then Form Compiler Options
NOTE: In Forms 10.1.2.0.2 and newer, the script names have changed. f90genm.sh is now frmcmp.sh and f90gen.sh is now frmcmp_batch.sh. Also, FORMS90_PATH is now FORMS_PATH. Please refer to the product documentation for more details.

9. Once all of the executables have been generated, the path to these files will need to be included in the Forms deployment environment. In most cases this will be the FORMS90_PATH value in the Forms env file, "default.env"

What Patches Are Required For Indian Localization In Release 12

What are the patches required for indian Localization in Release 12?

In Release 12, India Localization functionality is included in Base rollup patches itself (For example RUP04, RUP05 etc.,). Hence there is no need to apply separate patches for India Localization as in Release 11i.

How to Create a Query-only Responsibility for HR

There is not a delivered responsibility that is query only but you can create one...

1. copy the seeded responsibility you want to use

2. in System Administrator responsibility, go to Profile > System

3. select your newly created responsibility in the Responsibility field

4. Select HR:Query Only Mode in the Profile field

5. set "HR:Query Only Mode" to "Yes" in the responsibility column

6. save

The new responsibility will have access to all the data but the user will not be able to update anything.

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.

IE "Unknown Publisher" Message when Running a Form after Initial 11g Installation

After a new installation of 11g Forms the following url is entered in IE to run the test form:
http://machine.domain:port/forms/frmservlet and the following occurs:

"Unknown Publisher"

This occurs because JRE 1.6.0.12 or higher is not installed on the client machine and because of Bug 8747086 FORMS 11 FORMSWEB.CFG INCORRECTLY CONFIGURED FOR SUN JRE AUTODOWNLOAD
Forms 11.1.1.1.0 is configured to run with Sun JRE 1.6.0.12 or higher. If this is not installed on the client machine it normally should be automatically downloaded when using IE but is not due to this bug.

Steps for IE ->

1. Locate the formsweb.cfg in DOMAIN_HOME\servers\WLS_FORMS\stage\formsapp\11.1.1\formsapp\config

2. Change the following:

jpi_codebase=http://java.sun.com/products/plugin/autodl/jinstall-1_6_0-windows-i586.cab#Version=1,6,0,12
to
jpi_codebase=http://java.sun.com/update/1.6.0/jinstall-6u12-windows-i586.cab#Version=1,6,0,12

3. Rerun the Form and you should be prompted to install the Sun JRE.