use a lov, then occurs the error: FRM 40212: Invalid value for field
FORM version:Forms 32 Bit Version 220.127.116.11.0 (Production)
Planform: oracle ebs 11.5.10
When I open the customized FORM , then search a record by a select of lov(Now the lov is right). It's ok.
When I create a record, then return to find window, then click item (created the lov), then get FRM 40212: Invalid value for field.
in the lov, the sql includes fnd_global.org_id
Use fnd_profile.value('ORG_ID'), and the same problem occurred.
When I update fnd_profile.value('ORG_ID') of the sql of lov to a specific value org_id(for example 120),
then compile the form. After creating a record, to return back to find window ,the item of lov can show record.
So I think that it have not get value from fnd_profile.value('ORG_ID') after creating a record.
Why is this?