Obtaining Forms Runtime Diagnostics (FRD) In Oracle Applications 11i

1. Set the user value for profile option 'ICX: Forms Launcher' to be
'http://hostname.domain:port/forms/frmservice?record=forms'

2. By default, this will enable tracing for errors only. As an optional step, you can enable different trace options (e.g. user actions, user-exit events, dbsql events, network events) by setting a trace group in file $ORA_CONFIG_HOME/10.1.2/forms/server/ftrace.cfg

3. Login to the Personal Home Page, navigate to the form and perform the steps that you wish to trace.

4. Locate the file in the directory set by variable FORMS_TRACE_DIR. Note: by default, this directory is named forms_.trc, where is the process identifier.Related

Tracing in 11.5.10

1. Make the user value for profile option 'ICX: Forms Launcher' the same as the site value
e.g. copy value of ICX: Forms Launcher for the site Test115 'http://testserver.oracle.com:8005/dev60cgi/f60cgi' to be the value for the user.

2. Append the user value of ICX: Forms Launcher with the Forms parameters for FRD
e.g. update the value of ICX: Forms Launcher for the user to be 'http://testserver.oracle.com:8005/dev60cgi/f60cgi?record=all&log=/tmp/username_frd.log

3. Login to the Personal Home Page, navigate to the form and perform the steps that you wish to trace.

4. Locate the file in the directory set by variable $FORMS60_TRACE_PATH. Note: the default directory for $FORMS60_TRACE_PATH is $ORACLE_HOME/forms60/log.

FRD Tracing in 11.5.x to 11.5.9

This method enables users to run FRD tracing through the Personal Home Page by setting debugging to true using the profile option 'ICX: Forms Launcher'.
When accessing Applications through the Personal Home Page (PHP), there is no way to pass command line parameters such as config=debug and record=all for the duration of a single session.
For example, you cannot add these variables to the PHP connect string

http://testserver.oracle.com/OA_HTML/US/ICXINDEX_test115.htm.

The advantages of using the profile option 'ICX: Forms Launcher' are that you can easily trace the activities of multiple users and assign different log file names.
With Oracle Developer Forms patch 16 and higher, users cannot create adhoc FRD trace files in any directory. The trace files are either created in the directory set by parameter

$FORMS60_TRACE_PATH or they are created in 8.0.6 $ORACLE_HOME/forms60/log directory.

Steps:

To start tracing in this way, modify Profile Option 'ICX: Forms Launcher' at USER level to include the Forms parameters required for FRD logging:

1. Make the user value for profile option 'ICX: Forms Launcher' the same as the site value

e.g. copy value of ICX: Forms Launcher for the site Test115

'http://testserver.oracle.com:8005/dev60cgi/f60cgi'
to be the value for the user.

2. Append the user value of ICX: Forms Launcher with the Forms parameters for FRD
e.g. update the value of ICX: Forms Launcher for the user to be

'http://testserver.oracle.com:8005/dev60cgi/f60cgi?record=all&log=/tmp/username_frd.log

3. Save this change at the USER level, and the next time you access the test115 database through PHP, the Forms variables will be enabled.

Old option: adhoc FRD tracing :

The steps below show how to create an FRD trace file quickly. This is not a supported or preferred method of tracing, however, it may be useful to use this method for adhoc and basic troubleshooting purposes.Note after Oracle Developer Forms patch 16 and higher, users cannot create adhoc FRD trace files in any directory. The trace files are either created in the directory set by parameter
$FORMS60_TRACE_PATH or they are created in 8.0.6 $ORACLE_HOME/forms60/log directory.

1. Logon to Applications 11i and append the following text to the URL: record=all&log=/tmp/username_frd.log
a) Example on Unix:
A typical URL to logon to 11i applications: 'http://testserver.oracle.com:8005/dev60cgi/f60cgi?'
The URL with FRD trace enabled: 'http://testserver.oracle.com:8005/dev60cgi/f60cgi?record= all&log=/tmp/username_frd.log'
b) Example on Windows platforms:
A typical URL to logon to 11i applications: 'http://testserver.oracle.com:8005/dev60cgi/ifcgi60.exe'
The URL with FRD trace enabled: 'http://testserver.oracle.com:8005/dev60cgi/ifcgi60.exe?record= all&log=c:\temp\username_frd.log'

2. Reproduce the steps that you wish to trace in Applications.

3. Exit Applications and logout.

4. Locate the trace file at the server. In the above example, the forms runtime diagnostic trace information will be created to file form1.frd in /tmp or in c:\temp directory depending on the platform on which Applications is installed.

How to run Forms Runtime Diagnostics (FRD) in 10gR2 Forms.

FRD is a runtime event-based logging system intended to aid in the debugging of Forms
applications. FRD is enabled at runtime on a user by user basis. When a form is run with
FRD enabled, a combination of external user-application interactions and internal Forms
processing events are written in chronological order to a log on the file system. These events
can then be analyzed by both application developers, and Oracle support staff. FRD is not
intended to be used as a performance benchmarking tool or as a mechanism for gauging code
coverage.
FRD generates extensive output useful for analysis and debugging, and it is therefore
recommended FRD be utilized as a logging mechanism only when specific issues are
encountered.

To implement FRD do the following:

In the $ORACLE_HOME/forms/server/default.env (or whatever env file you are using), add the environment variable FORMS_TRACE_DIR specifying a physical directory on the Application Server machine. The FRD log file will be written into the directory specified.

In the formsweb.cfg create a config section something like: [my_frd] otherparams=record=collect log=my_frd.txt form=my_form.fmx

Then call this from a url using the config section.
Example: http://my_machine:my_port/forms/frmservlet?config=my_frd

Trace the files loaded in java console while Oracle forms are invoked

1. Enable Java console as follows from Windows client machine,

Run - > Control - > Java - > Advanced Tab - > Java Console - > Click on Java console

2. Whenever the forms get loaded, the java console will be placed in the task bar and we can opne the console and see the files get loaded or trace the debug in case we have any issue with forms load

Eg:

Java Plug-in 1.6.0_12
Using JRE version 1.6.0_12 Java HotSpot(TM) Client VM
User home directory = C:\Users\admin

----------------------------------------------------
c: clear console window
f: finalize objects on finalization queue
g: garbage collect
h: display this help message
l: dump classloader list
m: print memory usage
o: trigger logging
q: hide console
r: reload policy configuration
s: dump system and deployment properties
t: dump thread list
v: dump thread stack
x: clear classloader cache
0-5: set trace level to
----------------------------------------------------

Loaded image: http://nglinux04.newgen.com:8099/OA_MEDIA/appslogo_new.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/splash.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndforms.jar!/oracle/forms/icons/oracle_logo.gif
proxyHost=null
proxyPort=0
connectMode=HTTP, native.
Forms Applet version is : 10.1.2.3
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndforms.jar!/oracle/forms/icons/ellipsis.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndforms.jar!/oracle/forms/icons/frame.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afapps.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afapps.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afapps.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afapps.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afnav.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afapps.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afinsrw.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/affind.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afnavig.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afsave.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afnxtstp.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afrsp115.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afprint.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afclsfrm.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afcut.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afcopy.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afpaste.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afclrrw.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afclrall.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afdelrw.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afedit.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afzoom.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/aftrans.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afattach.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/affldtls.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afhelp.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/aflleft.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/aflright.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afclps.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afclpsa.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afxpnda.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afxpnd.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afxpndc.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afapps.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afapps.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afapps.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afapps.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afapps.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afapps.gif
Loaded image: jar:http://nglinux04.newgen.com:8099/OA_JAVA/oracle/apps/fnd/jar/fndaol.jar!/oracle/apps/media/afapps.gif

Invalid ICX, JG, JAI, AND OKL Objects After Patching

