Error " Each Row In The Query Result Columns Must Be Mapped To A Unique Query Attribute" Trying To Extend ReqsApprovalsVO.xml And ReqsApprovedVO.xml

(Doc ID 2301085.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle iProcurement - Version 12.2.5 and later
Information in this document applies to any platform.


For the project requirement, when trying to extend the standard VOs:
,the following error occurs.

Jdeveloper version is

"Each row in the Query Result Columns must be mapped to a unique Query Attribute in the Mapped Entity Columns"

The issue can be reproduced at will with the following steps:
1. Open Jdeveloper
2. Run the create View Object wizard, Extend the VOs:
3. Accept all of the default values for steps 1 to 3 in the create View Object wizard
4. At step 4 the failure occurs


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms