Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

FRM-40202 / FRM 40222 Errors

Posted on 2004-09-25
1
Medium Priority
?
3,501 Views
Last Modified: 2012-06-27
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
Comment
Question by:ptreves
1 Comment
 
LVL 1

Accepted Solution

by:
Kagiejot earned 1500 total points
ID: 12153991
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

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question