After applying AP patches one or all of the following objects are invalid:ICX_PO_VENDOR_SITES_V JG_AP_TAX_LINES_SUMMARY_V JG_PO_TAX_LINES_SUMMARY_V JG_PO_REQ_TAX_LINES_SUMMARY_V JG_PO_REL_TAX_LINES_SUMMARY_V JAI_AP_IA_TRIGGER_PKG JAI_AP_IDA_TRIGGER_PKG OKL_PAY_INVOICES_DISB_PVT
The following error messages are received when trying to recompile the invalids:
Errors for ICX_PO_VENDOR_SITES_V ORA-00904: "BANK_NUMBER": invalid identifier
Errors for JG_AP_TAX_LINES_SUMMARY_V'; ORA-00904: "POVS"."AP_TAX_ROUNDING_RULE": invalid identifier Errors for JG_PO_REL_TAX_LINES_SUMMARY_V ORA-00904: "POVS"."AP_TAX_ROUNDING_RULE": invalid identifier Errors for JG_PO_REL_TAX_LINES_SUMMARY_V ORA-00904: "POVS"."AP_TAX_ROUNDING_RULE": invalid identifier Errors for JG_PO_REQ_TAX_LINES_SUMMARY_ ORA-00904: "PRVS"."AP_TAX_ROUNDING_RULE": invalid identifier Errors for JG_PO_TAX_LINES_SUMMARY_V ORA-00904: "POVS"."AP_TAX_ROUNDING_RULE": invalid identifier
Errors for PACKAGE BODY JAI_AP_IA_TRIGGER_PKG: LINE/COL ERROR -------- ----------------------------------------------------------------- 86/7 PL/SQL: Statement ignored 86/28 PLS-00302: component 'CHECK_TOLERANCE_HOLD' must be declared
Errors for PACKAGE BODY JAI_AP_IDA_TRIGGER_PKG: LINE/COL ERROR -------- ----------------------------------------------------------------- 103/7 PL/SQL: Statement ignored 103/28 PLS-00302: component 'CHECK_TOLERANCE_HOLD' must be declared
Errors for PACKAGE BODY OKL_PAY_INVOICES_DISB_PVT: LINE/COL ERROR -------- ----------------------------------------------------------------- 675/10 PL/SQL: SQL Statement ignored 678/46 PL/SQL: ORA-00904: "PVS"."PAYMENT_METHOD_LOOKUP_CODE": invalid identifier 795/3 PL/SQL: Statement ignored 795/10 PLS-00364: loop index variable 'CUR_VENDOR_DTLS' use is invalid


This is because Various Payables and other patches have caused these objects to become invalid.

Follow the step below that pertains to the invalid package that is your issue:
1. Drop ICX_PO_VENDOR_SITES_V, this is an obsolete object.

2. To resolve JG_AP_TAX_LINES_SUMMARY_V
a) Download and review the readme for Patch 7641584: UNABLE TO VALIDAT AN INVALID
OBJECT JG_AP_TAX_LINES_SUMMARY_V .

3. To resolve JG_PO_REL_TAX_LINES_SUMMARY_V, JG_PO_REQ_TAX_LINES_SUMMARY_V, and JG_PO_TAX_LINES_SUMMARY_V:
Download and review the readme for Patch 82019111OFF:7757644:12.0.4:12.0.4:INVALID JG OBJECTS.

4. For invalid packages; JAI_AP_IA_TRIGGER_PKG and JAI_AP_IDA_TRIGGER_PKG
Download and review the readme for Patch 7659470:1OFF:7612034:12.0.5:R12:ORA-4088: ERROR DURING EXECUTION OF TRIGGER 'AP

5. If JAI_AP_IDA_TRIGGER_PKG remains invalid after Patch 7659470, perform the following:
a) Download and review the readme for Patch 6708042

6) To resolve OKL_PAY_INVOICES_DISB_PVT
a) Download and review the readme for Patch 7662017: APPLICATION OF Patch 7596239 HAS CREATED 8 INVALID OBJECTS

Query To Get Enabled Trace/Log/Debug Profile Options

. This will display values of profile options "FND: Debug Log Enabled" (AFLOG_ENABLED) and
"Initialization SQL Statement - Custom'" (FND_INIT_SQL) at each level. If the values are
respectively 'Y' and/or contains sql statement for these profile options then log and/or
trace are enable for that level (which could be at site, user, ... level):


set pagesize 200
col NAME for a25
col LEV for a6
col CONTEXT for a25
col VALUE for a50
col USER_PROFILE_OPTION_NAME for a37
select po.profile_option_name "NAME",
po.USER_PROFILE_OPTION_NAME,
decode(to_char(pov.level_id),
'10001', 'SITE',
'10002', 'APP',
'10003', 'RESP',
'10005', 'SERVER',
'10006', 'ORG',
'10004', 'USER', '???') "LEV",
decode(to_char(pov.level_id),
'10001', '',
'10002', app.application_short_name,
'10003', rsp.responsibility_key,
'10005', svr.node_name,
'10006', org.name,
'10004', usr.user_name,
'???') "CONTEXT",
pov.profile_option_value "VALUE"
from FND_PROFILE_OPTIONS_VL po,
FND_PROFILE_OPTION_VALUES pov,
fnd_user usr,
fnd_application app,
fnd_responsibility rsp,
fnd_nodes svr,
hr_operating_units org
where (po.profile_option_name like '%AFLOG_ENABLED%' or po.profile_option_name like
'%FND_INIT_SQL%')
and pov.application_id = po.application_id
and pov.profile_option_id = po.profile_option_id
and usr.user_id (+) = pov.level_value
and rsp.application_id (+) = pov.level_value_application_id
and rsp.responsibility_id (+) = pov.level_value
and app.application_id (+) = pov.level_value
and svr.node_id (+) = pov.level_value
and org.organization_id (+) = pov.level_value
order by "NAME", pov.level_id, "VALUE";


2. This will display all profile options with values and levels where the word TRACE, LOG, or
DEBUG is found in the PROFILE_OPTION_NAME:


