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:

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

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