oracle frm 40737,Troubleshooting Using Forms with App11i&11.0(2)

11. FRM-92100 Error Occurs After Applying Developer Patch

8

Problem

After applying Oracle Forms Developer patch 8, the following

error occurs after logging into Applications:

FRM-92100

Your connection to the server was interrupted

Solution

Please follow Note:125767.1 and make sure the required patches

are installed e.g. patch 2115765.

References

Note:125767.1 Upgrading Developer 6i with Oracle Applications

11i

12. FATAL?(18) Error(s) with

Flint60 when Upgrading Custom Forms From 4.5 to 6i

Problem

The following error occurs when converting forms 4.5 (10.7) to

forms 6i using the flint60 utility:

Flint60

Utility Core Dumps Fatal? (18)]

(18)Passed

in type does not match the actual object

fnd/src/flint/flup.c line:166(182) [Oct 27 2001 14:57:39]

Applying patch 2151584 makes no difference.

Manually relinking flint60 executable makes no difference.

Solution

This error is raised in bug 2253536, which is based on bug

1856386.

Please apply patch 2253536.

References

Note:171710.1 FATAL?(18) Error(s) with Flint60 when Upgrading

Custom Forms From 4.5 to 6i

Note:112536.1 How Do I Upgrade Custom Forms from 10.7/11.0.x to

11i?

13. Forms Applet Gives Core Dump

With Error Code: 11, Call Stack Trace Fails At Siehjmpt

Problem

When preparing to applying 11.5.6. ERP Family Pack, one of the

pre-installation steps is to upgrade to the latest Oracle 6i Forms

patchset.

After followed Note:125767.1 and after successfully applying

required patches for Developer 6i, Developer6i Patch 9,

Interoperability Patch, the following core dump

error occurs when the Form Applet starts:

ERROR:

Abnormal termination of connection, Error Code: 11

FORM/BLOCK/FIELD: FNDSCSGN:NAVIGATOR.TYPE

Last

Trigger: WHEN-NEW-FORM-INSTANCE - (In Progress)

Msg:

Last

Builtin: USER_EXIT - (In Progress)

------------- Call Stack Trace [ConnId = 1, ProcId = 84848]

-------------

calling call entry argument values in hex

location type point (? means dubious value)

-------------------- -------- -------------------- ----------------------------

siehjmpt+02fc bl siehDump 2FF18F78 ? D9004CE0 ? B ?

D0B2 ?

00004774 ? 00000000

------------- End of Call Stack Trace -------------

Other symptoms:

- The Java Console completes, the security form starts (FNDSCGN)

and then dies.

- Relinked with updated LD_LIBRARY_PATH and regenerated the jar

files via adadmin.

- iAS and Forms6i Server are started.

- Login to the Responsibilities page is successful on "Single

SignOn".

Solution

1. Try relinking f60webmx and confirm that $FND_TOP/bin/f60webmx

is overwritten and the timestamp is updated.

Relink

f60webmx passing link_debug=y parameter which stops the

linker

stripping

out the symbols.

2. If step 1 makes no difference, this could be related to

Bug:1455853. Please apply patch 2074588. This is partly documented

in Note 165029.1 step 2.

3. Please regenerate all forms.

References:

Note:125767.1 Upgrading Developer 6i with Oracle Applications

11i

Note:165029.1 Quick Run Down Of Issues Found With Applying

FND.D Patch 1932070

14. Launching A Second

Responsibility Causes Problems When Navigating Using A

Mouse

Problem

Login to Applications works and launching a responsibility works

successfully. The user is able use

the mouse to navigate to any field on a given form and it redirects

the cursor there.

On launching a second responsibility and navigate back to the

first open responsibility screen, the

mouse can no longer be used to navigate from field to field.

The user then can only navigate between fields using the tab

key.

Solution

This issue is similar to the problem with a loss of

synchronization between the client and the middle tier,

raised in bug 1875006. This is fixed in patch 2010167 and Developer

Forms 6.0.8.18.

Please apply the latest patchset for Developer Forms.

References

Bug:1875006 Cursor Returns To Original Item After Clicking On A

New Item With The Mouse

15. Forms Process Holding The Session

Causing PGA Increase, User Web Connections Using >

30M

Problem

Instance each user session is using on average more than 30

megabytes of memory. This is causing

a general performance issue on the machine and is affecting other

instances.

The following script gives the current PGA and UGA size for the

session. For this issue,

run the script several times and monitor the user session

memory.

column username format a10;

