We have a Custom Find Form and Main Form.
In the FIND FORM we have QUERY_PROJECT_NUMBER has a LOV attached Q_PROJ_NO
In the MAIN_FORM we have COLUMN PROJECT_NUMBER which has LOV attached M_PROJ_NO.
When the user selects the Project Number from Find FORM and hits the FIND Button, I am getting the following error message!
"FRM-40212: invalid value for field PROJECT_NUMBER"
What am i doing wrong? Any suggestion would be great!
What is the data type of the PROJECT_NUMBER in your Find Form? Sounds to me like the form field doesn't match the data.
Hope this helps,
Craig B-) If someone's response is helpful or correct, please mark it accordingly.
The only other thing I can think of is to check with your DBA/App Server Admin and have them enable tracing and then go through the trace log produced by EBS to see if you can see why it is reporting this error.
Sorry I couldn't be more helpful. You might also want to check in the EBS General Discussion forum.