My Oracle Support Banner

Unable To Extend Seeded VO ViewReceiptsSearchSupplierVO - Row Must be Mapped To A Unique Query Attribute (Doc ID 1399640.1)

Last updated on APRIL 04, 2025

Applies to:

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

Symptoms

When trying to extend a seeded View Object (VO) ViewReceiptsSearchSupplierVO, JDeveloper fails with error.
(<Note 1301848.1> Cannot Extend / Customize Seeded VO for Notifications, NotifCashLinesVO, NotifCreditLinesVO, NotifExpLinesVO (Doc ID 1301848.1)) is similar for other products, but does not give solution for iProcurement views.

Try with any other view, but get the same error, like:

VO, ViewReceiptsDetailListVO

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. Open jDeveloper
2. Run the create View Object wizard
3. Accept all of the default values for steps 1 to 3 in the create View Object wizard
4. See at step 4 the failure occurs

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot extend views for iProcurement.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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