OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » FRM-40735 Error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FRM-40735 Error [message #146438]

Thu, 10 November 2005 07:39

Safeeq.S
Messages: 100
Registered: October 2005
Location: Bangalore

Senior Member

Hi All,
I have created a new form with 2 database tables.When i tried to execute the form, its throwing me an error like
'FRM-40735:ON ERROR trigger raised unhandled exception ORA06508'.

Could any one tell me how to go about it?

Report message to a moderator

Re: FRM-40735 Error [message #146440 is a reply to message #146438]

Thu, 10 November 2005 07:43

Safeeq.S
Messages: 100
Registered: October 2005
Location: Bangalore

Senior Member

Sorry, i'd forget to mention about the piece of the code that is written in that ON_ERROR trigger.

ON_ERROR Trigger :-

APP_STANDARD.EVENT('ON-ERROR');

Regards
Safeeq

Report message to a moderator

Re: FRM-40735 Error [message #146441 is a reply to message #146440]

Thu, 10 November 2005 07:47

Maaher
Messages: 7065
Registered: December 2001

Senior Member

ORA-06508 PL/SQL: could not find program unit being called


Cause: An attempt was made to call a stored program that could not be found. 
The program may have been dropped or incompatibly modified, or have compiled with errors.

Action: Check that all referenced programs, including their package bodies, exist and are compatible.

MHE

Report message to a moderator

Re: FRM-40735 Error [message #207258 is a reply to message #146441]

Mon, 04 December 2006 20:56

yanfuju_1979
Messages: 42
Registered: October 2006

Member

hi,
i got the same error:
'FRM-40735:ON ERROR trigger raised unhandled exception ORA-06508'.

i alse check the attached library and found the APP_EXPORT package in APPCORE.pll can not compile. when i compile this package it will cause the form builder6.0 to close.

please tell me what should i do to solve the question in client and run the template.fmb normally.

Best Regards

Report message to a moderator

Re: FRM-40735 Error [message #207269 is a reply to message #207258]

Mon, 04 December 2006 22:08

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Why is 'APPCORE.pll' not compiling? Is the rest of your application built using Forms 6? Have you ever compiled anything else? Are you using a different userid?

David

Report message to a moderator

Re: FRM-40735 Error [message #207299 is a reply to message #207269]

Tue, 05 December 2006 00:04

yanfuju_1979
Messages: 42
Registered: October 2006

Member

dear David ,

i open APPCORE.pll using Form Builder 6.0.
i can not compile the package APP_EXPORT of APPCORE.pll , when i compile it the Form Builder will be closed, but other package is ok,i mean they can compile successful.
i use the apps/apps to login .

can you tell me what is wrong? i attached the error picture,please check it for me.

BestRegards

Attachment: error.doc
(Size: 237.50KB, Downloaded 2116 times)

Report message to a moderator

Re: FRM-40735 Error [message #207302 is a reply to message #207299]

Tue, 05 December 2006 00:15

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Your attached image is a runtime error, not a compile time error.

I repeat:

Why is 'APPCORE.pll' not compiling?
Is the rest of your application built using Forms 6?
Have you ever compiled anything else?

David

Report message to a moderator

Re: FRM-40735 Error [message #207304 is a reply to message #207302]

Tue, 05 December 2006 00:21

yanfuju_1979
Messages: 42
Registered: October 2006

Member

Dear David,

yes, in my attachment the first image is a runtime error, but why it happened.
for i am not confirm the root cause,so i check attached libiary and found i can not compile APPCORE.pll (error like the second image in my attachment doc).

Best Reagards

Report message to a moderator

Re: FRM-40735 Error [message #207306 is a reply to message #207304]

Tue, 05 December 2006 00:26

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Sorry, I stopped at the first image.

Please close the Forms Builder, reopen the Forms builder, connect to your database, open the PLL file, press Ctrl-Shft-K (Compile all). Please reply if this gave any error.

I repeat, again:

Is the rest of your application built using Forms 6?
Have you ever compiled anything else?

David

Report message to a moderator

Re: FRM-40735 Error [message #207309 is a reply to message #207306]

Tue, 05 December 2006 00:38

yanfuju_1979
Messages: 42
Registered: October 2006

Member

dear David ,

1)
i close my Form Builder and reopen APPCORE.pll .
compile APPCORE.pll as you said,but i get the same error.this error can cause the Form Builder to close.

2)
i do know the meaning of "Is the rest of your application built using Forms 6?
"

3) i compile nothing except Template.fmb.

Best Reagards

Report message to a moderator

Re: FRM-40735 Error [message #207310 is a reply to message #207309]

Tue, 05 December 2006 00:40

yanfuju_1979
Messages: 42
Registered: October 2006

Member

the error i attached ,please check.

Attachment: error_v1.doc
(Size: 86.00KB, Downloaded 2107 times)

Report message to a moderator

Re: FRM-40735 Error [message #207312 is a reply to message #207309]

Tue, 05 December 2006 00:47

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Did you connect to the database before doing the compile?

"Is the rest of your application built using Forms 6?" means What version of Forms was used to build the Oracle Applications Suite with which you are working. Did you install the Oracle Applications Suite? Is there anyone else at your facility that has got their Forms Builder to work?

If you have never compiled anything previously then I suggest that you try to compile and run the 'test' or 'demo' form that either came with Forms or is available from the Oracle Forms web site.

David

Report message to a moderator

Re: FRM-40735 Error [message #207320 is a reply to message #207312]

Tue, 05 December 2006 01:02

yanfuju_1979
Messages: 42
Registered: October 2006

Member

Dear David ,

i use apps/apps to connect to database.

our oracle erp application version is below:
Forms Server
----------------------------------------
Oracle Forms Version : 6.0.8.21.3
Application Object Library : 11.5.0

i am erp developer and trying to Form builder . nobody else use Form Builder. so i ask you for help.

if i want to run 'demo' form then how to do. please tell me path in detail.

Best Regards

Report message to a moderator

Re: FRM-40735 Error [message #207501 is a reply to message #207320]

Tue, 05 December 2006 17:02

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Go to http://www.oracle.com/technology/products/forms/index.html go to the 'Releases' section in the right hand column and select 'Sample Code', go to the bottom and select 'Forms 6i Developer and Forms 6i Services Demos', under 'Benfits (sic) and Features Demo' select 'Forms 6i', sign on to OTN (free membership), download the 'demos' zip file, read the instructions, run the code, get back to us with any issues.

David

Report message to a moderator

Re: FRM-40735 Error [message #207510 is a reply to message #207501]

Tue, 05 December 2006 19:12

yanfuju_1979
Messages: 42
Registered: October 2006

Member

Dear David ,

i go to http://www.oracle.com/technology/products/forms/index.html and download forms6idemos.zip successful.
but i can not install it after extract.
When I install forms6idemos it show me below message.
-------------------------------
Please install Forms Server from the product CD fist(Choose Oracle Forms Developer,custom install and select Oracle Forms Developer Server)

--------------------------------
so i follow this message and back to install Oracle Foms Developer and choose custom install but i can not found Oracle Forms Developer Server component in the list.
i have alse tried to insatll oracle Forms Server and then to install forms6idemos but this message show again and forms6idemos installation canceled by itself.
why?

Best Regards

Report message to a moderator

Re: FRM-40735 Error [message #207524 is a reply to message #207510]

Tue, 05 December 2006 21:47

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

How many Oracle homes do you have on your PC? (Look in the register under "hkey_local_machine\software\oracle".) What Oracle software other than Forms have you installed? Do you have access to a test database?

David

Report message to a moderator

Re: FRM-40735 Error [message #207538 is a reply to message #207524]

Tue, 05 December 2006 23:44

yanfuju_1979
Messages: 42
Registered: October 2006

Member

Dear David ,

in my pc i have 4 oracle homes .only one is important others are test. three are client one is my own test database.
should i uninstall my test database ?

Best Regards

Attachment: Regedit_info.doc
(Size: 129.50KB, Downloaded 1753 times)

Report message to a moderator

Re: FRM-40735 Error [message #207548 is a reply to message #207524]

Wed, 06 December 2006 00:19

yanfuju_1979
Messages: 42
Registered: October 2006

Member

Dear David ,

yes,i have userid to access to database,but i am not DBA ,I am only erp developer.my purpose is to learn how to custom oracle forms using Oracle Form Builder6.0 and template.fmb and appstand.fmb .so can i achieve this in client?

Best Reards

Report message to a moderator

Re: FRM-40735 Error [message #207549 is a reply to message #207538]

Wed, 06 December 2006 00:23

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

These all look like 10g homes!! You said that you are using Forms 6!! Which is it - 10g or 6?

Do not have 'test' homes. Oracle installations can become confused very easily as they interact with each other during the installation process.

Q1) What do you want to do with this PC?
Q2) Do you want an Oracle 10g environment or an Oracle Forms 6 environment?
Q3) Do you want to run a test database on this PC?

Please send an image with the 'HOME0' selected.

David

Report message to a moderator

Re: FRM-40735 Error [message #207553 is a reply to message #207548]

Wed, 06 December 2006 00:32

kkinapps
Messages: 29
Registered: November 2006
Location: Hyderabad

Junior Member

Hi yanfuju

I'm also an erp developer(junior level), as far as i know we can't run the apps from in form builder. After we customize or develop the form we compile it and run it but it raises an error

ON-ERROR trigger raised an unhandled..... as you got. But observe in you current working directory, u'll get an fmx for that form. Register this in apps and check whether its working or not.

This is upto my knowledge and was able to complete my previous jobs perfectly... Hope this helps you to some extent. Please let me know the result and your commnets on this.

Bye
KK

Report message to a moderator

Re: FRM-40735 Error [message #207555 is a reply to message #207549]

Wed, 06 December 2006 00:38

yanfuju_1979
Messages: 42
Registered: October 2006

Member

Dear sir,

10g homes is private installed database .the database of my company i work for is 9i database which is not in my pc .and our erp application is using oracle reports6.0 to custom reports.
my purpose is to install Form builder to customer oracle forms that connect ot my company's database not the private database in my pc.

if necessary i will uninstall 10g.

the image with the 'HOME0' is attached ,please check for me.

Best Regards

Attachment: Regedit_info2.doc
(Size: 178.50KB, Downloaded 1745 times)

Report message to a moderator

Re: FRM-40735 Error [message #207557 is a reply to message #207553]

Wed, 06 December 2006 00:48

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

KK,

Thank you very much for your input. Would you expect that yanfuju_1979 would be able to compile 'APPCORE.pll'? Should I move this question to the Applications Forum or do you think yanfuju_1979 does have a Forms environment problem?

David

Report message to a moderator

Re: FRM-40735 Error [message #207560 is a reply to message #207555]

Wed, 06 December 2006 00:55

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I don't see a FORMS60_PATH in the 'HOME0' area. In which 'home' do you believe you installed Forms 6?

Having a local 10g database is not a problem but I would suggest having only one of them.

Perhaps you need to start again. After making a backup of any data you want to keep, you can either uninstall the Oracle software unit by unit or make sure that any services have been closed, delete the Oracle directory, and delete the Oracle branch from the registry. You will probably have to do this manual delete after you have uninstalled the software anyway, so doing it that way initially is just a very quick way of removing Oracle from your PC.

Please wait for KK's answer to my previous question before doing this.

David

Report message to a moderator

Re: FRM-40735 Error [message #207570 is a reply to message #207560]

Wed, 06 December 2006 01:30

kkinapps
Messages: 29
Registered: November 2006
Location: Hyderabad

Junior Member

David,

I don't know much abt these installations and setups for FORMS or DATABASE in our company. But i suggest yanfuju to first check whether he is successfull to generate the fmx for his form(it may throw an error as stated previuosly, but no probs), then register this fmx in application and test...coz APPCORE.pll has lot of references to other pll's and application enviroment profile options(i believe)....

So if this fails then may be he has some problem in FORMS setups and he need to follow your steps.

Note: If fmx is generated and you get the ON-ERROR trigger when u run the form in FORM builder it's done.

Yanfuju please let me know if still u encounter any issues.

Thanks and Regards
KK

Report message to a moderator

Re: FRM-40735 Error [message #207573 is a reply to message #207570]

Wed, 06 December 2006 01:35

yanfuju_1979
Messages: 42
Registered: October 2006

Member

David ,
i have removed my local database ,but i would not delete the Oracle directory,for i am coding oracle reports now .

kk,
i am not confirm what's your suggestion .
i want to run oracle forms using downloaded libirays in client. but i nearly can not complie fmb to fmx and then the error happend .i have set Oracle directory FORM60_PATH before.

though i am not confirm the root cause ,but i still think mybe it is not due to my oracle installation or directory ,it is due to the server. the 'APPCORE.pll' has not correctly compiled in server.

Thanks

Report message to a moderator

Re: FRM-40735 Error [message #207574 is a reply to message #207573]

Wed, 06 December 2006 01:46

kkinapps
Messages: 29
Registered: November 2006
Location: Hyderabad

Junior Member

Yanfuju,

can u please send me the screen shots of fully expanded(atleast to a min level, so that i can see the attached libraires,programunits..) display of your form in object navigator of FORM builder and also clearly the variuos stages of your form compiling and running .....

Thanks
KK

Report message to a moderator

Re: FRM-40735 Error [message #207577 is a reply to message #207574]

Wed, 06 December 2006 02:13

yanfuju_1979
Messages: 42
Registered: October 2006

Member

kk,

sorry, let you wait so many time.
your suggestion is right ,though error happened when compile in client (i mean in my pc),but is still generate fmx.
and i upload this fmx to server the register in application ,it runs well.
thank you KK, but are there any method to run fmx in client,i want to run it in client.

David ,
thanks for your help .

Best Regards

Report message to a moderator

Re: FRM-40735 Error [message #207579 is a reply to message #207574]

Wed, 06 December 2006 02:17

yanfuju_1979
Messages: 42
Registered: October 2006

Member

KK & David ,

why i can not compil pll in client?

Best Regards

Report message to a moderator

Re: FRM-40735 Error [message #207583 is a reply to message #207577]

Wed, 06 December 2006 02:30

kkinapps
Messages: 29
Registered: November 2006
Location: Hyderabad

Junior Member

Good Good so finally you got it... Cool

As i said you can't run apps form in client(upto my knowledge) as it has many things to do with apps profile options.And let me also know if you get any inf in future.

Coming on to pll u can compile it if all the packages it refernces are available to it....

Thanks
KK

Report message to a moderator

Re: FRM-40735 Error [message #207588 is a reply to message #207583]

Wed, 06 December 2006 02:36

yanfuju_1979
Messages: 42
Registered: October 2006

Member

Dear KK,

can you compile APPCORE.pll in your pc using Oracle Form Builder6.0??
i can not ,if i compile the APP_EXPORT package in APPCORE.pll it will close Form Builder.
please try this in your computer.

Best Regards

Report message to a moderator

Re: FRM-40735 Error [message #207597 is a reply to message #207588]

Wed, 06 December 2006 02:58

kkinapps
Messages: 29
Registered: November 2006
Location: Hyderabad

Junior Member

yanfuju,

I too got the same error when i compiled appcore.pll directly
try this way..

compile APPCORE.pll by pressing ctrl+t and then review errors.
You should get the following

Quote:

Compilation errors on APP_EXPORT:
PL/SQL ERROR 0 at line 0, column 0
ORA-00600: internal error code, arguments: [17003], [65143580], [994], [1], [], [], [], []

Failed to generate library.

Then try to compile individual packages specifications listed in the error list(your's) and then try agian compiling APPCORE.pll normally i.e. Program>Compile Selection, this will compile without errors.

Thanks
KK

Report message to a moderator

Re: FRM-40735 Error [message #207603 is a reply to message #207597]

Wed, 06 December 2006 03:19

yanfuju_1979
Messages: 42
Registered: October 2006

Member

KK,

yes,it comile normal.thank you again.

Best Regards

Report message to a moderator

Re: FRM-40735 Error [message #207606 is a reply to message #207603]

Wed, 06 December 2006 03:31

kkinapps
Messages: 29
Registered: November 2006
Location: Hyderabad

Junior Member

You're welcome Very Happy

Report message to a moderator

Re: FRM-40735 Error [message #207750 is a reply to message #207606]

Wed, 06 December 2006 20:21

yanfuju_1979
Messages: 42
Registered: October 2006

Member

hi KK,

i have another quesiton running customized form in application.
you know though i will get error on running template.fmb on client,the generated fmx can upload to server and will run without error.

but i can not see the modification when i run in application.
example if adjust the PRE-FROM trigger:
app_window.set_window_position('ORDERS_WIN', 'FIRST_WINDOW');

and reupload the fmx .i can't see any changes when runing my customize form.
so i think,the generated fmx in client is not correct.

why, please advise.
can you send your advise directly to my mail : yanfuju_1979@hotmail.com

Best regards
Yanfuju

Best Regards

Report message to a moderator

Re: FRM-40735 Error [message #207753 is a reply to message #207750]

Wed, 06 December 2006 20:42

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I don't believe that this type of behaviour is possible in the Pre-Form, try it in the When-New-Form-Instance trigger.

David

Report message to a moderator

Re: FRM-40735 Error [message #207756 is a reply to message #207753]

Wed, 06 December 2006 21:12

yanfuju_1979
Messages: 42
Registered: October 2006

Member

dear David ,

no, no usage ,i have tied to use go_block('DEM_ORDERS'); in When-New-Form-Instance trigger.
the running DEM01.fmb still keep in original window (like attached picture).but i have add my window ,canvans,block
mybe i must compile fmb to fmx in server.but customize forms is my private learning in test applicaiton not job.

Best Regards

Report message to a moderator