Unable To Extend VO RCOReqLinesNotificationsVO.xml File

(Doc ID 1541760.1)

Last updated on APRIL 08, 2016

Applies to:

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


After completing Step 4, Attribute Mapping, from the View Object wizard in JDeveloper and clicking on the 'Next' button, the following error message is displayed while trying to extend the standard oracle.apps.icx.por.wf.server.RCOReqLinesNotificationsVO.xml:

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

However, the wizard allows extending the view object (VO) with the original query and then modifying the query to add an additional column.
After adding one additional column, GL account, to the extended VO PRJ1RCOReqLinesNotificationsVO.xml, the following error occurs:


## Detail 0 ##
at oracle.apps.icx.por.wf.server.RCOApprovalNotificationsAMImpl.initRCOReqLinesNotfnVOQry(RCOApprovalNotificationsAMImpl.java:105)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)

Steps To Reproduce
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. At step 4, Attribute Mapping, the failure occurs.

Other VO extensions for ReqLinesNotificationsVO are working fine for the same change.


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