Oracle World

Thursday, October 13, 2011

How to generate FND Debug log

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: How to generate FND Debug log

Solution:

FND Debug log:
1) Please set following profile options on user level, using responsibility System administrator:

FND: Debug Log Enabled YES
FND: Debug Log Filename NULL
FND: Debug Log Level STATEMENT
FND: Debug Log Module %

2) Note down current max value of log sequence retrieved as follows :

SELECT MAX(LOG_SEQUENCE)
FROM FND_LOG_MESSAGES

3) Run your test case, try to stay on track in reproducing the issue and leave out extraneous steps so that you don't end up with debug messages that are not relevant to your issue.

4) For ease of review spool the output of the following to a .xls spreadsheet :

SELECT module, message_text
FROM fnd_log_messages
WHERE log_sequence > &max_log_from_step2
ORDER BY log_sequence;

Get Oracle Certifications for all Exams
Free Online Exams.com

"Exception in thread "thread applet-oracle.forms.engine.Main-2" java.lang.IllegalAccessError: class oracle.forms.ui.VTextField$FormsPWAccess cannot access its superclass oracle.ewt.lwAWT.lwText.LWTextField$Access"

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: "Exception in thread "thread applet-oracle.forms.engine.Main-2" java.lang.IllegalAccessError: class oracle.forms.ui.VTextField$FormsPWAccess cannot access its superclass oracle.ewt.lwAWT.lwText.LWTextField$Access"

On : 6.0.8.28.0 version, Forms for App Technology

When attempting to start forms,
the jre console displays an exception and the form session did not start.

ERROR
-----------------------
"Exception in thread "thread applet-oracle.forms.engine.Main-2" java.lang.IllegalAccessError: class oracle.forms.ui.VTextField$FormsPWAccess cannot access its superclass oracle.ewt.lwAWT.lwText.LWTextField$Access"

Symptoms:

The issue can be reproduced at will with the following steps:
1. Login to apps
2. Select a form resposibility
3. The form session did no start
Apps login is successful but after launching forms, window open but progress bar stops shortly after and jre console displays an exception "Exception in thread "thread applet-oracle.forms.engine.Main-2" java.lang.IllegalAccessError: class oracle.forms.ui.VTextField$FormsPWAccess cannot access its superclass oracle.ewt.lwAWT.lwText.LWTextField$Access"

Log files:

jre_log.trace
Exception in thread "thread applet-oracle.forms.engine.Main-2" java.lang.IllegalAccessError: class oracle.forms.ui.VTextField$FormsPWAccess cannot access its superclass oracle.ewt.lwAWT.lwText.LWTextField$Access
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClassCond(Unknown Source)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.security.SecureClassLoader.defineClass(Unknown Source)
...
at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
basic: Starting applet teardown
basic: Finished applet teardown
Thread causing the error:Forms-StreamMessageWriter
java.lang.InterruptedException
at java.lang.Object.wait(Native Method)
at oracle.forms.engine.Heartbeat.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Solution:

The version of the fndjar.dep is 115.296 as expected, which confirms interop patch was applied

Comparing class sizes of EWT classes delivered by Patch 9863561 (ewt3.jar) and the ones included in the fndewt.jar uploaded. Starting with the classes mentioned in the error:

oracle.forms.ui.VTextField$FormsPWAccess
- Patch 695 bytes
- JAR 695 bytes

>>> Seems fine

oracle.ewt.lwAWT.lwText.LWTextField$Access
- Patch 2.590 bytes
- JAR 2.570 bytes

>>> These are different !!!!!

Compared sizes of all files in the 'oracle.ewt.lwAWT.lwText' between Patch 9863561 and FNDEWT.JAR. This shows that also following classes has different size.

LWTextField.class
Paragraph.class

This seems to indicate that during application of Patch 9863561 something went wrong with the manual steps to be done with the ewt3.jar. The above results indicate that incorrect (older?) versions of the ewt3 classes are picked up and these cause the 'corruption'.....

1. Redo the copy actions to apply patch 9863561 and ensure the ewt3.jar delivered by this patch is extracted.

2. After having this done confirm that the classes in ewt directory on the server have the same size as mentioned in the below update "PATCH - \ewt3\oracle\ewt\lwAWT\lwText" and the other Forms classes also do have equal sizes as delivered in the patch.

3. If this is the case regenerate the PRODUCT JAR files in ADADMIN and retest

4. Migrate the solution as appropriate to other environments.

Get Oracle Certifications for all Exams
Free Online Exams.com

"Error Codes: EHWH2A7E" in OBIEE (installed in HP-UX) while running the drill down report

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: "Error Codes: EHWH2A7E" in OBIEE (installed in HP-UX) while running the drill down report

Symptoms:
While drilling down the reports from dashboard, rather than showing the expected results it is showing error message "Error Codes: EHWH2A7E". We have tried to redeploy the repository, clear cache and restart application but the same issue persists. The reports are developed in local OBIEE 10.1.3.4.1 environments installed in windows and later deployed in OBIEE 10.1.3.4.1 in HP-UX environment where it is displaying this error message.

Log files:
A numeric value was expected (received "4389")
Error Codes: EHWH2A7E

