Data Loading In Qa_results For Plan Having Element Datatype As Sequence (Doc ID 443390.1)

Last updated on OCTOBER 27, 2016

Applies to:

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

Goal

While Data Loading in to QA_RESULTS through QA_RESULTS_INTERFACE for plans having Collection
Element data type as "Sequence" it is generating its own sequence as per the definition of that collection element. If it is required to insert a predefinedĀ  number (which is there in the previous legacy data ) it is not allowed and the following errorĀ  "Value Entered for sequence Column" appears
So How to migrate the data with given numbers into a Sequence type collection element ?

Solution

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