Update QA Collection Record Through Interface Table - Error With "No Row Matched The Specified Condition (Doc ID 2288803.1)

Last updated on AUGUST 14, 2017

Applies to:

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

Symptoms




Problem Description

Problem : When we try to update the existing QA Collection Record , it does error out with "No row matched the specified condition".

Users have the requirement to update one of the collection element after it was created initially. So they insert the records on to interface table with insert_type as 2 along with existing collection_id from qa_result table and trying to change the value of character6(Element: TEST) from NULL to "VAL1". But when they run the QA Import , it errors out with "o row matched the specified condition".

They created a simple new Collection plan (T1 ) with 8 collection element and trying to update one non mandatory element to really understand how this whole update QA records works?

1. When they try to update one single element on the plan, what are the minimum required fields that should be populated ? Do they have to populate collection_id , org_id , item_id all the time. They assume they don't need to populate all other mandatory elements all the time?


2. what are the other existing bugs or limitations with this update ? Do they need to apply any patch?


3. When they update , do they need to populate this matching_elements column , with the actual column from QA table ie CHARACTER6 or with the actual element name ie TEST.  they tried both and it is giving us either "no matching rows found " error or "invalid Value " error.


Please provide additional technical documentation links.



ERROR

"No row matched the specified condition"




Cause

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