Solution:

Known issue; BUG 8394579.

>> BUG 8394579 - NUMERIC INPUT RESULTS IN NON-NUMERIC ERROR

The following article on 'My Oracle Support' explains more about this issue.
>> Encountered error code EHWH2A7E after installing patch 10.1.3.4.1 (Doc ID 872035.1)

Get Oracle Certifications for all Exams
Free Online Exams.com

Conflict when applying DB patch 9032412 (pre-req for APPS CPU APR2010) - conflicts with DB patch 9352164 (10.2.0.4.4 PSU incl. CPU APR2010)

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:

Conflict when applying DB patch 9032412 (pre-req for APPS CPU APR2010) - conflicts with DB patch 9352164 (10.2.0.4.4 PSU incl. CPU APR2010)
Symptoms:
DB upgraded from 10.2.0.2 to 10.2.0.4.4 PSU. APP upgraded to RUP7. Now, to apply APP CPU APR2010, was trying to apply patch 9032412 but conflict reported with DB PSU 10.20.0.4.4 (9352164).

Log files:

opatch apply
Invoking OPatch 10.2.0.5.0

Oracle Interim Patch Installer version 10.2.0.5.0
Copyright (c) 2010, Oracle Corporation. All rights reserved.

Oracle Home : db/10.2.0
Central Inventory : db/10.2.0/oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version : 10.2.0.5.0
OUI version : 10.2.0.4.0
OUI location : db/10.2.0/oui
Log file location : db/10.2.0/cfgtoollogs/opatch/opatch2010-09-16_11-12-45AM.log

Patch history file: db/10.2.0/cfgtoollogs/opatch/opatch_history.txt

ApplySession applying interim patch '9032412' to OH 'db/10.2.0'
Interim patch 9032412 conflict with patch(es) [ 9352164 ] in the Oracle Home

Patch [ 9032412 ] conflict with patch(es) [ 9352164 ] in the Oracle Home.

To resolve patch conflicts please contact Oracle Support Services.
If you continue, patch(es) [ 9352164 ] will be rolled back and the new Patch [ 9032412 ] will be installed.

Solution:

applying patch 9032412 would be bad/contraproductive.
Patch 9352164 DATABASE PSU 10.2.0.4.4 (INCLUDES CPUAPR2010) already contains the newer CPUAPR2010 patch (from April 2010).
Patch 8836683 - DB-10.2.0.4-MOLECULE-033-CPUOCT2009 would apply a molecule of the much older CPUOCT2009 (from October 2009) and this is not useful (you do not want to replace a newer CPU with an older CPU).

Customers who run PSU patches should no longer apply PSU patches anyway (this is described in Note.854428.1 Patch Set Updates for Oracle Products: => see step 8.) as the PSU patch contains the suitable CPU patch.
So in your case there is no action required. You should NOT apply any of the patches listed in this SR as you already run the latest Patch 9352164 DATABASE PSU 10.2.0.4.4 (INCLUDES CPUAPR2010)

References:

Patch 9352164 DATABASE PSU 10.2.0.4.4 (INCLUDES CPUAPR2010)
(Note.9352164.8 Bug 9352164 - 10.2.0.4.4 Patch Set Update (PSU))

Bug 9032412 - MERGE REQUEST ON TOP OF 10.2.0.4.0 FOR BUGS 6600051 & 8836683
Bug 6600051 - AQRAC:ENQUEUE AND ALTER QUEUE TABLE RESULT IN HANG IN RAC ENV
=> according to internal Note 1123863.1 this got fixed in 10.2.0.4.3 (and later as PSUs are cumulative)
Bug 8836683 - DB-10.2.0.4-MOLECULE-033-CPUOCT2009 (see Note 881301.1)

Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], [], causing the batch schedule program failing.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], [], causing the batch schedule program failing.

Symptoms:

On HP-UX Itanium running 10.2.0.4 in Production

The following error causes the batch schedule program failure.

ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []

Log files:

trace

*** 2010-07-13 09:52:14.429
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []
Current SQL statement for this session:
select case
when o.seq = 1 and o.max_val = 1 then
' <Item'||chr(10)||
' ChangeType="'|| decode(o.change_type,'ADD','UPS',o.change_type)||'"'||chr(10)||
' ID="'||o.item||'"'||chr(10)||
' Type="'||o.item_type||'"'||chr(10)||
.
.
.

and o.vat_region = vd.vat_region (+)
and o.item = vi.item (+)
and o.vat_region = vi.vat_region (+)
and vi.seq (+) = 1
order by o.item, o.seq, o.max_val
----- Call Stack Trace -----

ksedst <- ksedmp <- ksfdmp <- kgeriv <- kgesiv <- ksesic0 <-
kkoipt kkoqbc apakkoqb apaqbd apaqbd apadrv opitca kksFullTypeCheck rpiswu2

Solution:

Bug:5652086 - OERI[15160] from ANSI join
Fixed-Releases: A204 B200
Tags: ANSI OERI Details: A query with a ANSI join can fail with ORA-600 [15160].

Note 5652086.8 - Bug 5652086 - OERI[15160] from ANSI join

