Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FRM 40212 - Invalid Value for Field - After LOV + Execute_Query

Sooraj P GeorgeJul 1 2019 — edited Jul 1 2019

Hi,

Forms Version : Forms 11g

Form Name is : Locker issue and Return.

In this form, I have a button for Returning already issued lockers. While clicking on the Return button, an LOV is populating with all issued lockers. CLEAR_FORM(NO_VALIDATE); is called for LOV selection. After selecting one record from the LOV then values copied to Parameters then assigned to Locker issue fields(Pre-Query). Then Execute_Query will executed and corresponding Locker issue details will populate. While populating the details, Locker location LOV will popup and showing message 'FRM 40212 - Invalid Value forĀ  Field'. Validate from list is enabled for Locker location.

Thanks in advance,

Sooraj P. George

Comments
Post Details
Added on Jul 1 2019
2 comments
1,553 views