OraFAQ Forum: Forms » FRM-40202: Field must be entered.

Home » Developer & Programmer » Forms » FRM-40202: Field must be entered. (Oracle Forms Version : 6.0.8.22.1 and Oracle Applications : 11.5.9)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FRM-40202: Field must be entered. [message #441408]

Sun, 31 January 2010 20:21

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

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: 21808
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.

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: 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.

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: 21808
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".

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: 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.

Report message to a moderator

Re: FRM-40202: Field must be entered. [message #441570 is a reply to message #441471]

Tue, 02 February 2010 00:17

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.

Report message to a moderator

Re: FRM-40202: Field must be entered. [message #441598 is a reply to message #441570]

Tue, 02 February 2010 01:56

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

Report message to a moderator

Re: FRM-40202: Field must be entered. [message #441603 is a reply to message #441598]

Tue, 02 February 2010 02:15

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

Report message to a moderator

Re: FRM-40202: Field must be entered. [message #441605 is a reply to message #441408]

Tue, 02 February 2010 02:19

cookiemonster
Messages: 13920
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?

Report message to a moderator

Re: FRM-40202: Field must be entered. [message #441610 is a reply to message #441605]

Tue, 02 February 2010 02:47

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.

Report message to a moderator

Re: FRM-40202: Field must be entered. [message #441616 is a reply to message #441408]

Tue, 02 February 2010 03:37

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

That leaves the obvious question of what does app_folder.event('KEY-EXEQRY') do?

Report message to a moderator

Re: FRM-40202: Field must be entered. [message #446672 is a reply to message #441616]

Tue, 09 March 2010 22:42

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: FRM-40202: Field must be entered. [message #447402 is a reply to message #446672]

Mon, 15 March 2010 01:19

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.

Report message to a moderator

Previous Topic:	How to integrate excel with oracle forms
Next Topic:	how to integrate excel with forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 20:41:36 CDT 2024