set pagesize 200
col NAME for a25
col LEV for a6
col CONTEXT for a25
col VALUE for a50
col USER_PROFILE_OPTION_NAME for a37
select po.profile_option_name "NAME",
po.USER_PROFILE_OPTION_NAME,
decode(to_char(pov.level_id),
'10001', 'SITE',
'10002', 'APP',
'10003', 'RESP',
'10005', 'SERVER',
'10006', 'ORG',
'10004', 'USER', '???') "LEV",
decode(to_char(pov.level_id),
'10001', '',
'10002', app.application_short_name,
'10003', rsp.responsibility_key,
'10005', svr.node_name,
'10006', org.name,
'10004', usr.user_name,
'???') "CONTEXT",
pov.profile_option_value "VALUE"
from FND_PROFILE_OPTIONS_VL po,
FND_PROFILE_OPTION_VALUES pov,
fnd_user usr,
fnd_application app,
fnd_responsibility rsp,
fnd_nodes svr,
hr_operating_units org
where (po.PROFILE_OPTION_NAME like '%TRACE%' or po.PROFILE_OPTION_NAME like '%
DEBUG%' or po.PROFILE_OPTION_NAME like '%LOG%')
and pov.application_id = po.application_id
and pov.profile_option_id = po.profile_option_id
and usr.user_id (+) = pov.level_value
and rsp.application_id (+) = pov.level_value_application_id
and rsp.responsibility_id (+) = pov.level_value
and app.application_id (+) = pov.level_value
and svr.node_id (+) = pov.level_value
and org.organization_id (+) = pov.level_value
order by "NAME", pov.level_id, "VALUE";

How To Disable Jinitiator Automatic Download

One simple way to disable downloading of Jinitiator is to rename the file $OA_HTML/oajinit.exe (oaj2se for R12). Another way is editing the file $OA_HTML/bin/appsweb.cfg and changing the value of the parameterjinit_name to be different from oajinit.exe; this second method includes changing appsweb.cfg which is managed by AutoConfig, thus any AutoConfig run will overwrite the change. To make it permanent, you will need to edit the template of appsweb.cfg which is $FND_TOP/admin/template/appsweb.cfg

Can The Apps Tier & The Db Tier Be On Different Subnets?

Possible , but It is "not recommended" to set a such configuration, having the Database Tier connected on the 2nd network cards.
The subnets are to do with IP addresses, we are only concerned if we can find each other's host name.It is ok for tiers to be in different domains, although that would suggest they were physically separated by some distance which Oracle does not encourage, so subnets are not a problem, so long as the host names are resolvable by all tiers locating different tiers in physically distant locations is not encouraged, due to the performance problems, customer should make sure that the network latency between tiers is as low as possible.

Spanning across subnets or domains will only increase this latency and therefore affect performance.

How to Bounce the Material Transaction Interface Manager

1. Responsibility = System Adminisitrator
2. Navigation = Concurrent > Request
3. Click "Specific Request" radio button
4. Name = "Process transaction interface"
5. When the request are displayed, click in any column for the row that has:
Phase = "Pending" and Status = "Scheduled"
6. Click the "Cancel Request" button
7. Click "Yes" button to Decision message.

To start the Material Transaction Interface Manager:
1. Responsibility = Inventory
2. Navigation = Setup > Transactions > Interface Managers
3. Click in any column in the row with Name = "Material Transaction"
4. Navigation = "Tools" or "Special" > Launch Mnager
5. Click "Submit" button

How You Can Reset The Sequence Number For The REQUEST_ID

Ensure that you have a current system backup prior to performing this
process.
1-Log in to SQLPLUS as apps/'apps password'.
2-SQL> drop sequence fnd_concurrent_requests_s;
3-SQL> create sequence fnd_concurrent_requests_s
start with xxxx;

4-Check the sequences again.

SQL> select max(request_id) from fnd_concurrent_requests;
from system.dual;

NOTE: The value from step 4 should be bigger than value from step 3.

How to create a FRD (Forms Runtime Diagnostic) Log in EBusiness Suite R12 using Forms 10g

1. Make the USER value for profile option 'ICX: Forms Launcher' the same as the SITE value
e.g. copy value of ICX: Forms Launcher for the SITE"http://testserver.oracle.com:8005/forms/frmservlet"to be the value for the USER.

2. Append the USER value of ICX: Forms Launcher with the "?record=collect" (without the quotes)
e.g. update the value of ICX: Forms Launcher for the user to behttp://testserver.oracle.com:8005/forms/frmservlet?record=collect
Another method is to set the "Forms Runtime Parameters" profile option with a value of "record=collect" (without quotes)

3. Save this change at the USER level.

4. Logout and Log back in again, for this profile to take effect. When you login again, a message box pops up, which alerts you that Diagnostics is enabled.

5. Go to Help->About Oracle Applications, go to the section
----------------------------------------
Forms Server Environment Variables
----------------------------------------
There you should see a FORMS_TRACE_DIR. Note the value of this variable.

If you find that the FORMS_TRACE_DIR is not defined, then ask your system administrator to:
- bring down the Forms server- define the "s_forms_trace_dir" context variable in the middle tier (Forms tier) to point to a valid directory. For this the preferred method is to use Oracle Applications Manager => Site Map link => System Configuration section => AutoConfig => for the Applications tier, click the Edit Parameters => System tab => click the + sign to expand the "oa_forms_server". In this expanded area, look for Title = "Forms runtime file directory location" (OA_VAR = "s_forms_trace_dir"). On this line, you can see the text box where the current value exists (if any).Enter/modify the value as desired here, and save.- run Autoconfig- then bring back up the Forms sever.

6. Reproduce the Forms-Issue, which you are trying to diagnose.

7. Go to the directory specified in the FORMS_TRACE_DIR variable. List the latest files. The FRD Log should be the one with the string "collect" in its name.

oafm,forms and oacore not starting up after IP adress change

oafm, forms and oacore not starting up after IP adress change of the Oracle Applications Error from the logs:
adformsctl.sh: exiting with status 204
adoafmctl.sh: exiting with status 204
adoacorectl.sh: exiting with status 204

This is because the OC4J lock files contains the IP adress, after the ip adress change the lock files includes the wrong Ip adress which caused the OJ4J to fail.

To implement the solution perform the following steps:

1 - open a new shell and set your apps environment
2 - cd $ADMIN_SCRIPTS_HOME3 - adopmnctl.sh stop
4 - check if it is really down: ps -ef grep grep opm
5 - delete the following:

rm -fr $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/*
rm -fr $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/*
rm -fr $INST_TOP/ora/10.1.3/j2ee/forms/persistence/*

6 - adopmnctl.sh start
7 - check if the issue has been resolved: adapcctl.sh status

http://host:port/forms/frmserlvlet not loading

http://host:port/forms/frmserlvlet does not load after installing formsbuilder11g even after enabling ActiveX controls in Internet explorer. For this, download and install the latest JRE and install it for the URL to work.

remove the Search region that comes in the Manager Self Service Responsibility Pages.

Follow these steps to remove the Search region that comes in the Manager Self Service Responsibility Pages.:

Profile Options:Enable the following profile options at user level
• HR: Enable User Personalization – Yes
• Personalize Self-Service Defn - Yes
• FND: Personalization Region Link Enabled – Yes

Personalization done at Responsibility Level:
Perform the following steps in the responsibility where you want to disable the search option.

1. Click on Personalize “Search Region”
2. Click on Personalize icon at the Row Layout: Quick Search in the personalization structure

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');

Installing Oracle Forms builder & Services 11G in windows

Perform the below steps to install Oracle Forms 11g and forms services on Windows.

- Download Oracle Weblogic server (Navigation: otn.oracle.com > downloads > Middleware: Weblogic server )

- Download Oracle Forms, Reports and Discoverer (Navigation: otn.oracle.com > Downloads > Middleware: Oracle Fusion Middleware 11gR1)

- Extract the two files Disk1_1of2 and ..disk1_2of2 and it creates disk directories (disk1, disk2, disk3 and disk4).

- Double click the setup.exe in the root of the disk1 folder.

- Click install and configure.

- The installer checks for System pre-requisites.

- Choose the Oracle Middleware location. This is where I installed the middleware home of Jdeveloper 11g

- Select Oracle Forms and Reports including the correct server components. And after accepting the defaults in the following steps choose [Finish] and the installation starts.

- The installer installs a one- off patch and then starts the configuration.

- Add TNS entry for the instance in tnsnames.ora under ([HOME_DRIVE]:\Oracle\Middleware\asinst_1)

- The forms builder can be accessed from the following menu (Start > Programs > Oracle classic instance > Developer tools > Forms Builder.)

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

What is the difference between OracleAS 10.1.2.x, 10.1.3.x and 11.1.x ?

10.1.2.x
~~~~~~~~
Oracle Application Server 10.1.2.x ships Infrastructure and MiddleTier components.

Oracle Application Server Infrastructure contains the following components:
* Oracle Application Server Metadata Repository
* Oracle Identity Management
+ Oracle Application Server Single Sign-On
+ Oracle Internet Directory and its components
+ Oracle Application Server Certificate Authority

Oracle Application Server Middletier includes the following components:

* OC4J
* WebCache & HTTP Server
* Portal
* Forms & Reports
* Discoverer
* Wireless

For complete list of all the components that are available as part of 10.1.2.x , refer the
following documentation

1.3.2 Oracle Application Server Components - Table 1-1
http://download.oracle.com/docs/cd/B14099_19/core.1012/b13994/intro.htm#sthref97

10.1.3.1
~~~~~~~~
Oracle Application Server 10g Release 3 (10.1.3.1.0) provides the Oracle SOA Suite, which is a complete set of service infrastructure components for creating, deploying, and managing Service Oriented Architectures. It is a complete J2EE Release and does not include
middle tier components like Forms, Reports, Portal, Discoverer unlike Oracle Application Server version 10.1.2.0.2. It does not include the Infrastructure components like OID, SSO, DIP etc,.

For further details on the components available, installation types and integration with OAS 10.1.2.0.2, refer the following Oracle documentation link

http://download.oracle.com/docs/cd/B31017_01/win.1013/install/topo.htm#CEGDIHID

11.1.x
~~~~~~~
This is the latest release that includes both Identity Management components and Middletier components.

Oracle Fusion Middleware provides two types of components:

* Java Components - Oracle Fusion Middleware components that are deployed as one or more Java EE applications and a set of resources. Java components are deployed to an Oracle WebLogic Server domain as part of a domain template. Examples of Java components are the Oracle SOA Suite and Oracle WebCenter components.

* System Components - Manageable processes that are not deployed as Java applications. Instead, system components are managed by the Oracle Process Manager and Notification (OPMN). The system components are:

Oracle HTTP Server
Oracle Web Cache
Oracle Internet Directory
Oracle Virtual Directory
Oracle Forms Services
Oracle Reports
Oracle Business Intelligence Discoverer
Oracle Business Intelligence

For further details on the functionalities of the components,installation guides, refer the following documentation

http://download.oracle.com/docs/cd/E12839_01/index.htm

UPGRADE PATHS

There is no upgrade path from Oracle Application Server 10.1.2.x to 10.1.3.x as they are completely different releases. However, there is an option to configure 10.1.3 middle tier to use Infrastructure components of OAS 10.1.2, which is documented in the following Metalink Note Note.

403164.1 - How to Configure 10.1.3.x Mid-tier Instance to Use Oracle Identity Management

# You can upgrade to Oracle Fusion Middleware 11g from the following previous versions of Oracle Application Server 10g:

* Oracle Application Server 10g Release 2 (10.1.2)

* Oracle Application Server 10g Release 3 (10.1.3)

* Oracle Application Server Portal Release 2 (10.1.4)

* Oracle Identity Management 10g (10.1.4) Identity Management instanceAs

The upgrade paths are varied and the steps detailed, you need to review the "Upgrade Guides" located in the following

http://download.oracle.com/docs/cd/E12839_01/upgrade.htm

Oracle Applications Technology 11i.ATG_PF.H.delta.7 (RUP 7) released Patch # 6241631

The most current version of About Oracle Applications Technology 11i.ATG_PF.H.delta.7 is My Oracle Support Knowledge Document 783600.1. Please ensure that you have the most current version before you begin.

Oracle Applications Technology 11i.ATG_PF.H.delta.7 is cumulative, in that everything found in Oracle Applications Technology 11i.ATG_PF.H Rollup 3 (4334965), Oracle Applications Technology 11i.ATG_PF.H Rollup 4 (4676589), Oracle Applications Technology 11i.ATG_PF.H.delta.5 (RUP5) (5473858), and Oracle Applications Technology 11i.ATG_PF.H.delta.6 (RUP6) (5903765) is also included in 11i.ATG_PF.H.delta.7.
Oracle Applications Technology 11i.ATG_PF.H.delta.7 (RUP7) contains Oracle Applications Technology (ATG) security fixes for core ATG products from the January 2005 Critical Patch Update (CPUJan2005) through the July 2009 Critical Patch Update (CPUJul2009). The following core ATG products are included in 11i.ATG_PF.H.delta.7: FND, OAM, OWF, FWK, JTT, JTA, TXK, XDO, ECX, EC, AK, ALR, UMX, BNE, and FRM.

How We Resolved the Account Locked (Timed) issue in Oracle Database 10g

Details: Oracle Database Version: 10g R2 (10.2.0.1)
Application User: APPUSR
Error: ORA-28000: the account is locked

Login as SYSDBA
SQL> conn /as sysdba

Check the APPSUSR account status.
SQL> SELECT username, account_status, profile FROM dba_users WHERE username= ‘APPUSR’; USERNAME ACCOUNT_STATUS PROFILE
-------------------- -------------------- ---------------
APPUSR LOCKED(TIMED) DEFAULT

Here we can see the account status is LOCKED (TIMED) and the default user’s profile is DEFAULT.

Check the resource limits of DEFAULT profile.
SQL> SELECT resource_name,resource_type,limit FROM dba_profiles WHERE profile='DEFAULT';
RESOURCE_NAME RESOURCE LIMIT
-------------------------------- -------- ----------
COMPOSITE_LIMIT KERNEL UNLIMITED
SESSIONS_PER_USER KERNEL UNLIMITED
CPU_PER_SESSION KERNEL UNLIMITED
CPU_PER_CALL KERNEL UNLIMITED
LOGICAL_READS_PER_SESSION KERNEL UNLIMITED
LOGICAL_READS_PER_CALL KERNEL UNLIMITED
IDLE_TIME KERNEL UNLIMITED
CONNECT_TIME KERNEL UNLIMITED
PRIVATE_SGA KERNEL UNLIMITED
FAILED_LOGIN_ATTEMPTS PASSWORD 10 PASSWORD_LIFE_TIME PASSWORD UNLIMITED
PASSWORD_REUSE_TIME PASSWORD UNLIMITED
PASSWORD_REUSE_MAX PASSWORD UNLIMITED
PASSWORD_VERIFY_FUNCTION PASSWORD NULL PASSWORD_LOCK_TIME PASSWORD UNLIMITED
PASSWORD_GRACE_TIME PASSWORD UNLIMITED

All resource limits for DEFAULT profile is set to UNLIMITED, but only for FAILED_LOGIN_ATTEMPTS attribute, it’s set to some value (10). Due to this the user account keeps getting locked(timed).When we check in the Oracle Documentations, it’s stated that FAILED_LOGIN_ATTEMPTS attribute for DEFAULT profile has been changed from 10.2.0.1 from UNLIMITED to 10.

What we can do is, either we may need to change the resource limit for FAILED_LOGIN_ATTEMPTS attribute in DEFAULT profile, or create a new profile for that user with FAILED_LOGIN_ATTEMPTS attribute value set to UNLIMITED. But for security reasons, we will not tamper the DEFAULT profile, which is not recommended too. Then let’s go for creating a new profile and assign that profile to the user.

Create a profile.

SQL> CREATE PROFILE APPUSR_DEFAULT LIMIT
2 COMPOSITE_LIMIT UNLIMITED
3 SESSIONS_PER_USER UNLIMITED
4 CPU_PER_SESSION UNLIMITED
5 CPU_PER_CALL UNLIMITED
6 LOGICAL_READS_PER_SESSION UNLIMITED
7 LOGICAL_READS_PER_CALL UNLIMITED
8 IDLE_TIME UNLIMITED
9 CONNECT_TIME UNLIMITED
10 PRIVATE_SGA UNLIMITED
11 FAILED_LOGIN_ATTEMPTS UNLIMITED
12 PASSWORD_LIFE_TIME UNLIMITED
13 PASSWORD_REUSE_TIME UNLIMITED
14 PASSWORD_REUSE_MAX UNLIMITED
15 PASSWORD_VERIFY_FUNCTION NULL
16 PASSWORD_LOCK_TIME UNLIMITED
17 PASSWORD_GRACE_TIME UNLIMITED;

Profile created.

Assign the newly created profile to the user as default profile.

SQL> ALTER USER appusr PROFILE appusr_default;

User altered. Unlock the user account:

SQL> ALTER USER appusr ACCOUNT UNLOCK;
User altered.
Now check again the status of APPUSR user.

SQL> SELECT username, account_status FROM dba_users WHERE username= ‘APPUSR’; USERNAME ACCOUNT_STATUS PROFILE
-------------------- -------------------- ---------------
APPUSR OPEN APPUSR_DEFAULT

Purge Concurrent Request FNDCPPUR program deletes files from database but not from the file system

Purge Concurrent Request and/or Manager Data (FNDCPPUR) program completes and it deletes concurrent request information from database but relevant files are not removed from the operating system (OS) file system. Concurrent request Log file shows file deletion failed as below.
For example
..
..
* 545345 - /../../w545345.mgr
* 545346 - /../../w545346.mgr

* denotes file deletion failed.

Cause:
The cause of this problem has been identified in Bug 6451570. It is caused by the domain name entry. The system manager_node entry contains the domain also. Therefore comparison between manager_node and node_name fails causing the files not to delete from OS (Unix,Windows,..) file system.

Solution
To implement the solution, Please execute the following steps if you are on 11i
1) Please download and review the readme for Patch 7210178
2) Please apply Patch 7210178 in a test environment.
3) Please confirm the following file versions: afppur.lpc 115.35 You can use the commands like the following: strings -a $FND_TOP/bin/FNDCPPUR grep afppur
4) Please retest the issue.
5) If the issue is resolved, please migrate the solution as appropriate to other environments.
(OR)
Please execute the following steps if you are on R12

1) Please download and review the readme for Patch 7530490
2) Please apply Patch 7530490 in a test environment.
3) Please confirm the following file versions: afppur.lpc 120.4.12000000.4 You can use the commands like the following: strings -a $FND_TOP/bin/FNDCPPUR grep afppur
4) Please retest the issue.
5) If the issue is resolved, please migrate the solution as appropriate to other environments.

Note: In this fix, the domain name is removed from the manager node if it exists and compared to node name. After the fix , It should delete relevant files from the file system.

How To Access Forms Directly In Oracle Applications R12

By default in Oracle Applications R12, users are not able to access Forms directly via the following url:
http://hostname.domain:port/forms/frmservlet
The following error would pop out:
APP-FND-01542: This Applications Server is not authorized to access this database.

The goal of this document is to allow users access to the Oracle Applications R12 directly via Forms especially in cases where access to the following url is not available:

http://hostname.domain:port/OA_HTML/AppsLogin
NOTE: Accessing Forms directly is not supported and should only be used for diagnostic and troubleshooting purposes.

Solution
1. Edit $CONTEXT_FILE which is located in $INST_TOP/appl/admin
2. ChangeSECUREtoOFF
Application Server Security Authentication can take one of the following values {ON, OFF, SECURE}.OFF - Server security is not checked. Any application server machine can access the database.ON - Some level of trust is required to access the database. Either the Application Server is registered with the database or the module and version ID are known to be trusted.SECURE - Full trust is required for access to the database. Only registered Application Server machines and trusted code modules may connect.
3. Run $INST_TOP/admin/scripts/adautocfg.sh to instantiate the changes
4. Users are now able to access Forms directly.

Oracle Alert Does Not Sent Any Emails After Applying Patch 4676589 11i.ATG_PF.H Rollup 4

A new feature has been introduced in Oracle Alert as of 11i.ATG_PF.H Rollup 4 and this has been described in Note 365228.1 About Oracle Applications Technology 11i.ATG_PF.H Rollup 4:

Oracle Alert
Oracle Alert now leverages the Workflow Notification Mailer to send alerte-mail messages and process responses. However, if you implemented responseprocessing in an earlier release, you can continue running the Oracle AlertResponse Processor as long as necessary to handle responses to alert messagessent prior to Oracle Applications Technology Family Pack 11i.ATG_PF.H Rollup 4.Before this enhancement, it was possible to specify via which mailing system Oracle Alert would send out the emails. The Oracle Alerts Options Window (System -> Options) has the following predefined Mail Systems:
Unix sendmail
Oracle InterOffice
VMS Mail
Windows NT Mail
The enhancement for the Workflow Notification Mailer has been implemented as of alssmn.lc 115.17 and higher.

$ adident Header $ALR_TOP/bin/ALECTC grep alssmn.lc
C:\> adident Header %ALR_TOP%\bin\ALECTC.exe grep alssmn.lc

Solution
Any environment which has 11i.ATG_PF.H Rollup 4 or later applied will no longer use any of the above listed Mail Systems like e.g. the Unix sendmail for sending out emails. Instead, this is done by the Workflow Notification Mailer (also known as Java Workflow Mailer) which sends and receives alert e-mail messages. The notification mailer uses the Simple Mail Transfer Protocol (SMTP) for outbound messages and the Internet Message Access Protocol (IMAP) for inbound messages.There are several benefits which justify this change in functionality :

Oracle Alert was using old technology which didn't support the new MAPI for Windows NT .
The Workflow Notification Mailer uses the latest technology for handling both incoming and outgoing e-mail messages.
Eliminates the requirement of setting up multiple mailing systems for a single E-Business Suite environment : e.g. one for Oracle Alert and a second for Oracle Workflow.
....
Detailed instructions on setting up the Workflow Notification Mailer for Oracle Alert are described in the Oracle Alert User's Guide - Setup Steps (page 9-3). This is a required post-installation step which is also available in Note 365228.1 About Oracle Applications Technology 11i.ATG_PF.H Rollup 4, 3. New and Changed Setup Steps - Oracle Alert.

After new installation of OracleAS, it is not possible to start web Forms in IE.

After new installation of OracleAS, it is not possible to start web Forms in IE.
It crashes without event loading the java applet. on jvm.dll @ 0x006d3fe348

We have executed the following steps:
1. Copy the jvm.dll (C:\Program Files\Java\jre1.6.0_03\bin\client) from Sun JRE 6.0 Update
( 1 -6 )or JRE 5.0 Update ( 5 - 13 )

2. Download the jinitiator through the URL,http://hostname:port/OA_HTML/oajinit.exe

3. Install the jinitiator in C:/Program Files

4. Paste the jvm.dll into Jinitiator's hotspot directory replacing the jvm.dll after a backup (C:\Program Files\Oracle\JInitiator 1.3.1.21\bin\hotspot) file.

But the problem persists.

We tested it with Fire fox and works fine.

Solution
The likely cause of the issue is an incompatibility between Jinitiator and a 3rd-party browser extension.
You can test this by disabling 3rd-party browser extensions as follows:
1. Navigate IE - Tools - Internet Options - Advanced - untick 'enable third-party browser extensions'
2. Re-start IE and re-test

Steps to be followed before using the Web ADI

1. Ensure that "Trust access to VBA Project Object Model" is selected when going to Microsoft Office button -> [Application] Options -> Trust Center -> Trust Center Settings -> Macro in Excel 2007

2. (1) Open Internet Explorer, click the Tools button, select Internet Options, then click the Security tab.
(2) Select the security zone that your web site is associated with - typically Local Intranet or Trusted Zones.
(3) Click on the Custom Level button.
(4) Scroll down until you find the settings – Automatic Promoting For File Downloads, File Download & Allow status bar updates via script.
(5) Check the Enable radio button.
(6) Save this change by clicking the Ok button

Unknown OracleAS Home Type Error Executing Runstartupconsole.Sh in a Middle Tier Home

When using the command runstartupconsole.sh to start up an Application Server 10g (10.1.2.x.x) Middle Tier on unix/linux, the following error is reported to the screen:

'I have encountered an unknown OracleAS Home type Business' (For a BI and Forms Middle Tier)

or

'I have encountered an unknown OracleAS Home type Portals' (For a Portal and Wireless Middle Tier)

The same command works fine when executed in an AS Infrastructure Oracle Home.

The runstartupasconsole.sh script is just a wrapper for opmnctl/emctl. To workaround the script failure execute the following commands:

To start:
$ORACLE_HOME/opmn/bin/opmnctl startall
$ORACLE_HOME/bin/emctl start iasconsole

To stop:
$ORACLE_HOME/bin/emctl stop iasconsole
$ORACLE_HOME/opmn/bin/opmnctl stopall

How to determine what email system is being utilized for Oracle Alert processing?

This depends on whether the following patch has been applied: 11i.ATG_PF.H Rollup 4 (RUP4) (Patch 4676589)

If unsure, check the file version of ALRALERT.fmx. Using Alert Manager responsibility, navigate to Alert / Define. From the menu, choose Help / About Oracle Applications. Under the heading Current Form, determine the version of: ALRALERT.fmx. If this version shows 11.5.55 or higher, then patch 4676589 HAS been applied.

If the patch 11i.ATG_PF.H Rollup 4 (RUP4) (4676589), has been applied then all Alert email will be sent through Workflow Mailer. For more information about this Mailer see:

Note 395128.1 Using Oracle Alert with Workflow Mailer

Note 164871.1 Configuring the Workflow Notification Mailer in Oracle Applications Manager 11i

For Oracle Applications that have not applied 11i.ATG_PF.H Rollup 4 (RUP4) (4676589), then this depends on the platform that is running the Application.

For all non-Windows platforms, Alert email will be sent through Unix Sendmail. Using Alert Manager responsibility, navigate to System / Options. The mail system: Unix Sendmail needs to be marked: ‘In Use’. For Windows platforms, Alert email will most likely be sent through MS Exchange Server. Using Alert Manager responsibility, navigate to System / Options. The mail system: Windows NT Mail needs to be marked: ‘In Use’. If another type of email is chosen like Lotus or Groupwise, the Alert email setup will be similar. See:

Note 174381.1 Oracle Alert 11i and Microsoft Exchange Server on Windows NT/2000 Setup Guide

How to find location of Install, Autoconfig, Patching , Clone and other logs in R12

Log files are useful in troubleshooting issues in Oracle Applications.
Here is the list of Log file location in Oracle Applications for Startup/Shutdown, Cloning, Patching, DB & Apps Listener and various components in Apps R12/12i:

Note:Instance top ($INST_TOP) is new directory added in R12 to keep the log files ,Startup/stop scripts for the application tier

A. Startup/Shutdown Log files for Application Tier in R12 =========================================================
i) Startup/Shutdown error message text files like adapcctl.txt, adcmctl.txt… :

$INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log

ii) Startup/Shutdown error message related to tech stack (10.1.2, 10.1.3 forms/reports/web) :

$INST_TOP/apps/$CONTEXT_NAME/logs/ora/ (10.1.2 & 10.1.3) $INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.3/Apache/error_log[timestamp] $INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.3/opmn/ (OC4J~…, oa*, opmn.log)$INST_TOP/apps/$CONTEXT_NAME/logs/ora/10.1.2/network/ (listener log) $INST_TOP/apps/$CONTEXT_NAME/logs/appl/conc/log (CM log files)

B. Log files related to cloning in R12
=======================================
Preclone (adpreclone.pl) log files in source instance

i) Database Tier-$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_.log)
ii) Apps Tier - $INST_TOP/apps/$CONTEXT_NAME/admin/log/ (StageAppsTier_.log)

Post-Clone (Adcfgclone.pl) log files in target instance
i) Database Tier- $ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_.log
ii) Apps Tier - $INST_TOP/apps/$CONTEXT_NAME/admin/log/ApplyAppsTier_.log

If your clone on DB Tier fails while running txkConfigDBOcm.pl ( Check metalink note - 415020.1) During clone step on DB Tier it prompts for “Target System base directory for source homes” and during this you have to give like /base_install_dir like ../../r12 and not oracle home like ../../r12/db/tech_st_10.2.0 C.

Patching related log files in R12
======================================
i) Application Tier-- adpatch log - $APPL_TOP/admin//log/
ii) Developer (Developer/Forms & Reports 10.1.2) Patch - $ORACLE_HOME/.patch_storage
iii) Web Server (Apache) patch - $IAS_ORACLE_HOME/.patch_storage
iv) Database Tier opatch log - $RDBMS_ORACLE_HOME/.patch_storage

D. Autoconfig related log files in R12
========================================
i) Database Tier Autoconfig log : $ORACLE_HOME/appsutil/log/$CONTEXT_NAME//adconfig.log $ORACLE_HOME/appsutil/log/$CONTEXT_NAME//NetServiceHandler.log
ii) Application Tier Autoconfig log -
$INST_TOP/apps/$CONTEXT_NAME/admin/log//adconfig.log

E. R12 Installation Logs
==========================
Database Tier Installation logs:

$RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTechStack_.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ohclone.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/make_.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/installdbf.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/adcrdb_.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDatabase_.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME//adconfig.log $RDBMS_ORACLE_HOME/appsutil/log/$CONTEXT_NAME//NetServiceHandler.log

Application Tier Installation logs :

$INST_TOP/logs/.log $APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppsTechStack.log $INST_TOP/logs/ora/10.1.2/install/make_.log $INST_TOP/logs/ora/10.1.3/install/make_.log $INST_TOP/admin/log/ApplyAppsTechStack.log $INST_TOP/admin/log/ohclone.log $APPL_TOP/admin/$CONTEXT_NAME/log/installAppl.log $APPL_TOP/admin/$CONTEXT_NAME/log/ApplyAppltop_.log $APPL_TOP/admin/$CONTEXT_NAME/log//adconfig.log $APPL_TOP/admin/$CONTEXT_NAME/log//NetServiceHandler.log
Inventory Registration logs : /logs/cloneActions.log /logs/oraInstall.log /logs/silentInstall.log

F. Other log files in R12 =========================
1) Database Tier
1.1) Relink Log files : $ORACLE_HOME/appsutil/log/$CONTEXT_NAME // make.log
1.2) Alert Log Files : $ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log
1.3) Network Logs : $ORACLE_HOME/network/admin/$SID.log
1.4) OUI Inventory Logs : $ORACLE_HOME/admin/oui/$CONTEXT_NAME/oraInventory/logs

Starting 10gr2 TNS Listener Yields TNS-12541, Linux Error: 111: Connection Refused

Lsnrctl start yields the following information. Attempting to start the Oracle10g R2 (10.2.0.1.0) TNS Listeneron Linux SuSE SLES9 x86_64:

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 02-DEC-2005 13:48:21Copyright (c) 1991, 2005, Oracle. All rights reserved.Starting /u01/oracle/product/10gdb/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 10.2.0.1.0 - ProductionSystem parameter file is /u01/oracle/product/10gdb/network/admin/listener.oraLog messages written to /u01/oracle/product/10gdb/network/log/listener.logListening on:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prod1.us.oracle.com)(PORT=1521)))Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=prod1.us.oracle.com)(PORT=1521)))TNS-12541: TNS:no listenerTNS-12560: TNS:protocol adapter errorTNS-00511: No listenerLinux Error: 111: Connection refusedConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL =IPC)(KEY=EXTPROC0)))

STATUS of the LISTENER
------------------------
Alias LISTENERVersion TNSLSNR for Linux: Version 10.2.0.1.0 - ProductionStart Date 02-DEC-2005 13:48:22Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/oracle/product/10gdb/network/admin/listener.oraListener Log File /u01/oracle/product/10gdb/network/log/listener.logListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prod1.us.oracle.com)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))Services Summary...Service "PLSExtProc" has 1 instance(s).Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...Service "10gdb1" has 1 instance(s).Instance "10gdb1", status UNKNOWN, has 1 handler(s) for this service...The command completed successfully

Any of the following listener error stacks might be thrown:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=prod1.us.oracle.com)(PORT=1521)))TNS-12541: TNS:no listenerTNS-12560: TNS:protocol adapter errorTNS-00511: No listenerLinux Error: 111: Connection refused

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))TNS-12537: TNS:connection closedTNS-12560: TNS:protocol adapter errorTNS-00507: Connection closed

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=prod1.us.oracle.com)(PORT=1521))) TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact Linux Error: 104: Connection reset by peer

Changes
This is likely a new installation.
Cause
1. There is possibly an incorrect IP Address specified for the host in the /etc/hosts file.For example:192.168.101.101 prod1.us.oracle.com prod1Whereas the actual ip address for the host "prod1.us.oracle.com" is 192.168.101.110
2. Also, the localhost reference may be incorrect or missing from the /etc/hosts file.
Solution
To implement the solution, please execute the following steps:
1. Correct the mapping in the /etc/hosts file by adding/correcting the IP address and/or hostname reference for the Unix/Linux Server (both long and short host names).For example:# Add or edit the /etc/hosts file to include a valid entry for the Server:192.168.101.110 prod1.us.oracle.com prod1
2. Check that the localhost loopback name and address are correct (both long and short host names).An example of a correct localhost entry would be as follows:
127.0.0.1 localhost.localdomain localhost
3. Remember to save the /etc/hosts file and then start the listener.

Interesting links around EBS Upgrade

Release 12.1
Operating Systems Install & Upgrade Notes
Note 761569.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for IBM AIX Based Systems (64-bit)'
Note 762891.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for HP-UX Itanium'
Note 762894.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for HP-UX PA-RISC (64-bit)'
Note 761564.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86'
Note 761566.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64'
Note 761568.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Sun Solaris SPARC (64-bit)'
Note 761567.1 - 'Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Microsoft Windows Server (32-bit)'Release Notes
Note 798258.1 - 'Oracle Applications Release Notes, Release 12.1.1'
Note 788053.1 - 'Oracle Applications NLS Release Notes, Release 12.1.1'

Upgrade and Preparation
Oracle Applications Upgrade Guide : Release 11i to Release 12.1.1
Note 752619.1 - 'Oracle E-Business Suite Release 12.1.1 Maintenance Pack Installation Instructions'
Note 374398.1 - 'Preparing Custom Development for Next Oracle E-Business Suite Release'
- 'Oracle E-Business Suite Upgrade Center - Home'
Note 761570.1 - 'Database Preparation Guidelines for an E-Business Suite Release 12.1.1 Upgrade'
Note 780989.1 - 'R12: Upgrade vs. Reimplementation (Financials)'

Maintenance Wizard
Note 215527.1 - 'Maintenance Wizard Overview'
Note 430732.1 - 'Downloading Maintenance Wizard'
Note 329476.1 - 'Installing the Maintenance Wizard: A Step-by-Step Guide'
Note 430734.1 - 'Maintenance Wizard User Guide Version 2.x'
Note 405263.1 - 'Maintenance Wizard FAQ'
Note 406917.1 - 'Maintenance Wizard Training Materials'
Note 291888.1 - 'Maintenance Wizard Scripting Language'

Interesting links about Applications Management Pack for E-Business Suite

Interesting links about Applications Management Pack for E-Business Suite

Introduction to Applications Management Pack
Oracle Grid Control Plug-in for Oracle Applications. 1.1 / 1.2: Scope DocumentNote 443521.1:Enterprise Manager Grid Control Plug-in for Oracle Applications, Version 1.0/1.2
Certification1. Enterprise Manager Grid Control
Note 412431.1 Oracle Enterprise Manager 10g Grid Control Certification Checker2. Applications Management Pack
Please find certification information in the Installation Notes listed below.3. Cloning with Applications Management Pack
Note 783188.1 Certified RAC Scenarios for E-Business Suite Cloning
AMP Installation
Note 394448.1: Getting Started with the Application Management Pack for Oracle E-Business Suite (Release 2.0.0-2.0.2)
Note 753584.1 Enterprise Manager Grid Control with Application Management Pack 2.0.2 for Oracle E-Business Suite Installation Guide
Note 812315.1:Oracle Application Management Pack for Oracle E-Business Suite, Release 3.0
AMP Troubleshooting/Known Issues
CATEGORY
DOCUMENT
Troubleshooting Guide
Note 412044.1 Application Management Pack for Oracle E-Business Suite Release 2.0 and 2.0.1 Troubleshooting Guide

Known Issues
Note 812294.1:Oracle Application Management Pack for Oracle E-Business Suite Release 3.0 Known Issues
Note 829450.1 Oracle Application Change Management Pack for Oracle E-Business Suite Known Issues

Log/Trace Files
Note 560350.1 How to trace Applications Management Pack (AMP) related issues and locate the log files
Note 387212.1:How to Locate the Installation Logs for Grid Control 10.2.0.x
Note 229624.1:How to Log and Trace the EM 10g Management Agents
Note 229627.1:How to Log and Trace the EM 10g Management Service

AMP Install/Upgrade
Note 568069.1 How to Verify Application Management Pack Installation?
Note 848760.1 java.sql.SQLException: ORA-20421: ERROR: The job type ebs_oam_register_ebsOd1...invalid command(s): OAMRegisterEBSOD

EM Diagkit
Note 421053.1:EMDiagkit Download and Master Index

Targets Deletion
Note 271691.1 How to Remove a Target From The EM 10g Grid Control Console

Automatic Discovery
Note 578356.1 Fail to get EMDCleint for Host, ORA-01403: no data found, ORA-06512: at "SYSMAN.MGMT_JOB_ENGINE"
Note 829317.1 AMP Discovery Fails with ORA-20233: Undefined Property Error
Note 758437.1 Can'T Add Target, Broken Reason=No Such Metadata
Note 798614.1 ServiceTemplateException: failed to apply ServiceTemplateException.;ORA-01403: no data found
Note 726956.1 Waited for five minutes, but unable to find TargetR12 (oracle_ias) in Repository
Note 432802.1 Waited for five minutes, but unable to find Target (oracle_ias) in Repository
Targets Status
Note 824236.1 AMP Application Nodes System Shows Pending After E-Business Discovery
Note 789368.1 How to troubleshoot Apps Listener down issues in EM Grid Control with Applications Management Pack
Note 731608.1 Applications Managment Pack Doesn't Show Report Server Up in an Apps Environment
Note 577351.1 Discoverer is Shown as Down in Grid Control AMP 2.0.1
Note 801494.1 Target "-Internal Concurrent Manager" status is DOWN although it is UP

AMP Cloning
Note 837157.1 Applications Management Pack cloning error: "zip error: Nothing to do!" while staging database
Note 848678.1 During Clone, Unable to select Policy Set for Data Scrambling. There are no Policy Sets found

Navigation/Accessing EM Grid Pages
Note 730402.1 Java.Lang.Nullpointerexception for Target Oracle-E-Business Suite

How to Generate a Specific Form Through AD utility ADADMIN

How to Generate a Specific Form Through AD utility ADADMIN

goal: How to Generate a Specific Form Through AD utility ADADMIN

fact: Oracle Application Object Library 11.5

fact: adadmin - Administration utility

fix:
Sometimes it might be necessary to generate a specific form due to several
possible reasons.

Here I will explain the steps to do so.

1) From a command line session, with OS applications user (i.e.: applmgr),
start ADADMIN utility. Please note that if your system is configured using
more than one tier, you should run this utility from the server which hosts
the forms server.

UNIX:

$ $AD_TOP/bin/adadmin

NT (From an ENVSHELL Command line session:

C:\ORACLE\PRODAPPL> %AD_TOP%\bin\adadmin.exe

2) Reply the questions as required:

Your default directory is '/u01/oracle/aol11iappl'.
Is this the correct APPL_TOP [Yes] ?
{If the above is true, then hit the [Enter] key).

AD Administration records your AD Administration session in a text file
you specify. Enter your AD Administration log file name or press [Return]
to accept the default file name shown in brackets.

Filename [adadmin.log] :

(Here you can record your adadmin session in a specific log file. If you want
adadmin to record your session, please enter a valid filename.
This log file will be saved in $APPL_TOP/admin//log
directory).

You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?

(This option only works in UNIX and the purpose of this question is to
notify AD administrator by mail if any failure ocurred while adadmin running
in unattended mode).

Please enter the batchsize [1000] :

(This option asks for a specific batch size, to reserve memory when
adadmin validates package and procedure information. This option only
is meaningful when running database administrative related tasks.
For the purpose of generating a form, you can leave the default value.)

After this last step, the utility will read the ad configuration file and
display related information. The next step which requires user interaction
is:

You are about to use or modify Oracle Applications product tables
in your ORACLE database 'aol11i'
using ORACLE executables in '/u01/oracle/aol11iora/8.0.6'.

Is this the correct database [Yes] ?

(If correct, please hit the [Enter] key. Otherwise, exit this utility
by typing "abort" plus the [Enter] key and verify if your environment
has
been sourced correctly).

AD Administration needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.

Enter the password for your 'SYSTEM' ORACLE schema:

(Here you must enter your SYSTEM database user password. There is no
default, since ADADMIN has no way to determine SYSTEM's password).

Connecting to SYSTEM......Connected successfully.

The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS

Enter the ORACLE password of Application Object Library [APPS] :

(At this point, please provide the APPS database user password.
By default, the password is APPS).

Once reached this point, the utility will try to connect to your
database and get information regarding your system.

The next step which requires user interaction is the main menu:

AD Administration Main Menu
--------------------------------------------------

1. Maintain Applications Files menu

2. Exit AD Administration

Enter your choice :

Note: In the example, we are showing the main menu for a forms tier
adadmin.

In single node installations, the menu is:

AD Administration Main Menu
--------------------------------------------------

1. Maintain Applications Database Objects menu

2. Maintain Applications Files menu

3. Exit AD Administration

Enter your choice :

2) Please select option "Maintain Applications Files menu" by
entering
the number located at the left of this option. In the above example, please
enter 2

3) Now, you wil.
l be able to see another menu:

Maintain Applications Files
----------------------------------------

1. Create Applications environment file

2. Relink Applications programs

3. Copy files to destinations

4. Convert Character Set

5. Verify files necessary for runtime

6. Generate message files

7. Generate form files

8. Generate graphics files

9. Generate product jar files

10. Return to Main Menu

Enter your choice :

In order to generate a specific form, you need to select option
"Generate form files". Please do so by entering the number located
at the left of the mentioned option (in this case, 7).

4) Now, you will be asked the for the number of parallel workers that
will start generating forms


Connecting to SYSTEM......Connected successfully.

Enter the number of workers [3] :

In order to determine the optimal number of workers for your system,
you should consider the following:

Total of available workers for your system = Amount of processors x 3

But in our case, we will generate only ONE form, so there is no need to
invoke 3 workers. In our example, we will generating one single form
but for 2 languages US (American English) and ESA (Latin American
Spanish), so the number of workers needed will be 2.

5) The next question is:

Your current character set is "WE8ISO8859P1".

Do you want to generate Oracle Forms objects
using this character set [Yes] ?

If this is your correct character set, please hit [Enter]. Otherwise,
please verify your environment.

6) Do you want to regenerate Oracle Forms PL/SQL library files [Yes] ?

In this case, we will not generate any PL/SQL library, so you might reply 'n'
to the above question.

7) Do you want to regenerate Oracle Forms menu files [Yes] ?

Same as above: Please reply 'n' to this question.

8) Do you want to regenerate Oracle Forms executable files [Yes] ?

Here, we will hit [Enter] to accept the default 'Yes'.

9) Enter list of products ('all' for all products) [all] :

Now, we need to specify the Application short name. (gl, for General Ledger,
ap for Payables, and so on). In our example we will be using module fnd
(Application Object Library). The entry must be typed using lowercase
characters.

10) Generate specific forms objects for each selected product [No] ?

We need to answer 'y' to this question, since it will regenerate all
forms for the module selected on step 9.

11) The next question is:

The current set of installed languages is: US ESA

Please select languages for generating Oracle Forms files.
You may select all of the above languages, or just a subset.

Enter list of languages ('all' for all of the above) [all] :

in this case, you will reply 'all', since we will regenerate
the form for all existing languages.

12) Reply to the validation 'y' in
You selected the following languages: US ESA

Is this the correct set of languages [Yes] ?

13) At this point, you will receive, based on how you answered the questions
a list of all posible forms that you are able to regenerate:

Selecting product forms to generate...

Selecting forms for Application Object Library...

List of forms in Application Object Library :

APPTREE.fmx FNDADDSQ.fmx FNDADDTC.fmx FNDADDVW.fmx FNDAPLT.fmx
FNDATCAT.fmx FNDATDAG.fmx FNDATDAI.fmx FNDATDAT.fmx FNDATDOC.fmx
FNDATENT.fmx FNDATFUN.fmx FNDATTCH.fmx FNDCPDCL.fmx FNDCPDCQ.fmx
FNDCPDCS.fmx FNDCPDIA.fmx FNDCPDPD.fmx FNDCPDSR.fmx FNDCPMCP.fmx
FNDCPMMD.fmx FNDCPMMT.fmx FNDCPMPE.fmx FNDCPRNO.fmx FNDCPVCM.fmx
FNDCPVWR.fmx FNDFBMAS.fmx FNDFBMPA.fmx FNDFBRFP.fmx FNDFBTST.fmx
FNDFFIDF.fmx FNDFFIIF.fmx FNDFFMCV.fmx FNDFFMDC.fmx FNDFFMHL.fmx
FNDFFMIS.fmx FNDFFMSA.fmx FNDFFMSV.fmx FNDFFMVS.fmx FNDFFMWP.fmx
FNDFFSRA.fmx FNDFFSRN.fmx FNDFFTST.fmx FNDFLADM.fmx FNDFMFBF.fmx.

FNDFMFUN.fmx FNDLVMLU.fmx FNDMDMSG.fmx FNDMNMNU.fmx FNDNLDCX.fmx
FNDNLDLG.fmx FNDNLDTI.fmx FNDPMNET.fmx FNDPOMPO.fmx FNDPOMPV.fmx
FNDPOMSV.fmx FNDPRMPD.fmx FNDPRMPR.fmx FNDPRRPS.fmx FNDPRTYP.fmx
FNDRSGRP.fmx FNDRSRUN.fmx FNDRSSET.fmx FNDSCAPP.fmx FNDSCAUS.fmx
FNDSCDDG.fmx FNDSCGRP.fmx FNDSCMON.fmx FNDSCMOU.fmx FNDSCPLS.fmx
FNDSCRSP.fmx FNDSCSGN.fmx FNDSNASQ.fmx FNDSNDCT.fmx FNDSNDSQ.fmx
TEMPLATE.fmx

Enter forms to generate, or enter 'all' [all] :


in our example we will try to regenerate FNDCPMCP.fmx.

Please enter 'FNDCPMCP.fmx' at the prompt. Once you did so, adadmin
will invoke Forms 60 compiler and will regenerate the forms.

If any error found, please review the adadmin log file and the worker log
file. The workers log files are also located at $APPL_TOP/admin/