For Oracle Applications 11i forms version 6.0.8.xCheck the readme of the patch. The patch readme will have instructions similar to the following: Backup the Forms class files, %cp -r $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class $ORACLE_HOME/forms60/java/oracle/forms/handler/UICommon.class.PRE_BUG6643292
Look in the directory for something like : PRE_BUG##### to determine if the forms patch has been applied.
For Oracle Applications R12 forms version 10g
Look in the opatch inventory for the patch number. cd $ORACLE_HOME/OPatch export $PATH=`pwd`:${PATH} opatch lsinventory -detail > 1012_inventory.txt check if patch ###### is listed Or you can review the patch readme for similar information as documented above for the 6.0.8.x forms patchsets.
The OPP is not started by default.It needs to be activated when BI Publisher is setup.
To activate the OPP please do this:Yes. From the manager work shift, by making the processes=0 for that work shift at specific time and date.
Something to remember when creating manager work shifts that:
A. Date-specific work shifts override work shifts that do not specify a specific date.
B. Overlapping Work Shifts - Priority Levels:
1. The work shift with the more specific time period takes effect for the overlapping time period.
2. Overlapping work shifts with the same priority:
The work shift with the largest target processes takes effect.
No document exists that list all the concurrent programs definitions and descriptions.There are many programs and are handled by many different teams, there is documentation for eachindividual program, but nothing that summarizes all together.A search through My Oracle Support application with the concurrent program executable name will return references that contain details of the particular program..The following is a query that summarizes all the concurrent programs and a brief description ofthem plus their respective executable file. This is the same information that you can be obtained throughapplications if you navigate programs one by one.
SQL> select cp.concurrent_program_name, cpt.user_concurrent_program_name, cpt.description,ex.executable_name, ext.user_executable_name, ext.descriptionfrom fnd_concurrent_programs cp, fnd_concurrent_programs_tl cpt,fnd_executables ex, fnd_executables_tl extwhere cp.concurrent_program_id = cpt.concurrent_program_idand ex.executable_id = ext.executable_idand cp.executable_id = ex.executable_id;
The System Administrator’s Guide does summarize some of the common programs utilized andtheir description, for example:
- Function Security Reports
- Active Responsibilities Report
- Active Users Report
- Signon Audit Concurrent Requests Report
- Signon Audit Responsibilities Report
- Report Group Responsibilities Reportand so on.
You may use Concurrent Program Details Report, which will list every concurrent report, to find out more details on a specfic report.The "Concurrent Program Details Report" provides details on how the program is registered and the"description" abstract of the registered program.For usage, you need to reference applications manuals.
There are 2 types of resources in use for PCP/RAC:
1.O/S processes for manager and requests
2.Shadow processes for database connection for managers and requests.
O/S processes for managers (e.g. FNDLIBR, etc.) and request processes (ar60run, sqlplus, etc.)will run on primary node defined for manager.Shadow processes for database connection use load balanced alias (s_cp_twotask) and the load isdistributed between database nodes by sqlnet. This is controlled by sqlnet and CP code is notinvolved. This should mimic what happens to sqlplus connections using load balanced alias forRAC. The following sql can be used to check how manager connections are spread:
select inst_id, count(*) from gv$session where process in (select os_process_id from fnd_concurrent_processes where process_status_code = 'A') group by inst_id;
Now to loadbalance the shadow concurrent manager processes please set the below :
1.Set the profile option "Concurrent: PCP Instance Check" to "OFF"
2.Set the context variable s_cp_twotask to '
3.Run autoconfig and after that you can check for the loadbalancing aspects
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.
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
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 "---------------------------------------------------"
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.
