My Oracle Support Banner

Oracle Quality Import Views With Matching_Elements Fails With No Row Matched The Specified Condition (Doc ID 2505797.1)

Last updated on DECEMBER 03, 2019

Applies to:

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


I have created a collection plan and inserted a collection data set via the import views.
Now I am creating code to do an update to the same record using the same import views but including the Matching_Elements.

I have the insert created to insert the data into the q_xxxxxx_iv (qa plan's import view). This works fine. When I go to the application and run the "Launch Manager" and select the Update Transaction and run this, it fails with error Message "no rows matched the specified column" and error_column = MATCHING_ELEMENTS


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

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