| Menu not mapping in Oracle form 12c [message #677558] |
Thu, 26 September 2019 02:57  |
 |
Shiv93
Messages: 34
Registered: September 2019
|
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  |
 |
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 #678038 is a reply to message #677773] |
Fri, 01 November 2019 08:03 |
|
Shiv93
Messages: 34
Registered: September 2019
|
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..
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
