Home » Developer & Programmer » Forms » FRM-40202: Field must be entered. (Oracle Forms Version : 6.0.8.22.1 and Oracle Applications : 11.5.9)
FRM-40202: Field must be entered. [message #441408] Sun, 31 January 2010 20:21 Go to next message
chandramatta
Messages: 15
Registered: 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
Re: FRM-40202: Field must be entered. [message #441418 is a reply to message #441408] Mon, 01 February 2010 00:02 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What does <Ctrl + F11> 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 <Ctrl + F11>, Forms expects you to enter ALL required items.

Run the form in debug mode to see what's going on.
Re: FRM-40202: Field must be entered. [message #441420 is a reply to message #441418] Mon, 01 February 2010 00:41 Go to previous messageGo to next message
chandramatta
Messages: 15
Registered: 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.
Re: FRM-40202: Field must be entered. [message #441425 is a reply to message #441420] Mon, 01 February 2010 01:45 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account 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".
Re: FRM-40202: Field must be entered. [message #441471 is a reply to message #441425] Mon, 01 February 2010 04:59 Go to previous messageGo to next message
Supernova11
Messages: 12
Registered: December 2008
Location: Indonesia
Junior Member
do you have

go_item();

or

go_block();


syntax,?

some times it hapen because you spesified trigger (post-query, key-next-item,...etc) in item to move to other block before all item in the first block is filled.
Re: FRM-40202: Field must be entered. [message #441570 is a reply to message #441471] Tue, 02 February 2010 00:17 Go to previous messageGo to next message
chandramatta
Messages: 15
Registered: January 2010
Junior Member

Hi Supernova,
Thanks for the updates. I looked for the code you mentioned in your reply.
I found following suspecious or may be dead code in my form.
---
level -> WHEN-NEW-ITEM-INSTANCE -- current Record Indecator
go_item('detailblock.text_item88');

level -> go_item('detailblock.text_item88');-- Drilldown Record Indicator.
---
I did comment this code and tested, but error message remains the same.


There is another "GO_ITEM()" in my form still.
which is at..
'Form' level and on event of - WHEN-NEW-FORM-INSTANCE
--
GO_ITEM('XXAR_220_MAPPING.ORG_ID');
--
I am not commented this statement, as I need my cursor to be on ORG_ID field, as soon as I open my custom form to enter/edit data.

Am missing anything.

Thanks,
Matt.

Re: FRM-40202: Field must be entered. [message #441598 is a reply to message #441570] Tue, 02 February 2010 01:56 Go to previous messageGo to next message
Supernova11
Messages: 12
Registered: December 2008
Location: Indonesia
Junior Member
did your ID item is the first item in the first datablock?
by default, when the form started, it will put the cursor on the first item in the first block. so you not have to use go_item().

anyway,
I Suggest you debug your form and trace it line by line.
try to put the breakpoint in the post-query trigger, from there you could use F7 key to trace line by line..

Sorry for my bad english.. i hope you understand what i'm talking about. Smile

Re: FRM-40202: Field must be entered. [message #441603 is a reply to message #441598] Tue, 02 February 2010 02:15 Go to previous messageGo to next message
chandramatta
Messages: 15
Registered: January 2010
Junior Member

Hi, thanks again for the update.
You are right. I don't need additional GO_TO, as this is my only block and first item in that block.

I commented this statement and tested. Issue exists still.
I will debug the form as you suggested and update you.

Thanks,
Matt
Re: FRM-40202: Field must be entered. [message #441605 is a reply to message #441408] Tue, 02 February 2010 02:19 Go to previous messageGo to next message
cookiemonster
Messages: 12321
Registered: September 2008
Location: Rainy Manchester
Senior Member
Judging from the original description the problem only occurs after you press CTRL-F11. So
1) How many blocks in your form?
2) Do you get the problem if you press CTRL-F11 as soon as you enter the form?
3) Do you have code in a KEY-EXEQRY or POST-QUERY trigger?
Re: FRM-40202: Field must be entered. [message #441610 is a reply to message #441605] Tue, 02 February 2010 02:47 Go to previous messageGo to next message
chandramatta
Messages: 15
Registered: January 2010
Junior Member

Thanks for the reply.
1.I just have one custom block. Other two blocks are "CALENDAR" and "PROGRESS_INDICATOR"

2.<< Do you get the problem if you press CTRL-F11 as soon as you enter the form?>>
No problem, if I press CTRL-F11, as soon as I enter into the form.
Error shown only when I insert a record, then do CTRL-F11 immediately.
No problem if I simply update/edit existing data.

3)no code in POST-QUERY, but KEY-EXEQRY has this statement.
app_folder.event('KEY-EXEQRY');

Regards
Matt.
Re: FRM-40202: Field must be entered. [message #441616 is a reply to message #441408] Tue, 02 February 2010 03:37 Go to previous messageGo to next message
cookiemonster
Messages: 12321
Registered: September 2008
Location: Rainy Manchester
Senior Member
That leaves the obvious question of what does app_folder.event('KEY-EXEQRY') do?
Re: FRM-40202: Field must be entered. [message #446672 is a reply to message #441616] Tue, 09 March 2010 22:42 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Sorry that I have been so long in replying. Have you solved your problem?

It sounds as though you are entering data and then trying to perform an 'Execute-Query'. If you mean the data should be used as part of your query then press the key combination to place the form in 'Enter Query' mode, enter the data, and THEN press the 'Execute-Query' combination.

David
Re: FRM-40202: Field must be entered. [message #447402 is a reply to message #446672] Mon, 15 March 2010 01:19 Go to previous message
chandramatta
Messages: 15
Registered: January 2010
Junior Member

I couldn't reproduce this bug anymore. So it's closed.
Thanks to all, for helping with your answers.

Regards,
Matt.
Previous Topic: How to integrate excel with oracle forms
Next Topic: how to integrate excel with forms
Goto Forum:
  


Current Time: Fri Sep 30 10:42:05 CDT 2016

Total time taken to generate the page: 0.08485 seconds