LOV: Error: FRM 40212: Invalid value for field

Nov 4, 2019 4:24AM

Version

Forms [32 Bit] Version 6.0.8.11.3 (Production)

Oracle Toolkit Version 6.0.5.35.0 (Production)

PL/SQL Version 8.0.6.0.0 (Production)

Oracle Procedure Builder V6.0.8.11.0 Build #449 - Production

PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)

Oracle Query Builder 6.0.7.0.0 - Production

Oracle Virtual Graphics System Version 6.0.5.35.0 (Production)

Oracle Tools GUI Utilities Version 6.0.5.35.0 (Production)

Oracle Multimedia Version 6.0.5.34.0 (Production)

Oracle Tools Integration Version 6.0.8.10.2 (Production)

Oracle Tools Common Area Version 6.0.5.32.1

Oracle CORE Version 4.0.6.0.0 - Production

Query

In customized Oracle FORM , On EMP_DEPT Table i have created 3 Database Fields. e.g. Emp_Number, Emp_Dep_No, Emp_DepName.

1 Record Group Created with below query. One LOV Created.

Column Mapping Properties. Assigned.

EBS Customizations (MOSC)