Frm 41810 Error Creating
Contents |
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 register before you can post: click the register link above frm-10221 cannot read file 11g to proceed. To start viewing messages, select the forum that you want to visit
Frm-10256
from the selection below. Results 1 to 3 of 3 Thread: FRM - 41810 (Error Creating Menu) Tweet Thread Tools Show
Frm-10221 Cannot Read Menu
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 Archives Other Feedback and Questions regarding the forums Obfuscation Unlimited « Previous Thread | Next Thread » Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On [VIDEO] code is On HTML c
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: Menu not found FRM-40105: Unable to resolve reference to item %s. I have encountered this problem at other times, but I settled for http://www.dbasupport.com/forums/showthread.php?11753-FRM-41810-(Error-Creating-Menu) 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 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 https://myotragusbalearicus.wordpress.com/2012/04/13/frm-41810-menu-security-in-oracle-forms-10g-release-2/ 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_enabled_roles, menu security, migration, oracle forms&reports, role Comments (3) Trackbacks (0) Leave a comment Trackback Zino June 25, 2015 at 16:54 Reply SUPER!!! This helped>>>>grant select on frm50_enabled_roles to public; LikeLike Drivera May 7, 2014 at 17:57 Reply Excellent!!! that was! thanks you very much. LikeLike kwame asuah October 2, 2012 at 14:23 Reply Good job man. It worked LikeLik
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have https://community.oracle.com/community/developer/search.jspa?q=FRM-41810 JavaScript enabled. This tool uses JavaScript http://www.dbforums.com/showthread.php?988667-Attaching-a-menu-in-a-form and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle frm-10221 cannot VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace frm-10221 cannot read depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x
to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 2 of 2 Thread: Attaching a menu in a form Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-16-04,06:50 #1 Sowmyam View Profile View Forum Posts Registered User Join Date Feb 2004 Posts 41 Unanswered: Attaching a menu in a form Hi all, I have attached a Menu to a Form. I have both .mmx and .fmx in the same folder. when i run the form it displays the following message >FRM-10221: Could not read file "menufile". "menufile" is the name of my menu. > >and then, > >FRM-41810: Error creating menu. Thanks in advance. 'A candle will loose nothing by lighting an another candle' Reply With Quote 03-16-04,09:04 #2 rizwan5 View Profile View Forum Posts Registered User Join Date Mar 2004 Posts 1 Re: Attaching a menu in a form Place your mmx and mmb files in the same path as your fmx and fmb files. Also add this location in the Registry Key FORMS60_PATH. if you are using Developer 6i. If u r using Developer 9i, the Registry Key will be FORMS90_PATH. It should work. Reply With Quote Quick Navigation Oracle Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft SQL Server MySQL Oracle Pervasive.SQL PostgreSQL Sybase Other Data Access, Manipulation & Batch Languages ASP Crystal Reports Delphi, C etc JAVA Perl and the DBI PHP ANSI SQL Unix Shell Scripts Visual Basic PC based Database Applications Brilliant Database Corel Paradox FileMaker Microsoft Access Microsoft Excel Other PC Databases General New Members & Introductions Applications & Tools Database Concepts & Design Chit Chat Marketplace Job Opportunities Suggestions & Feedback Links to other iNet owned sites web development forum Web Hosting Talk « Previous Thread | Next Thread » Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit yo