My Oracle Support Banner

Problem In Updating Elements Of The Same Group using DB Plug-in (Doc ID 1195655.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Communications Order and Service Management - Version: 6.3 and later   [Release: 6.3 and later ]
Information in this document applies to any platform.


You have an SQL query which returns us a set of records (name,value pairs) from the DB, which is to be updated to a data element in the view named as "Mandatory parameter set" which instantiates from 0..99. For each result, from the query, the mandatory parameter set gets instantiated and its child elements NAME, VALUE should be updated with the database values.

The problem is that the name is getting updated in a Mandatory parameter set group and its corresponding value is getting updated in a new instance of the mandatory parameter set group. And this is getting repeated for all the records from the query.

Instead, what is needed is for an update of the name and value pair in a single "Mandatory parameter set" group not in double "Mandatory parameter set group" and this should be repeated for all the records from the SQL query.


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.