Home » Developer & Programmer » Forms » Menu not mapping in Oracle form 12c (Oracle form 12c 12.2.1.3.0)
Menu not mapping in Oracle form 12c [message #677558] Thu, 26 September 2019 02:57 Go to next message
Shiv93
Messages: 16
Registered: September 2019
Junior Member
Hi,

I have a form compiled in 12c version and when i logged in and try to access form am getting a couple of error message as "ORA-00942:table or view doesnt exist". further am getting a error message like "error:41810 error in creating menu".Also i;m getting another error as "FRM-41067 Cannot find menu item:Invalid id". My form is succesfully loaded but i dont see the menu attached to it. Can someone let me know the solution if you have come across such situation.

Thanks
Siva
Re: Menu not mapping in Oracle form 12c [message #677559 is a reply to message #677558] Thu, 26 September 2019 05:27 Go to previous messageGo to next message
Littlefoot_fan
Messages: 18
Registered: June 2019
Location: Uruguay
Junior Member
Hello.

It would be helpful if you post the code of the triggers that get executed whenever you open your form (e.g. WHEN-NEW-FORM-INSTANCE), just to give a better insight.

ORA-00942: I think the reason is, as the message says, that you are trying to perform a query somewhere and, either you don't have that table created, you lack the privileges to do it or you need to put the name of the schema before the name of the table. (e.g. select * from schema1.table1 (you could also create a synonym for this table to avoid writing the schema name first)).

FRM-41810: It's hard to say. Could it be that the name of the menu you are specifying is incorrect? (e.g. replace_menu('incorrectname'), or in your form Property Palette, option Menu Module) Maybe the menu file it's not in the same directory as the form file and then the form can't find it?

FRM-41067: The only time I've faced this error was when I wrote the name of a certain menu option wrong. (e.g. set_menu_item_property('INCORRECT.NAME', visible, property_false)) You could look for something similar.

That's what comes to my mind at first.

Also, make us know what you already tried, please.

[Updated on: Thu, 26 September 2019 05:51]

Report message to a moderator

Re: Menu not mapping in Oracle form 12c [message #677773 is a reply to message #677559] Fri, 11 October 2019 07:16 Go to previous messageGo to next message
Shiv93
Messages: 16
Registered: September 2019
Junior Member
Hi

So for ORA-00942 I have the table or view which is referring to in the Database and also I tried calling the table or view with the schema name (schema.table or view)

For FRM-41810 I try to call the menu which is present.to be precise when I put a message in the screen I could see all the menus value are displayed but not getting applied to the screen.

For frm-41067 I have the correct name of the menu.
Re: Menu not mapping in Oracle form 12c [message #678038 is a reply to message #677773] Fri, 01 November 2019 08:03 Go to previous message
Shiv93
Messages: 16
Registered: September 2019
Junior Member
Hi,

I was able to resolve the menu mapping error issue.

What i have did is just changed menu role in the property pallet of the fmb file.

In all my fmb files it had a Designer role assigned to it and after removing the menu role, I compiled my form and the menu got mapped correctly in the screen.


Thanks for all your support folks..
Previous Topic: Default_where
Next Topic: FRM-40501 and ORA-00054
Goto Forum:
  


Current Time: Thu Dec 05 10:48:34 CST 2019