Home » Developer & Programmer » Forms » FRM-40202: Field must be entered (Forms migration from forms6i to forms11g R2)
FRM-40202: Field must be entered [message #633612] Mon, 23 February 2015 03:18 Go to next message
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.
Re: FRM-40202: Field must be entered [message #633630 is a reply to message #633612] Mon, 23 February 2015 07:01 Go to previous messageGo to next message
kuwait
Messages: 55
Registered: October 2007
Member
Hi

In your table creation, maybe you mentioned that field to be not null.
Re: FRM-40202: Field must be entered [message #633631 is a reply to message #633630] Mon, 23 February 2015 07:13 Go to previous messageGo to next message
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
Re: FRM-40202: Field must be entered [message #633643 is a reply to message #633631] Mon, 23 February 2015 15:42 Go to previous messageGo to next message
joy_division
Messages: 4963
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 Go to previous messageGo to next message
miersuzzemes
Messages: 8
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.
Re: FRM-40202: Field must be entered [message #669804 is a reply to message #669801] Mon, 14 May 2018 10:16 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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?
Re: FRM-40202: Field must be entered [message #669813 is a reply to message #669804] Mon, 14 May 2018 13:46 Go to previous messageGo to next message
miersuzzemes
Messages: 8
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
Re: FRM-40202: Field must be entered [message #669820 is a reply to message #669813] Tue, 15 May 2018 03:21 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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?
Re: FRM-40202: Field must be entered [message #669832 is a reply to message #669820] Tue, 15 May 2018 14:30 Go to previous messageGo to next message
miersuzzemes
Messages: 8
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.
Re: FRM-40202: Field must be entered [message #669836 is a reply to message #669832] Wed, 16 May 2018 03:11 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Have a look at the validation unit and defer required enforcement properties at form level.
Re: FRM-40202: Field must be entered [message #669838 is a reply to message #669836] Wed, 16 May 2018 03:18 Go to previous messageGo to next message
miersuzzemes
Messages: 8
Registered: July 2013
Location: Latvia, Riga
Junior Member
Yes, tried the "Defer Required Enforcement" set to "No" or "4.5".
Didn't help.
Re: FRM-40202: Field must be entered [message #669839 is a reply to message #669838] Wed, 16 May 2018 04:42 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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.
Re: FRM-40202: Field must be entered [message #669843 is a reply to message #669839] Wed, 16 May 2018 06:11 Go to previous message
miersuzzemes
Messages: 8
Registered: July 2013
Location: Latvia, Riga
Junior Member
Yes, setting the form level <Validation unit> to "Form" helped.
Thanks.
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:
  


Current Time: Thu Mar 28 05:16:27 CDT 2024