• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3596
  • Last Modified:

FRM-40202 / FRM 40222 Errors

Hello,

I am in the process of deplying my application over the Web from my Linux Red Hat Enterprise 3 (ES) server. I have installed Oracle 9i Database (9.2.0.4).

I migrated my database from Oracle 8i to 9i and recompiled and migrated my Oracle Forms/Reports application from Forms 6i to Forms 9i and deployed via Oracle Forms/Reports Services 10g.

Through my WebForm application, I can query my database, but when I want to create a new entry and commit it to the database, It does not work. I get the following error when pressing the SAVE button:

FRM-40222: Disabled item "B1.DSP_CTRLNUM" failed validation

Any changes from the commit from Oracle 8i to Oracle 9i ?

Your toughts ?

PT

PS: Do I need to retouch my source code ?
What should I be looking for ?
0
ptreves
Asked:
ptreves
1 Solution
 
KagiejotCommented:
I think that, there is no database error.
You must analyze your form, for example on-validate triggers and places with SET_ITEM_PROPERTY, SET_BLOCK_PROPERTY and so on routines.

Here is description this error:
Probable application design error.  Forms determined that the item contains an invalid value, but it cannot give focus to the item because it is disabled.  This could happen because either:

The application programmatically assigned an invalid valid to the item.

The application programmatically disabled the item after the end user entered an invalid valid in the item (and before the item was validated).

Good Luck
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now