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

Home » Developer & Programmer » Forms » FRM-40202: Field must be entered (Forms migration from forms6i to forms11g R2)

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

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

Mon, 23 February 2015 03:18

sujithc
Messages: 3
Registered: February 2015
Location: BANGALORE

Junior Member

Even though fields required property set to "Yes", Not getting "Field must be entered" while navigating out of block.

But after migration, started getting the error "Field must be entered" while navigating out of block(Clicking button which is outside the regular block).
But, if we develop form 11g by setting "Required" property to "Yes", not getting the error.

As well tried with "validation unit" set to "Item" level and "Defer Required Enforcement" set to "4.5" and as well to "Yes"

Even then getting the "Field must be entered"

Please let us know any solution to fix Field must be entered issue.

Report message to a moderator

Re: FRM-40202: Field must be entered [message #633630 is a reply to message #633612]

Mon, 23 February 2015 07:01

kuwait
Messages: 52
Registered: October 2007

Member

Hi

In your table creation, maybe you mentioned that field to be not null.

Report message to a moderator

Re: FRM-40202: Field must be entered [message #633631 is a reply to message #633630]

Mon, 23 February 2015 07:13

sujithc
Messages: 3
Registered: February 2015
Location: BANGALORE

Junior Member

Thanks for your reply, but we have done migration of forms from 6i to 11g, after migration we started facing the issue of "field must be entered" issue

Report message to a moderator

Re: FRM-40202: Field must be entered [message #633643 is a reply to message #633631]

Mon, 23 February 2015 15:42

joy_division
Messages: 4944
Registered: February 2005
Location: East Coast USA

Senior Member

If you are really not getting the error, check the database to see what value is in there. Maybe you loaded a "space" into a VARCHAR2 field via some bad code.

I really don't know what is happening based on the description you gave.

[Updated on: Mon, 23 February 2015 15:42]

Report message to a moderator

Re: FRM-40202: Field must be entered [message #669801 is a reply to message #633612]

Mon, 14 May 2018 08:27

miersuzzemes
Messages: 7
Registered: July 2013
Location: Latvia, Riga

Junior Member

Same problem here after migration. Any known solution?

Of course you can set the field property Required to No. But I don't think that is the right way.

Report message to a moderator

Re: FRM-40202: Field must be entered [message #669804 is a reply to message #669801]

Mon, 14 May 2018 10:16

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

Senior Member

OPs problem was that the system wasn't telling him a field was required when he hadn't entered anything even though required was set to Yes.

So setting required to No is definitely not the right way for that.

Are you sure you've got the same problem?

Report message to a moderator

Re: FRM-40202: Field must be entered [message #669813 is a reply to message #669804]

Mon, 14 May 2018 13:46

miersuzzemes
Messages: 7
Registered: July 2013
Location: Latvia, Riga

Junior Member

Oh.
I have the opposite problem.
After migration several places in forms started to throw this error.
This error kind of makes sense but I wonder why didn't the error appear in 6i.
The idea was that the migration wouldn't impact the behavior of forms but it did Smile

Report message to a moderator

Re: FRM-40202: Field must be entered [message #669820 is a reply to message #669813]

Tue, 15 May 2018 03:21

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

Senior Member

Well if you have the fields set to required then the old version should have thrown that error at some point if you didn't enter anything.
So is the point at which it is doing the check changed?

Report message to a moderator

Re: FRM-40202: Field must be entered [message #669832 is a reply to message #669820]

Tue, 15 May 2018 14:30

miersuzzemes
Messages: 7
Registered: July 2013
Location: Latvia, Riga

Junior Member

"at some point" yes, but not when just navigating to a different block item.
GO_ITEM was the one that caused the error in new forms.
Anyway...I gave up - made it Required: No Smile

Will handle the mandatory of the item later.

Report message to a moderator

Re: FRM-40202: Field must be entered [message #669836 is a reply to message #669832]

Wed, 16 May 2018 03:11

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

Senior Member

Have a look at the validation unit and defer required enforcement properties at form level.

Report message to a moderator

Re: FRM-40202: Field must be entered [message #669838 is a reply to message #669836]

Wed, 16 May 2018 03:18

miersuzzemes
Messages: 7
Registered: July 2013
Location: Latvia, Riga

Junior Member

Yes, tried the "Defer Required Enforcement" set to "No" or "4.5".
Didn't help.

Report message to a moderator

Re: FRM-40202: Field must be entered [message #669839 is a reply to message #669838]

Wed, 16 May 2018 04:42

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

Senior Member

I suspect you want it set to Yes and validation unit set to something other than item.

Report message to a moderator

Re: FRM-40202: Field must be entered [message #669843 is a reply to message #669839]

Wed, 16 May 2018 06:11

miersuzzemes
Messages: 7
Registered: July 2013
Location: Latvia, Riga

Junior Member

Yes, setting the form level <Validation unit> to "Form" helped.
Thanks.

Report message to a moderator

Previous Topic:	When call reports from forms 12c using RUN_REPORT_OBJECT() built-in fails with the following error
Next Topic:	Hide default menu bar on certain conditions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 22 23:21:37 CST 2019