This error due to the problem investigated in the following bug
Bug:5652086 - OERI[15160] from ANSI join

- Upgrade to 10.2.0.5
- No solution for the issue available on top of 10.2.0.3 (No patches available on 10.2.0.3 for HP-UX Itanium)

1. Download and review the readme and pre-requisites ** CAREFULLY** for Patchset 6810189

Patchset 8202632
Description 10.2.0.5.0 PATCH SET FOR ORACLE DATABASE
Product Oracle Database Family
Release 10.2.0.5

2. Ensure that you have taken a backup of your system before applying the patchset

3. Apply the patchset in a test environment.

4. Retest the issue.

5. Migrate the solution as appropriate to other environments.

Workaround:
-------------

he only possible method that's may to stop the error is testing the following values

1) alter session set "_qa_control"=521;
2) alter session set "_qa_control"=64;
3) alter session set "_qa_control"=32;
4) alter session set "_qa_control"=16;
5) alter session set "_qa_control"=8;
6) alter session set "_qa_control"=4;
7) alter session set "_qa_control"=2;
8) alter session set "_qa_control"=1;
9) alter session set "_qa_control"=0;

Test each of the values above in a separate session in the same order.

Get Oracle Certifications for all Exams
Free Online Exams.com

Missing responsibilities after 'affurgol.sql FORCE'

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Missing responsibilities after 'affurgol.sql FORCE'

Symptoms:
Being in "11i.AD.I.6" patch level with "11.5.10.2" release , on following below steps mentioned in Metalink Note # 335487.1 & 316959.1; {I ran with 'affurgol.sql FORCE'.}we lost all the responsibilities that came as part of production cloning. Now when we login to HTML page, it doesn't show any responsibilities.
Log files:

Solution:

1. Install the Patch mentioned in Metalink Note #433473.1 that fixes the cache issue, otherwise ...you need to clear cache and bounce Apache very often
2. Run Workflow Directory Services User/Role Validation concurrent request only once with the parameters as "1000,yes,yes,no"
3. Rebuild the WF_deferred and java_deferred queues
4. disable AP_WEB_PROXY_ASSIGN_PKG.proxy_assignments subscription

References:

Reference bug : 7410672 => HOW TO UNDOO RUN OF: AFFURGOL.SQL FORCE

Get Oracle Certifications for all Exams
Free Online Exams.com

How to enable the As control in 10.1.3.1?

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: How to enable the As control in 10.1.3.1?

Symptoms:
Installation went successful. But em page is not coming.

Solution:
The AS Control in OracleAS 10g Rel 3 (10.1.3) is a j2ee application deployed in the default OC4J instance.

If you perform a basic install of OracleAS 10.1.3 the AS Control application will be activated by default as part of the install process.

If you choose the OracleAS 10.1.3 Advanced Install type, the installation process will only activate the application if you choose to make the OracleAS instance an administration instance. This is done in the install "Administration Settings Screen". In this screen there is a checkbox labelled

"Configure this as an administrative instance"

If this checkbox left unchecked the resulting OracleAS instance will not have an active AS Control application. The assumption is that you will be installing other OracleAS 10.1.3 instances as part of a cluster topology and one of the OracleAS instances will be chosen to be 'configured' as the administrative instance, and thus host the active AS Control application.

Note: Only one OracleAS instance in a cluster topology can have an active AS Control. In other words one AS Control application is used to manage all OracleAS instances configured in a cluster topology.

Question:

If you have

- mistakenly forgotten to check the box
or
- checked the box for more than one OracleAS instance install in a cluster topology
or
- simply wish to transfer the active AS Control to a different OracleAS in a cluster topology

what steps should be taken?
Solution

Disabling an Application Server Control instance
If two OracleAS instances are clustered together and ASC application is running on both instances, the following warning will appears in the browser when ASC is accessed:

Warning
You have more than one instance of the Application Server Control application running in this cluster. This is not a recommended configuration and could lead to unexpected problems. Please stop the additional instances of Application Server Control or disable routing to these instances.

Perform following steps on one of the nodes to disable the ASC application:

1. Stop the AS Control application:
opmnctl stopproc application=ascontrol

2. Modify /j2ee/home/config/default-web-site.xml. Configure ohs-routing= "false" for the web-app application="ascontrol" element.

3. Modify /j2ee/home/config/server.xml. Configure start="false" for the application name="ascontrol" element

Enabling an Application Server Control instance

If you failed to check the box "Configure this as an administrative instance" then an attempt to access the AS Control will simply fail with

HTTP 404 Not Found

appearing in the browser

To rectify (without recourse to a reinstall), follow the advice given in

Oracle Application Server Administrator's Guide 10g Release 3 (10.1.3.1.0)
Appendix A Managing and Configuring Application Server Control
A.6.4 Identifying and Configuring a New Active Application Server Control

This is also the advice to be followed if the AS Control is active and working fine, but you wish to switch the active deployment to a different OC4J instance.

References:

Note.418395.1 - How to Activate or Reconfigure the OracleAS 10.1.3 AS Control Application Post Install

Get Oracle Certifications for all Exams
Free Online Exams.com