Error Frm 40202

Message Navigator E-mail to friend FRM-40202: Field must be entered. [message #441408] Sun, 31 January 2010 20:21 chandramatta Messages: 15Registered: January 2010 Junior Member Hi All, Please help me with the issue - FRM-40202: Field must be entered. I have a custom form,developed by someone few years ago. While doing a F11 (query-find) in this custom forms in Oracle application, I get the message FRM-40202 Field must be entered because I have some mandatory fields. Below are the steps I follow to reproduce this bug. - Open custom form - Enter data/values in all mandatory fields. - save. It saved back in database. - then CTRL+F11 to see all the records. - Only first two records are showing in the screen. - And "FRM-40202: Field must be entered." at the bottom. Kindly help to fix this issue. Thanks, Matt Report message to a moderator Re: FRM-40202: Field must be entered. [message #441418 is a reply to message #441408] Mon, 01 February 2010 00:02 Littlefoot Messages: 20837Registered: June 2005 Location: Croatia, Europe Senior MemberAccount Moderator What does do? It seems that one (or more database items) gets its value (perhaps "behind the scene", triggered by some event), so when you press the , Forms expects you to enter ALL required items. Run the form in debug mode to see what's going on. Report message to a moderator Re: FRM-40202: Field must be entered. [message #441420 is a reply to message #441418] Mon, 01 February 2010 00:41 chandramatta Messages: 15Registered: January 2010 Junior Member Hi Littlefoot, Thanks for your reply. Could you tell me what statements set the values to database items? Is this SET_PROPERTY - statments ? Thanks, Matt. Report message to a moderator Re: FRM-40202: Field must be entered. [message #441425 is a reply to message #441420] Mon, 01 February 2010 01:45 Littlefoot Messages: 20837Registered: June 2005 Location: Croatia, Europe Senior MemberAccount Moderator No; SET_ITEM_PROPERTY modifies items' properties, not values. Check whether there's ':=' sign there, for example:dept.deptno := 99;Also, check whether some items contain "initial values". Report message to a moderator Re: FRM-40202: Field must be entered. [message #441471 is a reply to message #441425] Mon, 01 February 2010 04:59 Supernova11 Messages: 12Reg

Visio Microsoft Word Microsoft Works Novell GroupWise WinZip Media Creation and Backup Modems http://www.orafaq.com/forum/t/154578/ Monitors Mouse and Keyboards Networking Devices Printers Scanners Storage Devices Web Cams Adobe Acrobat Adobe FrameMaker Adobe Photoshop Adobe Reader Applie iLife CorelDraw http://www.helpinfo.com/index.jsp?k2dockey=1021033036645832707&formwassubmitted=true Macromedia Dreamweaver Windows Media Player Instant Messaging Internet RSS News Readers Microsoft Internet Explorer Mozilla Firefox Netscape Blackberry HP iPAQ Palm Treo 650 Mac OS X Microsoft Windows 2000 Microsoft Windows 2003 Microsoft Windows XP McAfee Norton Symantec Ad-Aware Spybot Search and Destroy SpyWare Prevention Caldera GNOME KDE Linux (General) Red Hat Linux Star Office ©2006 HelpInfo About HelpInfoContact UsRegister for Email AlertsTerms of Service

the error Frm-40202, it's fine. But when i closing this error message by clicking on OK button to enter the field it was not allowing me to navigate into the field. The same error message is reopening. http://oracledba.bigresource.com/Forms-FRM-40202-Field-must-be-entered-dialogue-not-closing-nwJfKewkM.html View 2 Replies Similar Messages: Forms :: FRM-40202 Field Must Be Entered Forms :: FRM-40202 - Field Must Be Entered Forms :: FRM-40202 - Field Must Be Entered On Two Blocks With Same Table? Forms :: FRM-40202 - https://www.experts-exchange.com/questions/10055463/How-to-exit-form.html Field Must Be Entered (after Standard Form Had Been Modified) Forms :: How To Handle Position / When Do You Want To Save Changes / Dialogue Box Appears Forms :: Getting Error When Cancel File Selection In File error frm Open Dialogue Forms :: Layout Not Opened - Closing And Giving Error? Forms :: Enable Property Of One Particular Text Item To False - Form Abruptly Closing Forms :: ERROR - Record Must Be Entered Or Deleted First Forms :: Replace Data Entered In Column Forms :: Frm-15500 Valid And Unique Object Name Must Be Entered Forms :: Frm-40405 Traced The Program And Only One Commit_form Is Being Entered Forms :: How To Reload Calling Form error frm 40202 After Closing Called Form Forms :: Hide The Data Input When Entered For Security Purposes? Forms :: Update Field Based On Another Field Checkbox Forms :: Filter Hard Coded Values In List Item (Tlist) Based On Value Entered In Text Item SQL & PL/SQL :: Session Aborted After Closing Window? Enterprise Manage Console Closing Automatically? LGWR / Error 1041 Closing Archive Log File (STANDBY) Application Express :: Refreshing Tabular Form On Closing Modal Page? Application Express :: Refreshing Main Page After Closing Skillbuilder Popup? SQL & PL/SQL :: Sum (cost) Basing On ID Entered SQL & PL/SQL :: Comparing Strings Entered In A Form? SQL & PL/SQL :: How To Get Time Zone Of The Country Entered SQL & PL/SQL :: How To Retrieve Values If User Entered In Mixed Case Forms :: One Lov For Different Field Client Tools :: Ignore Sql Prompt And Command Entered While Spooling? Reports & Discoverer :: Custom SQL Entered Is Not A Valid Statement - ORA-01031 Forms :: Format For SSN Field ADVERTISEMENT Forms :: FRM-40202 Field Must Be Entered Jan 31, 2010 FRM-40202: Field must be entered.I have a custom form,developed by someone few years ago. While doing a F11 (query-find) in this custom forms in Oracle application, I get the message FRM-40202 Field must be entered because I have some mandatory fields.Below are the steps I foll

for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > How to exit form? Want to Advertise Here? Solved How to exit form? Posted on 1998-05-31 Oracle Database 1 Verified Solution 10 Comments 4,782 Views Last Modified: 2008-02-01 How to exit a form at runtime, when the input focus is in a required text_item? I am getting an error message FRM-40202 "Field must be entered" ,when I tried to use exit_ form built in. 0 Question by:Venkat052498 Facebook Twitter LinkedIn Google LVL 3 Best Solution byponcejua ================================================ CASE 1. ======= FRM-40202 can occur if you are using button items in a block that also contains required fields or fields with validation. Go to Solution 10 Comments LVL 4 Overall: Level 4 Oracle Database 3 Message Expert Comment by:sganta1998-05-31 Hai Venkat ! I have 2 solutions for your answer. If you are trying to EXIT the form without VALIDATING the records (i.e without committing). Am I Right ! Fine. Then use this COMMAND in your code Solution 1 EXIT_FORM(NO_VALIDATE); (Or) Solution 2 : CLEAR_FORM(NO_VALIDATE); EXIT_FORM; I hope this is acceptable to you, If you have any problems, you are always welcome to me. Thanks & Regards - sganta 0 LVL 4 Overall: Level 4 Oracle Database 3 Message Expert Comment by:sganta1998-06-01 Hi You go to Default Menu Field/Clear Record/Clear Block/Clear Then EXIT_FORM 0 LVL 3 Overall: Level 3 Oracle Database 2 Message Expert Comment by:vlad_impala1998-06-04 In the key-exit trigger at form level... if exit_form(no_validate) does not work you could always re-set :system.message_level to 20. This message is at level 15 and would be suppressed. If your exit procredure is on a button yo