column name format a30;

SELECT V.sid,

P.SPID "OS_PID",

P.USERNAME "OS_USERNAME",

U.USERNAME "USERNAME",

P.PROGRAM "PROGRAM",

B.NAME,

TO_CHAR(V.VALUE,'999,999,999.99')

FROM V$SESSTAT V, V$STATNAME B, V$SESSION U, V$PROCESS P

WHERE V.STATISTIC# = B.STATISTIC# AND

U.SID = V.SID AND

(B.NAME LIKE '%pga%' OR B.NAME LIKE '%uga%') AND

U.USERNAME <> ' ' AND

U.PADDR = P.ADDR

ORDER BY V.SID,B.NAME;

Solution

Please apply latest forms patchset by following Note

125767.1.

This could possibly be related to any of the following

issues:

Bug 1882902 Unable to Perform Query While Opening AR Form To

See Invoice Details

This issue is based on Bug 1987820; the fix is scheduled to be

fixed in patchset 11i.AR.K.

Bug 1734087 High Memory Consumption By Cached Application Info

SQL

This issue is fixed in patch 1829459 and 11i.FND.D (patch

1932070)

Bug 762114 CBO And Large In-Lists Can Waste Private

Memory.

This isse is fixed in Server releases: 8.0.6.2, 8.1.6.2,

8.1.7.0.

References:

Note:125767.1 Upgrading Developer 6i with Oracle Applications

11i

Bug:1882902 Unable to Perform Query While Opening AR Form To

See Invoice Details

Bug:1987820 AppsPerf: AR: Tune The RA_CUSTOMER_TRX_V View

Bug:1734087 High Memory Consumption By Cached Application Info

SQL

Bug:762114 CBO And Large In-Lists Can Waste Private

Memory.

Note:61998.1 Introduction to Tuning Oracle7 / Oracle8 / 8i /

9i

16. Error FRM-92050 Occurs After

Upgrading Developer Forms 6i

Problem

The following error occurs when connecting to Applications after

applying Developer

Forms 6i Patchset 9 (patch 2211449):

FRM-92050: Failed to connect to the Server:

:9001

Solution

Please make sure the required interoperability patch installs

successfully. In this case,

patch 2161931 needs to be applied. This is documented in the

Note:125767.1.

References

Note:125767.1 Upgrading Developer 6i with Oracle Applications

11i

17. 'Would

You Like To Log Back In So You Can Continue Working?' Timeout

Message In 11i

Problem

The following timeout message window appears eventhough the

following profile options are

set for 11i : ICX: Limit Time = 999999, ICX: Limit Connect = 1000,

ICX: Session Timeout = NULL:

"Your log on session is no longer

valid.

Would you like to log back in

so you can

continue working? If you do

not log in, any

outstanding data changes in

your forms will

not be saved. "

Solution

The ICX:LIMIT TIME is set for many hours - 1 year =

8,736 hours.

Try setting ICX: Limit Time to 999 and ICX:Limit Connect to 2000

to more appropriate values

for your system. E.g. set ICX: Limit Time to 999 and ICX: Limit

Connect to 2000.

References

Note:171261.1 11i Timeout Window - Would You Like To Log Back

In To Continue Working?

18. File Does Not

Exist Error For AlertBundle_en_US.class Appears In Apache

Error_log.txt

Problem

Errors appear in the Apache error log:

[Fri Mar

22 14:58:13 2002] [error] [client 192.236.1.170] File does not

exist:

/

usr1/oracle/opiccomn/java/oracle/ewt/alert/resource/AlertBundle_en_US.class

[Fri Mar 22

14:58:13 2002] [error] [client 192.236.1.170] File does not

exist:

/

Solution

This error is one that you can safely ignore.

References

Bug:1265762 AOL: Class Files Are Being Called In Java Console,

S/B Jar Files

Bug:1376609 The EWT Resource Bundles Are Missing From

java/oracle/ewt/alert/resource

19. NLS:

MissingResourceException: Can't Find Resource For File

AccessibilityBundle_en_US

Problem

In an Applications NLS environment, the following error occurs

in the Java Console window:

"

java.util.MissingResourceException: can't find resource for

oracle.ewt.access.resource.AccessibilityBundle_en_US:

oracle.ewt.access.resource.AccessibilityBundle not found"

fndewt.jar shows AccessibilityBundle.class exists but not

AccessibilityBundle_en_US in EWT:

oracle/ewt/access/resource/AccessibilityBundle

oracle/ewt/alert/resource/AlertBundle

oracle/ewt/color/resource/ColorBundle

oracle/ewt/dialog/directory/resource/DirectoryDialogBundle

oracle/ewt/font/resource/FontBundle

oracle/ewt/lwAWT/lwWindow/laf/resource/SystemMenuBundle

oracle/ewt/shuttle/resource/ShuttleBundle

oracle/ewt/wizard/resource/WizardBundle

Solution

Several NLS issues were raised in early Forms 6i versions which

were caused by missing files

EWT files. Generally, the advice from Oracle Support is to see if

the problem reproduces when

using the latest Forms 6i patch with the latest supported release

of Jinitiator.

References

Bug:1454440 ADA: No AccessibilityBundler - Translations Fail In

Apps 6.0.8.10.3

Bug:769120 Forms Need To Set The Java Locale To Be Consistant

With NLS_LANG, fixed in Forms 6.0.8.14.

Bug:1736371 NLS: English Resource Files Missing From The EWT

Resource Bundle, fixed in EWT 3.4.6.

Issues in 11.0

1. FRM-40800

When Starting NCA Applet Viewer After Upgrading Dev2k 1.6.1

Problem

The system is running Applications 11.0.3 in Server Partitioned

mode with 8.0.6 and 8.1.7.

Developer 2000 was upgraded from 4.5.10.17.0

(Dev2k 1.6.1 patch 11) to version 4.5.10.22 by

applying patch 16 (patch 1699863.)

Relinked procbuilder, browser20, forms45 , reports25, graphics25

using *wv8.mkNo

Now error FRM-40800 occurs when starting the NCA applet viewer.

Solution

The Forms executable was not relinked with the new form

version.

1. Renamed the file f45webm to be f45webm.

2. Connect to your Forms Server as applmgr and run the following

command:

$FND_TOP/bin> adrelink force=y ranlib=y "fnd

f45webm"

3. Apply I/O patch 1713365.

References

Bug:1713365 Applications Interoperability Patch For D2k1.6.1

Patch 16 (Forms 4.5.10.22)

2. Error

FRM-92050 Occurs After Applying Developer 2k 1.6.1 Patch 16

Problem

After applying Developer 2k 1.6.1 upgrade patch 16, the

following error occurs in several forms:

FRM-40737: Illegal restricted procedure SYNCHRONIZE in

WHEN-VALIDATE-ITEM trigger

Solution

Similar FRM-40737 errors are raised in several notes and bugs,

e.g. bug 2012165. There is no single fix that will resolve

synchronize issues accross product groups. It is

the responsibility of the individual product group to fix problems

with the form in question. Please provide a Forms Runtime

Diagnostics trace with the error.

@ Support analysts will find bug 1841721 useful for Development

view of handling FRM-40737 error.

References

Bug:2012165 When Open Receipts Form Gives Error

FRM-40737,FRM-40734,FRM-40350

Note:150168.1 Obtaining Forms Runtime Diagnostics (FRD) In

Oracle Applications 11i

Note:148982.1 How To Perform Forms Runtime Diagnostics (FRD)

Tracing In Applications 10.7 and 11.0

3. Error

FRM-99999 Occurs And Forms Server Process Dies After Upgrading The

Database

Problem

Upgraded database to Oracle 8i by following 8i interoperability

Note 148902.1. Now the following error

occurs on the clients:

FRM-99999: A network error occurred, the client will not be able to

continue.

Forms Server log:

FORMS CONNECTION ACTIVITY LOG FILE

Developer/2000:Forms/LogRecord

[Tue Mar 26 12:21:32 2002 EST]::Server Start-up Data:

Server Log Filename: /export/home/oracle/f45_test.log

Server Hostname: un-010-prod1

Server Port: 9001

Server Pool: 1

Server Process Id: 27712

[Tue Mar 26 12:21:32 2002 EST]::READY_FOR_CONNECTION [Port

9001]

[Tue Mar 26 12:22:47 2002 EST]::Connection Request [ConnId=0,

Addr=10.59.206.87:1925]

Solution

Please regenerate forms, libraries, and menus using Adadmin

utility. If the error still occurs,

please follow Note 73332.1 and Note 103502.1 referenced below.

References

Note:73332.1 FRM-99999 - Troubleshooting Common NCA

Problems

Note:103502.1 Verifying JAR file versions for FRM-99999 errors

in Apps 10.7NCA and 11

Note:148902.1 Interoperability Notes Oracle Applications

Release 11.0 with Release 8.1.7