My Oracle Support Banner

In Oracle iSupplier Portal, Error Occurs When Extending the Seeded View Object PosViewShipmentsVO - Each row in the query result columns must be mapped to a unique query attribute in the mapped entity columns (Doc ID 3015487.1)

Last updated on APRIL 09, 2024

Applies to:

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

Symptoms

In Oracle iSupplier Portal, an error when trying to extend the seeded view object PosViewShipmentsVO.


Error

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


Steps To Reproduce

1. In the "Create View Object - Step 1 of 7: Name" window, set the following values:
- Package = xx.oracle.apps.pos.changeorder.server
- Name = XXPosViewShipmentsVOExt
- Extends = oracle.apps.pos.changeorder.server.PosViewShipmentsVO

Rows Populated by a SQL Query, with:
- Read-only Access

2. In the "Create View Object - Step 2 of 7: SQL Statement" window, do not make any changes, in order to use the seeded definition of PosViewShipmentsVO.

3. Continuing with the Next button to the "Create View Object - Step 4 of 7: Attribute Mappings" window, click the Finish button.
The error occurs at this point.

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





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.