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 laterInformation 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 |