Oracle Error Creating Menu
41810 (Error Creating Menu) If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to frm-10221 cannot read file 11g register before you can post: click the register link above to proceed. frm-10256 To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: FRM - 41810 (Error Creating Menu) Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 06-07-2001,03:59 PM #1 valentin View Profile View Forum Posts Junior Member Join Date Jan 2001 Posts 13 What is this error? It's a database problem or a Forms problem? Error: FRM - 41810 (Error Creating Menu) TIA Valentin Reply With Quote 06-08-2001,07:29 AM #2 rvsagar View Profile View Forum Posts Visit Homepage Junior Member Join Date Jun 2001 Posts 12 This must be FORM ERROR FRM-41810: Error creating menu. Cause: You tried to use the menu component from within Form Builder, and an internal error occurred. Action: Contact your DBA. Level: >25 Type: Error Try to recompile your MMB file and attach it to Form ..it will work , If it does not work Change the MMB file name and location then recompile it . This may help to sort out your Problem. Vidya Reply With Quote 07-04-2007,05:46 PM #3 gnajerap View Profile View Forum Posts Junior Member Join Date Jul 2007 Posts 1 Configure your default.env You should set you configuration file called "default.env" you must set the path var: FORMS_PATH, this var must be filled with the path where your forms are, for instance: FORMS_PATH = c:\myaplication;c:\OtherApp; and so on. Reply With Quote Quick Navigation Oracle Development Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Oracle Forums Oracle Database Administration Oracle Applications DBA Oracle Development Oracle Certification Oracle : How To Oracle Careers Oracle Positions Available Oracle Job Wanted Archives Forum Ar
Miquel Coll Leave a comment Go to comments I'm migrating an app from forms 9i to forms 10g release 2. The menus uses role security, I've compiled the forms in 10g release 2 and when I open the form I get this chain of errors: FRM-41810: Error creating menu FRM-10256: User is not authorized to run form builder menu FRM-41810: Error creating menu FRM-10205: http://www.dbasupport.com/forums/showthread.php?11753-FRM-41810-(Error-Creating-Menu) Menu not found FRM-40105: Unable to resolve reference to item %s. I have encountered this problem at other times, but I settled for the fast-track: disable the menu security. But today I feel inspired and I want to find a solution. After trying different things, I've found this oracle note: Implementing and Troubleshooting Menu Security https://myotragusbalearicus.wordpress.com/2012/04/13/frm-41810-menu-security-in-oracle-forms-10g-release-2/ in Forms [ID 28933.1] To implement menu security in Oracle Forms 9.0.x, 10.1.2 or 11.1.x you have to create an old compatibility view, execute this in SQL*Plus as SYSTEM user: For 9.0.x: SQL> @$ORACLE_HOME\tools\dbtab90\forms90\frm90sec.sql; For 10.1.2 or 11.1.x: SQL> @$ORACLE_HOME\tools\dbtab\forms\frmsec.sql; The script, in 10g is this: create or replace view FRM50_ENABLED_ROLES as select urp.granted_role role, sum(distinct decode(rrp.granted_role, 'ORAFORMS$OSC',2, 'ORAFORMS$BGM',4, 'ORAFORMS$DBG',1,0)) flag from sys.user_role_privs urp, role_role_privs rrp where urp.granted_role = rrp.role (+) and urp.granted_role not like 'ORAFORMS$%' group by urp.granted_role; create public synonym FRM50_ENABLED_ROLES for system.FRM50_ENABLED_ROLES; create role ORAFORMS$OSC; create role ORAFORMS$DBG; create role ORAFORMS$BGM; Now, grant select access to the view created: SQL> grant select on frm50_enabled_roles to public; And now, from a user account, test the view: SQL> select * from frm50_enabled_roles; If you can see values, the menu security must work in Forms 10g. Rate this:Share this:EmailPrintFacebookTwitterLinkedInGoogleMorePinterestTumblrRedditLike this:Like Loading... Related Categories: oracle, oracle forms&reports Tags: frm-10205, frm-10256, frm-40105, frm-41810, frm50
default menu. You also learn how to enhance your applications by including menu toolbars and http://www.oracle.com/webfolder/technetwork/tutorials/obe/forms/11g/formsmenuscreate/formsmenuscreate.htm pop-up menus. Finally you learn how to modify the Forms default http://dbaforums.org/oracle/index.php?showtopic=351 menu. Time to Complete Approximately 30 minutes. Overview This tutorial is aimed at Oracle Forms developers who wish to broaden their skills with the tool, enabling them to create more user-friendly applications. You learn how you can improve the usability of Forms applications by adding custom oracle error menus. Scenario In this tutorial, you design a custom menu with very basic commands to use with an order entry application. You also provide a context-sensitive popup menu for a text item. Software Requirements The following is a list of software requirements: Oracle Forms Builder Oracle database Application server compatible with Forms Builder This tutorial is oracle error creating not specific to a particular version of Forms. However, it was developed using Oracle Forms 11g 11.1.1.4, Oracle WebLogic Server 10.3.4, and Oracle database 11g 11.2.0.1. Prerequisites Before starting this tutorial, you should perform the following setup steps:: Download the file MenuOBE.zip and unzip it to the directory of your choice. Ensure that the directory where you unzipped the file is included in your FORMS_PATH environment variable (set in default.env or other environment file that you use for your application). To see how to set environment variables for Forms Runtime, see the deployment guide for the version of Forms that you are using, such as Oracle Fusion Middleware Forms Services Deployment Guide 11g Release 1. Open a command window and navigate to the directory where you unzipped the file. Run SQL*Plus and log into your database as the SYSTEM user. Run the script create_user.sql to create the summit user with the password oracle. In SQL*Plus, connect to your database as the summit user. Run the script create_schema.sql to create database