ADF UI: LOV on Non-Reference Key Attribute

Pre-Requirements: Table Employee in HR Schema.

Use-case: Create LOV on FirstName attirbute of all FirstName exist in the same VO 'Employee' and when user select another 'FirstName', Fields updates without change current row binding.

Steps:

• Create default entity object and view object in tables employee, department
• In Employee VO:
• Add two transient attributes 'FirstName_T' and 'EmployeeID_T'
• Set FirstName_T default Value to expression 'FirstName'
• Set EmployeeId_T default Value to expression 'EmployeeId'
• Add new LOV in 'FirstName_T' Attribute.
• Make accessor to same VO with list attribute 'FirstName_T'.
• Add list return value
• EmployeeId_T map to EmployeeId_T
• In UI Hints tab:
• Default List:  Input Text with List of Values
• Display Attributes (FirstName - LastName - EmployeeId)