Extend Project and Task VOs Error "Each Row in the Query Result Columns Must be Mapped to a Unique Query Attribute in the Mapped Entity Columns" (Doc ID 2873578.1)

Last updated on JUNE 28, 2022

Applies to:

Symptoms

When trying to extend ProjectLOVVO.xml and TaskLOVVO.xml  VOs to add custom logic. Using Jdeveloper 10.1.3.5.0.3.

While using the Create View Object wizard to extend the seeded VO, getting below error-

This error is shown even without making any changes to the seeded query.

ERROR
-----------------------
"Each row in the query result columns must be mapped to a unique query attribute in the mapped entity columns" .

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Using Jdeveloper 10.1.3.5.0.3 

2- Navigate to Create View Object wizard to extend the seeded VO  seeded VOs ProjectLOVVO.xml
TaskLOVVO.xml , ExpenditureType2LOVVO.xml residing in $JAVA_TOP/oracle/apps/hxc/selfservice/timecard/server

Issue is occurring only with ProjectLOVVO.xml and TaskLOVVO.xml, and no issue with ExpenditureType2LOVVO.xml

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.